[
https://issues.apache.org/jira/browse/PHOENIX-3754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15953715#comment-15953715
]
Josh Elser commented on PHOENIX-3754:
-------------------------------------
[~smizy], re-read that exception message :)
{noformat}
Failed after retry of OutOfOrderScannerNextException: was there a rpc timeout?
{noformat}
Most likely, you just need to bump up the values for hbase.rpc.timeout.
Remember that phoenix.query.timeoutMs is also important to increase (but this
defaults to 10mins which is probably much larger than your hbase.rpc.timeout).
I'm going to close this issue. Please re-open if you found a bug that is
causing this to fail on 4.10.0-SNAPSHOT. If you are still having problems
getting this to run, please reach out to the users mailing list instead.
> The query in the Getting Started page fails (OutOfOrderScannerNextException)
> ----------------------------------------------------------------------------
>
> Key: PHOENIX-3754
> URL: https://issues.apache.org/jira/browse/PHOENIX-3754
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.10.0
> Environment: Phoenix: 4.10
> HBase: 1.2.4
> Reporter: Yasunari Shimizu
>
> The following command fails on 4.10.0, passes on 4.9.0.
> > psql.py localhost ../examples/web_stat.sql ../examples/web_stat.csv
> > ../examples/web_stat_queries.sql
> Exception occured at the following query in web_stat_queries.sql.
> --
> SELECT HOST, SUM(ACTIVE_VISITOR) TOTAL_ACTIVE_VISITORS
> FROM WEB_STAT
> WHERE DB > (CORE * 10)
> GROUP BY HOST;
> --
> # check data
> 0: jdbc:phoenix:zookeeper-1.vnet> SELECT * FROM WEB_STAT WHERE DB > (CORE *
> 10);
> +-------+-----------------+----------+--------------------------+-------+-----+-----------------+
> | HOST | DOMAIN | FEATURE | DATE | CORE | DB
> | ACTIVE_VISITOR |
> +-------+-----------------+----------+--------------------------+-------+-----+-----------------+
> | EU | Salesforce.com | Login | 2013-01-12 01:01:01.000 | 5 | 62
> | 150 |
> | NA | Salesforce.com | Login | 2013-01-04 06:01:21.000 | 3 | 52
> | 1 |
> +-------+-----------------+----------+--------------------------+-------+-----+-----------------+
> 2 rows selected (0.077 seconds)
> LOG
> ---
> 17/03/29 04:44:25 WARN impl.MetricsConfig: Cannot locate configuration: tried
> hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
> no rows upserted
> Time: 2.289 sec(s)
> csv columns from database.
> CSV Upsert complete. 39 rows upserted
> Time: 0.07 sec(s)
> DOMAIN
> AVERAGE_CPU_USAGE AVERAGE_DB_USAGE
> ----------------------------------------
> ----------------------------------------
> ----------------------------------------
> Salesforce.com
> 260.727 257.636
> Google.com
> 212.875 213.75
> Apple.com
> 114.111 119.556
> Time: 0.039 sec(s)
> DAY TOTAL_CPU_USAGE
> MIN_CPU_USAGE MAX_CPU_USAGE
> ----------------------- ----------------------------------------
> ----------------------------------------
> ----------------------------------------
> 2013-01-01 00:00:00.000 35
> 35 35
> 2013-01-02 00:00:00.000 150
> 25 125
> 2013-01-03 00:00:00.000 88
> 88 88
> 2013-01-04 00:00:00.000 26
> 3 23
> 2013-01-05 00:00:00.000 550
> 75 475
> 2013-01-06 00:00:00.000 12
> 12 12
> 2013-01-08 00:00:00.000 345
> 345 345
> 2013-01-09 00:00:00.000 390
> 35 355
> 2013-01-10 00:00:00.000 345
> 345 345
> 2013-01-11 00:00:00.000 335
> 335 335
> 2013-01-12 00:00:00.000 5
> 5 5
> 2013-01-13 00:00:00.000 355
> 355 355
> 2013-01-14 00:00:00.000 5
> 5 5
> 2013-01-15 00:00:00.000 720
> 65 655
> 2013-01-16 00:00:00.000 785
> 785 785
> 2013-01-17 00:00:00.000 1590
> 355 1235
> Time: 0.037 sec(s)
> org.apache.phoenix.exception.PhoenixIOException:
> org.apache.phoenix.exception.PhoenixIOException: Failed after retry of
> OutOfOrderScannerNextException: was there a rpc timeout?
> at
> org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:113)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:852)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:796)
> at
> org.apache.phoenix.iterate.RowKeyOrderedAggregateResultIterator.getIterators(RowKeyOrderedAggregateResultIterator.java:61)
> at
> org.apache.phoenix.iterate.RowKeyOrderedAggregateResultIterator.nextTuple(RowKeyOrderedAggregateResultIterator.java:108)
> at
> org.apache.phoenix.iterate.RowKeyOrderedAggregateResultIterator.advance(RowKeyOrderedAggregateResultIterator.java:146)
> at
> org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultIterator.java:59)
> at
> org.apache.phoenix.iterate.LookAheadResultIterator.next(LookAheadResultIterator.java:65)
> at
> org.apache.phoenix.iterate.RowKeyOrderedAggregateResultIterator.next(RowKeyOrderedAggregateResultIterator.java:133)
> at
> org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:778)
> at
> org.apache.phoenix.jdbc.PhoenixConnection.executeStatements(PhoenixConnection.java:372)
> at
> org.apache.phoenix.util.PhoenixRuntime.executeStatements(PhoenixRuntime.java:318)
> at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:265)
> Caused by: java.util.concurrent.ExecutionException:
> org.apache.phoenix.exception.PhoenixIOException: Failed after retry of
> OutOfOrderScannerNextException: was there a rpc timeout?
> at java.util.concurrent.FutureTask.report(FutureTask.java:122)
> at java.util.concurrent.FutureTask.get(FutureTask.java:206)
> at
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:847)
> ... 11 more
> :
> :
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
