[
https://issues.apache.org/jira/browse/TRAFODION-790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14714239#comment-14714239
]
Suresh Subbiah commented on TRAFODION-790:
------------------------------------------
Weishiun Tsai (wei-shiun-tsai) wrote on 2015-01-20:
Just to provide some more updates on this problem. This core is still being
seen in recent builds, generally once or twice in each build when tests were
run. Here is one from the v0118 build:
(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 0x00007ffff2e1ca51 in ExHbaseAccessTcb::setupUniqueKeyAndCols (
this=0x7fffcf4e9cb8, doInit=0) at ../executor/ExHbaseAccess.cpp:1709
#7 0x00007ffff2e2e50a in ExHbaseAccessSQRowsetTcb::work (this=0x7fffcf4e9cb8)
at ../executor/ExHbaseIUD.cpp:3805
#8 0x00007ffff2e4b553 in ExScheduler::work (this=0x7fffcf4e87c0,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#9 0x00007ffff2d79462 in ex_root_tcb::execute (this=0x7fffcf4edc40,
cliGlobals=0xeebba0, glob=0x7fffe296c3a8, input_desc=0x7fffcf423470,
diagsArea=@0x7fffe3dd4930, reExecute=0) at ../executor/ex_root.cpp:1055
#10 0x00007ffff437c554 in CliStatement::execute (this=0x7fffcf4b4e40,
cliGlobals=0xeebba0, input_desc=0x7fffcf423470,
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=0xeebba0,
tasks=4882,
statement_id=0x7fffcf124f38, input_descriptor=0x7fffcf124fa8,
output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0,
ap=0x7fffe3dd4ad0, 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=0x7fffcf124f38,
input_descriptor=0x7fffcf124fa8, num_ptr_pairs=0)
at ../cli/CliExtern.cpp:2071
#14 0x00007ffff2de1261 in ExeCliInterface::exec (this=0x7fffe3dd6f20,
inputBuf=<value optimized out>, inputBufLen=<value optimized out>)
at ../executor/ExExeUtilCli.cpp:599
#15 0x00007ffff2dea155 in ExeCliInterface::executeImmediateExec (
this=0x7fffe3dd6f20, stmtStr=<value optimized out>, outputBuf=0x0,
outputBufLen=0x0, nullTerminate=1, rowsAffected=0x0)
at ../executor/ExExeUtilCli.cpp:898
#16 0x00007ffff2dea3cc in ExeCliInterface::executeImmediate (
this=0x7fffe3dd6f20,
stmtStr=0x7fffe3dd4d30 "update TRAFODION.\"_MD_\".OBJECTS set catalog_name
= 'TRAFODION', schema_name = 'ALTER_RENAME_RENAME21', object_name =
'TAB_EMP_NEW_01' where object_uid = 93505755278138431 ", outputBuf=0x0,
outputBufLen=0x0,
nullTerminate=1, rowsAffected=0x0, monitorThis=0, globalDiags=0x0)
at ../executor/ExExeUtilCli.cpp:993
#17 0x00007fffef7d3e34 in CmpSeabaseDDL::updateObjectName (
this=0x7fffe3dd8d60, cliInterface=0x7fffe3dd6f20,
objUID=93505755278138431, catName=0x7fffe3dd77a8 "TRAFODION",
schName=<value optimized out>, objName=<value optimized out>)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:4123
#18 0x00007fffef83eeea in CmpSeabaseDDL::renameSeabaseTable (
this=0x7fffe3dd8d60, renameTableNode=0x7fffd119eb98,
currCatName=<value optimized out>, currSchName=<value optimized out>)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:3163
#19 0x00007fffef7fec76 in CmpSeabaseDDL::executeSeabaseDDL (
this=0x7fffe3dd8d60, ddlExpr=0x7fffd1170350, ddlNode=0x7fffd1170168,
currCatName=..., currSchName=...)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:6830
#20 0x00007fffed50e85c in CmpStatement::process (this=<value optimized out>,
statement=<value optimized out>) at ../arkcmp/CmpStatement.cpp:931
#21 0x00007fffed502546 in CmpContext::compileDirect (this=0x7fffe1d6b090,
data=0x7fffd0dcbf20 "\200", data_len=224, outHeap=0x7fffe3374128,
charset=15, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffe3dd9760,
gen_code_len=@0x7fffe3dd976c, parserFlags=4194304,
diagsArea=0x7fffd0dcc008) at ../arkcmp/CmpContext.cpp:717
#22 0x00007ffff2d1d056 in ExDDLTcb::work (this=0x7fffcf2a4530)
at ../executor/ex_ddl.cpp:265
#23 0x00007ffff2e4b553 in ExScheduler::work (this=0x7fffcf2a4098,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#24 0x00007ffff2d79462 in ex_root_tcb::execute (this=0x7fffcf2a4b08,
cliGlobals=0xeebba0, glob=0x7fffd0dcb8e8, input_desc=0x7fffcf525f18,
diagsArea=@0x7fffe3ddae90, reExecute=0) at ../executor/ex_root.cpp:1055
#25 0x00007ffff437c554 in CliStatement::execute (this=0x7fffcf3b9c30,
cliGlobals=0xeebba0, input_desc=0x7fffcf525f18,
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=0xeebba0,
tasks=8063,
statement_id=0x213a5b8, input_descriptor=0x213a5e8, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe3ddb030,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3284
#27 0x00007ffff438a40b in SQL_EXEC_ClearExecFetchClose (
statement_id=0x213a5b8, input_descriptor=0x213a5e8, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, num_total_ptr_pairs=0)
at ../cli/CliExtern.cpp:2627
#28 0x00007ffff687039f in SRVR::WSQL_EXEC_ClearExecFetchClose (
statement_id=0x213a5b8, 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 0x00007ffff6866cdf in SRVR::EXECUTE2 (pSrvrStmt=0x2139fa0)
at sqlinterface.cpp:5520
#30 0x00007ffff689730e 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=34840480, cursorLength=0, cursorName=0x0,
cursorCharset=1, holdableCursor=0, inValuesLength=0, inValues=0x0,
returnCode=0x7fffe3ddb928, sqlWarningOrErrorLength=0x7fffe3ddb924,
sqlWarningOrError=@0x7fffe3ddb900, rowsAffected=0x7fffe3ddb920,
outValuesLength=0x7fffe3ddb914, outValues=@0x7fffe3ddb8f8)
at srvrothers.cpp:1517
#31 0x00000000004cbc62 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x1a23c30,
call_id_=0x1a23c88, dialogueId=89802224, stmtLabel=<value optimized out>,
cursorName=0x0, stmtExplainLabel=<value optimized out>, stmtType=0,
sqlStmtType=0,
sqlString=0x2353944 "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:7636
#32 0x00000000004940a6 in SQLEXECUTE_IOMessage (objtag_=0x1a23c30,
call_id_=0x1a23c88, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
#33 0x0000000000494154 in DISPATCH_TCPIPRequest (objtag_=0x1a23c30,
call_id_=0x1a23c88, operation_id=<value optimized out>)
at Interface/odbcs_srvr.cpp:1799
#34 0x0000000000433842 in BUILD_TCPIP_REQUEST (pnode=0x1a23c30)
at ../Common/TCPIPSystemSrvr.cpp:603
#35 0x00000000004341dd in PROCESS_TCPIP_REQUEST (pnode=0x1a23c30)
at ../Common/TCPIPSystemSrvr.cpp:581
#36 0x00000000004623b6 in CNSKListenerSrvr::tcpip_listener (arg=0xda5c30)
at Interface/linux/Listener_srvr_ps.cpp:397
#37 0x00007ffff47f92a0 in sb_thread_sthr_disp (pp_arg=0xeb6a70)
at threadl.cpp:253
#38 0x00007ffff45c5851 in start_thread () from /lib64/libpthread.so.0
#39 0x00007ffff4afb90d in clone () from /lib64/libc.so.6
> 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)
