[
https://issues.apache.org/jira/browse/PHOENIX-3754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Josh Elser resolved PHOENIX-3754.
---------------------------------
Resolution: Invalid
> 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)
