Socket timeout while counting number of rows of a table

[PERNOLLET Martin <ma...@sgcib.com>]

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.
*************************************************************************