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:15:33 UTC
[jira] [Created] (TRAFODION-298) LP Bug: 1323159 - create-table-as
fails, trafci reports ERROR[1] whereas sqlci cores
Alice Chen created TRAFODION-298:
------------------------------------
Summary: LP Bug: 1323159 - create-table-as fails, trafci reports ERROR[1] whereas sqlci cores
Key: TRAFODION-298
URL: https://issues.apache.org/jira/browse/TRAFODION-298
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Julie Thai
Assignee: Anoop Sharma
Priority: Critical
Encountered this issue on workstation, datalake_64_1 v40963.
In trafci:
Welcome to Trafodion Command Interface
Copyright(C) 2013-2014 Hewlett-Packard Development Company, L.P.
Host Name/IP Address: localhost:27700
User Name: zz
Connected to Trafodion
SQL>create table aaa ( cola int not null, colb int not null, colc int not null, primary key (cola, colb));
--- SQL operation complete.
SQL>create table bbb primary key (colc) no load as select * from aaa;
*** ERROR[1] The message id: problem_with_server_read
*** ERROR[1] The message id: header_not_long_enough
*** ERROR[1] The message id: problem_with_server_read
*** ERROR[1] The message id: header_not_long_enough
SQL>
>From sqlci:
Trafodion Conversational Interface 0.7.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>create table aaa ( cola int not null, colb int not null, colc int not null, primary key (cola, colb));
--- SQL operation complete.
>>create table bbb primary key (colc) no load as select * from aaa;
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007ffff0ac84d0, pid=6318, tid=140737182505856
#
# JRE version: 7.0_09-b05
# Java VM: Java HotSpot(TM) 64-Bit Server VM (23.5-b02 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [libparser.so+0x3ab4d0] StmtDDLCreateTable::synthesize()+0x6d0
#
# Core dump written. Default location: /opt/home/thaiju/dcs-0.7.0-beta/core or core.6318
#
# An error report file with more information is saved as:
# /opt/home/thaiju/dcs-0.7.0-beta/hs_err_pid6318.log
#
# If you would like to submit a bug report, please visit:
# http://bugreport.sun.com/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
Aborted (core dumped)
Callstack from sqlci core:
#0 0x00000033088328a5 in raise () from /lib64/libc.so.6
#1 0x0000003308834085 in abort () from /lib64/libc.so.6
#2 0x00007ffff6d46455 in os::abort(bool) ()
from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff6ea6717 in VMError::report_and_die() ()
from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff6d49f60 in JVM_handle_linux_signal ()
from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 0x00007ffff0ac84d0 in StmtDDLCreateTable::synthesize (
this=<value optimized out>) at ../parser/StmtDDLCreate.cpp:4401
#7 0x00007ffff0a278f1 in arkcmpparse ()
at parser/linux/64bit/release/sqlparser.cpp:72458
#8 0x00007ffff16cc854 in Parser::parseSQL (this=0x7fffffff3d80,
node=0x7fffffff3e90, internalExpr=<value optimized out>, paramItemList=
0x41) at ../sqlcomp/parser.cpp:736
#9 0x00007ffff16cdf34 in Parser::parseDML (this=0x7fffffff3d80,
txt=<value optimized out>, node=0x7fffffff3e90, internalExpr=0,
paramItemList=0x0) at ../sqlcomp/parser.cpp:1032
#10 0x00007ffff165bdea in CmpMain::sqlcomp (this=0x7fffffff3f60, input=...,
gen_code=0x7fffd4b30460, gen_code_len=0x7fffd4b30458, heap=0x7fffe91ceaa0,
phase=CmpMain::END, fragmentDir=0x7fffffff40b8, op=3004)
at ../sqlcomp/CmpMain.cpp:753
#11 0x00007ffff576715f in CmpStatement::process (this=0x7fffd4b0eae8,
sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:474
#12 0x00007ffff575bd6e in CmpContext::compileDirect (this=0x7fffe8639090,
data=0x7fffe91f1880 "\200", data_len=200, outHeap=0x7fffe9c40660,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffffff4680,
gen_code_len=@0x7fffffff4688, parserFlags=0, diagsArea=0x7fffe91f1950)
at ../arkcmp/CmpContext.cpp:663
#13 0x00007ffff6114c57 in CliStatement::prepare2 (this=0x7fffe91cf010,
source=0x7fffe9211a10 "create table bbb primary key (colc) no load as select * from aaa;", diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=<value optimized out>, charset=15, unpackTdbs=1,
cliFlags=129) at ../cli/Statement.cpp:1786
#14 0x00007ffff6115106 in CliStatement::prepare (this=0x7fffe91cf010,
source=0x7fffe9211a10 "create table bbb primary key (colc) no load as select * from aaa;", diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=<value optimized out>, charset=<value optimized out>,
unpackTdbs=1, cliFlags=129) at ../cli/Statement.cpp:1376
#15 0x00007ffff60dff0c in SQLCLI_Prepare2 (cliGlobals=0xba1320,
statement_id=0x1cc97c0, sql_source=0x1d7b8c0, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffffff5be0,
query_comp_stats_info=0x7fffffff4950, uniqueStmtId=<value optimized out>,
uniqueStmtIdLen=0x7fffffff5c98, flags=129) at ../cli/Cli.cpp:5941
#16 0x00007ffff611fe3a in SQL_EXEC_Prepare2 (statement_id=0x1cc97c0,
sql_source=0x1d7b8c0, gencode_ptr=0x0, gencode_len=0, ret_gencode_len=0x0,
query_cost_info=0x7fffffff5be0, comp_stats_info=0x7fffffff4950,
uniqueStmtId=0x7fffffff5a50 " ", uniqueStmtIdLen=0x7fffffff5c98,
flags=129) at ../cli/CliExtern.cpp:4901
#17 0x00007ffff7bd8c2f in SqlCmd::do_prepare (sqlci_env=0xb9fb20,
prep_stmt=0x1b96410,
sqlStmt=0x1b89d10 "create table bbb primary key (colc) no load as select * from aaa;", resetLastExecStmt=1, rsIndex=-42416, prepcode=0x7fffffff5d6c,
statisticsType=0x7fffffff5d68) at ../sqlci/SqlCmd.cpp:879
#18 0x00007ffff7bd8080 in DML::process (this=0x20bd100, sqlci_env=0xb9fb20)
at ../sqlci/SqlCmd.cpp:2781
#19 0x00007ffff7bc4f66 in SqlciEnv::executeCommands (this=0xb9fb20,
input_stmt=@0x7fffffff5ec8) at ../sqlci/SqlciEnv.cpp:835
#20 0x00007ffff7bc700b in SqlciEnv::run (this=0xb9fb20)
at ../sqlci/SqlciEnv.cpp:644
#21 0x0000000000401ae1 in main (argc=1, argv=0x7fffffff6098)
at ../bin/SqlciMain.cpp:305
To reproduce in trafci/sqlci, issue:
create table aaa ( cola int not null, colb int not null, colc int not null, primary key (cola, colb));
create table bbb primary key (colc) no load as select * from aaa;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)