[
https://issues.apache.org/jira/browse/TRAFODION-298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708673#comment-14708673
]
Atanu Mishra commented on TRAFODION-298:
----------------------------------------
Anoop Sharma (anoop-sharma) on 2014-05-30
Changed in trafodion:
status: In Progress → Fix Committed
Julie Thai (julie-y-thai) wrote on 2014-06-02: #1
Verified on traf_0601:
>>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;
--- 0 row(s) inserted.
Julie Thai (julie-y-thai) on 2014-06-02
Changed in trafodion:
status: Fix Committed → Fix Released
> 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
> Fix For: 0.8 (pre-incubation)
>
>
> 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)
