You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by KhajaAsmath Mohammed <md...@gmail.com> on 2022/09/20 19:45:23 UTC

Timeout with Apache Phenonix

HI,

I have set up below properties in hbase-site.xml but I stil get error with
timeout.

/usr/lib/phoenix/bin/sqlline-thin.py ip-10-120-1-129.qa.i-edo.net

I have set this in hbase-site.xml of phoenix and hbase too.


<property>
    <name>phoenix.query.timeoutMs</name>
    <value>18000000</value>
</property>
<property>
    <name>phoenix.query.timeoutMs</name>
    <value>18000000</value>
</property>

<property>
      <name>hbase.rpc.timeout</name>
    <value>18000000</value>
</property>
<property>
          <name>hbase.client.scanner.timeout.period"</name>
    <value>18000000</value>
</property>


 -> SocketTimeoutException: callTimeout=60000, callDuration=60109: Call to
ip-10-120-1-227.qa.i-edo.net/10.120.1.227:16020 failed on local exception:
org.apache.hadoop.hbase.ipc.CallTimeoutException: Call id=2991,
waitTime=60009, rpcTimetout=60000 row '' on table 'prewards_event' at
region=prewards_event,,1464725388671.1a93bb2902ee8d2e08f1b08ab084c7d3.,
hostname=ip-10-120-1-227.qa.i-edo.net,16020,1663694862836, seqNum=4738591
-> IOException: Call to ip-10-120-1-227.qa.i-edo.net/10.120.1.227:16020
failed on local exception:
org.apache.hadoop.hbase.ipc.CallTimeoutException: Call id=2991,
waitTime=60009, rpcTimetout=60000 -> CallTimeoutException: Call id=2991,
waitTime=60009, rpcTimetout=60000
        at
org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:54)
        at
org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:41)
        at
org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163)
        at
org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:217)
        at sqlline.Commands.execute(Commands.java:822)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:813)
        at sqlline.SqlLine.begin(SqlLine.java:686)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:291)
        at
org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93)


Thanks,
Asmath