Alice Chen created TRAFODION-262:
------------------------------------
Summary: LP Bug: 1318788 - create salt table with key on interval
column dumps core.
Key: TRAFODION-262
URL: https://issues.apache.org/jira/browse/TRAFODION-262
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Julie Thai
Assignee: Pavani Puppala
Priority: Critical
Create salt table keyed on interval columns generates core on datalake_64_1
v40125.
/opt/home/thaiju/lpbxxxx: sqlci
Trafodion Conversational Interface 0.7.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>drop table f00salt;
*** ERROR[1389] Object TRAFODION.SEABASE.F00SALT does not exist in Trafodion.
--- SQL operation failed with errors.
>>
>>create table f00( cola int not null, colb interval day not null, colc
>>varchar(20) character set ucs2 not null, primary key (cola, colb));
--- SQL operation complete.
>>
>>create table f00salt(cola int not null, colb interval day not null, colc
>>varchar(20) character set ucs2 not null, primary key (cola, colb)) salt using
>>13 partitions;
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007ffff014d919, pid=31366, tid=140737179590592
#
# 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 [liboptimizer.so+0x48f919] buildEncodeTree(desc_struct*, desc_struct*,
NAString*, Generator*, ComDiagsArea*)+0x3f9
#
# Core dump written. Default location: /opt/home/thaiju/lpbxxxx/core or
core.31366
#
# An error report file with more information is saved as:
# /opt/home/thaiju/lpbxxxx/hs_err_pid31366.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)
To reproduce:
1. drop table f00salt;
2. create table f00salt(
cola int not null,
colb interval day not null,
colc varchar(20) character set ucs2 not null,
primary key (cola, colb))
salt using 13 partitions;
reproduced on workstation:
MY_SQROOT=/opt/home/thaiju/datalake_64_1
who@[email protected]
JAVA_HOME=/opt/home/tools/jdk1.7.0_09_64
linux=2.6.32-279.el6.x86_64
redhat=6.3
Release 0.7.0 (Build release [40125], branch 40125-project/datalake_64_1, date
06May14)
Attached tar containing:
-reproducible script
-log generated from repro script
-core.g4t3029.houston.hp.com.31366.sqlci
-hs_err_pid31366.log
Callstack from core.g4t3029.houston.hp.com.31366.sqlci:
Core was generated by `sqlci'.
Program terminated with signal 6, Aborted.
#0 0x00000033088328a5 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.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 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
qpid-cpp-client-0.14-16.el6.x86_64 zlib-1.2.3-27.el6.x86_64
(gdb) where
#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 0x00007ffff014d919 in size (column=0x7fffd47fd5d8, key=0x7fffd47fd958,
dataBuffer=0x0, generator=0x7ffffffeee80, diagsArea=0x7fffe8384008)
at ../export/FBString.h:803
#7 size (column=0x7fffd47fd5d8, key=0x7fffd47fd958, dataBuffer=0x0,
generator=0x7ffffffeee80, diagsArea=0x7fffe8384008) at
../export/FBString.h:1388
#8 length (column=0x7fffd47fd5d8, key=0x7fffd47fd958, dataBuffer=0x0,
generator=0x7ffffffeee80, diagsArea=0x7fffe8384008)
at ../export/NAStringDef.h:404
#9 operator+= (column=0x7fffd47fd5d8, key=0x7fffd47fd958, dataBuffer=0x0,
generator=0x7ffffffeee80, diagsArea=0x7fffe8384008)
at ../export/NAStringDef.h:545
#10 buildEncodeTree (column=0x7fffd47fd5d8, key=0x7fffd47fd958, dataBuffer=0x0,
generator=0x7ffffffeee80, diagsArea=0x7fffe8384008)
at ../optimizer/EncodedKeyValue.cpp:215
#11 0x00007ffff0150588 in encodeKeyValues (column_descs=0x7fffd47fd0f8,
key_descs=<value optimized out>, inValuesArray=<value optimized out>,
encodedKeyBuffer=0x7fffd47fd000 "", h=0x7fffd47ee098,
diagsArea=0x7fffe8384008)
at ../optimizer/EncodedKeyValue.cpp:361
#12 0x00007ffff18d888f in CmpSeabaseDDL::createSeabaseTable
(this=0x7fffffff1cd0,
createTableNode=<value optimized out>, currCatName=..., currSchName=...)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:1292
#13 0x00007ffff18c245d in CmpSeabaseDDL::executeSeabaseDDL (this=0x7fffffff1cd0,
ddlExpr=<value optimized out>, ddlNode=0x7fffd47faca0, currCatName=...,
currSchName=...) at ../sqlcomp/CmpSeabaseDDLcommon.cpp:3586
#14 0x00007fffef72261d in CmpStatement::process (this=<value optimized out>,
statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:892
#15 0x00007fffef718e10 in CmpContext::compileDirect (this=0x7fffe8383090,
data=0x7fffe8f29bf8 "\200", data_len=320, outHeap=0x7fffe998a648,
charset=15,
op=<value optimized out>, gen_code=@0x7fffffff2280,
gen_code_len=@0x7fffffff228c, parserFlags=0, diagsArea=0x7fffe8f29d40)
at ../arkcmp/CmpContext.cpp:563
#16 0x00007ffff4f1b4c0 in ExDDLTcb::work (this=0x7fffe8f1d3e8)
at ../executor/ex_ddl.cpp:253
#17 0x00007ffff4fe5243 in ExScheduler::work (this=0x7fffe8f1cf50,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:316
#18 0x00007ffff4f58e92 in ex_root_tcb::execute (this=0x7fffe8f1d9c0,
cliGlobals=0xba2b70, glob=0x7fffe8f28820, input_desc=0x7fffe8f27698,
diagsArea=@0x7fffffff3970, reExecute=0) at ../executor/ex_root.cpp:1014
#19 0x00007ffff61175d4 in CliStatement::execute (this=0x7fffe8f27918,
cliGlobals=0xba2b70, input_desc=0x7fffe8f27698,
diagsArea=<value optimized out>, execute_state=<value optimized out>,
fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4738
#20 0x00007ffff60db8aa in SQLCLI_PerformTasks(CliGlobals *, ULng32, SQLSTMT_ID
*, SQL
DESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag __va_list_tag *,
SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *) (cliGlobals=0xba2b70, tasks=4882,
statement_id=0x1648580, input_descriptor=0xba3ea0, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffffff3b10,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3325
#21 0x00007ffff60dc5d2 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:3572
#22 0x00007ffff612309a in SQL_EXEC_Exec (statement_id=0x1648580,
input_descriptor=0xba3ea0, num_ptr_pairs=0) at ../cli/CliExtern.cpp:2050
#23 0x00007ffff7bd6fcb in SqlCmd::doExec (sqlci_env=0xb97c30, stmt=0x1648580,
prep_stmt=<value optimized out>, numUnnamedParams=<value optimized out>,
unnamedParamArray=<value optimized out>,
unnamedParamCharSetArray=<value optimized out>, handleError=1)
at ../sqlci/SqlCmd.cpp:1692
#24 0x00007ffff7bd7939 in SqlCmd::do_execute (sqlci_env=0xb97c30,
prep_stmt=0x18ddd10, numUnnamedParams=0, unnamedParamArray=0x0,
unnamedParamCharSetArray=0x0, prepcode=0) at ../sqlci/SqlCmd.cpp:2023
#25 0x00007ffff7bd806d in DML::process (this=0x14f67b0, sqlci_env=0xb97c30)
at ../sqlci/SqlCmd.cpp:2794
#26 0x00007ffff7bbe914 in Obey::process (this=0x1b2b3f0,
sqlci_env=<value optimized out>) at ../sqlci/Obey.cpp:252
#27 0x00007ffff7bc4cc6 in SqlciEnv::executeCommands (this=0xb97c30,
input_stmt=@0x7fffffff5578) at ../sqlci/SqlciEnv.cpp:837
#28 0x00007ffff7bc6d6b in SqlciEnv::run (this=0xb97c30) at
../sqlci/SqlciEnv.cpp:646
#29 0x0000000000401a76 in main (argc=1, argv=0x7fffffff5748)
at ../bin/SqlciMain.cpp:303
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
