[
https://issues.apache.org/jira/browse/TRAFODION-253?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708611#comment-14708611
]
Atanu Mishra commented on TRAFODION-253:
----------------------------------------
Anoop Sharma (anoop-sharma) on 2014-05-30
Changed in trafodion:
status: In Progress → Fix Committed
Weishiun Tsai (wei-shiun-tsai) wrote on 2014-05-30: #1
Verified on the GIT 0529_1530 build. This problem has been fixed:
>> set schema mytest2;
--- SQL operation complete.
>>
>> drop table Female_actors cascade;
*** ERROR[1389] Object TRAFODION.MYTEST2.FEMALE_ACTORS does not exist in
Trafodion.
--- SQL operation failed with errors.
>> drop table Male_actors cascade;
*** ERROR[1389] Object TRAFODION.MYTEST2.MALE_ACTORS does not exist in
Trafodion.
--- SQL operation failed with errors.
>> drop table Directors cascade;
*** ERROR[1389] Object TRAFODION.MYTEST2.DIRECTORS does not exist in Trafodion.
--- SQL operation failed with errors.
>> drop table Movie_titles cascade;
*** ERROR[1389] Object TRAFODION.MYTEST2.MOVIE_TITLES does not exist in
Trafodion.
--- SQL operation failed with errors.
>>
>> create table Female_actors (
+> f_no int not null not droppable,
+> f_name varchar(30) not null,
+> f_realname varchar(50) default null,
+> f_birthday date constraint md1 check (f_birthday > date '1900-01-01'),
+> primary key (f_no)
+> );
--- SQL operation complete.
>>
>>
>> create table Male_actors (
+> m_no int not null not droppable unique,
+> m_name varchar(30) not null,
+> m_realname varchar(50) default null,
+> m_birthday date constraint md2 check (m_birthday > date '1900-01-01')
+> ) no partition;
--- SQL operation complete.
>>
>> create table Directors (
+> d_no int not null not droppable,
+> d_name varchar(30) not null,
+> "d_specialty" varchar(15) not null unique,
+> primary key (d_no),
+> constraint td1 check ("d_specialty" <> 'Music Video'),
+> unique (d_no, "d_specialty")
+> );
--- SQL operation complete.
>>
>>
>> Create table Movie_titles (
+> mv_no int not null not droppable,
+> mv_name varchar (40) not null,
+> mv_malestar int default NULL constraint ma_fk
+> references male_actors(m_no),
+> mv_femalestar int default NULL,
+> mv_director int default 0 not null,
+> mv_yearmade int check (mv_yearmade > 1901),
+> mv_star_rating char(4),
+> mv_movietype varchar(15),
+> primary key (mv_no),
+> constraint fa_fk foreign key (mv_femalestar)
+> references female_actors,
+> constraint d_fk foreign key (mv_director, mv_movietype)
+> references directors (d_no, "d_specialty")
+> );
--- SQL operation complete.
>>
>> insert into male_actors values (1444,'Mike Myers','Mike Myers',date
>> '1963-05-23');
--- 1 row(s) inserted.
>> insert into male_actors values (6555,'Jimmy Stewart','James Maitland
>> Stewart',date '1908-05-20');
--- 1 row(s) inserted.
>> delete from male_actors where m_no = 6555;
--- 1 row(s) deleted.
>>
>> drop table Female_actors cascade;
--- SQL operation complete.
>> drop table Male_actors cascade;
--- SQL operation complete.
>> drop table Directors cascade;
--- SQL operation complete.
>> drop table Movie_titles cascade;
--- SQL operation complete.
Changed in trafodion:
status: Fix Committed → Fix Released
> LP Bug: 1317709 - Delete from a table with constraints crashes
> sqlci/tdm_arkcmp with cores
> ------------------------------------------------------------------------------------------
>
> Key: TRAFODION-253
> URL: https://issues.apache.org/jira/browse/TRAFODION-253
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Assignee: Anoop Sharma
> Priority: Critical
>
> The following sequence of statements crashed sqlci at the delete statement
> with a core at ExHbaseAccessTcb::setupUniqueKeyAndCols(). After that, the
> database entered into an inconsistent state. Dropping and recreating the
> same tables complained about duplicate unique constraints and generated
> tdm_arkcmp cores at reateConstraintInfo()
> This is seen on the datalake build v40174 installed on a workstation.
> Here is the entire script to reproduce it:
> -bash-4.1$ cat mytest.sql
> log mytest.log;
> set schema mytest2;
> drop table Female_actors cascade;
> drop table Male_actors cascade;
> drop table Directors cascade;
> drop table Movie_titles cascade;
> create table Female_actors (
> f_no int not null not droppable,
> f_name varchar(30) not null,
> f_realname varchar(50) default null,
> f_birthday date constraint md1 check (f_birthday > date '1900-01-01'),
> primary key (f_no)
> );
> create table Male_actors (
> m_no int not null not droppable unique,
> m_name varchar(30) not null,
> m_realname varchar(50) default null,
> m_birthday date constraint md2 check (m_birthday > date '1900-01-01')
> ) no partition;
> create table Directors (
> d_no int not null not droppable,
> d_name varchar(30) not null,
> "d_specialty" varchar(15) not null unique,
> primary key (d_no),
> constraint td1 check ("d_specialty" <> 'Music Video'),
> unique (d_no, "d_specialty")
> );
> Create table Movie_titles (
> mv_no int not null not droppable,
> mv_name varchar (40) not null,
> mv_malestar int default NULL constraint ma_fk
> references male_actors(m_no),
> mv_femalestar int default NULL,
> mv_director int default 0 not null,
> mv_yearmade int check (mv_yearmade > 1901),
> mv_star_rating char(4),
> mv_movietype varchar(15),
> primary key (mv_no),
> constraint fa_fk foreign key (mv_femalestar)
> references female_actors,
> constraint d_fk foreign key (mv_director, mv_movietype)
> references directors (d_no, "d_specialty")
> );
> insert into male_actors values (1444,'Mike Myers','Mike Myers',date
> '1963-05-23');
> insert into male_actors values (6555,'Jimmy Stewart','James Maitland
> Stewart',date '1908-05-20');
> delete from male_actors where m_no = 6555;
> drop table Female_actors cascade;
> drop table Male_actors cascade;
> drop table Directors cascade;
> drop table Movie_titles cascade;
> =================================================================================
> Here is the output of the 1st run with the sqlci core:
> >>obey mytest.sql;
> >>log mytest.log;
> >>
> >>set schema mytest2;
> --- SQL operation complete.
> >>
> >>drop table Female_actors cascade;
> *** ERROR[1389] Object TRAFODION.MYTEST2.FEMALE_ACTORS does not exist in
> Trafodion.
> --- SQL operation failed with errors.
> >>drop table Male_actors cascade;
> *** ERROR[1389] Object TRAFODION.MYTEST2.MALE_ACTORS does not exist in
> Trafodion.
> --- SQL operation failed with errors.
> >>drop table Directors cascade;
> *** ERROR[1389] Object TRAFODION.MYTEST2.DIRECTORS does not exist in
> Trafodion.
> --- SQL operation failed with errors.
> >>drop table Movie_titles cascade;
> *** ERROR[1389] Object TRAFODION.MYTEST2.MOVIE_TITLES does not exist in
> Trafodion.
> --- SQL operation failed with errors.
> >>
> >>create table Female_actors (
> +>f_no int not null not droppable,
> +>f_name varchar(30) not null,
> +>f_realname varchar(50) default null,
> +>f_birthday date constraint md1 check (f_birthday > date '1900-01-01'),
> +>primary key (f_no)
> +>);
> --- SQL operation complete.
> >>
> >>
> >>create table Male_actors (
> +>m_no int not null not droppable unique,
> +>m_name varchar(30) not null,
> +>m_realname varchar(50) default null,
> +>m_birthday date constraint md2 check (m_birthday > date '1900-01-01')
> +>) no partition;
> --- SQL operation complete.
> >>
> >>create table Directors (
> +>d_no int not null not droppable,
> +>d_name varchar(30) not null,
> +>"d_specialty" varchar(15) not null unique,
> +>primary key (d_no),
> +>constraint td1 check ("d_specialty" <> 'Music Video'),
> +>unique (d_no, "d_specialty")
> +>);
> --- SQL operation complete.
> >>
> >>
> >>Create table Movie_titles (
> +>mv_no int not null not droppable,
> +>mv_name varchar (40) not null,
> +>mv_malestar int default NULL constraint ma_fk
> +>references male_actors(m_no),
> +>mv_femalestar int default NULL,
> +>mv_director int default 0 not null,
> +>mv_yearmade int check (mv_yearmade > 1901),
> +>mv_star_rating char(4),
> +>mv_movietype varchar(15),
> +>primary key (mv_no),
> +>constraint fa_fk foreign key (mv_femalestar)
> +>references female_actors,
> +>constraint d_fk foreign key (mv_director, mv_movietype)
> +>references directors (d_no, "d_specialty")
> +>);
> --- SQL operation complete.
> >>
> >>insert into male_actors values (1444,'Mike Myers','Mike Myers',date
> >>'1963-05-23');
> --- 1 row(s) inserted.
> >>insert into male_actors values (6555,'Jimmy Stewart','James Maitland
> >>Stewart',date '1908-05-20');
> --- 1 row(s) inserted.
> >>delete from male_actors where m_no = 6555;
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007ffff4cc9818, pid=689, 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+0x2aa818]
> ExHbaseAccessTcb::setupUniqueKeyAndCols(int)+0x66
> #
> # Core dump written. Default location:
> /opt/home/wtsai/dlv40174d/sql/scripts/core or core.689
> #
> # An error report file with more information is saved as:
> # /opt/home/wtsai/dlv40174d/sql/scripts/hs_err_pid689.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)
> 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 0x00007ffff4cc9818 in ExHbaseAccessTcb::setupUniqueKeyAndCols (
> this=0x7fffe8222e30, doInit=0) at ../executor/ExHbaseAccess.cpp:1442
> #7 0x00007ffff4cdd88e in ExHbaseAccessSQRowsetTcb::work (this=0x7fffe8222e30)
> at ../executor/ExHbaseIUD.cpp:3632
> #8 0x00007ffff4beb4bb in ex_tcb::sWork (tcb=0x7fffe8222e30)
> at ../executor/ex_tcb.h:87
> #9 0x00007ffff4cf1437 in ExSubtask::work (this=0x7fffe82236d8)
> at ../executor/ExScheduler.cpp:739
> #10 0x00007ffff4cf07fa in ExScheduler::work (this=0x7fffe8221f60,
> prevWaitTime=0) at ../executor/ExScheduler.cpp:316
> #11 0x00007ffff4c2b097 in ex_root_tcb::execute (this=0x7fffe82257c0,
> cliGlobals=0xba3af0, glob=0x7fffe823e948, input_desc=0x0,
> diagsArea=@0x7fffffff4370, reExecute=0) at ../executor/ex_root.cpp:1014
> #12 0x00007ffff604ad6f in CliStatement::execute (this=0x7fffe822c930,
> cliGlobals=0xba3af0, input_desc=0x0, diagsArea=...,
> execute_state=CliStatement::INITIAL_STATE_, fixupOnly=0, cliflags=0)
> at ../cli/Statement.cpp:4738
> #13 0x00007ffff5ff2733 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=0xba3af0, tasks=8063,
> statement_id=0x20668c0, 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:3325
> #14 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=0xba3af0,
> statement_id=0x20668c0, 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
> #15 0x00007ffff605ecb1 in SQL_EXEC_ClearExecFetchClose (
> statement_id=0x20668c0, 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
> #16 0x00007ffff7bbc35a in SqlCmd::doClearExecFetchClose (sqlci_env=0xb9c460,
> stmt=0x20668c0, prep_stmt=0x1b72e70, numUnnamedParams=0,
> unnamedParamArray=0x0, unnamedParamCharSetArray=0x0, handleError=1)
> at ../sqlci/SqlCmd.cpp:1750
> #17 0x00007ffff7bbcdbc in SqlCmd::do_execute (sqlci_env=0xb9c460,
> prep_stmt=0x1b72e70, numUnnamedParams=0, unnamedParamArray=0x0,
> unnamedParamCharSetArray=0x0, prepcode=0) at ../sqlci/SqlCmd.cpp:2004
> #18 0x00007ffff7bbf0df in DML::process (this=0xd1cab0, sqlci_env=0xb9c460)
> at ../sqlci/SqlCmd.cpp:2794
> #19 0x00007ffff7ba0900 in Obey::process (this=0xba4e50, sqlci_env=0xb9c460)
> at ../sqlci/Obey.cpp:252
> #20 0x00007ffff7ba960e in SqlciEnv::executeCommands (this=0xb9c460,
> input_stmt=@0x7fffffff6278) at ../sqlci/SqlciEnv.cpp:837
> #21 0x00007ffff7ba8d4f in SqlciEnv::run (this=0xb9c460)
> at ../sqlci/SqlciEnv.cpp:646
> #22 0x0000000000401f51 in main (argc=1, argv=0x7fffffff6438)
> at ../bin/SqlciMain.cpp:303
> =================================================================================
> Here is the output of the 2nd run with the tdm_arkcmp cores:
> >>
> >>set schema mytest2;
> --- SQL operation complete.
> >>
> >>drop table Female_actors cascade;
> --- SQL operation complete.
> >>drop table Male_actors cascade;
> --- SQL operation complete.
> >>drop table Directors cascade;
> --- SQL operation complete.
> >>drop table Movie_titles cascade;
> --- SQL operation complete.
> >>
> >>create table Female_actors (
> +>f_no int not null not droppable,
> +>f_name varchar(30) not null,
> +>f_realname varchar(50) default null,
> +>f_birthday date constraint md1 check (f_birthday > date '1900-01-01'),
> +>primary key (f_no)
> +>);
> --- SQL operation complete.
> >>
> >>
> >>create table Male_actors (
> +>m_no int not null not droppable unique,
> +>m_name varchar(30) not null,
> +>m_realname varchar(50) default null,
> +>m_birthday date constraint md2 check (m_birthday > date '1900-01-01')
> +>) no partition;
> *** ERROR[1254] Duplicate unique constraints are not allowed with same set of
> columns.
> *** ERROR[8811] Trying to close a statement that is either not in the open
> state or has not reached EOF.
> *** ERROR[4082] Object TRAFODION.MYTEST2.MOVIE_TITLES does not exist or is
> inaccessible.
> *** ERROR[4082] Object TRAFODION.MYTEST2.MOVIE_TITLES does not exist or is
> inaccessible.
> *** ERROR[8811] Trying to close a statement that is either not in the open
> state or has not reached EOF.
> *** ERROR[8811] Trying to close a statement that is either not in the open
> state or has not reached EOF.
> --- SQL operation failed with errors.
> >>
> >>
> >>create table Directors (
> +>d_no int not null not droppable,
> +>d_name varchar(30) not null,
> +>"d_specialty" varchar(15) not null unique,
> +>primary key (d_no),
> +>constraint td1 check ("d_specialty" <> 'Music Video'),
> +>unique (d_no, "d_specialty")
> +>);
> *** ERROR[1254] Duplicate unique constraints are not allowed with same set of
> columns.
> *** ERROR[8811] Trying to close a statement that is either not in the open
> state or has not reached EOF.
> *** ERROR[4082] Object TRAFODION.MYTEST2.MOVIE_TITLES does not exist or is
> inaccessible.
> *** ERROR[4082] Object TRAFODION.MYTEST2.MOVIE_TITLES does not exist or is
> inaccessible.
> *** ERROR[8811] Trying to close a statement that is either not in the open
> state or has not reached EOF.
> *** ERROR[8811] Trying to close a statement that is either not in the open
> state or has not reached EOF.
> --- SQL operation failed with errors.
> >>
> >>
> >>Create table Movie_titles (
> +>mv_no int not null not droppable,
> +>mv_name varchar (40) not null,
> +>mv_malestar int default NULL constraint ma_fk
> +>references male_actors(m_no),
> +>mv_femalestar int default NULL,
> +>mv_director int default 0 not null,
> +>mv_yearmade int check (mv_yearmade > 1901),
> +>mv_star_rating char(4),
> +>mv_movietype varchar(15),
> +>primary key (mv_no),
> +>constraint fa_fk foreign key (mv_femalestar)
> +>references female_actors,
> +>constraint d_fk foreign key (mv_director, mv_movietype)
> +>references directors (d_no, "d_specialty")
> +>);
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007ffff4d88051, pid=4747, tid=140737170876672
> #
> # 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 [liboptimizer.so+0x7a3051] createConstraintInfo(desc_struct const*,
> QualifiedName const&, NAColumnArray const&, CheckConstraintList&,
> AbstractRIConstraintList&, AbstractRIConstraintList&, NAMemory*,
> BindWA*)+0x233
> #
> # Core dump written. Default location:
> /opt/home/wtsai/dlv40174d/sql/scripts/core or core.4747
> #
> # An error report file with more information is saved as:
> # /opt/home/wtsai/dlv40174d/sql/scripts/hs_err_pid4747.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.
> #
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007ffff4d88051, pid=6563, tid=140737170876672
> #
> # 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 [liboptimizer.so+0x7a3051] createConstraintInfo(desc_struct const*,
> QualifiedName const&, NAColumnArray const&, CheckConstraintList&,
> AbstractRIConstraintList&, AbstractRIConstraintList&, NAMemory*,
> BindWA*)+0x233
> #
> # Core dump written. Default location:
> /opt/home/wtsai/dlv40174d/sql/scripts/core or core.6563
> #
> # An error report file with more information is saved as:
> # /opt/home/wtsai/dlv40174d/sql/scripts/hs_err_pid6563.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.
> #
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007ffff4d88051, pid=6900, tid=140737170876672
> #
> # 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 [liboptimizer.so+0x7a3051] createConstraintInfo(desc_struct const*,
> QualifiedName const&, NAColumnArray const&, CheckConstraintList&,
> AbstractRIConstraintList&, AbstractRIConstraintList&, NAMemory*,
> BindWA*)+0x233
> #
> # Core dump written. Default location:
> /opt/home/wtsai/dlv40174d/sql/scripts/core or core.6900
> #
> # An error report file with more information is saved as:
> # /opt/home/wtsai/dlv40174d/sql/scripts/hs_err_pid6900.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.
> #
> #
> # A fatal error has been detected by the Java Runtime Environment:
> #
> # SIGSEGV (0xb) at pc=0x00007ffff4d88051, pid=7358, tid=140737170876672
> #
> # 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 [liboptimizer.so+0x7a3051] createConstraintInfo(desc_struct const*,
> QualifiedName const&, NAColumnArray const&, CheckConstraintList&,
> AbstractRIConstraintList&, AbstractRIConstraintList&, NAMemory*,
> BindWA*)+0x233
> #
> # Core dump written. Default location:
> /opt/home/wtsai/dlv40174d/sql/scripts/core or core.7358
> #
> # An error report file with more information is saved as:
> # /opt/home/wtsai/dlv40174d/sql/scripts/hs_err_pid7358.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.
> #
> *** ERROR[1389] Object MALE_ACTORS_227812755_4578 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[8811] Trying to close a statement that is either not in the open
> state or has not reached EOF.
> *** ERROR[8811] Trying to close a statement that is either not in the open
> state or has not reached EOF.
> --- SQL operation failed with errors.
> >>
> >>insert into male_actors values (1444,'Mike Myers','Mike Myers',date
> >>'1963-05-23');
> *** ERROR[4082] Object TRAFODION.MYTEST2.MALE_ACTORS does not exist or is
> inaccessible.
> *** ERROR[8822] The statement was not prepared.
> >>insert into male_actors values (6555,'Jimmy Stewart','James Maitland
> >>Stewart',date '1908-05-20');
> *** ERROR[4082] Object TRAFODION.MYTEST2.MALE_ACTORS does not exist or is
> inaccessible.
> *** ERROR[8822] The statement was not prepared.
> >>delete from male_actors where m_no = 6555;
> *** ERROR[4082] Object TRAFODION.MYTEST2.MALE_ACTORS does not exist or is
> inaccessible.
> *** ERROR[8822] The statement was not prepared.
> >>
> >>drop table Female_actors cascade;
> --- SQL operation complete.
> >>drop table Male_actors cascade;
> *** ERROR[1389] Object TRAFODION.MYTEST2.MALE_ACTORS does not exist in
> Trafodion.
> --- SQL operation failed with errors.
> >>drop table Directors cascade;
> *** ERROR[1389] Object TRAFODION.MYTEST2.DIRECTORS does not exist in
> Trafodion.
> --- SQL operation failed with errors.
> >>drop table Movie_titles cascade;
> *** ERROR[1389] Object TRAFODION.MYTEST2.MOVIE_TITLES does not exist in
> Trafodion.
> --- SQL operation failed with errors.
> An example stack of the tdm_arkcmp cores:
> (gdb) bt
> #0 0x00000039e28328a5 in raise () from /lib64/libc.so.6
> #1 0x00000039e2834085 in abort () from /lib64/libc.so.6
> #2 0x00007ffff0e9a455 in os::abort(bool) ()
> from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
> #3 0x00007ffff0ffa717 in VMError::report_and_die() ()
> from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
> #4 0x00007ffff0e9df60 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 0x00007ffff4d88051 in createConstraintInfo (table_desc=0x7fffd9e5e8e0,
> tableQualName=..., columnArray=..., checkConstraints=...,
> uniqueConstraints=..., refConstraints=..., heap=0x7fffd9e55628,
> bindWA=0x7fffffff8370) at ../optimizer/NATable.cpp:4433
> #7 0x00007ffff4d89f6f in NATable::NATable (this=0x7fffd9e5f610,
> bindWA=0x7fffffff8370, corrName=..., heap=0x7fffd9e55628,
> inTableDesc=0x7fffd9e5e8e0) at ../optimizer/NATable.cpp:4901
> #8 0x00007ffff4d92a1a in NATableDB::get (this=0x7fffe7b3ab48, corrName=...,
> bindWA=0x7fffffff8370, inTableDescStruct=0x0)
> at ../optimizer/NATable.cpp:7247
> #9 0x00007ffff4b025b6 in BindWA::getNATable (this=0x7fffffff8370,
> corrName=..., catmanCollectTableUsages=1, inTableDescStruct=0x0)
> at ../optimizer/BindRelExpr.cpp:1431
> #10 0x00007ffff7d2d443 in CmpSeabaseDDL::createSeabaseIndex (
> this=0x7fffffffa9e0, createIndexNode=0x7fffd9c1b308, currCatName=...,
> currSchName=...) at ../sqlcomp/CmpSeabaseDDLindex.cpp:168
> #11 0x00007ffff7d07a34 in CmpSeabaseDDL::executeSeabaseDDL (
> this=0x7fffffffa9e0, ddlExpr=0x7fffd9c1ba30, ddlNode=0x7fffd9c1b308,
> currCatName=..., currSchName=...)
> at ../sqlcomp/CmpSeabaseDDLcommon.cpp:3618
> #12 0x00007ffff3edf2e3 in CmpStatement::process (this=0x7fffd9e806f0,
> statement=...) at ../arkcmp/CmpStatement.cpp:892
> #13 0x00007ffff3ecca03 in ExCmpMessage::actOnReceive (this=0x7fffffffbbf0)
> at ../arkcmp/CmpConnection.cpp:386
> #14 0x00007ffff727c9c1 in IpcMessageStream::internalActOnReceive (
> this=0x7fffffffbbf0, buffer=0x12439a0, connection=0xbc71c0)
> at ../common/Ipc.cpp:3541
> #15 0x00007ffff727a8e7 in IpcMessageBuffer::callReceiveCallback (
> this=0x12439a0, conn=0xbc71c0) at ../common/Ipc.cpp:2415
> #16 0x00007ffff728e9d0 in GuaConnectionToClient::acceptBuffer (this=0xbc71c0,
> buffer=0x12439a0, receivedDataLength=472) at
> ../common/IpcGuardian.cpp:2455
> #17 0x00007ffff72903e7 in GuaReceiveControlConnection::wait (this=0xbb69f0,
> timeout=-1, eventConsumed=0x0, ipcAwaitiox=0x0)
> at ../common/IpcGuardian.cpp:3152
> #18 0x00007ffff728ddee in GuaConnectionToClient::wait (this=0xbc71c0,
> timeout=-1, eventConsumed=0x0, ipcAwaitiox=0x0)
> at ../common/IpcGuardian.cpp:2124
> #19 0x00007ffff7278d79 in IpcSetOfConnections::waitOnSet (this=0x7fffffffbd90,
> timeout=-1, calledByESP=0, timedout=0x0) at ../common/Ipc.cpp:1697
> #20 0x00007ffff727c007 in IpcMessageStream::waitOnMsgStream (
> this=0x7fffffffbbf0, timeout=-1) at ../common/Ipc.cpp:3260
> #21 0x00007ffff727bf75 in IpcMessageStream::receive (this=0x7fffffffbbf0,
> waited=1) at ../common/Ipc.cpp:3242
> #22 0x00000000004093ec in main (argc=2, argv=0x7fffffffc388)
> at ../bin/arkcmp.cpp:341
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
