[
https://issues.apache.org/jira/browse/TRAFODION-790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14714246#comment-14714246
]
Suresh Subbiah commented on TRAFODION-790:
------------------------------------------
Weishiun Tsai (wei-shiun-tsai) wrote on 2015-02-12:
A 2nd core from this problem was seen on the v1.0.1rc1 build installed on a
4-node Hortonworks machine:
(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 0x00007ffff2e1c2e1 in ExHbaseAccessTcb::setupUniqueKeyAndCols (
this=0x7fffcbda0078, doInit=0) at ../executor/ExHbaseAccess.cpp:1709
#7 0x00007ffff2e2dd9a in ExHbaseAccessSQRowsetTcb::work (this=0x7fffcbda0078)
at ../executor/ExHbaseIUD.cpp:3805
#8 0x00007ffff2e4ade3 in ExScheduler::work (this=0x7fffcbd9eb80,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#9 0x00007ffff2d784e2 in ex_root_tcb::execute (this=0x7fffcbda4000,
cliGlobals=0xeea730, glob=0x7fffc7ff0520, input_desc=0x7fffc09c7198,
diagsArea=@0x7fffe41e6bb0, reExecute=0) at ../executor/ex_root.cpp:1055
#10 0x00007ffff437c554 in CliStatement::execute (this=0x7fffc09c7458,
cliGlobals=0xeea730, input_desc=0x7fffc09c7198,
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=0xeea730,
tasks=4882,
statement_id=0x7fffd12ed3d0, input_descriptor=0x7fffd12ed440,
output_descriptor=0x0, num_input_ptr_pairs=0, num_output_ptr_pairs=0,
ap=0x7fffe41e6d50, 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=0x7fffd12ed3d0,
input_descriptor=0x7fffd12ed440, num_ptr_pairs=0)
at ../cli/CliExtern.cpp:2071
#14 0x00007ffff2de0311 in ExeCliInterface::exec (this=0x7fffe41e91a0,
inputBuf=<value optimized out>, inputBufLen=<value optimized out>)
at ../executor/ExExeUtilCli.cpp:611
#15 0x00007ffff2de9255 in ExeCliInterface::executeImmediateExec (
this=0x7fffe41e91a0, stmtStr=<value optimized out>, outputBuf=0x0,
outputBufLen=0x0, nullTerminate=1, rowsAffected=0x0)
at ../executor/ExExeUtilCli.cpp:910
#16 0x00007ffff2de94cc in ExeCliInterface::executeImmediate (
this=0x7fffe41e91a0,
stmtStr=0x7fffe41e6fb0 "update TRAFODION.\"_MD_\".OBJECTS set catalog_name
= 'TRAFODION', schema_name = 'FEATURES_RMS', object_name = 'F0102' where
object_uid = 322628626383173833 ", outputBuf=0x0, outputBufLen=0x0,
nullTerminate=1,
rowsAffected=0x0, monitorThis=0, globalDiags=0x0)
at ../executor/ExExeUtilCli.cpp:1005
#17 0x00007fffef7d2e54 in CmpSeabaseDDL::updateObjectName (
this=0x7fffe41eafe0, cliInterface=0x7fffe41e91a0,
objUID=322628626383173833, catName=0x7fffe41e9a28 "TRAFODION",
schName=<value optimized out>, objName=<value optimized out>)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:4089
#18 0x00007fffef83e06e in CmpSeabaseDDL::renameSeabaseTable (
this=0x7fffe41eafe0, renameTableNode=0x47a3506bdf0f8c9,
currCatName=<value optimized out>, currSchName=<value optimized out>)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:3163
#19 0x00007fffef7fdbe6 in CmpSeabaseDDL::executeSeabaseDDL (
this=0x7fffe41eafe0, ddlExpr=0x7fffcc07b430, ddlNode=0x7fffcc07b288,
currCatName=..., currSchName=...)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:6797
#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=0x7fffcbdee638 "\200", data_len=192, outHeap=0x7fffe3786128,
charset=15, op=CmpMessageObj::PROCESSDDL, gen_code=@0x7fffe41eb9e0,
gen_code_len=@0x7fffe41eb9ec, parserFlags=4194304,
diagsArea=0x7fffcbdee700) at ../arkcmp/CmpContext.cpp:717
#22 0x00007ffff2d1c0d6 in ExDDLTcb::work (this=0x7fffe2d3d960)
at ../executor/ex_ddl.cpp:265
#23 0x00007ffff2e4ade3 in ExScheduler::work (this=0x7fffe2d3d4c8,
prevWaitTime=<value optimized out>) at ../executor/ExScheduler.cpp:328
#24 0x00007ffff2d784e2 in ex_root_tcb::execute (this=0x7fffe2d3df38,
cliGlobals=0xeea730, glob=0x7fffcbdee000, input_desc=0x7fffcbdf0f68,
diagsArea=@0x7fffe41ed110, reExecute=0) at ../executor/ex_root.cpp:1055
#25 0x00007ffff437c554 in CliStatement::execute (this=0x7fffcf87b678,
cliGlobals=0xeea730, input_desc=0x7fffcbdf0f68,
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=0xeea730,
tasks=8063,
statement_id=0xf3e8198, input_descriptor=0xf3e81c8, output_descriptor=0x0,
num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffe41ed2b0,
input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3284
#27 0x00007ffff438a40b in SQL_EXEC_ClearExecFetchClose (
statement_id=0xf3e8198, input_descriptor=0xf3e81c8, 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=0xf3e8198, 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=0xf3e7b80)
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=255753088, cursorLength=0, cursorName=0x0,
cursorCharset=0, holdableCursor=0, inValuesLength=0, inValues=0x0,
returnCode=0x7fffe41ed92c, sqlWarningOrErrorLength=0x7fffe41ed928,
sqlWarningOrError=@0x7fffe41ed918, rowsAffected=0x7fffe41ed924,
outValuesLength=0x7fffe41ed920, outValues=@0x7fffe41ed910)
at srvrothers.cpp:1517
#31 0x00000000004b6c8e in odbc_SQLSrvr_Execute2_ame_ (objtag_=0xcadbfd0,
call_id_=0xcadc028, dialogueId=1945423036, sqlAsyncEnable=0,
queryTimeout=0, inputRowCnt=1, sqlStmtType=0, stmtHandle=255753088,
cursorName=0x0, cursorCharset=0, inValuesLength=0, inValues=0x0,
sqlQueryType=0, outputDescLength=0, outputDesc=0x0, rowLength=0, txnID=0,
holdableCursor=0) at SrvrConnect.cpp:8006
#32 0x00000000004940b2 in SQLEXECUTE_IOMessage (objtag_=0xcadbfd0,
call_id_=0xcadc028, operation_id=3025) at Interface/odbcs_srvr.cpp:1714
#33 0x00000000004940f4 in DISPATCH_TCPIPRequest (objtag_=0xcadbfd0,
call_id_=0xcadc028, operation_id=<value optimized out>)
at Interface/odbcs_srvr.cpp:1799
#34 0x00000000004337e2 in BUILD_TCPIP_REQUEST (pnode=0xcadbfd0)
at ../Common/TCPIPSystemSrvr.cpp:603
#35 0x000000000043417d in PROCESS_TCPIP_REQUEST (pnode=0xcadbfd0)
at ../Common/TCPIPSystemSrvr.cpp:581
#36 0x0000000000462356 in CNSKListenerSrvr::tcpip_listener (arg=0xda5c60)
at Interface/linux/Listener_srvr_ps.cpp:397
#37 0x00007ffff47f92a0 in sb_thread_sthr_disp (pp_arg=0xeb5d90)
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)
