We have resolved the issue by following these steps. This is just for the
benefit of someone facing similar issues.
Regards,
Ajit
1. Set client side environment variables:
Create some conf folder e.g. /home/conf
setenv HBASE_CONF_DIR /
home
/conf
2. Create hbase-site.xml, Make sure that following settings are included:
--> phoenix.query.timeoutMs=1200000
--> hbase.rpc.timeout = 1200000
--> hbase.client.scanner.timeout.period = 1200000
E.g.
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<property>
<name>phoenix.query.timeoutMs</name>
<value>1200000</value>
</property>
<property>
<name>hbase.rpc.timeout</name>
<value>1200000</value>
</property>
<property>
<name>hbase.client.scanner.timeout.period</name>
<value>1200000</value>
</property>
</configuration>
3
. Make sure that
this
hbase-site.xml is in class path of
Java client
.
On Thu, Jun 15, 2017 at 10:54 AM, Ajit Bhingarkar <
ajit.bhingar...@nielsen.com> wrote:
> Hi,
>
> We are using a java based client for phoenix, and there is no hbase
> installation available on the client machine. During longer database
> operations we are getting the error as below:
>
> Error Code: 101, SQL State: 08000]
> org.apache.phoenix.exception.PhoenixIOException:
> Failed after attempts=36, exceptions:
> Wed Jun 14 12:32:26 IST 2017, null, java.net.SocketTimeoutException:
> callTimeout=60000, callDuration=79332: row '' on table
> 'D2O_OPTAL_MY.D2O_OPTAL_CELL_DIFF_REPORT' at
> region=D2O_OPTAL_MY.D2O_OPTAL_CELL_DIFF_REPORT,,149735181184
> 4.ebdeb51f81914e7ea2291e83e1ff6022., hostname=tparhegapi008.enterpr
> isenet.org,60020,1493969895840, seqNum=2
>
> From various references found through google it is clear that the
> SocketTimeoutException is caused by default value of hbase.rpc.timeput
> which is 60000 ms.
>
> Can someone please help us configure this setting on the client side?
> Same setting on the server side in hbase-site.xml has been set to 10
> minutes, but looks like client is timing out the connection.
>
> Thanks in advance for your help.
>
> Regards,
> Ajit
>
>
> On Thu, Jun 15, 2017 at 10:47 AM, Ajit Bhingarkar <
> ajit.bhingar...@nielsen.com> wrote:
>
>> Hi,
>>
>> We are using a java based client for phoenix, and there is no hbase
>> installation available on the client machine. During longer database
>> operations we are getting the error as below:
>>
>> Error Code: 101, SQL State: 08000]
>> org.apache.phoenix.exception.PhoenixIOException:
>> Failed after attempts=36, exceptions:
>> Wed Jun 14 12:32:26 IST 2017, null, java.net.SocketTimeoutException:
>> callTimeout=60000, callDuration=79332: row '' on table
>> 'D2O_OPTAL_MY.D2O_OPTAL_CELL_DIFF_REPORT' at
>> region=D2O_OPTAL_MY.D2O_OPTAL_CELL_DIFF_REPORT,,149735181184
>> 4.ebdeb51f81914e7ea2291e83e1ff6022., hostname=tparhegapi008.enterpr
>> isenet.org,60020,1493969895840, seqNum=2
>>
>> From various references found through google it is clear that the
>> SocketTimeoutException is caused by default value of hbase.rpc.timeput
>> which is 60000 ms.
>>
>> Can someone please help us configure this setting on the client side?
>> Same setting on the server side in hbase-site.xml has been set to 10
>> minutes, but looks like client is timing out the connection.
>>
>> Thanks in advance for your help.
>>
>> Regards,
>> Ajit
>>
>>
>
