phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josh Elser (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3754) The query in the Getting Started page fails (OutOfOrderScannerNextException)
Date Mon, 03 Apr 2017 16:14:41 GMT

    [ 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)

Mime
View raw message