You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Marek Wiewiorka <ma...@gmail.com> on 2015/04/07 11:46:12 UTC

operation timed out

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

Re: operation timed out

Posted by Marek Wiewiorka <ma...@gmail.com>.
Ok - I think I found it:
phoenix.query.timeoutMs

M.


2015-04-07 11:46 GMT+02:00 Marek Wiewiorka <ma...@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
>
>