You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Hans Zeller (JIRA)" <ji...@apache.org> on 2016/05/12 00:29:12 UTC
[jira] [Resolved] (TRAFODION-893) LP Bug: 1411104 - create salt
table statement may fail with ERROR[1], or abort with sqlci core.
[ https://issues.apache.org/jira/browse/TRAFODION-893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hans Zeller resolved TRAFODION-893.
-----------------------------------
Resolution: Fixed
Tried the test case in a recent 2.0 build and the problem is fixed. Unfortunately I can't say in which commit the fix was implemented - this could have been done a long time ago.
> 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)