[
https://issues.apache.org/jira/browse/TRAFODION-255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-255.
----------------------------------
Resolution: Fixed
Assignee: (was: Anoop Sharma)
Fix Version/s: 1.0 (pre-incubation)
0.9 (pre-incubation)
> 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
> Priority: Critical
> Fix For: 0.9 (pre-incubation), 1.0 (pre-incubation)
>
>
> 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)
