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:15:23 UTC
[jira] [Created] (TRAFODION-255) LP Bug: 1317736 - Update statement
crashes sqlci with a core at HbaseAccessUMDTcb::work()
Alice Chen created TRAFODION-255:
------------------------------------
Summary: LP Bug: 1317736 - Update statement crashes sqlci with a core at HbaseAccessUMDTcb::work()
Key: TRAFODION-255
URL: https://issues.apache.org/jira/browse/TRAFODION-255
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Weishiun Tsai
Assignee: Anoop Sharma
Priority: Critical
The following sequence of statements crashes sqlci with a core at HbaseAccessUMDTcb::work(). This is fairly reproducible on the datalake v40174 build installed on a workstation.
Here is the entire script to reproduce this problem:
log mytest.log clear;
drop view VWTAB6c;
drop view VWTAB6d;
drop table table6c cascade;
drop table table6d cascade;
CREATE TABLE TABLE6c(Col_var1 VARCHAR(30) NOT NULL,
Col_fix2 CHAR(20),
Col_var3 VARCHAR(20),
Col_fix4 INT,
Col_var5 VARCHAR(30),
Col_fix6 DECIMAL(5,1) SIGNED,
Col_var7 VARCHAR(30),
Col_fix8 LARGEINT,
Col_var9 VARCHAR(25),
Col_fix10 NUMERIC(10),
Col_var11 Varchar(40) NOT NULL,
Col_fix12 SMALLINT,
PRIMARY KEY (Col_var1, Col_var11))
STORE BY PRIMARY KEY;
CREATE TABLE TABLE6d(Col_var1 VARCHAR(30),
Col_fix2 CHAR(10),
Col_var3 VARCHAR(20),
Col_fix4 INT,
Col_var5 VARCHAR(25),
Col_fix6 DECIMAL(5,1) SIGNED,
Col_var7 VARCHAR(50),
Col_fix8 LARGEINT,
Col_var9 VARCHAR(25),
Col_fix10 NUMERIC(10),
Col_var11 VARCHAR(30),
Col_var12 VARCHAR(35)
) no partition;
CREATE VIEW VWTAB6c AS SELECT * FROM TABLE6c;
CREATE VIEW VWTAB6d AS SELECT * FROM TABLE6d;
CREATE INDEX i6cvar7 ON TABLE6c(col_var7);
CREATE INDEX i6cvar9 ON TABLE6c(col_var9);
CREATE INDEX i6cvar11 ON TABLE6c(col_var11);
CREATE INDEX i6dvar1 ON TABLE6d(col_var1);
CREATE INDEX i6dvar3 ON TABLE6d(col_var3);
CREATE INDEX i6dvar5 ON TABLE6d(col_var5);
CREATE INDEX i6dvar7 ON TABLE6d(col_var7);
CREATE INDEX i6dvar9 ON TABLE6d(col_var9);
CREATE INDEX i6dvar11 ON TABLE6d(col_var11);
CREATE INDEX i6dvar12 ON TABLE6d(col_var12);
INSERT INTO TABLE6c VALUES('Karen',
'XIONG',
'Female',
001,
'LOC251',
2200,
'San Jose State',
980520,
'China',
94,
'Texas',
1997
);
INSERT INTO TABLE6c VALUES('Lalitha',
'Maruvada',
'Female',
002,
'LOC252',
2130,
'University of Colorado',
970320,
'India',
93,
'Colorado',
1997
);
INSERT INTO TABLE6c VALUES('Jerry',
'Zheng',
'Male',
003,
'LOC201',
1320,
'Cornell University',
960302,
'Taiwan',
92,
'New York',
1995
);
INSERT INTO TABLE6d VALUES('Karen',
'XIONG',
'Female',
001,
'LOC251',
2200,
'San Jose State',
980520,
'China',
94,
'Texas',
'University relations'
);
INSERT INTO TABLE6d VALUES('Lalitha',
'Maruvada',
'Female',
002,
'LOC252',
2130,
'University of Colorado',
970320,
'India',
93,
'Colorado',
'Job Fair'
);
INSERT INTO TABLE6d VALUES('Jerry',
'Zheng',
'Male',
003,
'LOC201',
1320,
'Cornell University',
960302,
'Taiwan',
92,
'New York',
'Internal Transfer'
);
UPDATE TABLE6c
SET col_fix2 = 'LAST_NAME',
col_var3= 'GENGER',
col_var5 = 'LOCATION',
col_var7 = 'SCHOOL',
col_var9 = 'COUNTRY'
WHERE EXISTS
(select TABLE6c.col_fix8 from TABLE6c, TABLE6d
where TABLE6c.col_fix8 = TABLE6d.col_fix8)
;
drop view VWTAB6c;
drop view VWTAB6d;
drop table table6c cascade;
drop table table6d cascade;
====================================================
Here is the output of the script execution:
>>obey mytest.sql;
>>log mytest.log clear;
>>
>>drop view VWTAB6c;
--- SQL operation complete.
>>drop view VWTAB6d;
--- SQL operation complete.
>>drop table table6c cascade;
--- SQL operation complete.
>>drop table table6d cascade;
--- SQL operation complete.
>>
>>CREATE TABLE TABLE6c(Col_var1 VARCHAR(30) NOT NULL,
+>Col_fix2 CHAR(20),
+>Col_var3 VARCHAR(20),
+>Col_fix4 INT,
+>Col_var5 VARCHAR(30),
+>Col_fix6 DECIMAL(5,1) SIGNED,
+>Col_var7 VARCHAR(30),
+>Col_fix8 LARGEINT,
+>Col_var9 VARCHAR(25),
+>Col_fix10 NUMERIC(10),
+>Col_var11 Varchar(40) NOT NULL,
+>Col_fix12 SMALLINT,
+>PRIMARY KEY (Col_var1, Col_var11))
+>STORE BY PRIMARY KEY;
--- SQL operation complete.
>>
>>CREATE TABLE TABLE6d(Col_var1 VARCHAR(30),
+>Col_fix2 CHAR(10),
+>Col_var3 VARCHAR(20),
+>Col_fix4 INT,
+>Col_var5 VARCHAR(25),
+>Col_fix6 DECIMAL(5,1) SIGNED,
+>Col_var7 VARCHAR(50),
+>Col_fix8 LARGEINT,
+>Col_var9 VARCHAR(25),
+>Col_fix10 NUMERIC(10),
+>Col_var11 VARCHAR(30),
+>Col_var12 VARCHAR(35)
+>) no partition;
--- SQL operation complete.
>>
>>CREATE VIEW VWTAB6c AS SELECT * FROM TABLE6c;
--- SQL operation complete.
>>CREATE VIEW VWTAB6d AS SELECT * FROM TABLE6d;
--- SQL operation complete.
>>CREATE INDEX i6cvar7 ON TABLE6c(col_var7);
--- SQL operation complete.
>>CREATE INDEX i6cvar9 ON TABLE6c(col_var9);
--- SQL operation complete.
>>CREATE INDEX i6cvar11 ON TABLE6c(col_var11);
--- SQL operation complete.
>>CREATE INDEX i6dvar1 ON TABLE6d(col_var1);
--- SQL operation complete.
>>CREATE INDEX i6dvar3 ON TABLE6d(col_var3);
--- SQL operation complete.
>>CREATE INDEX i6dvar5 ON TABLE6d(col_var5);
--- SQL operation complete.
>>CREATE INDEX i6dvar7 ON TABLE6d(col_var7);
--- SQL operation complete.
>>CREATE INDEX i6dvar9 ON TABLE6d(col_var9);
--- SQL operation complete.
>>CREATE INDEX i6dvar11 ON TABLE6d(col_var11);
--- SQL operation complete.
>>CREATE INDEX i6dvar12 ON TABLE6d(col_var12);
--- SQL operation complete.
>>
>>INSERT INTO TABLE6c VALUES('Karen',
+>'XIONG',
+>'Female',
+>001,
+>'LOC251',
+>2200,
+>'San Jose State',
+>980520,
+>'China',
+>94,
+>'Texas',
+>1997
+>);
--- 1 row(s) inserted.
>>
>>INSERT INTO TABLE6c VALUES('Lalitha',
+>'Maruvada',
+>'Female',
+>002,
+>'LOC252',
+>2130,
+>'University of Colorado',
+>970320,
+>'India',
+>93,
+>'Colorado',
+>1997
+>);
--- 1 row(s) inserted.
>>
>>INSERT INTO TABLE6c VALUES('Jerry',
+>'Zheng',
+>'Male',
+>003,
+>'LOC201',
+>1320,
+>'Cornell University',
+>960302,
+>'Taiwan',
+>92,
+>'New York',
+>1995
+>);
--- 1 row(s) inserted.
>>
>>INSERT INTO TABLE6d VALUES('Karen',
+>'XIONG',
+>'Female',
+>001,
+>'LOC251',
+>2200,
+>'San Jose State',
+>980520,
+>'China',
+>94,
+>'Texas',
+>'University relations'
+>);
--- 1 row(s) inserted.
>>
>>INSERT INTO TABLE6d VALUES('Lalitha',
+>'Maruvada',
+>'Female',
+>002,
+>'LOC252',
+>2130,
+>'University of Colorado',
+>970320,
+>'India',
+>93,
+>'Colorado',
+>'Job Fair'
+>);
--- 1 row(s) inserted.
>>
>>INSERT INTO TABLE6d VALUES('Jerry',
+>'Zheng',
+>'Male',
+>003,
+>'LOC201',
+>1320,
+>'Cornell University',
+>960302,
+>'Taiwan',
+>92,
+>'New York',
+>'Internal Transfer'
+>);
--- 1 row(s) inserted.
>>
>>UPDATE TABLE6c
+>SET col_fix2 = 'LAST_NAME',
+>col_var3= 'GENGER',
+>col_var5 = 'LOCATION',
+>col_var7 = 'SCHOOL',
+>col_var9 = 'COUNTRY'
+>WHERE EXISTS
+>(select TABLE6c.col_fix8 from TABLE6c, TABLE6d
+>where TABLE6c.col_fix8 = TABLE6d.col_fix8)
+>;
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007ffff4cdcc1e, pid=4573, tid=140737165994240
#
# 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 [libexecutor.so+0x2bdc1e] ExHbaseAccessUMDTcb::work()+0xea
#
# Core dump written. Default location: /opt/home/wtsai/dlv40174d/sql/scripts/core or core.4573
#
# An error report file with more information is saved as:
# /opt/home/wtsai/dlv40174d/sql/scripts/hs_err_pid4573.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)
====================================================
Here is the stack of the sqlci core:
(gdb) bt
#0 0x00000039e28328a5 in raise () from /lib64/libc.so.6
#1 0x00000039e2834085 in abort () from /lib64/libc.so.6
#2 0x00007ffff6cb4455 in os::abort(bool) ()
from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff6e14717 in VMError::report_and_die() ()
from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff6cb7f60 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 0x00007ffff4cdcc1e in ExHbaseAccessUMDTcb::work (this=0x7fffd3fd08e8)
at ../executor/ExHbaseIUD.cpp:3298
#7 0x00007ffff4beb4bb in ex_tcb::sWork (tcb=0x7fffd3fd08e8)
at ../executor/ex_tcb.h:87
#8 0x00007ffff4cf1437 in ExSubtask::work (this=0x7fffd3fd1020)
at ../executor/ExScheduler.cpp:739
#9 0x00007ffff4cf07fa in ExScheduler::work (this=0x7fffe8221f60,
prevWaitTime=33821833) at ../executor/ExScheduler.cpp:316
#10 0x00007ffff4c2c81b in ex_root_tcb::fetch (this=0x7fffd3d7d9e0,
cliGlobals=0xba3b00, glob=0x7fffe823b708, output_desc=0x0,
diagsArea=@0x7fffffff4688, timeLimit=-1, newOperation=1,
closeCursorOnError=@0x7fffffff4684) at ../executor/ex_root.cpp:1812
#11 0x00007ffff604b683 in CliStatement::fetch (this=0x7fffe822c930,
cliGlobals=0xba3b00, output_desc=0x0, diagsArea=..., newOperation=1)
at ../cli/Statement.cpp:4953
#12 0x00007ffff5ff2b2e 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=0xba3b00, tasks=8063,
statement_id=0x2934110, input_descriptor=0x0, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffffff4960,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3423
#13 0x00007ffff5ff39d1 in SQLCLI_ClearExecFetchClose(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *) (cliGlobals=0xba3b00,
statement_id=0x2934110, input_descriptor=0x0, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0,
ap=0x7fffffff4960, input_ptr_pairs=0x0, output_ptr_pairs=0x0)
at ../cli/Cli.cpp:3816
#14 0x00007ffff605ecb1 in SQL_EXEC_ClearExecFetchClose (
statement_id=0x2934110, input_descriptor=0x0, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
at ../cli/CliExtern.cpp:2606
#15 0x00007ffff7bbc35a in SqlCmd::doClearExecFetchClose (sqlci_env=0xb9c460,
stmt=0x2934110, prep_stmt=0x1498520, numUnnamedParams=0,
unnamedParamArray=0x0, unnamedParamCharSetArray=0x0, handleError=1)
at ../sqlci/SqlCmd.cpp:1750
#16 0x00007ffff7bbcdbc in SqlCmd::do_execute (sqlci_env=0xb9c460,
prep_stmt=0x1498520, numUnnamedParams=0, unnamedParamArray=0x0,
unnamedParamCharSetArray=0x0, prepcode=0) at ../sqlci/SqlCmd.cpp:2004
#17 0x00007ffff7bbf0df in DML::process (this=0x14952f0, sqlci_env=0xb9c460)
at ../sqlci/SqlCmd.cpp:2794
#18 0x00007ffff7ba0900 in Obey::process (this=0xba4e60, sqlci_env=0xb9c460)
at ../sqlci/Obey.cpp:252
#19 0x00007ffff7ba960e in SqlciEnv::executeCommands (this=0xb9c460,
input_stmt=@0x7fffffff6278) at ../sqlci/SqlciEnv.cpp:837
#20 0x00007ffff7ba8d4f in SqlciEnv::run (this=0xb9c460)
at ../sqlci/SqlciEnv.cpp:646
#21 0x0000000000401f51 in main (argc=1, argv=0x7fffffff6438)
at ../bin/SqlciMain.cpp:303
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)