You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2016/05/05 06:06:13 UTC

[jira] [Created] (TRAFODION-1974) Timeout exception updating statistics for a very large table

Atanu Mishra created TRAFODION-1974:
---------------------------------------

             Summary: Timeout exception updating statistics for a very large table
                 Key: TRAFODION-1974
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1974
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-general
    Affects Versions: 2.0-incubating
         Environment: CentOS 6.x - HBase 1.0 - Trafodion R2.0
on an AWS instance
            Reporter: Atanu Mishra


Errors observed during the following maintain sequence --

Maintain Table : 2016-05-05 00:26:11
----------------------------------------------------------
SQLEXCEPTION on Statement, Error Code = -9200
update statistics for table trafodion.javabench.oe_stock_10000 on every column, (S_I_ID, S_W_ID) sample

*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.JAVABENCH.OE_STOCK_10000 encountered an error (8448) from statement HSCursor::fetchRowset(). [2016-05-05 00:28:40]

*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::nextRow returned error HBASE_ACCESS_ERROR(-706). Cause:
java.util.concurrent.ExecutionException: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:
Thu May 05 00:27:32 GMT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=60304: row '?. [2016-05-05 00:28:40]

*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.JAVABENCH.OE_STOCK_10000 encountered an error (8448) from statement READ_COLS_INTO_MEM. [2016-05-05 00:28:40]

*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::nextRow returned error HBASE_ACCESS_ERROR(-706). Cause:
java.util.concurrent.ExecutionException: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:
Thu May 05 00:27:32 GMT 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=60304: row '?. [2016-05-05 00:28:40]
----------------------------------------------------------





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)