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:18:36 UTC
[jira] [Created] (TRAFODION-893) LP Bug: 1411104 - create salt
table statement may fail with ERROR[1], or abort with sqlci core.
Alice Chen created TRAFODION-893:
------------------------------------
Summary: LP Bug: 1411104 - create salt table statement may fail with ERROR[1], or abort with sqlci core.
Key: TRAFODION-893
URL: https://issues.apache.org/jira/browse/TRAFODION-893
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Julie Thai
Assignee: Hans Zeller
Priority: Minor
Fix For: 2.0-incubating
In trafci, CREATE TABLE...SALT USING...PARTITIONS statement where invalid column name is in primary key clause, may fail with ERROR[1].
In sqlci, /CREATE TABLE...SALT USING...PARTITIONS statement where invalid column name is in primary key clause, is aborted and core dumped.
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 f00(
+>colint int not null,
+>colnum numeric(11,3) not null,
+>colvchrucs2 varchar(115) character set ucs2 not null,
+>primary key (colwhat))
+>salt using 4 partitions;
*** 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>CREATE TABLE f00(
+>colint int not null,
+>colnum numeric(11,3) not null,
+>colvchrucs2 varchar(115) character set ucs2 not null,
+>primary key (colwhat))
+>;
*** ERROR[1009] Column COLWHAT does not exist in the specified table. [2015-01-15 05:18:49]
In SQLCI:
Trafodion Conversational Interface 0.9.1
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>CREATE TABLE f00(
+>colint int not null,
+>colnum numeric(11,3) not null,
+>colvchrucs2 varchar(115) character set ucs2 not null,
+>primary key (colwhat))
+>;
*** ERROR[1009] Column COLWHAT does not exist in the specified table.
--- SQL operation failed with errors.
>>CREATE TABLE f00(
+>colint int not null,
+>colnum numeric(11,3) not null,
+>colvchrucs2 varchar(115) character set ucs2 not null,
+>primary key (colwhat))
+>salt using 4 partitions;
Aborted (core dumped)
>From sqlci core:
Core was generated by `sqlci'.
Program terminated with signal 6, Aborted.
#0 0x0000003ce9e328a5 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install cyrus-sasl-lib-2.1.23-13.el6.x86_64 glibc-2.12-1.107.el6.x86_64 keyutils-libs-1.4-4.el6.x86_64 krb5-libs-1.9-33.el6.x86_64 libcom_err-1.41.12-12.el6.x86_64 libgcc-4.4.6-4.el6.x86_64 libselinux-2.0.94-5.3.el6.x86_64 libstdc++-4.4.6-4.el6.x86_64 nspr-4.9-1.el6.x86_64 nss-3.13.3-6.el6.x86_64 nss-softokn-freebl-3.12.9-11.el6.x86_64 nss-util-3.13.3-2.el6.x86_64 openldap-2.4.23-26.el6.x86_64 openssl-1.0.0-20.el6_2.5.x86_64 zlib-1.2.3-27.el6.x86_64
(gdb) bt
#0 0x0000003ce9e328a5 in raise () from /lib64/libc.so.6
#1 0x0000003ce9e3400d in abort () from /lib64/libc.so.6
#2 0x00007ffff5d14810 in assert_botch_abend (
f=0x7ffff145f1a0 "../common/Collections.cpp", l=871,
m=0x7ffff145fa08 "List index exceeds # of entries",
c=<value optimized out>) at ../export/NAAbort.cpp:282
#3 0x00007ffff138f2e0 in NAList<ElemDDLColDef*>::operator[] (this=
0x7fffd7447198, i=4294967295) at ../common/Collections.cpp:871
#4 0x00007ffff13bf357 in CmpSeabaseDDL::createSeabaseTable (
this=0x7ffffffef100, createTableNode=0x7fffd7446fd0, currCatName=...,
currSchName=...) at ../sqlcomp/CmpSeabaseDDLtable.cpp:1127
#5 0x00007ffff138d0bf in CmpSeabaseDDL::executeSeabaseDDL (
this=0x7ffffffef100, ddlExpr=0x7fffd7447cf0, ddlNode=0x7fffd7446fd0,
currCatName=..., currSchName=...)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:6201
#6 0x00007ffff55dab7a in CmpStatement::process (this=<value optimized out>,
statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:911
#7 0x00007ffff55cec98 in CmpContext::compileDirect (this=0x7fffe8b95090,
data=0x7fffe974f600 "\200", data_len=328, outHeap=0x7fffea19c0f0,
charset=15, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7ffffffef9c0,
gen_code_len=@0x7ffffffef9cc, parserFlags=0, diagsArea=0x7fffe974f750)
at ../arkcmp/CmpContext.cpp:718
#8 0x00007ffff4e121f6 in ExDDLTcb::work (this=0x7fffe9741cd0)
---Type <return> to continue, or q <return> to quit---
at ../executor/ex_ddl.cpp:265
#9 0x00007ffff4f43de3 in ExScheduler::work (this=0x7fffe9741838,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#10 0x00007ffff4e6d1a2 in ex_root_tcb::execute (this=0x7fffe97422a8,
cliGlobals=0xb85ce0, glob=0x7fffe974efc8, input_desc=0x7fffe9768630,
diagsArea=@0x7fffffff10f0, reExecute=0) at ../executor/ex_root.cpp:1029
#11 0x00007ffff5fb2be4 in CliStatement::execute (this=0x7fffe975b390,
cliGlobals=0xb85ce0, input_desc=0x7fffe9768630,
diagsArea=<value optimized out>, execute_state=<value optimized out>,
fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4785
#12 0x00007ffff5f5afba in SQLCLI_PerformTasks(CliGlobals *, ULng32, SQLSTMT_ID *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *) (cliGlobals=0xb85ce0, tasks=4882,
statement_id=0x1d13580, input_descriptor=0x29124e0, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffffff1290,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3279
#13 0x00007ffff5f5bce2 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (
cliGlobals=<value optimized out>, statement_id=<value optimized out>,
input_descriptor=<value optimized out>,
num_ptr_pairs=<value optimized out>, ap=<value optimized out>,
ptr_pairs=<value optimized out>) at ../cli/Cli.cpp:3526
#14 0x00007ffff5fc1d85 in SQL_EXEC_Exec (statement_id=0x1d13580,
---Type <return> to continue, or q <return> to quit---
input_descriptor=0x29124e0, num_ptr_pairs=0) at ../cli/CliExtern.cpp:2062
#15 0x00007ffff79ce38b in SqlCmd::doExec (sqlci_env=0xb84500, stmt=0x1d13580,
prep_stmt=<value optimized out>, numUnnamedParams=<value optimized out>,
unnamedParamArray=<value optimized out>,
unnamedParamCharSetArray=<value optimized out>, handleError=1)
at ../sqlci/SqlCmd.cpp:1706
#16 0x00007ffff79ced82 in SqlCmd::do_execute (sqlci_env=0xb84500,
prep_stmt=0x28fe830, numUnnamedParams=0, unnamedParamArray=0x0,
unnamedParamCharSetArray=0x0, prepcode=0) at ../sqlci/SqlCmd.cpp:2042
#17 0x00007ffff79cf4ad in DML::process (this=0x230f6b0, sqlci_env=0xb84500)
at ../sqlci/SqlCmd.cpp:2816
#18 0x00007ffff79bbfe6 in SqlciEnv::executeCommands (this=0xb84500,
input_stmt=@0x7fffffff2c88) at ../sqlci/SqlciEnv.cpp:847
#19 0x00007ffff79be08b in SqlciEnv::run (this=0xb84500)
at ../sqlci/SqlciEnv.cpp:656
#20 0x0000000000401ab1 in main (argc=1, argv=0x7fffffff2e58)
at ../bin/SqlciMain.cpp:319
To reproduce, issue in TRAFCI or SQLCI:
CREATE TABLE f00(
colint int not null,
colnum numeric(11,3) not null,
colvchrucs2 varchar(115) character set ucs2 not null,
primary key (colwhat))
salt using 4 partitions;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)