phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marek Wiewiorka <marek.wiewio...@gmail.com>
Subject Re: operation timed out
Date Tue, 07 Apr 2015 13:59:09 GMT
Ok - I think I found it:
phoenix.query.timeoutMs

M.


2015-04-07 11:46 GMT+02:00 Marek Wiewiorka <marek.wiewiorka@gmail.com>:

> Hi All - I keep on getting operation timeout errors while running queries:
> Error: Operation timed out (state=TIM01,code=6000)
> java.sql.SQLTimeoutException: Operation timed out
>         at
> org.apache.phoenix.exception.SQLExceptionCode$14.newException(SQLExceptionCode.java:313)
>         at
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
>         at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:583)
>         at
> org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50)
>         at
> org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97)
>         at
> org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117)
>         at
> org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCompiler.java:679)
>         at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:280)
>         at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:272)
>         at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>         at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:270)
>         at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1063)
>         at sqlline.Commands.execute(Commands.java:822)
>         at sqlline.Commands.sql(Commands.java:732)
>         at sqlline.SqlLine.dispatch(SqlLine.java:808)
>         at sqlline.SqlLine.begin(SqlLine.java:681)
>         at sqlline.SqlLine.start(SqlLine.java:398)
>         at sqlline.SqlLine.main(SqlLine.java:292)
>
>
> I've already set the following properties in hbase-site:
>
>    <property>
>     <name>zookeeper.session.timeout</name>
>     <value>90000000</value>
>   </property>
>  <property>
>     <name>hbase.rpc.timeout</name>
>     <value>90000000</value>
>   </property>
>   <property>
>     <name>hbase.client.scanner.timeout.period</name>
>     <value>90000000</value>
>   </property>
>
> But the problem still persists - could you please advise me what other
> properties should I consider to set?
>
> Thanks!
> Marek
>
>

Mime
View raw message