[
https://issues.apache.org/jira/browse/TRAFODION-200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696304#comment-14696304
]
Atanu Mishra commented on TRAFODION-200:
----------------------------------------
Weishiun Tsai (wei-shiun-tsai) wrote on 2014-07-15: #3
Download full text (4.5 KiB)
Verified on the v0.8.3rc1 build, this problem has been fixed:
>>set schema mytest;
--- 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 i6dva...
Read more...
Changed in trafodion:
status: Fix Committed → Fix Released
> 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
> Fix For: 1.0 (pre-incubation)
>
>
> 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)
