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:20 UTC

[jira] [Created] (TRAFODION-244) LP Bug: 1315526 - CRASH: SQLCI or MXOSRV cores when creating a table with syntax error.

Alice Chen created TRAFODION-244:
------------------------------------

             Summary: LP Bug: 1315526 - CRASH: SQLCI or MXOSRV cores when creating a table with syntax error.
                 Key: TRAFODION-244
                 URL: https://issues.apache.org/jira/browse/TRAFODION-244
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-general
            Reporter: Guy Groulx
            Assignee: Anoop Sharma


Try the following using any interface, sqlci or trafci.

DROP TABLE TRAFODION.TESTSCH.CTRY_D;

CREATE TABLE TRAFODION.TESTSCH.CTRY_D
(
   CTRY_KY INT NO DEFAULT NOT NULL,
   ISO_CTRY_CD CHAR(2) DEFAULT NULL,
   ISO_CTRY_NM CHAR(40) DEFAULT NULL,
   ISO_CTRY_DN CHAR(40) DEFAULT NULL,
   SUBREGN_3_CD CHAR(10) DEFAULT NULL,
   SUBREGN_3_NM CHAR(40) DEFAULT NULL,
   SUBREGN_2_CD CHAR(10) DEFAULT NULL,
   SUBREGN_2_NM CHAR(40) DEFAULT NULL,
   SUBREGN_1_CD CHAR(10) DEFAULT NULL,
   SUBREGN_1_NM CHAR(40) DEFAULT NULL,
   STRAT_RGN_CD CHAR(10) DEFAULT NULL,
   STRAT_RGN_NM CHAR(40) DEFAULT NULL,
   RGN_CD CHAR(10) DEFAULT NULL,
   RGN_NM CHAR(40) DEFAULT NULL,
   WW_CD CHAR(10) NO DEFAULT NOT NULL,
   WW_NM CHAR(40) DEFAULT NULL,
   INS_GMT_TS TIMESTAMP(6) DEFAULT NULL,
   UPD_GMT_TS TIMESTAMP(6) DEFAULT NULL,
   SRC_SYS_KY INT DEFAULT NULL,
   ACTIVE_FG CHAR(1) DEFAULT NULL,
   LOAD_JOB_NR NUMERIC(15, 0) DEFAULT NULL,
   LGCL_DEL_FG CHAR(1) DEFAULT NULL,
   REC_ST_NR SMALLINT DEFAULT NULL,
   RGN_KY INT DEFAULT NULL,
-- Syntax bug - misspelled column in PRIMARY KEY clause, should be “CTRY_KY” not “CTRY_KEY”
   PRIMARY KEY (CTRY_KEY ASC)
)
;


2014-05-02 20:25:18 /local/cores/1008/core.1399062318.n001.29462.sqlci
/home/squser2> gdb sqlci /local/cores/1008/core.1399062318.n001.29462.sqlci 
Core was generated by `sqlci'.
Program terminated with signal 6, Aborted.
#0  0x00007ffff585c8a5 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install boost-filesystem-1.41.0-11.el6_1.2.x86_64 boost-program-options-1.41.0-11.el6_1.
2.x86_64 boost-system-1.41.0-11.el6_1.2.x86_64 cyrus-sasl-lib-2.1.23-13.el6.x86_64 glibc-2.12-1.107.el6.x86_64 keyutils-libs-1.4-4.e
l6.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 li
bstdc++-4.4.6-4.el6.x86_64 libuuid-2.17.2-12.7.el6.x86_64 nss-softokn-freebl-3.12.9-11.el6.x86_64 openssl-1.0.0-20.el6_2.5.x86_64 qp
id-cpp-client-0.14-16.el6.x86_64 zlib-1.2.3-27.el6.x86_64
(gdb) bt
#0  0x00007ffff585c8a5 in raise () from /lib64/libc.so.6
#1  0x00007ffff585e00d in abort () from /lib64/libc.so.6
#2  0x00007ffff4f831e5 in assert_botch_abend (f=0x7ffff0a15e61 "../common/Collections.cpp", l=866, m=<value optimized out>, 
    c=<value optimized out>) at ../export/NAAbort.cpp:235
#3  0x00007ffff09dc630 in NAList<ElemDDLColDef*>::operator[] (this=0x7fffcc1dc6e8, i=4294967295) at ../common/Collections.cpp:866
#4  0x00007ffff09db09f in CmpSeabaseDDL::createSeabaseTable (this=0x7fffffff31f0, createTableNode=0x7fffcc1dc520, currCatName=..., 
    currSchName=...) at ../sqlcomp/CmpSeabaseDDLtable.cpp:408
#5  0x00007ffff09cd46e in CmpSeabaseDDL::executeSeabaseDDL (this=0x7fffffff31f0, ddlExpr=0x7fffcc1dd3d8, ddlNode=0x7fffcc1dc520, 
    currCatName=..., currSchName=...) at ../sqlcomp/CmpSeabaseDDLcommon.cpp:2629
#6  0x00007fffee86714b in CmpStatement::process (this=<value optimized out>, statement=<value optimized out>)
    at ../arkcmp/CmpStatement.cpp:888
#7  0x00007fffee85c6e0 in CmpContext::compileDirect (this=0x7fffe6284090, data=0x7fffe6e392d0 "\200", data_len=1112, outHeap=
    0x7ffff7ebf648, charset=15, op=<value optimized out>, gen_code=@0x7fffffff37a0, gen_code_len=@0x7fffffff37ac, parserFlags=0, 
    diagsArea=0x7fffe6e39730) at ../arkcmp/CmpContext.cpp:563
#8  0x00007ffff4413620 in ExDDLTcb::work (this=0x7fffe6e1e430) at ../executor/ex_ddl.cpp:253
#9  0x00007ffff44d84a3 in ExScheduler::work (this=0x7fffe6e1df98, prevWaitTime=<value optimized out>)
    at ../executor/ExScheduler.cpp:316
#10 0x00007ffff4450f42 in ex_root_tcb::execute (this=0x7fffe6e1ea08, cliGlobals=0xba1250, glob=0x7fffe6e37bd8, input_desc=
    0x7fffe6e5a330, diagsArea=@0x7fffffff4e90, reExecute=0) at ../executor/ex_root.cpp:1014
#11 0x00007ffff5603794 in CliStatement::execute (this=0x7fffe6e28960, cliGlobals=0xba1250, input_desc=0x7fffe6e5a330, 
    diagsArea=<value optimized out>, execute_state=<value optimized out>, fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4738
#12 0x00007ffff55c7eca 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=0xba1250, tasks=4882, statement_id=0x182e4d0, 
    input_descriptor=0x1b65590, output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffffff5030, 
    input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3323
#13 0x00007ffff55c8bf2 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:3570
#14 0x00007ffff560f12a in SQL_EXEC_Exec (statement_id=0x182e4d0, input_descriptor=0x1b65590, num_ptr_pairs=0)
    at ../cli/CliExtern.cpp:2050
#15 0x00007ffff79b7fdb in SqlCmd::doExec (sqlci_env=0xb975e0, stmt=0x182e4d0, prep_stmt=<value optimized out>, 
    numUnnamedParams=<value optimized out>, unnamedParamArray=<value optimized out>, 
    unnamedParamCharSetArray=<value optimized out>, handleError=1) at ../sqlci/SqlCmd.cpp:1692
#16 0x00007ffff79b8949 in SqlCmd::do_execute (sqlci_env=0xb975e0, prep_stmt=0x1b65470, numUnnamedParams=0, unnamedParamArray=0x0, 
    unnamedParamCharSetArray=0x0, prepcode=0) at ../sqlci/SqlCmd.cpp:2023
#17 0x00007ffff79b907d in DML::process (this=0x1b65420, sqlci_env=0xb975e0) at ../sqlci/SqlCmd.cpp:2794
#18 0x00007ffff79a5cd6 in SqlciEnv::executeCommands (this=0xb975e0, input_stmt=@0x7fffffff6a08) at ../sqlci/SqlciEnv.cpp:837
#19 0x00007ffff79a7d7b in SqlciEnv::run (this=0xb975e0) at ../sqlci/SqlciEnv.cpp:646
#20 0x0000000000401a76 in main (argc=1, argv=0x7fffffff6bd8) at ../bin/SqlciMain.cpp:303
(gdb)



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