[
https://issues.apache.org/jira/browse/TRAFODION-790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14714242#comment-14714242
]
Suresh Subbiah commented on TRAFODION-790:
------------------------------------------
Weishiun Tsai (wei-shiun-tsai) wrote on 2015-01-28:
This problem was seen twice on the v1.0.0 rc3 build, one on a Cloudera system
and another one on the HortonWorks system:
(gdb) bt
#0 0x00007ffff4a458a5 in raise () from /lib64/libc.so.6
#1 0x00007ffff4a4700d in abort () from /lib64/libc.so.6
#2 0x00007ffff5b4ea55 in os::abort(bool) ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff5ccef87 in VMError::report_and_die() ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff5b5396f in JVM_handle_linux_signal ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 0x00007ffff2e1c0b1 in ExHbaseAccessTcb::setupUniqueKeyAndCols (
this=0x7fffcf1b70a0, doInit=0) at ../executor/ExHbaseAccess.cpp:1709
#7 0x00007ffff2e2db6a in ExHbaseAccessSQRowsetTcb::work (this=0x7fffcf1b70a0)
at ../executor/ExHbaseIUD.cpp:3805
#8 0x00007ffff2e4abb3 in ExScheduler::work (this=0x7fffcf1b5ba8,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#9 0x00007ffff2d784b2 in ex_root_tcb::execute (this=0x7fffcf1bb028,
cliGlobals=0xeebbb0, glob=0x7fffcf3d02d8, input_desc=0x7fffcf3b5cd8,
diagsArea=@0x7fffe3dd2930, reExecute=0) at ../executor/ex_root.cpp:1055
#10 0x00007ffff437c554 in CliStatement::execute (this=0x7fffe295d958,
cliGlobals=0xeebbb0, input_desc=0x7fffcf3b5cd8,
diagsArea=<value optimized out>, execute_state=<value optimized out>,
fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4812
#11 0x00007ffff4324d0a 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=0xeebbb0,
tasks=4882,
statement_id=0x7fffcef3cc98, input_descriptor=0x7fffd10935a0,
output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0,
ap=0x7fffe3dd2ad0, input_ptr_pairs=0x0, output_ptr_pairs=0x0)
at ../cli/Cli.cpp:3284
#12 0x00007ffff4325a32 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *,
Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (
cliGlobals=<value optimized out>, statement_id=<value optimized out>,
input_descriptor=<value optimized out>,
num_ptr_pairs=<value optimized out>, ap=<value optimized out>,
ptr_pairs=<value optimized out>) at ../cli/Cli.cpp:3531
#13 0x00007ffff438b10a in SQL_EXEC_Exec (statement_id=0x7fffcef3cc98,
input_descriptor=0x7fffd10935a0, num_ptr_pairs=0)
at ../cli/CliExtern.cpp:2071
#14 0x00007ffff2de02b1 in ExeCliInterface::exec (this=0x7fffe3dd4f20,
inputBuf=<value optimized out>, inputBufLen=<value optimized out>)
at ../executor/ExExeUtilCli.cpp:599
#15 0x00007ffff2de91a5 in ExeCliInterface::executeImmediateExec (
this=0x7fffe3dd4f20, stmtStr=<value optimized out>, outputBuf=0x0,
outputBufLen=0x0, nullTerminate=1, rowsAffected=0x0)
at ../executor/ExExeUtilCli.cpp:898
#16 0x00007ffff2de941c in ExeCliInterface::executeImmediate (
this=0x7fffe3dd4f20,
stmtStr=0x7fffe3dd2d30 "update TRAFODION.\"_MD_\".OBJECTS set catalog_name
= 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name =
'TAB_EMP_NEW_01' where object_uid = 28767550681680312 ", outputBuf=0x0,
outputBufLen=0x0,
nullTerminate=1, rowsAffected=0x0, monitorThis=0, globalDiags=0x0)
at ../executor/ExExeUtilCli.cpp:993
#17 0x00007fffef7d2e54 in CmpSeabaseDDL::updateObjectName (
this=0x7fffe3dd6d60, cliInterface=0x7fffe3dd4f20,
objUID=28767550681680312, catName=0x7fffe3dd57a8 "TRAFODION",
schName=<value optimized out>, objName=<value optimized out>)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:4086
#18 0x00007fffef83e460 in CmpSeabaseDDL::renameSeabaseTable (
this=0x7fffe3dd6d60, renameTableNode=0x6633ef577089b8,
currCatName=<value optimized out>, currSchName=<value optimized out>)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:3163
#19 0x00007fffef7fdb66 in CmpSeabaseDDL::executeSeabaseDDL (
this=0x7fffe3dd6d60, ddlExpr=0x7fffd10a0bf8, ddlNode=0x7fffd10a0a10,
currCatName=..., currSchName=...)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:6793
#20 0x00007fffed50c85c in CmpStatement::process (this=<value optimized out>,
statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:931
#21 0x00007fffed500546 in CmpContext::compileDirect (this=0x7fffe1d69090,
data=0x7fffcf0a8c38 "\200", data_len=224, outHeap=0x7fffe3372128,
charset=15, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffe3dd7760,
gen_code_len=@0x7fffe3dd776c, parserFlags=4194304,
diagsArea=0x7fffcf0a8d20) at ../arkcmp/CmpContext.cpp:717
#22 0x00007ffff2d1c0a6 in ExDDLTcb::work (this=0x7fffcf3c3d50)
at ../executor/ex_ddl.cpp:265
#23 0x00007ffff2e4abb3 in ExScheduler::work (this=0x7fffcf3c38b8,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#24 0x00007ffff2d784b2 in ex_root_tcb::execute (this=0x7fffcf3c4328,
cliGlobals=0xeebbb0, glob=0x7fffcf0a8600, input_desc=0x7fffcf013580,
diagsArea=@0x7fffe3dd8e90, reExecute=0) at ../executor/ex_root.cpp:1055
#25 0x00007ffff437c554 in CliStatement::execute (this=0x7fffe2943688,
cliGlobals=0xeebbb0, input_desc=0x7fffcf013580,
diagsArea=<value optimized out>, execute_state=<value optimized out>,
fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4812
#26 0x00007ffff4324d0a 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=0xeebbb0,
tasks=8063,
statement_id=0x21ef1b8, input_descriptor=0x21ef1e8, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe3dd9030,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3284
#27 0x00007ffff438a40b in SQL_EXEC_ClearExecFetchClose (
statement_id=0x21ef1b8, input_descriptor=0x21ef1e8, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
at ../cli/CliExtern.cpp:2627
#28 0x00007ffff68703ff in SRVR::WSQL_EXEC_ClearExecFetchClose (
statement_id=0x21ef1b8, input_descriptor=<value optimized out>,
output_descriptor=<value optimized out>,
num_input_ptr_pairs=<value optimized out>,
num_output_ptr_pairs=<value optimized out>,
num_total_ptr_pairs=<value optimized out>) at SQLWrapper.cpp:459
#29 0x00007ffff6866d3f in SRVR::EXECUTE2 (pSrvrStmt=0x21eeba0)
at sqlinterface.cpp:5520
#30 0x00007ffff689737e in odbc_SQLSvc_Execute2_sme_ (
objtag_=<value optimized out>, call_id_=<value optimized out>,
dialogueId=<value optimized out>, sqlAsyncEnable=<value optimized out>,
queryTimeout=<value optimized out>, inputRowCnt=<value optimized out>,
sqlStmtType=0, stmtHandle=35580832, cursorLength=0, cursorName=0x0,
cursorCharset=1, holdableCursor=0, inValuesLength=0, inValues=0x0,
returnCode=0x7fffe3dd9928, sqlWarningOrErrorLength=0x7fffe3dd9924,
sqlWarningOrError=@0x7fffe3dd9900, rowsAffected=0x7fffe3dd9920,
outValuesLength=0x7fffe3dd9914, outValues=@0x7fffe3dd98f8)
at srvrothers.cpp:1517
#31 0x00000000004cbb12 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x124ff20,
call_id_=0x124ff78, dialogueId=706975365, stmtLabel=<value optimized out>,
cursorName=0x0, stmtExplainLabel=<value optimized out>, stmtType=0,
sqlStmtType=0,
sqlString=0xedd254 "alter table tab_emp_original_01 rename to
tab_emp_new_01", sqlAsyncEnable=0, queryTimeout=0, inputRowCnt=0, txnID=0,
holdableCursor=0)
at SrvrConnect.cpp:7629
#32 0x0000000000494046 in SQLEXECUTE_IOMessage (objtag_=0x124ff20,
call_id_=0x124ff78, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
#33 0x00000000004940f4 in DISPATCH_TCPIPRequest (objtag_=0x124ff20,
call_id_=0x124ff78, operation_id=<value optimized out>)
at Interface/odbcs_srvr.cpp:1799
#34 0x00000000004337e2 in BUILD_TCPIP_REQUEST (pnode=0x124ff20)
at ../Common/TCPIPSystemSrvr.cpp:603
#35 0x000000000043417d in PROCESS_TCPIP_REQUEST (pnode=0x124ff20)
at ../Common/TCPIPSystemSrvr.cpp:581
#36 0x0000000000462356 in CNSKListenerSrvr::tcpip_listener (arg=0xda5c40)
at Interface/linux/Listener_srvr_ps.cpp:397
#37 0x00007ffff47f92a0 in sb_thread_sthr_disp (pp_arg=0xebdc10)
at threadl.cpp:253
#38 0x00007ffff45c5851 in start_thread () from /lib64/libpthread.so.0
#39 0x00007ffff4afb90d in clone () from /lib64/libc.so.6
(gdb) bt
#0 0x00007ffff4a458a5 in raise () from /lib64/libc.so.6
#1 0x00007ffff4a4700d in abort () from /lib64/libc.so.6
#2 0x00007ffff5b4ea55 in os::abort(bool) ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff5ccef87 in VMError::report_and_die() ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff5b5396f in JVM_handle_linux_signal ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 0x00007ffff2e1c0b1 in ExHbaseAccessTcb::setupUniqueKeyAndCols (
this=0x7fffd006adf8, doInit=0) at ../executor/ExHbaseAccess.cpp:1709
#7 0x00007ffff2e2db6a in ExHbaseAccessSQRowsetTcb::work (this=0x7fffd006adf8)
at ../executor/ExHbaseIUD.cpp:3805
#8 0x00007ffff2e4abb3 in ExScheduler::work (this=0x7fffd0069900,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#9 0x00007ffff2d784b2 in ex_root_tcb::execute (this=0x7fffd006ed80,
cliGlobals=0xeeaa40, glob=0x7fffe2d55770, input_desc=0x7fffe2d2dd50,
diagsArea=@0x7fffe41e6930, reExecute=0) at ../executor/ex_root.cpp:1055
#10 0x00007ffff437c554 in CliStatement::execute (this=0x7fffcfab5d78,
cliGlobals=0xeeaa40, input_desc=0x7fffe2d2dd50,
diagsArea=<value optimized out>, execute_state=<value optimized out>,
fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4812
#11 0x00007ffff4324d0a 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=0xeeaa40,
tasks=4882,
statement_id=0x7fffcf6edc98, input_descriptor=0x7fffd18445a0,
output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0,
ap=0x7fffe41e6ad0, input_ptr_pairs=0x0, output_ptr_pairs=0x0)
at ../cli/Cli.cpp:3284
#12 0x00007ffff4325a32 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *,
Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (
cliGlobals=<value optimized out>, statement_id=<value optimized out>,
input_descriptor=<value optimized out>,
num_ptr_pairs=<value optimized out>, ap=<value optimized out>,
ptr_pairs=<value optimized out>) at ../cli/Cli.cpp:3531
#13 0x00007ffff438b10a in SQL_EXEC_Exec (statement_id=0x7fffcf6edc98,
input_descriptor=0x7fffd18445a0, num_ptr_pairs=0)
at ../cli/CliExtern.cpp:2071
#14 0x00007ffff2de02b1 in ExeCliInterface::exec (this=0x7fffe41e8f20,
inputBuf=<value optimized out>, inputBufLen=<value optimized out>)
at ../executor/ExExeUtilCli.cpp:599
#15 0x00007ffff2de91a5 in ExeCliInterface::executeImmediateExec (
this=0x7fffe41e8f20, stmtStr=<value optimized out>, outputBuf=0x0,
outputBufLen=0x0, nullTerminate=1, rowsAffected=0x0)
at ../executor/ExExeUtilCli.cpp:898
#16 0x00007ffff2de941c in ExeCliInterface::executeImmediate (
this=0x7fffe41e8f20,
stmtStr=0x7fffe41e6d30 "update TRAFODION.\"_MD_\".OBJECTS set catalog_name
= 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name =
'TAB_EMP_NEW_01' where object_uid = 564695906400148227 ", outputBuf=0x0,
outputBufLen=0x0,
nullTerminate=1, rowsAffected=0x0, monitorThis=0, globalDiags=0x0)
at ../executor/ExExeUtilCli.cpp:993
#17 0x00007fffef7d2e54 in CmpSeabaseDDL::updateObjectName (
this=0x7fffe41ead60, cliInterface=0x7fffe41e8f20,
objUID=564695906400148227, catName=0x7fffe41e97a8 "TRAFODION",
schName=<value optimized out>, objName=<value optimized out>)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:4086
#18 0x00007fffef83e460 in CmpSeabaseDDL::renameSeabaseTable (
this=0x7fffe41ead60, renameTableNode=0x7d633ef5b191b03,
currCatName=<value optimized out>, currSchName=<value optimized out>)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:3163
#19 0x00007fffef7fdb66 in CmpSeabaseDDL::executeSeabaseDDL (
this=0x7fffe41ead60, ddlExpr=0x7fffd1851bf8, ddlNode=0x7fffd1851a10,
currCatName=..., currSchName=...)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:6793
#20 0x00007fffed50c85c in CmpStatement::process (this=<value optimized out>,
statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:931
#21 0x00007fffed500546 in CmpContext::compileDirect (this=0x7fffe217d090,
data=0x7fffd0074578 "\200", data_len=224, outHeap=0x7fffe3786128,
charset=15, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffe41eb760,
gen_code_len=@0x7fffe41eb76c, parserFlags=4194304,
diagsArea=0x7fffd0074660) at ../arkcmp/CmpContext.cpp:717
#22 0x00007ffff2d1c0a6 in ExDDLTcb::work (this=0x7fffcfb985b0)
at ../executor/ex_ddl.cpp:265
#23 0x00007ffff2e4abb3 in ExScheduler::work (this=0x7fffcfb98118,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#24 0x00007ffff2d784b2 in ex_root_tcb::execute (this=0x7fffcfb98b88,
cliGlobals=0xeeaa40, glob=0x7fffd0073f40, input_desc=0x7fffd005dea0,
diagsArea=@0x7fffe41ece90, reExecute=0) at ../executor/ex_root.cpp:1055
#25 0x00007ffff437c554 in CliStatement::execute (this=0x7fffe2d2c730,
cliGlobals=0xeeaa40, input_desc=0x7fffd005dea0,
diagsArea=<value optimized out>, execute_state=<value optimized out>,
fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4812
#26 0x00007ffff4324d0a 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=0xeeaa40,
tasks=8063,
statement_id=0x16be0f8, input_descriptor=0x16be128, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe41ed030,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3284
#27 0x00007ffff438a40b in SQL_EXEC_ClearExecFetchClose (
statement_id=0x16be0f8, input_descriptor=0x16be128, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
at ../cli/CliExtern.cpp:2627
#28 0x00007ffff68703ff in SRVR::WSQL_EXEC_ClearExecFetchClose (
statement_id=0x16be0f8, input_descriptor=<value optimized out>,
output_descriptor=<value optimized out>,
num_input_ptr_pairs=<value optimized out>,
num_output_ptr_pairs=<value optimized out>,
num_total_ptr_pairs=<value optimized out>) at SQLWrapper.cpp:459
#29 0x00007ffff6866d3f in SRVR::EXECUTE2 (pSrvrStmt=0x16bdae0)
at sqlinterface.cpp:5520
#30 0x00007ffff689737e in odbc_SQLSvc_Execute2_sme_ (
objtag_=<value optimized out>, call_id_=<value optimized out>,
dialogueId=<value optimized out>, sqlAsyncEnable=<value optimized out>,
queryTimeout=<value optimized out>, inputRowCnt=<value optimized out>,
sqlStmtType=0, stmtHandle=23845600, cursorLength=0, cursorName=0x0,
cursorCharset=1, holdableCursor=0, inValuesLength=0, inValues=0x0,
returnCode=0x7fffe41ed928, sqlWarningOrErrorLength=0x7fffe41ed924,
sqlWarningOrError=@0x7fffe41ed900, rowsAffected=0x7fffe41ed920,
outValuesLength=0x7fffe41ed914, outValues=@0x7fffe41ed8f8)
at srvrothers.cpp:1517
#31 0x00000000004cbb12 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x2ee97c0,
call_id_=0x2ee9818, dialogueId=166096729, stmtLabel=<value optimized out>,
cursorName=0x0, stmtExplainLabel=<value optimized out>, stmtType=0,
sqlStmtType=0,
sqlString=0x3075b94 "alter table tab_emp_original_01 rename to
tab_emp_new_01", sqlAsyncEnable=0, queryTimeout=0, inputRowCnt=0, txnID=0,
holdableCursor=0)
at SrvrConnect.cpp:7629
#32 0x0000000000494046 in SQLEXECUTE_IOMessage (objtag_=0x2ee97c0,
call_id_=0x2ee9818, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
#33 0x00000000004940f4 in DISPATCH_TCPIPRequest (objtag_=0x2ee97c0,
call_id_=0x2ee9818, operation_id=<value optimized out>)
at Interface/odbcs_srvr.cpp:1799
#34 0x00000000004337e2 in BUILD_TCPIP_REQUEST (pnode=0x2ee97c0)
at ../Common/TCPIPSystemSrvr.cpp:603
#35 0x000000000043417d in PROCESS_TCPIP_REQUEST (pnode=0x2ee97c0)
at ../Common/TCPIPSystemSrvr.cpp:581
#36 0x0000000000462356 in CNSKListenerSrvr::tcpip_listener (arg=0xda5fb0)
at Interface/linux/Listener_srvr_ps.cpp:397
#37 0x00007ffff47f92a0 in sb_thread_sthr_disp (pp_arg=0xeb60e0)
at threadl.cpp:253
#38 0x00007ffff45c5851 in start_thread () from /lib64/libpthread.so.0
#39 0x00007ffff4afb90d in clone () from /lib64/libc.so.6
(gdb)
> LP Bug: 1395840 - Alter rename cores mxosrvr at
> ExHbaseAccessTcb::setupUniqueKeyAndCols()
> -----------------------------------------------------------------------------------------
>
> Key: TRAFODION-790
> URL: https://issues.apache.org/jira/browse/TRAFODION-790
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Weishiun Tsai
> Assignee: Suresh Subbiah
> Priority: Blocker
> Fix For: 2.0-incubating
>
>
> This core was seen several times when running the following sequence of
> commands. This problem can’t always be reproduced, but when it occurred, it
> always happened with the same statement and the cores all showed the same
> stack.
> This is seen on the v1119_0830 build installed on a 4-node cluster. It is a
> regression introduced between the v1108_0830 build and the v1119_0830 build.
> ------------------------------------------------------------------------------------------------------------------
> Here is the stack of the core files:
> #0 0x00007ffff527f8a5 in raise () from /lib64/libc.so.6
> #1 0x00007ffff528100d in abort () from /lib64/libc.so.6
> #2 0x00007ffff6388a55 in os::abort(bool) ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #3 0x00007ffff6508f87 in VMError::report_and_die() ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #4 0x00007ffff638d96f in JVM_handle_linux_signal ()
> from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
> #5 <signal handler called>
> #6 0x00007ffff3743a61 in ExHbaseAccessTcb::setupUniqueKeyAndCols (
> this=0x7fffce17ac50, doInit=0) at ../executor/ExHbaseAccess.cpp:1682
> #7 0x00007ffff374ee5b in ExHbaseAccessSQRowsetTcb::work (this=0x7fffce17ac50)
> at ../executor/ExHbaseIUD.cpp:3759
> #8 0x00007ffff37613c3 in ExScheduler::work (this=0x7fffce179758,
> prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
> #9 0x00007ffff36d3542 in ex_root_tcb::execute (this=0x7fffce17ebd8,
> cliGlobals=0xf40b30, glob=0x7fffd029e780, input_desc=0x7fffd16bb090,
> diagsArea=@0x7fffe4646a00, reExecute=0) at ../executor/ex_root.cpp:1029
> #10 0x00007ffff49c991c in CliStatement::execute (this=0x7fffce1bca38,
> cliGlobals=0xf40b30, input_desc=0x7fffd16bb090,
> diagsArea=<value optimized out>, execute_state=<value optimized out>,
> fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4779
> #11 0x00007ffff498c22a 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=0xf40b30, tasks=4882,
> statement_id=0x7fffcf38fe90, input_descriptor=0x7fffcf38ff00,
> output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0,
> ap=0x7fffe4646ba0, input_ptr_pairs=0x0, output_ptr_pairs=0x0)
> at ../cli/Cli.cpp:3278
> #12 0x00007ffff498cf52 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID
> *, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (
> cliGlobals=<value optimized out>, statement_id=<value optimized out>,
> input_descriptor=<value optimized out>,
> num_ptr_pairs=<value optimized out>, ap=<value optimized out>,
> ptr_pairs=<value optimized out>) at ../cli/Cli.cpp:3525
> #13 0x00007ffff49d5ca5 in SQL_EXEC_Exec (statement_id=0x7fffcf38fe90,
> input_descriptor=0x7fffcf38ff00, num_ptr_pairs=0)
> at ../cli/CliExtern.cpp:2062
> #14 0x00007ffff3710bd1 in ExeCliInterface::exec (this=0x7fffe4648fc0,
> inputBuf=<value optimized out>, inputBufLen=<value optimized out>)
> at ../executor/ExExeUtilCli.cpp:599
> #15 0x00007ffff37144c5 in ExeCliInterface::executeImmediateExec (
> this=0x7fffe4648fc0, stmtStr=<value optimized out>, outputBuf=0x0,
> outputBufLen=0x0, nullTerminate=1, rowsAffected=0x0)
> at ../executor/ExExeUtilCli.cpp:898
> #16 0x00007ffff371744c in ExeCliInterface::executeImmediate (
> this=0x7fffe4648fc0,
> stmtStr=0x7fffe4646e00 "update TRAFODION.\"_MD_\".OBJECTS set
> catalog_name = 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21',
> object_name = 'TAB_EMP_NEW_01' where object_uid = 103071044763640121 ",
> outputBuf=0x0, outputBufLen=0x0,
> nullTerminate=1, rowsAffected=0x0, monitorThis=0, globalDiags=0x0)
> at ../executor/ExExeUtilCli.cpp:993
> #17 0x00007ffff01b9264 in CmpSeabaseDDL::updateObjectName (
> this=0x7fffe464ae30, cliInterface=0x7fffe4648fc0,
> objUID=103071044763640121, catName=0x7fffe4649848 "TRAFODION",
> schName=<value optimized out>, objName=<value optimized out>)
> at ../sqlcomp/CmpSeabaseDDLcommon.cpp:3636
> #18 0x00007ffff01e9a1f in CmpSeabaseDDL::renameSeabaseTable (
> this=0x7fffe464ae30, renameTableNode=0x7fffe46488c0,
> currCatName=<value optimized out>, currSchName=<value optimized out>)
> at ../sqlcomp/CmpSeabaseDDLtable.cpp:2631
> #19 0x00007ffff01daade in CmpSeabaseDDL::executeSeabaseDDL (
> this=0x7fffe464ae30, ddlExpr=0x7fffd199c520, ddlNode=0x7fffd199c338,
> currCatName=..., currSchName=...)
> at ../sqlcomp/CmpSeabaseDDLcommon.cpp:5696
> #20 0x00007fffedfb240a in CmpStatement::process (this=<value optimized out>,
> statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:911
> #21 0x00007fffedfa82d8 in CmpContext::compileDirect (this=0x7fffe25dd090,
> data=0x7fffd01abef8 "\200", data_len=224, outHeap=0x7fffe3be60f0,
> charset=15, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffe464b6f0,
> gen_code_len=@0x7fffe464b6fc, parserFlags=4194304,
> diagsArea=0x7fffd01abfe0) at ../arkcmp/CmpContext.cpp:718
> #22 0x00007ffff36954f0 in ExDDLTcb::work (this=0x7fffe316d0a8)
> at ../executor/ex_ddl.cpp:265
> #23 0x00007ffff37613c3 in ExScheduler::work (this=0x7fffe316cc10,
> prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
> #24 0x00007ffff36d3542 in ex_root_tcb::execute (this=0x7fffe316d680,
> cliGlobals=0xf40b30, glob=0x7fffd01ab8c0, input_desc=0x7fffe3180a40,
> diagsArea=@0x7fffe464ce10, reExecute=0) at ../executor/ex_root.cpp:1029
> #25 0x00007ffff49c991c in CliStatement::execute (this=0x7fffd16ecd08,
> cliGlobals=0xf40b30, input_desc=0x7fffe3180a40,
> diagsArea=<value optimized out>, execute_state=<value optimized out>,
> fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4779
> #26 0x00007ffff498c22a 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=0xf40b30, tasks=8063,
> statement_id=0x2deb558, input_descriptor=0x2deb588, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe464cfb0,
> input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3278
> #27 0x00007ffff49d4f55 in SQL_EXEC_ClearExecFetchClose (
> statement_id=0x2deb558, input_descriptor=0x2deb588, output_descriptor=0x0,
> num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
> at ../cli/CliExtern.cpp:2618
> #28 0x00007ffff6e79b0f in SRVR::WSQL_EXEC_ClearExecFetchClose (
> statement_id=0x2deb558, input_descriptor=<value optimized out>,
> output_descriptor=<value optimized out>,
> num_input_ptr_pairs=<value optimized out>,
> num_output_ptr_pairs=<value optimized out>,
> num_total_ptr_pairs=<value optimized out>) at SQLWrapper.cpp:459
> #29 0x00007ffff6e7044f in SRVR::EXECUTE2 (pSrvrStmt=0x2deaf40)
> at sqlinterface.cpp:5521
> #30 0x00007ffff6ea0a45 in odbc_SQLSvc_Execute2_sme_ (
> objtag_=<value optimized out>, call_id_=<value optimized out>,
> dialogueId=<value optimized out>, sqlAsyncEnable=<value optimized out>,
> queryTimeout=<value optimized out>, inputRowCnt=<value optimized out>,
> sqlStmtType=0, stmtHandle=48148288, cursorLength=0, cursorName=0x0,
> cursorCharset=1, holdableCursor=0, inValuesLength=0, inValues=0x0,
> returnCode=0x7fffe464d8a8, sqlWarningOrErrorLength=0x7fffe464d8a4,
> sqlWarningOrError=@0x7fffe464d880, rowsAffected=0x7fffe464d8a0,
> outValuesLength=0x7fffe464d894, outValues=@0x7fffe464d878)
> at srvrothers.cpp:1514
> #31 0x00000000004d2685 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x31c8ce0,
> call_id_=0x31c8d38, dialogueId=1676333437,
> stmtLabel=<value optimized out>, cursorName=0x0,
> stmtExplainLabel=<value optimized out>, stmtType=0, sqlStmtType=0,
> sqlString=0x379d794 "alter table tab_emp_original_01 rename to
> tab_emp_new_01", sqlAsyncEnable=0, queryTimeout=0, inputRowCnt=0, txnID=0,
> holdableCursor=0)
> at SrvrConnect.cpp:7018
> #32 0x00000000004a1a36 in SQLEXECUTE_IOMessage (objtag_=0x31c8ce0,
> call_id_=0x31c8d38, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
> #33 0x00000000004a1ae4 in DISPATCH_TCPIPRequest (objtag_=0x31c8ce0,
> call_id_=0x31c8d38, operation_id=<value optimized out>)
> at Interface/odbcs_srvr.cpp:1799
> #34 0x0000000000432a02 in BUILD_TCPIP_REQUEST (pnode=0x31c8ce0)
> at ../Common/TCPIPSystemSrvr.cpp:603
> #35 0x000000000043339d in PROCESS_TCPIP_REQUEST (pnode=0x31c8ce0)
> at ../Common/TCPIPSystemSrvr.cpp:581
> #36 0x0000000000470ad6 in CNSKListenerSrvr::tcpip_listener (arg=0xde0f40)
> at Interface/linux/Listener_srvr_ps.cpp:397
> #37 0x00007ffff50329f0 in sb_thread_sthr_disp (pp_arg=0xf13020)
> at threadl.cpp:253
> #38 0x00007ffff4bf9851 in start_thread () from /lib64/libpthread.so.0
> #39 0x00007ffff533590d in clone () from /lib64/libc.so.6
> ------------------------------------------------------------------------------------------------------------------
> Here is the execution output from trafci. The last ‘alter table
> tab_emp_original_01 rename to tab_emp_new_01;’ statement cored mxosrvr and
> caused trafci to lose its connection whenever the problem was seen:
> SQL>drop schema trafodion.alter_rename_rename21 cascade;
> --- SQL operation complete.
> SQL>create schema trafodion.alter_rename_rename21;
> --- SQL operation complete.
> SQL>set schema trafodion.alter_rename_rename21;
> --- SQL operation complete.
> SQL>set nametype ansi;
> --- SQL operation complete.
> SQL>create table tab_emp_original_01
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_emp_original_02
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_ten_original_03
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_ten_original_04
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_lrg_original_05
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>create table tab_lrg_original_06
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> --- SQL operation complete.
> SQL>insert into tab_ten_original_03 values
> (1,'ABCDEFGH',1001,1001,11,'IJKLMNOPQRSTUVWX','YZABCDEF',1001,11,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (2,'ABCDEFGH',1002,1002,12,'IJKLMNOPQRSTUVWX','YZABCDEF',1002,12,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (3,'ABCDEFGH',1003,1003,13,'IJKLMNOPQRSTUVWX','YZABCDEF',1003,13,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (4,'ABCDEFGH',1004,1004,14,'IJKLMNOPQRSTUVWX','YZABCDEF',1004,14,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (5,'ABCDEFGH',1005,1005,15,'IJKLMNOPQRSTUVWX','YZABCDEF',1005,15,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (6,'ABCDEFGH',1006,1006,16,'IJKLMNOPQRSTUVWX','YZABCDEF',1006,16,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (7,'ABCDEFGH',1007,1007,17,'IJKLMNOPQRSTUVWX','YZABCDEF',1007,17,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (8,'ABCDEFGH',1008,1008,18,'IJKLMNOPQRSTUVWX','YZABCDEF',1008,18,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (9,'ABCDEFGH',1009,1009,19,'IJKLMNOPQRSTUVWX','YZABCDEF',1009,19,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_03 values
> (10,'ABCDEFGH',1010,1010,20,'IJKLMNOPQRSTUVWX','YZABCDEF',1010,20,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (1,'ABCDEFGH',1001,1001,11,'IJKLMNOPQRSTUVWX','YZABCDEF',1001,11,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (2,'ABCDEFGH',1002,1002,12,'IJKLMNOPQRSTUVWX','YZABCDEF',1002,12,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (3,'ABCDEFGH',1003,1003,13,'IJKLMNOPQRSTUVWX','YZABCDEF',1003,13,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (4,'ABCDEFGH',1004,1004,14,'IJKLMNOPQRSTUVWX','YZABCDEF',1004,14,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (5,'ABCDEFGH',1005,1005,15,'IJKLMNOPQRSTUVWX','YZABCDEF',1005,15,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (6,'ABCDEFGH',1006,1006,16,'IJKLMNOPQRSTUVWX','YZABCDEF',1006,16,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (7,'ABCDEFGH',1007,1007,17,'IJKLMNOPQRSTUVWX','YZABCDEF',1007,17,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (8,'ABCDEFGH',1008,1008,18,'IJKLMNOPQRSTUVWX','YZABCDEF',1008,18,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (9,'ABCDEFGH',1009,1009,19,'IJKLMNOPQRSTUVWX','YZABCDEF',1009,19,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>insert into tab_ten_original_04 values
> (10,'ABCDEFGH',1010,1010,20,'IJKLMNOPQRSTUVWX','YZABCDEF',1010,20,'GHIJKLMN');
> --- 1 row(s) inserted.
> SQL>upsert using load into
> trafodion.alter_rename_rename21.tab_lrg_original_05 select * from
> trafodion.g_cmureg.btpnl17a;
> --- SQL operation complete.
> SQL>select count(*) from tab_lrg_original_05;
> (EXPR)
> --------------------
> 2000
> --- 1 row(s) selected.
> SQL>update statistics for table tab_lrg_original_05 on every column;
> --- SQL operation complete.
> SQL>upsert using load into
> trafodion.alter_rename_rename21.tab_lrg_original_06 select * from
> trafodion.g_cmureg.btpnl17a;
> --- SQL operation complete.
> SQL>select count(*) from tab_lrg_original_06;
> (EXPR)
> --------------------
> 2000
> --- 1 row(s) selected.
> SQL>update statistics for table tab_lrg_original_06 on every column;
> --- SQL operation complete.
> -------------------------------------------------------------------------------
> == TEST: tcase.test001
> -------------------------------------------------------------------------------
> SQL>select * from tab_emp_original_01;
> --- 0 row(s) selected.
> SQL>showddl tab_emp_original_01;
> CREATE TABLE TRAFODION.ALTER_RENAME_RENAME21.TAB_EMP_ORIGINAL_01
> (
> SBIN0_10 NUMERIC(18, 0) DEFAULT NULL
> , CHAR0_2 CHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL
> , UDEC0_UNIQ DECIMAL(9, 0) UNSIGNED DEFAULT NULL
> , UBIN0_UNIQ NUMERIC(9, 0) UNSIGNED DEFAULT NULL
> , SDEC0_500 DECIMAL(9, 0) DEFAULT NULL
> , VARCHAR0_10 VARCHAR(16) CHARACTER SET ISO88591
> COLLATE
> DEFAULT DEFAULT NULL
> , VARCHAR1_20 VARCHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL
> , SBIN1_5000 NUMERIC(4, 0) DEFAULT NULL
> , SDEC1_4 DECIMAL(18, 0) DEFAULT NULL
> , CHAR1_4 CHAR(8) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL
> )
> ;
> --- SQL operation complete.
> SQL>alter table tab_emp_original_01 rename to tab_emp_new_01;
> *** 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
