question Re: hbase.client.scanner.timeout.period in Support Questions

hbase.client.scanner.timeout.period

arunpoy — Wed, 31 Aug 2016 09:16:18 GMT

I changed the hbase.client.scanner.timeout.period at both the client and server level. After that i use phoenix to run a query, but still see the error. Seems even after changing the require parameters the defaults get applied. Any suggestions on how to fix this?

Caused by: org.apache.hadoop.hbase.client.ScannerTimeoutException: 1864561ms passed since the last invocation, timeout is currently set to 60000

Also sometimes i do see the below exception too

java.net.SocketTimeoutException: callTimeout=60000, callDuration=60307

i have set the following properties

<property> <name>hbase.client.scanner.timeout.period</name> <value>1800000</value> </property> -- <property> <name>hbase.rpc.timeout</name> <value>1800000</value> </property> -- <property> <name>phoenix.query.keepAliveMs</name> <value>1800000</value> </property> <property> <name>phoenix.query.timeoutMs</name> <value>1800000</value> </property> <property> <name>zookeeper.session.timeout</name> <value>1800000</value> </property>

Re: hbase.client.scanner.timeout.period

vrodionov — Wed, 31 Aug 2016 09:20:45 GMT

java.net.SocketTimeoutException: callTimeout=60000, callDuration=60307

Have you changed hbase.rpc.timeout? It seems, you have not.

Re: hbase.client.scanner.timeout.period

arunpoy — Wed, 31 Aug 2016 09:43:30 GMT

yes i have changed that too. you could see above

Re: hbase.client.scanner.timeout.period

rmaruthiyodan — Wed, 31 Aug 2016 13:10:51 GMT

Looks like the hbase configuration is not picked by the phoenix client.

Please check by setting either of the following environment variables:

export HBASE_CONF_DIR=/etc/hbase/conf Or

export HBASE_CONF_PATH=/etc/hbase/conf

Re: hbase.client.scanner.timeout.period

asinghal — Wed, 31 Aug 2016 13:22:14 GMT

It seems that server adhered this property "hbase.client.scanner.timeout.period" for lease expiration but the client has not . can you check that your hbase-site.xml is in class path of your phoenix client(application/sqlline) as well.

Re: hbase.client.scanner.timeout.period

vrodionov — Fri, 02 Sep 2016 02:42:46 GMT

Verify that you use the same hbase-site.xml on both: client and server sides.

Re: hbase.client.scanner.timeout.period

PrathapKumar — Fri, 06 May 2022 09:42:31 GMT

@arunpoy

If we are using the CDH/CDP both timeout parameters(hbase.rpc.timeout & hbase.client.scanner.timeout.period) need to be added in both server-side and client-side in the below paths from the HBase configuration.

HBase Service Advanced Configuration Snippet (Safety Valve) for hbase-site.xml

HBase Client Advanced Configuration Snippet (Safety Valve) for hbase-site.xml

Bothe the time-out parameters need to be added on the server and client-side and RPC(hbase.rpc.timeout) time-out needs to be set a bit higher than the client scanner time-out (hbase.client.scanner.timeout.period).