You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:47 UTC
[jira] [Created] (TRAFODION-364) LP Bug: 1328271 - got mxosrvr core
while allowing constraint as a reference object to be dropped
Alice Chen created TRAFODION-364:
------------------------------------
Summary: LP Bug: 1328271 - got mxosrvr core while allowing constraint as a reference object to be dropped
Key: TRAFODION-364
URL: https://issues.apache.org/jira/browse/TRAFODION-364
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Apache Trafodion
Assignee: Pavani Puppala
Priority: Critical
Allow constraint mno_uniq to be dropped where it is used as reference object
SQL>-- n001.14 drop ri referenced constraint
SQL>create table male_actors77
(
m_no int no default not null not droppable
, m_name varchar(30) character set iso88591 collate
default no default not null not droppable
, m_realname varchar(50) character set iso88591 collate
default default null
, m_birthday date default null
, constraint mno_uniq unique (m_no) droppable
, constraint mdx_date check (m_birthday > date
'1900-01-01') droppable
) no partition
;
--- SQL operation complete.
SQL>create table male_titles
(
mv_no int no default not null not droppable
, mv_name varchar(40) character set iso88591 collate
default no default not null not droppable
, mv_malestar int default null
, mv_femalestar int default null
, mv_director int default 0 not null not droppable
, mv_yearmade int default null
, mv_star_rating char(4) character set iso88591 collate
default default null
, mv_movietype varchar(15) character set iso88591 collate
default default null
, mv_subspecialty varchar(15) character set iso88591 collate
default default null
, primary key (mv_no) not droppable
, constraint maxstar_fk2 foreign key (mv_malestar) references
male_actors77(m_no) droppable)
;
--- SQL operation complete.
SQL>-- error[1050] constraint cannot be dropped because it is used as a referenced object for a foreign key
SQL>-- #expect any *error[1050]*
--- *** should not be dropped, should get error 1050 ***
SQL>alter table male_actors77 drop constraint mno_uniq;
--- SQL operation complete.
SQL>drop table male_titles cascade;
*** ERROR[1] The message id: problem_with_server_read
*** ERROR[1] The message id: header_not_long_enough
*** ERROR[1] The message id: problem_with_server_read
*** ERROR[1] The message id: header_not_long_enough
SQL>drop table male_actors77 cascade;
*** ERROR[1] The message id: socket_write_error With parameters: Broken pipe
*** ERROR[1] The message id: socket_write_error With parameters: Broken pipe
SQL>select * from "_MD_".objects where schema_name = 'SCH_TEMP';
*** ERROR[1] The message id: invalid_connection
SQL>select * from "_MD_".objects_uniq_idx where schema_name = 'SCH_TEMP';
*** ERROR[1] The message id: invalid_connection
SQL>log off;
-- back trace for mxosrvr
(gdb) bt
#0 0x000000309f4328a5 in raise () from /lib64/libc.so.6
#1 0x000000309f434085 in abort () from /lib64/libc.so.6
#2 0x00007ffff6508865 in os::abort(bool) ()
from /designs/seaquest/tools/jdk1.7.0_21_64/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff6668b77 in VMError::report_and_die() ()
from /designs/seaquest/tools/jdk1.7.0_21_64/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff650c370 in JVM_handle_linux_signal ()
from /designs/seaquest/tools/jdk1.7.0_21_64/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 0x00007fffef619a56 in createConstraintInfo (table_desc=0x7fffd5403800,
tableQualName=..., columnArray=..., checkConstraints=...,
uniqueConstraints=..., refConstraints=..., heap=0x7fffd543adf8, bindWA=
0x7fffe6ead0d0) at ../optimizer/NATable.cpp:4063
#7 0x00007fffef61b8b9 in NATable::NATable (this=0x7fffd53e7c20,
bindWA=0x7fffe6ead0d0, corrName=..., heap=0x7fffd543adf8,
inTableDesc=0x7fffd5403800) at ../optimizer/NATable.cpp:4531
#8 0x00007fffef6246b9 in NATableDB::get (this=0x7fffe4e48660, corrName=...,
bindWA=0x7fffe6ead0d0, inTableDescStruct=0x0) at ../optimizer/NATable.cpp:6975
---Type <return> to continue, or q <return> to quit---
#9 0x00007fffef38caea in BindWA::getNATable (this=0x7fffe6ead0d0, corrName=...,
catmanCollectTableUsages=1, inTableDescStruct=0x0)
at ../optimizer/BindRelExpr.cpp:1443
#10 0x00007ffff0e9157e in CmpSeabaseDDL::dropSeabaseTable (this=0x7fffe6eb01d0,
dropTableNode=0x7fffd54100f0, currCatName=..., currSchName=...)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:1914
#11 0x00007ffff0e83a68 in CmpSeabaseDDL::executeSeabaseDDL (this=0x7fffe6eb01d0,
ddlExpr=0x7fffd5410320, ddlNode=0x7fffd54100f0, currCatName=...,
currSchName=...) at ../sqlcomp/CmpSeabaseDDLcommon.cpp:4158
#12 0x00007fffee74dce4 in CmpStatement::process (this=0x7fffd53e7ad0,
statement=...) at ../arkcmp/CmpStatement.cpp:909
#13 0x00007fffee74152f in CmpContext::compileDirect (this=0x7fffe4e43090,
data=0x7fffe5a38eb0 "\200", data_len=184, outHeap=0x7fffe644b660, charset=15,
op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffe6eb09f8,
gen_code_len=@0x7fffe6eb09f4, parserFlags=4194304, diagsArea=0x7fffe5a38f70)
at ../arkcmp/CmpContext.cpp:710
#14 0x00007ffff456c036 in ExDDLTcb::work (this=0x7fffe5a3d3a0)
at ../executor/ex_ddl.cpp:265
---Type <return> to continue, or q <return> to quit---
#15 0x00007ffff457f9b3 in ex_tcb::sWork (tcb=0x7fffe5a3d3a0)
at ../executor/ex_tcb.h:99
#16 0x00007ffff468121b in ExSubtask::work (this=0x7fffe5a3d8f8)
at ../executor/ExScheduler.cpp:751
#17 0x00007ffff46805de in ExScheduler::work (this=0x7fffe5a3cf08, prevWaitTime=0)
at ../executor/ExScheduler.cpp:328
#18 0x00007ffff45bf6e7 in ex_root_tcb::execute (this=0x7fffe5a3d978,
cliGlobals=0x10dcbf0, glob=0x7fffe5a37cc8, input_desc=0x7fffe59f2ab0,
diagsArea=@0x7fffe6eb2030, reExecute=0) at ../executor/ex_root.cpp:1025
#19 0x00007ffff58fb11b in CliStatement::execute (this=0x7fffe5a46520,
cliGlobals=0x10dcbf0, input_desc=0x7fffe59f2ab0, diagsArea=...,
execute_state=CliStatement::INITIAL_STATE_, fixupOnly=0, cliflags=0)
at ../cli/Statement.cpp:4754
#20 0x00007ffff58a0fd3 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=0x10dcbf0, tasks=8063,
statement_id=0x1c79388, input_descriptor=0x1c793b8, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe6eb2620,
---Type <return> to continue, or q <return> to quit---
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3323
#21 0x00007ffff58a2271 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=0x10dcbf0,
statement_id=0x1c79388, input_descriptor=0x1c793b8, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0,
ap=0x7fffe6eb2620, input_ptr_pairs=0x0, output_ptr_pairs=0x0)
at ../cli/Cli.cpp:3814
#22 0x00007ffff590f20f in SQL_EXEC_ClearExecFetchClose (statement_id=0x1c79388,
input_descriptor=0x1c793b8, output_descriptor=0x0, num_input_ptr_pairs=0,
num_output_ptr_pairs=0, num_total_ptr_pairs=0) at ../cli/CliExtern.cpp:2618
#23 0x00007ffff6ff661b in SRVR::WSQL_EXEC_ClearExecFetchClose (
statement_id=0x1c79388, input_descriptor=0x1c793b8, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
at SQLWrapper.cpp:459
#24 0x00007ffff6fdfc1c in SRVR::EXECUTE2 (pSrvrStmt=0x1c78d70)
at sqlinterface.cpp:5521
#25 0x00007ffff7036f86 in odbc_SQLSvc_Execute2_sme_ (objtag_=0x10caa60,
---Type <return> to continue, or q <return> to quit---
call_id_=0x10caab8, dialogueId=1384679176, sqlAsyncEnable=0, queryTimeout=0,
inputRowCnt=0, sqlStmtType=128, stmtHandle=29855088, cursorLength=0,
cursorName=0x0, cursorCharset=1, holdableCursor=0, inValuesLength=0,
inValues=0x0, returnCode=0x7fffe6eb3244,
sqlWarningOrErrorLength=0x7fffe6eb3240, sqlWarningOrError=@0x7fffe6eb3238,
rowsAffected=0x7fffe6eb3234, outValuesLength=0x7fffe6eb3228,
outValues=@0x7fffe6eb3220) at srvrothers.cpp:1508
#26 0x00000000005a08bb in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x10caa60,
call_id_=0x10caab8, dialogueId=1384679176, stmtLabel=0x125a01f "SQL_CUR_2",
cursorName=0x0, stmtExplainLabel=0x0, stmtType=0, sqlStmtType=128,
sqlString=0x1259ff4 "drop table male_titles cascade", sqlAsyncEnable=0,
queryTimeout=0, inputRowCnt=0, txnID=0, holdableCursor=0)
at SrvrConnect.cpp:6874
#27 0x000000000053c1db in SQLEXECUTE_IOMessage (objtag_=0x10caa60,
call_id_=0x10caab8, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
#28 0x000000000053c4a7 in DISPATCH_TCPIPRequest (objtag_=0x10caa60,
call_id_=0x10caab8, operation_id=3012) at Interface/odbcs_srvr.cpp:1799
#29 0x000000000046381e in BUILD_TCPIP_REQUEST (pnode=0x10caa60)
---Type <return> to continue, or q <return> to quit---
at ../Common/TCPIPSystemSrvr.cpp:593
#30 0x0000000000463765 in PROCESS_TCPIP_REQUEST (pnode=0x10caa60)
at ../Common/TCPIPSystemSrvr.cpp:571
#31 0x00000000004d24d4 in CNSKListenerSrvr::CheckTCPIPRequest (this=0xf78940,
ipnode=0x10caa60) at Interface/Listener_srvr.cpp:61
#32 0x00000000004e3aed in CNSKListenerSrvr::tcpip_listener (arg=0xf78940)
at Interface/linux/Listener_srvr_ps.cpp:397
#33 0x00007ffff5b7fa70 in sb_thread_sthr_disp (pp_arg=0x10ca020)
at threadl.cpp:253
#34 0x000000309f807851 in start_thread () from /lib64/libpthread.so.0
#35 0x000000309f4e890d in clone () from /lib64/libc.so.6
(gdb)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)