phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marek Wiewiorka <marek.wiewio...@gmail.com>
Subject operation timed out
Date Tue, 07 Apr 2015 09:46:12 GMT
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