You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:18:02 UTC
[jira] [Created] (TRAFODION-746) LP Bug: 1390274 - sqlci
inconsistent select output
Alice Chen created TRAFODION-746:
------------------------------------
Summary: 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)