Yasunari Shimizu created PHOENIX-3754:
-----------------------------------------
Summary: 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)
