[TRAFODION-746] LP Bug: 1390274 - sqlci inconsistent select output

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: client-ci
• External issue URL: https://bugs.launchpad.net/bugs/1390274
• Assignee: Anoop Sharma
• Reporter: Apache Trafodion
• Created: 22/Jul/15 18:17
• Updated: 31/Aug/15 05:35
• Resolved: 31/Aug/15 05:35

Description

– This is the table DDL:

CREATE TABLE TRAFODION.TPCDS.BJDETAIL
(
CASEID CHAR(14) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, COL_NAME VARCHAR(1000) CHARACTER SET ISO88591
COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, COL_VALUE VARCHAR(7000) CHARACTER SET ISO88591
COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, PRIMARY KEY (CASEID ASC, COL_NAME ASC, COL_VALUE ASC)
)
SALT USING 4 PARTITIONS
;

– First I do a count:
>>select count from bjdetail;
..

(EXPR)
--------------------

8309

— 1 row(s) selected.

– I then select the top CaseID value and get a ? back
>>SELECT MAX(CaseID) FROM tpcds.bjdetail
+>;

(EXPR)
--------------

?

— 1 row(s) selected.

– I then select the CaseID from all rows and 0 is returned:
>>SELECT CaseID FROM tpcds.bjdetail
..
>>;
..

— 0 row(s) selected.

– I then select the first row using the field col_name and get a core dump:
>>select [first 1] caseid from bjdetail;

— 0 row(s) selected.
>>select [first 1] col_name from bjdetail;
#

1. A fatal error has been detected by the Java Runtime Environment:
   #
2. SIGSEGV (0xb) at pc=0x00007f25698aa94f, pid=15042, tid=139798547789728
   #
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 [libexecutor.so+0x1ad94f] ExHbaseAccessTcb::createSQRowFromHbaseFormat()+0x33f
   #
7. Core dump written. Default location: /home/trafodion/core or core.15042
   #
8. An error report file with more information is saved as:
9. /home/trafodion/hs_err_pid15042.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)

– the core dump core.15042 is located here:
/home/trafodion

System access information is:
16.145.80.111
trafodion
traf123

– this is the bt from the core dump:
(gdb) bt
#0 0x0000003515232925 in raise () from /lib64/libc.so.6
#1 0x000000351523408d in abort () from /lib64/libc.so.6
#2 0x00007f256b758a55 in os::abort(bool) ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#3 0x00007f256b8d8f87 in VMError::report_and_die() ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#4 0x00007f256b75d96f in JVM_handle_linux_signal ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 ExHbaseAccessTcb::createSQRowFromHbaseFormat (this=0x7f255e202e00)
at ../executor/ExHbaseAccess.cpp:1085
#7 0x00007f25698aac16 in ExHbaseAccessTcb::createSQRowDirect (
this=<value optimized out>) at ../executor/ExHbaseAccess.cpp:959
#8 0x00007f25698b140d in ExHbaseScanSQTaskTcb::work (this=0x7f255e20f580,
rc=@0x7fffdfeb394e) at ../executor/ExHbaseSelect.cpp:448
#9 0x00007f25698b0dff in ExHbaseAccessSelectTcb::work (this=0x7f255e202e00)
at ../executor/ExHbaseSelect.cpp:1283
#10 0x00007f25698c8eb3 in ExScheduler::work (this=0x7f255e202968,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#11 0x00007f256983be42 in ex_root_tcb::execute (this=0x7f255e260c18,
cliGlobals=0x268fe80, glob=0x7f255e20da98, input_desc=0x7f255e24f2b0,
diagsArea=@0x7fffdfeb5030, reExecute=0) at ../executor/ex_root.cpp:1034
#12 0x00007f256a85520c in CliStatement::execute (this=0x7f255e2295b0,
cliGlobals=0x268fe80, input_desc=0x7f255e24f2b0,
diagsArea=<value optimized out>, execute_state=<value optimized out>,
fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4746
#13 0x00007f256a818c5a 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=0x268fe80, tasks=4882,
statement_id=0x36ee1f0, input_descriptor=0x348d100, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffdfeb51d0,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3280
#14 0x00007f256a819982 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:3527
#15 0x00007f256a861435 in SQL_EXEC_Exec (statement_id=0x36ee1f0,
input_descriptor=0x348d100, num_ptr_pairs=0) at ../cli/CliExtern.cpp:2062
#16 0x00007f256c23e38b in SqlCmd::doExec (sqlci_env=0x268e680, stmt=0x36ee1f0,
prep_stmt=<value optimized out>, numUnnamedParams=<value optimized out>,
unnamedParamArray=<value optimized out>,
unnamedParamCharSetArray=<value optimized out>, handleError=1)
--Type <return> to continue, or q <return> to quit--
at ../sqlci/SqlCmd.cpp:1706
#17 0x00007f256c23ed82 in SqlCmd::do_execute (sqlci_env=0x268e680,
prep_stmt=0x3590bb0, numUnnamedParams=0, unnamedParamArray=0x0,
unnamedParamCharSetArray=0x0, prepcode=0) at ../sqlci/SqlCmd.cpp:2042
#18 0x00007f256c23f4ad in DML::process (this=0x2e77440, sqlci_env=0x268e680)
at ../sqlci/SqlCmd.cpp:2816
#19 0x00007f256c22bfe6 in SqlciEnv::executeCommands (this=0x268e680,
input_stmt=@0x7fffdfeb6bc8) at ../sqlci/SqlciEnv.cpp:847
#20 0x00007f256c22e08b in SqlciEnv::run (this=0x268e680)
at ../sqlci/SqlciEnv.cpp:656
#21 0x0000000000401ab1 in main (argc=1, argv=0x7fffdfeb6d98)
at ../bin/SqlciMain.cpp:319
(gdb)