phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From PERNOLLET Martin <martin.pernollet-...@sgcib.com>
Subject Socket timeout while counting number of rows of a table
Date Thu, 09 Apr 2015 15:51:33 GMT
Hi,

When asking to Phoenix to count the lines of a HBase table (select count("UUID") from "bulk_1month")
it fails after one minute :

java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException:
Failed after attempts=36, exceptions:
Thu Apr 09 16:49:33 CEST 2015, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=62366:
row '' on table 'bulk_1month' at region=bulk_1month,,1428582098717.2b2c2f1b5eab43e15b5789c2aa0dfc80.,
hostname=reid,60020,1428590222546, seqNum=37

        at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440)
        at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074)
        at sqlline.SqlLine.print(SqlLine.java:1735)
        at sqlline.SqlLine$Commands.execute(SqlLine.java:3683)
        at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
        at sqlline.SqlLine.dispatch(SqlLine.java:821)
        at sqlline.SqlLine.begin(SqlLine.java:699)
        at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
        at sqlline.SqlLine.main(SqlLine.java:424)

A post (https://github.com/forcedotcom/phoenix/issues/730) suggested to edit timeout values
so I added the following properties to HBase configuration via Ambari.

    <property>
      <name>phoenix.query.keepAliveMs</name>
      <!-changed to timeout from 1 min to 10 min -->
      <value>600000</value>
    </property>

    <property>
      <name>phoenix.query.timeoutMs</name>
      <!-changed to timeout from 60 sec to 2h -->
      <value>7200000</value>
    </property>

And once HBase restarted I copied the updated HBase conf to Phoenix bin/ directory :

cp /etc/hbase/conf/hbase-site.xml  /usr/hdp/2.2.0.0-2041/phoenix/bin

It did not change anything to the actual timeout.

Did I miss a property or am I wrong while copying the hbase settings?

Thanks for your help!


*************************************************************************
This message and any attachments (the "message") are confidential, intended solely for the
addressee(s), and may contain legally privileged information.
Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration.
  
Neither SOCIETE GENERALE nor any of its subsidiaries or affiliates shall be liable for the
message if altered, changed or
falsified.
Please visit http://swapdisclosure.sgcib.com for important information with respect to derivative
products.
                              ************
Ce message et toutes les pieces jointes (ci-apres le "message") sont confidentiels et susceptibles
de contenir des informations couvertes 
par le secret professionnel. 
Ce message est etabli a l'intention exclusive de ses destinataires. Toute utilisation ou diffusion
non autorisee est interdite.
Tout message electronique est susceptible d'alteration. 
La SOCIETE GENERALE et ses filiales declinent toute responsabilite au titre de ce message
s'il a ete altere, deforme ou falsifie.
Veuillez consulter le site http://swapdisclosure.sgcib.com afin de recueillir d'importantes
informations sur les produits derives.
*************************************************************************

Mime
View raw message