Comment 3 for bug 1391271

Revision history for this message
Weishiun Tsai (wei-shiun-tsai) wrote :

Saw it two more times on the v1209_0830 build on amethyst9 (a Cloudera machine) while trying to rerun update stats on g_tpch2x.lineitem. The 3rd try finally succeeded. The g_tpch2x.lineitem table was already populated last night. Seeing this error this morning rules out the possibility that it has anything to do with how close we run update stats with the actual table populating.

>>update statistics for table lineitem on every column sample random 10 percent;

*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_TPCH2X.LINEITEM encountered an error (8448) from statement Process_Query.

*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::nextRow returned error HBASE_ACCESS_ERROR(-705). Cause:
java.util.concurrent.ExecutionException: org.apache.hadoop.hbase.DoNotRetryIOException: Failed after retry of OutOfOrderScannerNextException: was there a rpc timeout?
java.util.concurrent.FutureTask.report(FutureTask.java:122)
java.util.concurrent.FutureTask.get(FutureTask.java:188)
org.trafodion.sql.HBaseAccess.HTableClient.fetchRows(HTableClient.java:415)
.

--- SQL operation failed with errors.
>>
>>update statistics for table lineitem on every column sample random 10 percent;

*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_TPCH2X.LINEITEM encountered an error (8448) from statement Process_Query.

*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::nextRow returned error HBASE_ACCESS_ERROR(-705). Cause:
java.util.concurrent.ExecutionException: org.apache.hadoop.hbase.DoNotRetryIOException: Failed after retry of OutOfOrderScannerNextException: was there a rpc timeout?
java.util.concurrent.FutureTask.report(FutureTask.java:122)
java.util.concurrent.FutureTask.get(FutureTask.java:188)
org.trafodion.sql.HBaseAccess.HTableClient.fetchRows(HTableClient.java:415)
.

--- SQL operation failed with errors.
>>update statistics for table lineitem on every column sample random 10 percent;

--- SQL operation complete.