You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Josh Elser (JIRA)" <ji...@apache.org> on 2017/04/03 16:14:41 UTC
[jira] [Commented] (PHOENIX-3754) The query in the Getting Started
page fails (OutOfOrderScannerNextException)
[ 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)