You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/31 07:36:49 UTC
[jira] [Closed] (TRAFODION-746) LP Bug: 1390274 - sqlci
inconsistent select output
[ https://issues.apache.org/jira/browse/TRAFODION-746?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-746.
------------------------------------
Resolution: Fixed
Close issues in JIRA to reflect status in LaunchPad
> LP Bug: 1390274 - sqlci inconsistent select output
> --------------------------------------------------
>
> Key: TRAFODION-746
> URL: https://issues.apache.org/jira/browse/TRAFODION-746
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-ci
> Reporter: Apache Trafodion
> Assignee: Anoop Sharma
>
> -- 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;
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007f25698aa94f, pid=15042, tid=139798547789728
> #
> # JRE version: Java(TM) SE Runtime Environment (7.0_67-b01) (build 1.7.0_67-b01)
> # Java VM: Java HotSpot(TM) 64-Bit Server VM (24.65-b04 mixed mode linux-amd64 compressed oops)
> # Problematic frame:
> # C [libexecutor.so+0x1ad94f] ExHbaseAccessTcb::createSQRowFromHbaseFormat()+0x33f
> #
> # Core dump written. Default location: /home/trafodion/core or core.15042
> #
> # An error report file with more information is saved as:
> # /home/trafodion/hs_err_pid15042.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)
> -- 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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)