[TRAFODION-918] LP Bug: 1412983 - Create table like view cores sqlci at hbaseCreateOptions()

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.0 (pre-incubation)
• Component/s: sql-cmu
• External issue URL: https://bugs.launchpad.net/bugs/1412983
• Assignee: Hans Zeller
• Reporter: Weishiun Tsai
• Created: 22/Jul/15 18:18
• Updated: 31/Aug/15 04:20
• Resolved: 31/Aug/15 04:05

Description

A create table … like view … statement currently crashes sqlci and generates a core at hbaseCreateOptions(). This is seen on the v0117 build.

-----------------------------------------------------

Here is the entire script to reproduce this problem:

create schema mytest;
set schema mytest;

create table mytab1 (a int);
create view myview1 as select a from mytab1;
create table mytab2 like myview1;

drop schema mytest cascade;

-----------------------------------------------------

Here is the execution output:

>>create schema mytest;

— SQL operation complete.
>>set schema mytest;

— SQL operation complete.
>>
>>create table mytab1 (a int);

— SQL operation complete.
>>create view myview1 as select a from mytab1;

— SQL operation complete.
>>create table mytab2 like myview1;
#

1. A fatal error has been detected by the Java Runtime Environment:
   #
2. SIGSEGV (0xb) at pc=0x00007fffeff24d85, pid=18522, tid=140737353869344
   #
3. JRE version: Java(TM) SE Runtime Environment (7.0_67-b01) (build 1.7.0_67-b01)
4. Java VM: Java HotSpot(TM) 64-Bit Server VM (24.65-b04 mixed mode linux-amd64 compressed oops)
5. Problematic frame:
6. C [libsqlcomp.so+0x84d85] CmpDescribeSeabaseTable(CorrName const&, short, char*&, unsigned int&, NAMemory*, char const*, int, int, int, int)+0x1635
   #
7. Core dump written. Default location: /opt/home/trafodion/v0117/sql/scripts/core or core.18522
   #
8. An error report file with more information is saved as:
9. /opt/home/trafodion/v0117/sql/scripts/hs_err_pid18522.log
   #
10. If you would like to submit a bug report, please visit:
11. http://bugreport.sun.com/bugreport/crash.jsp
12. The crash happened outside the Java Virtual Machine in native code.
13. See problematic frame for where to report the bug.
    #
    Aborted (core dumped)

-----------------------------------------------------

Here is the stack trace of the core

(gdb) bt
#0 0x00007ffff57108a5 in raise () from /lib64/libc.so.6
#1 0x00007ffff571200d in abort () from /lib64/libc.so.6
#2 0x00007ffff6f04a55 in os::abort(bool) ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff7084f87 in VMError::report_and_die() ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff6f0996f in JVM_handle_linux_signal ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 0x00007fffeff24d85 in hbaseCreateOptions (dtName=..., type=3,
outbuf=@0x7ffffffef860, outbuflen=@0x7ffffffef86c, heap=0x7fffd5364e80,
pkeyStr=0x0, withPartns=0, withoutSalt=0, withoutDivisioning=0,
noTrailingSemi=1) at ../optimizer/NAFileSet.h:169
#7 hbaseCreateOptions (dtName=..., type=3, outbuf=@0x7ffffffef860,
outbuflen=@0x7ffffffef86c, heap=0x7fffd5364e80, pkeyStr=0x0, withPartns=0,
withoutSalt=0, withoutDivisioning=0, noTrailingSemi=1)
at ../optimizer/NATable.h:774
#8 CmpDescribeSeabaseTable (dtName=..., type=3, outbuf=@0x7ffffffef860,
outbuflen=@0x7ffffffef86c, heap=0x7fffd5364e80, pkeyStr=0x0, withPartns=0,
withoutSalt=0, withoutDivisioning=0, noTrailingSemi=1)
at ../sqlcomp/CmpDescribe.cpp:2790
#9 0x00007fffeffcf5f6 in CmpSeabaseDDL::createSeabaseTableLike (
this=<value optimized out>, createTableNode=<value optimized out>,
currCatName=<value optimized out>, currSchName=<value optimized out>)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:295
#10 0x00007fffeffd14e2 in CmpSeabaseDDL::createSeabaseTable (
this=0x7fffffff2f80, createTableNode=0x7fffd53232c0, currCatName=...,
currSchName=...) at ../sqlcomp/CmpSeabaseDDLtable.cpp:1081
#11 0x00007fffeff7776b in CmpSeabaseDDL::executeSeabaseDDL (
this=0x7fffffff2f80, ddlExpr=0x7fffd5322868, ddlNode=0x7fffd53232c0,
currCatName=..., currSchName=...)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:6649
#12 0x00007ffff4abc85c in CmpStatement::process (this=<value optimized out>,
statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:931
#13 0x00007ffff4ab0546 in CmpContext::compileDirect (this=0x7fffe5eab090,
data=0x7fffe6a51f70 "\200", data_len=192, outHeap=0x7ffff7ee1128,
charset=15, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffffff3980,
gen_code_len=@0x7fffffff398c, parserFlags=0, diagsArea=0x7fffe6a52038)
at ../arkcmp/CmpContext.cpp:717
#14 0x00007ffff3e2f056 in ExDDLTcb::work (this=0x7fffe6a57cd0)
at ../executor/ex_ddl.cpp:265
#15 0x00007ffff3f5d553 in ExScheduler::work (this=0x7fffe6a57838,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#16 0x00007ffff3e8b462 in ex_root_tcb::execute (this=0x7fffe6a582a8,
cliGlobals=0xb7de80, glob=0x7fffe6a51938, input_desc=0x7fffe6a9aba8,
diagsArea=@0x7fffffff50b0, reExecute=0) at ../executor/ex_root.cpp:1055
#17 0x00007ffff549c554 in CliStatement::execute (this=0x7fffe6a36bd0,
cliGlobals=0xb7de80, input_desc=0x7fffe6a9aba8,
diagsArea=<value optimized out>, execute_state=<value optimized out>,
fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4812
#18 0x00007ffff5444d0a 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=0xb7de80, tasks=4882,
statement_id=0x148c1b0, input_descriptor=0xf0c450, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffffff5250,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3284
#19 0x00007ffff5445a32 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:3531
#20 0x00007ffff54ab10a in SQL_EXEC_Exec (statement_id=0x148c1b0,
input_descriptor=0xf0c450, num_ptr_pairs=0) at ../cli/CliExtern.cpp:2071
#21 0x00007ffff77ae39b in SqlCmd::doExec (sqlci_env=0xb7cc30, stmt=0x148c1b0,
prep_stmt=<value optimized out>, numUnnamedParams=<value optimized out>,
unnamedParamArray=<value optimized out>,
unnamedParamCharSetArray=<value optimized out>, handleError=1)
at ../sqlci/SqlCmd.cpp:1706
#22 0x00007ffff77aed92 in SqlCmd::do_execute (sqlci_env=0xb7cc30,
prep_stmt=0x1fe84e0, numUnnamedParams=0, unnamedParamArray=0x0,
unnamedParamCharSetArray=0x0, prepcode=0) at ../sqlci/SqlCmd.cpp:2042
#23 0x00007ffff77af4bd in DML::process (this=0x1e2ba30, sqlci_env=0xb7cc30)
at ../sqlci/SqlCmd.cpp:2816
#24 0x00007ffff7795ad4 in Obey::process (this=0x1ffb900,
sqlci_env=<value optimized out>) at ../sqlci/Obey.cpp:264
#25 0x00007ffff779bff6 in SqlciEnv::executeCommands (this=0xb7cc30,
input_stmt=@0x7fffffff6cd8) at ../sqlci/SqlciEnv.cpp:847
#26 0x00007ffff779e09b in SqlciEnv::run (this=0xb7cc30)
at ../sqlci/SqlciEnv.cpp:656
#27 0x0000000000401ad9 in main (argc=1, argv=0x7fffffff6ea8)
at ../bin/SqlciMain.cpp:328