You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:33 UTC
[jira] [Created] (TRAFODION-615) LP Bug: 1368437 - update
statistics fails with error(4001) from statement
HSCursor::prepareRowsetInternal()
Alice Chen created TRAFODION-615:
------------------------------------
Summary: LP Bug: 1368437 - update statistics fails with error(4001) from statement HSCursor::prepareRowsetInternal()
Key: TRAFODION-615
URL: https://issues.apache.org/jira/browse/TRAFODION-615
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Julie Thai
Assignee: Barry Fritchman
Priority: Blocker
On cluster, build 20140909_0830, using jdbc to create, load and updatestats, updatestats fails with the following error msg sequences:
SQL>update statistics for table trafodion.g_sqldopt.b2uwl12 on every column sample;
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_SQLDOPT.B2UWL12 encountered an error (4001) from statement HSCursor::prepareRowsetInternal(). [2014-09-11 12:01:19]
*** ERROR[4001] Column "DATE3_N2000" is not found. Tables in scope: TRAFODION.G_SQLDOPT.B2UWL12. Default schema: TRAFODION.G_SQLDOPT. [2014-09-11 12:01:19]
*** WARNING[4104] If a character literal was intended, you must use the single quote delimiter: 'DATE3_N2000'. The use of double quotes causes SQL to interpret "DATE3_N2000" as a delimited identifier column name. [2014-09-11 12:01:19]
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_SQLDOPT.B2UWL12 encountered an error (4001) from statement FETCH_BOUNDARY_ROWSET. [2014-09-11 12:01:19]
*** ERROR[4001] Column "DATE3_N2000" is not found. Tables in scope: TRAFODION.G_SQLDOPT.B2UWL12. Default schema: TRAFODION.G_SQLDOPT. [2014-09-11 12:01:19]
*** WARNING[4104] If a character literal was intended, you must use the single quote delimiter: 'DATE3_N2000'. The use of double quotes causes SQL to interpret "DATE3_N2000" as a delimited identifier column name. [2014-09-11 12:01:19]
----------------------------------
SQL>update statistics for table trafodion.g_sqldopt.b2uwl14 on every column sample;
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_SQLDOPT.B2UWL14 encountered an error (8448) from statement HSCursor::prepareRowsetInternal(). [2014-09-11 12:02:54]
*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::nextRow returned error HBASE_ACCESS_ERROR(-705). Cause:
java.lang.OutOfMemoryError: Java heap space
. [2014-09-11 12:02:54]
*** ERROR[4082] Object TRAFODION.G_SQLDOPT.B2UWL14 does not exist or is inaccessible. [2014-09-11 12:02:54]
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_SQLDOPT.B2UWL14 encountered an error (8448) from statement READ_COLS_INTO_MEM. [2014-09-11 12:02:54]
*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::nextRow returned error HBASE_ACCESS_ERROR(-705). Cause:
java.lang.OutOfMemoryError: Java heap space
. [2014-09-11 12:02:54]
*** ERROR[4082] Object TRAFODION.G_SQLDOPT.B2UWL14 does not exist or is inaccessible. [2014-09-11 12:02:54]
--------------------------------------
SQL>update statistics for table trafodion.g_sqldopt.b2uwl18 on every column sample;
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_SQLDOPT.B2UWL18 encountered an error (2235) from statement HSCursor::prepare(). [2014-09-11 12:05:57]
*** ERROR[2235] Compiler Internal Error: List index exceeds # of entries, originated from file ../common/Collections.cpp at line 905. [2014-09-11 12:05:57]
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_SQLDOPT.B2UWL18 encountered an error (2235) from statement fetchNumColumn. [2014-09-11 12:05:57]
*** ERROR[2235] Compiler Internal Error: List index exceeds # of entries, originated from file ../common/Collections.cpp at line 905. [2014-09-11 12:05:57]
--------------------------------------
SQL>update statistics for table trafodion.g_sqldopt.btunl03 on every column sample;
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_SQLDOPT.BTUNL03 encountered an error (4082) from statement HSCursor::prepare(). [2014-09-11 12:14:40]
*** ERROR[4082] Object TRAFODION.G_SQLDOPT.BTUNL03 does not exist or is inaccessible. [2014-09-11 12:14:40]
*** ERROR[9200] UPDATE STATISTICS for table TRAFODION.G_SQLDOPT.BTUNL03 encountered an error (4082) from statement fetchNumColumn. [2014-09-11 12:14:40]
*** ERROR[4082] Object TRAFODION.G_SQLDOPT.BTUNL03 does not exist or is inaccessible. [2014-09-11 12:14:40]
Schema consists of 50 tables. Initially updatestats is successful for the first dozen or so tables, then all subsequent updstats fail with one of the above error sequences. Afterwards, was able to successfully run updatestats in sqlci.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)