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:11 UTC
[jira] [Created] (TRAFODION-200) LP Bug: 1295431 - Update a table
with indexes causes sqlci to core at ExScheduler::work()
Alice Chen created TRAFODION-200:
------------------------------------
Summary: LP Bug: 1295431 - Update a table with indexes causes sqlci to core at ExScheduler::work()
Key: TRAFODION-200
URL: https://issues.apache.org/jira/browse/TRAFODION-200
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Weishiun Tsai
Assignee: Anoop Sharma
Priority: Critical
An update statement causes sqlci to core at ExScheduler::work(). This only happens when a number of indexes are created on the table to be updated. The following output shows two parts. The 1st part shows that the update stmt runs fine when indexes are NOT created for the table. The 2nd part shows that the update stmt causes sqlci to core when indexes are created for the table.
The stack of the core file is shown at the end. This is seen on the beta 0.7.0 RC1 build installed on a workstation.
>>obey test.sql;
>>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));
--- SQL operation complete.
>>
>>INSERT INTO TABLE6c VALUES('Karen', 'XIONG', 'Female', 001, 'LOC251', 2200, 'San Jose State', 980520, 'China', 94, 'Texas', 1997),
+>('Lalitha', 'Maruvada', 'Female', 002, 'LOC252', 2130, 'University of Colorado', 970320, 'India', 93, 'Colorado', 1997),
+>('Jerry', 'Zheng', 'Male', 003, 'LOC201', 1320, 'Cornell University', 960302, 'Taiwan', 92, 'New York', 1995);
--- 3 row(s) inserted.
>>
>>INSERT INTO TABLE6d VALUES
+>('Karen', 'XIONG', 'Female', 001, 'LOC251', 2200, 'San Jose State', 980520, 'China', 94, 'Texas', 'University relations'),
+>('Lalitha', 'Maruvada', 'Female', 002, 'LOC252', 2130, 'University of Colorado', 970320, 'India', 93, 'Colorado', 'Job Fair'),
+>('Jerry', 'Zheng', 'Male', 003, 'LOC201', 1320, 'Cornell University', 960302, 'Taiwan', 92, 'New York', 'Internal Transfer');
--- 3 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);
--- 3 row(s) updated.
=============================================================================================================
>>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));
--- 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),
+>('Lalitha', 'Maruvada', 'Female', 002, 'LOC252', 2130, 'University of Colorado', 970320, 'India', 93, 'Colorado', 1997),
+>('Jerry', 'Zheng', 'Male', 003, 'LOC201', 1320, 'Cornell University', 960302, 'Taiwan', 92, 'New York', 1995);
--- 3 row(s) inserted.
>>
>>INSERT INTO TABLE6d VALUES
+>('Karen', 'XIONG', 'Female', 001, 'LOC251', 2200, 'San Jose State', 980520, 'China', 94, 'Texas', 'University relations'),
+>('Lalitha', 'Maruvada', 'Female', 002, 'LOC252', 2130, 'University of Colorado', 970320, 'India', 93, 'Colorado', 'Job Fair'),
+>('Jerry', 'Zheng', 'Male', 003, 'LOC201', 1320, 'Cornell University', 960302, 'Taiwan', 92, 'New York', 'Internal Transfer');
--- 3 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=0x00007ffff4ff1934, pid=28839, tid=140737180245824
#
# 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+0x1bb934] ExScheduler::work(long)+0x634
#
# Core dump written. Default location: /opt/home/wtsai/beta070rc1/sql/scripts/core or core.28839
#
# An error report file with more information is saved as:
# /opt/home/wtsai/beta070rc1/sql/scripts/hs_err_pid28839.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 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 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 0x00007ffff4ff1934 in ExScheduler::work (this=0x7fffe8fbba00,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:478
#7 0x00007ffff4f68e93 in ex_root_tcb::fetch (this=0x7fff9a5e49c0,
cliGlobals=<value optimized out>, glob=0x7fffe8fd7e30, output_desc=0x0,
diagsArea=@0x7fffffff5480, timeLimit=-1, newOperation=1,
closeCursorOnError=@0x7fffffff548c) at ../executor/ex_root.cpp:1775
#8 0x00007ffff611a157 in CliStatement::fetch (this=0x7fffe8fc63c8,
cliGlobals=0xba1050, output_desc=0x0, diagsArea=..., newOperation=1)
at ../cli/Statement.cpp:4953
#9 0x00007ffff60dcf4f 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=0xba1050, tasks=8063,
statement_id=0xdbd480, input_descriptor=0x0, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffffff5620,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3413
#10 0x00007ffff6123299 in SQL_EXEC_ClearExecFetchClose (statement_id=0xdbd480,
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:2554
#11 0x00007ffff7bd6e35 in SqlCmd::doClearExecFetchClose (sqlci_env=0xb96f20,
stmt=0xdbd480, prep_stmt=0xec6570, numUnnamedParams=<value optimized out>,
unnamedParamArray=<value optimized out>,
unnamedParamCharSetArray=<value optimized out>, handleError=1)
at ../sqlci/SqlCmd.cpp:1750
#12 0x00007ffff7bd7433 in SqlCmd::do_execute (sqlci_env=0xb96f20,
prep_stmt=0xec6570, numUnnamedParams=0, unnamedParamArray=0x0,
unnamedParamCharSetArray=0x0, prepcode=0) at ../sqlci/SqlCmd.cpp:2004
#13 0x00007ffff7bd807d in DML::process (this=0x1b63970, sqlci_env=0xb96f20)
at ../sqlci/SqlCmd.cpp:2794
#14 0x00007ffff7bbe924 in Obey::process (this=0x1e79d70,
sqlci_env=<value optimized out>) at ../sqlci/Obey.cpp:252
#15 0x00007ffff7bc4cd6 in SqlciEnv::executeCommands (this=0xb96f20,
input_stmt=@0x7fffffff6e98) at ../sqlci/SqlciEnv.cpp:837
#16 0x00007ffff7bc6d7b in SqlciEnv::run (this=0xb96f20)
at ../sqlci/SqlciEnv.cpp:646
#17 0x0000000000401a76 in main (argc=1, argv=0x7fffffff7068)
at ../bin/SqlciMain.cpp:303
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)