[jira] [Created] (TRAFODION-210) LP Bug: 1301023 - update statistics fails with ERROR[8838]

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-210:
------------------------------------

             Summary: LP Bug: 1301023 - update statistics fails with ERROR[8838]
                 Key: TRAFODION-210
                 URL: https://issues.apache.org/jira/browse/TRAFODION-210
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Julie Thai
            Assignee: Barry Fritchman
            Priority: Blocker


Via sqlci, update statistics on salted table, which contains large number of rows fails and reports ERROR[8838].
No core file(s) generated. 

[trafodion@rhel-cdh1 ~]$ sqid
cat: /opt/hptc/pdsh/nodes: No such file or directory
MY_SQROOT=/home/trafodion/dlv38708
who@host=trafodion@rhel-cdh1
JAVA_HOME=/usr/lib/jvm/java
linux=2.6.32-358.18.1.el6.x86_64
redhat=6.4
Release 0.7.0 (Build release [38708], branch 38708-project/datalake_64_1, date 25Mar14)

>>cqd ustat_log 'updstats.partsupp';    

--- SQL operation complete.
>>update statistics log on;

--- SQL operation complete.
>>update statistics for table partsupp on every column, (ps_partkey, ps_suppkey);

*** ERROR[8838] Unable to receive reply from Compiler, possibly caused by internal errors when compiling SQL statements, processing DDL statements, or executing the builtin stored procedures.

--- SQL operation failed with errors.
>>update statistics log off;

--- SQL operation complete.
>>cqd ustat_log 'updstats.orders';

--- SQL operation complete.
>>update statistics log on;

--- SQL operation complete.
>>update statistics for table orders on every column;

*** ERROR[8838] Unable to receive reply from Compiler, possibly caused by internal errors when compiling SQL statements, processing DDL statements, or executing the builtin stored procedures.

--- SQL operation failed with errors.
>>update statistics log off;

--- SQL operation complete.
>>cqd ustat_log 'updstats.lineitem';

--- SQL operation complete.
>>update statistics log on;

--- SQL operation complete.
>>update statistics for table lineitem on every column, (l_shipdate, l_orderkey, l_linenumber);

*** ERROR[8838] Unable to receive reply from Compiler, possibly caused by internal errors when compiling SQL statements, processing DDL statements, or executing the builtin stored procedures.

--- SQL operation failed with errors.
>>update statistics log off;  

--- SQL operation complete.
>>select count(*) from orders;
       
(EXPR)              
--------------------

             3000000

--- 1 row(s) selected.
>>select count(*) from partsupp; 

(EXPR)              
--------------------

             1600000

--- 1 row(s) selected.
>>select count(*) from lineitem;
 
(EXPR)              
--------------------

            11997996

--- 1 row(s) selected.



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