[ 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)