create table with foreign-key, referential constraint generates tdm_arkcmp core
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Committed
|
High
|
Mike Hanlon |
Bug Description
Create table with foreign key constraint intermittently produces tdm_arkcmp core. Script attempts to execute many ddl statements and must be run in its entirety to reproduce issue. Issue occurs more often via sqlci.
Encountered on traf_20140606_0930, 4-node cluster.
To reproduce, extract contents of attachment:
1. ./cleanup
2. ./repro_it
from log:
>>Create table T5(O int,
+>P smallint,
+>Q largeint,
+>R numeric(9,3)not null not droppable,
+>S decimal(18,9),
+>T char(20),
+>U float(52),
+>V real,
+>W double precision,
+>X timestamp,
+>Y interval year to month ,
+>Z char (12),
+>AA time not null not droppable, primary key(R,AA));
--- SQL operation complete.
>>
>>Create table T6 (O int default null,
+> P smallint default null,
+> Q largeint default null,
+> R numeric(9,3) not null ,
+> S decimal(18,9) default null,
+> T char(20) default null,
+> U float(52) default null,
+> V real default null,
+> W double precision default null,
+> X timestamp default null,
+> Y interval year to month default null ,
+> Z char (12) default null,
+> AA time not null primary key droppable)
+> attribute extent 256;
--- SQL operation complete.
>>
>>Create table T7 (R Numeric(9,3),AA Time, FOREIGN KEY(R,AA) REFERENCES T5
+> );
*** ERROR[1389] Object T5_699928485_4973 does not exist in Trafodion.
*** ERROR[8838] Unable to receive reply from Compiler, possibly caused by internal errors when compiling SQL statements, processing DDL statements, or executing the builtin stored procedures.
*** ERROR[1029] Object TRAFODION.
*** ERROR[1029] Object TRAFODION.MYSCH.T7 could not be created.
--- SQL operation failed with errors.
From stdout:
>>Create table T7 (R Numeric(9,3),AA Time, FOREIGN KEY(R,AA) REFERENCES T5
+> );
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f8bfd
#
# JRE version: OpenJDK Runtime Environment (7.0_55-b13) (build 1.7.0_55-
# Java VM: OpenJDK 64-Bit Server VM (24.51-b03 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [liboptimizer.
#
# Core dump written. Default location: /home/trafodion
#
# An error report file with more information is saved as:
# /tmp/jvm-
#
# If you would like to submit a bug report, please include
# instructions on how to reproduce the bug and visit:
# http://
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f7ad3
#
# JRE version: OpenJDK Runtime Environment (7.0_55-b13) (build 1.7.0_55-
# Java VM: OpenJDK 64-Bit Server VM (24.51-b03 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [liboptimizer.
#
# Core dump written. Default location: /home/trafodion
#
# An error report file with more information is saved as:
# /tmp/jvm-
#
# If you would like to submit a bug report, please include
# instructions on how to reproduce the bug and visit:
# http://
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f21f4
#
# JRE version: OpenJDK Runtime Environment (7.0_55-b13) (build 1.7.0_55-
# Java VM: OpenJDK 64-Bit Server VM (24.51-b03 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [liboptimizer.
#
# Core dump written. Default location: /home/trafodion
#
# An error report file with more information is saved as:
# /tmp/jvm-
#
# If you would like to submit a bug report, please include
# instructions on how to reproduce the bug and visit:
# http://
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007fd387
#
# JRE version: OpenJDK Runtime Environment (7.0_55-b13) (build 1.7.0_55-
# Java VM: OpenJDK 64-Bit Server VM (24.51-b03 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [liboptimizer.
#
# Core dump written. Default location: /home/trafodion
#
# An error report file with more information is saved as:
# /tmp/jvm-
#
# If you would like to submit a bug report, please include
# instructions on how to reproduce the bug and visit:
# http://
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
*** ERROR[1389] Object T5_699928485_4973 does not exist in Trafodion.
*** ERROR[8838] Unable to receive reply from Compiler, possibly caused by internal errors when compiling SQL statements, processing DDL statements, or executing the builtin stored procedures.
*** ERROR[1029] Object TRAFODION.
*** ERROR[1029] Object TRAFODION.MYSCH.T7 could not be created.
--- SQL operation failed with errors.
Stacktrace from core file:
#0 0x0000003fc0832925 in raise () from /lib64/libc.so.6
#1 0x0000003fc0834105 in abort () from /lib64/libc.so.6
#2 0x00007f8bf9abe8c5 in ?? () from /usr/lib/
#3 0x00007f8bf9c2c78f in ?? () from /usr/lib/
#4 0x00007f8bf9ac3a92 in JVM_handle_
from /usr/lib/
#5 <signal handler called>
#6 0x00007f8bfd94da56 in createConstrain
columnArray
0x7f8be6595ca0, bindWA=
#7 0x00007f8bfd94f8b9 in NATable::NATable (this=0x7f8be64
corrName=..., heap=0x7f8be659
at ../optimizer/
#8 0x00007f8bfd9586b9 in NATableDB::get (this=0x7f8befc
bindWA=
#9 0x00007f8bfd6c0aea in BindWA::getNATable (this=0x7fff19e
catmanColle
#10 0x00007f8c0092e300 in CmpSeabaseDDL:
createIndex
at ../sqlcomp/
#11 0x00007f8c00903b62 in CmpSeabaseDDL:
0x7f8be6596288, ddlNode=
at ../sqlcomp/
#12 0x00007f8bfca81ce4 in CmpStatement:
at ../arkcmp/
#13 0x00007f8bfca6e4c5 in ExCmpMessage:
at ../arkcmp/
#14 0x00007f8bffe60fa5 in IpcMessageStrea
buffer=
#15 0x00007f8bffe5eecb in IpcMessageBuffe
at ../common/
#16 0x00007f8bffe72fb4 in GuaConnectionTo
buffer=
#17 0x00007f8bffe749cb in GuaReceiveContr
eventConsum
#18 0x00007f8bffe723d2 in GuaConnectionTo
eventConsum
#19 0x00007f8bffe5d35d in IpcSetOfConnect
calledByESP=0, timedout=0x0) at ../common/
#20 0x00007f8bffe605eb in IpcMessageStrea
at ../common/
#21 0x00007f8bffe60559 in IpcMessageStrea
at ../common/
#22 0x0000000000407b8c in main (argc=2, argv=0x7fff19f0
Changed in trafodion: | |
assignee: | nobody → Pavani Puppala (pavani-puppala) |
Changed in trafodion: | |
milestone: | none → r0.9 |
Changed in trafodion: | |
assignee: | Pavani Puppala (pavani-puppala) → Mike Hanlon (mike-hanlon) |
status: | New → Fix Committed |
This bug is mostly the same problem as /bugs.launchpad .net/trafodion/ +bug/1328271 --- got mxosrvr core while allowing constraint as a reference object to be dropped
https:/
This bug is not reproducible easily but bug 1328271 is reproducible easily, so it is better to debug the other one to find the root cause.