You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/09/02 17:54:45 UTC

[jira] [Commented] (TRAFODION-790) LP Bug: 1395840 - Alter rename cores mxosrvr at ExHbaseAccessTcb::setupUniqueKeyAndCols()

    [ https://issues.apache.org/jira/browse/TRAFODION-790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14727538#comment-14727538 ] 

Suresh Subbiah commented on TRAFODION-790:
------------------------------------------

This problem now seems to have been resolved. There were a few checkins that went in in the missing key area that may have solved it. Plans are attached to show that the problem is not seen any more. I will mark it as resolved.

prepare s1 from
update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = ? ;

prepare s2 from
update "_MD_".objects set catalog_name = 'TRAFODION', schema_name = 'SCH', object_name = 'OBJECT1' where object_uid = 1234 ;

-- Please look at begin/end keys for TRAFODION_VSBB_DELETE operator.
>>explain s1 ;

------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... S1
PLAN_ID .................. 212307799356035465
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ update "_MD_".objects
                           set catalog_name = 'TRAFODION', schema_name = 'SCH',
                             object_name = 'OBJECT1'
                           where object_uid = ? ;


------------------------------------------------------------------ NODE LISTING
ROOT ======================================  SEQ_NO 9        ONLY CHILD 8
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  max_card_est ........... 1
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  statement_index ........ 0
  affinity_value ......... 0
  max_max_cardinality .... 1
  total_overflow_size .... 0.00 KB
  upd_action_on_error .... xn_rollback
  xn_access_mode ......... read_only
  xn_autoabort_interval    0
  auto_query_retry ....... enabled for privilege checks
  plan_version ....... 2,600
  embedded_arkcmp ........ used
  self_referencing_update  forced_sort
  IS_SQLCI ............... ON
  LDAP_USERNAME
  input_variables ........ ?, %('TRAFODION'), %('SCH'), %('OBJECT1'),
                             %('TRAFODION'), %('SCH'), %('OBJECT1')


NESTED_JOIN ===============================  SEQ_NO 8        CHILDREN 6, 7
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  max_card_est ........... 1
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  join_type .............. inner
  join_method ............ nested


TRAFODION_INSERT ==========================  SEQ_NO 7        NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
  max_card_est ........... 1
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  iud_type ............... index_trafodion_insert TRAFODION."_MD_".OBJECTS_UNIQ
                             _IDX
  new_rec_expr ........... (TRAFODION."_MD_".OBJECTS_UNIQ_IDX."OBJECT_UID@"
                             assign ?), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.CATA
                             LOG_NAME assign TRAFODION."_MD_".OBJECTS.CATALOG_N
                             AME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.SCHEMA_NA
                             ME assign TRAFODION."_MD_".OBJECTS.SCHEMA_NAME),
                             (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_NAME
                             assign TRAFODION."_MD_".OBJECTS.OBJECT_NAME),
                             (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_TYPE
                             assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE)


NESTED_JOIN ===============================  SEQ_NO 6        CHILDREN 4, 5
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  max_card_est ........... 1
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  join_type .............. inner
  join_method ............ in-order nested


TRAFODION_INSERT ==========================  SEQ_NO 5        NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
  max_card_est ........... 1
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  iud_type ............... trafodion_insert TRAFODION._MD_.OBJECTS  (implements
                             update of clustering key or unique index key)
  new_rec_expr ........... (TRAFODION."_MD_".OBJECTS.CATALOG_NAME assign
                             %('TRAFODION')), (TRAFODION."_MD_".OBJECTS.SCHEMA_
                             NAME assign %('SCH')), (TRAFODION."_MD_".OBJECTS.O
                             BJECT_NAME assign %('OBJECT1')),
                             (TRAFODION."_MD_".OBJECTS.OBJECT_TYPE assign
                             TRAFODION."_MD_".OBJECTS.OBJECT_TYPE),
                             (TRAFODION."_MD_".OBJECTS.OBJECT_UID assign ?),
                             (TRAFODION."_MD_".OBJECTS.CREATE_TIME assign
                             TRAFODION."_MD_".OBJECTS.CREATE_TIME),
                             (TRAFODION."_MD_".OBJECTS.REDEF_TIME assign
                             TRAFODION."_MD_".OBJECTS.REDEF_TIME),
                             (TRAFODION."_MD_".OBJECTS.VALID_DEF assign
                             TRAFODION."_MD_".OBJECTS.VALID_DEF),
                             (TRAFODION."_MD_".OBJECTS.DROPPABLE assign
                             TRAFODION."_MD_".OBJECTS.DROPPABLE),
                             (TRAFODION."_MD_".OBJECTS.OBJECT_OWNER assign
                             TRAFODION."_MD_".OBJECTS.OBJECT_OWNER),
                             (TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER assign
                             TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER),
                             (TRAFODION."_MD_".OBJECTS.FLAGS assign
                             TRAFODION."_MD_".OBJECTS.FLAGS)


SORT ======================================  SEQ_NO 4        ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  memory_quota ........... 0 MB
  max_card_est ........... 1
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  sort_type .............. full
  self_referencing_update  forced_sort
  sort_key ............... TRAFODION."_MD_".OBJECTS.OBJECT_TYPE


NESTED_ANTI_SEMI_JOIN =====================  SEQ_NO 3        CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  max_card_est ........... 1
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  join_type .............. inner anti-semi
  join_method ............ nested


TRAFODION_VSBB_DELETE =====================  SEQ_NO 2        NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
  max_card_est ........... 1
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  iud_type ............... index_trafodion_vsbb_delete
                             TRAFODION."_MD_".OBJECTS_UNIQ_IDX
  begin_key .............. (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ = ?)
  end_key ................ (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ = ?)


TRAFODION_DELETE ==========================  SEQ_NO 1        NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
  max_card_est ........... 1
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  iud_type ............... trafodion_delete TRAFODION._MD_.OBJECTS  (implements
                             update of clustering key or unique index key)
  columns ................ all
  begin_keys(incl)
  end_keys(incl)
  predicate .............. (cast((cast(TRAFODION."_MD_".OBJECTS.OBJECT_UID) *
                             cast(1000000))) = cast(?))

--- SQL operation complete.
>>explain s2 ;

------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... S2
PLAN_ID .................. 212307799387943344
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ update "_MD_".objects
                           set catalog_name = 'TRAFODION', schema_name = 'SCH',
                             object_name = 'OBJECT1'
                           where object_uid = 1234 ;


------------------------------------------------------------------ NODE LISTING
ROOT ======================================  SEQ_NO 9        ONLY CHILD 8
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  max_card_est .......... 10
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  statement_index ........ 0
  affinity_value ......... 0
  max_max_cardinality ... 10
  total_overflow_size .... 0.00 KB
  upd_action_on_error .... xn_rollback
  xn_access_mode ......... read_only
  xn_autoabort_interval    0
  auto_query_retry ....... enabled for privilege checks
  plan_version ....... 2,600
  embedded_arkcmp ........ used
  self_referencing_update  forced_sort
  IS_SQLCI ............... ON
  LDAP_USERNAME
  input_variables ........ %('TRAFODION'), %('SCH'), %('OBJECT1'),
                             %('TRAFODION'), %('SCH'), %('OBJECT1'), %(1234)


NESTED_JOIN ===============================  SEQ_NO 8        CHILDREN 6, 7
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  max_card_est .......... 10
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  join_type .............. inner
  join_method ............ nested


TRAFODION_INSERT ==========================  SEQ_NO 7        NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
  max_card_est .......... 10
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  iud_type ............... index_trafodion_insert TRAFODION."_MD_".OBJECTS_UNIQ
                             _IDX
  new_rec_expr ........... (TRAFODION."_MD_".OBJECTS_UNIQ_IDX."OBJECT_UID@"
                             assign %(1234)), (TRAFODION."_MD_".OBJECTS_UNIQ_ID
                             X.CATALOG_NAME assign TRAFODION."_MD_".OBJECTS.CAT
                             ALOG_NAME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.SCH
                             EMA_NAME assign TRAFODION."_MD_".OBJECTS.SCHEMA_NA
                             ME), (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_NAM
                             E assign TRAFODION."_MD_".OBJECTS.OBJECT_NAME),
                             (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_TYPE
                             assign TRAFODION."_MD_".OBJECTS.OBJECT_TYPE)


NESTED_JOIN ===============================  SEQ_NO 6        CHILDREN 4, 5
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  max_card_est .......... 10
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  join_type .............. inner
  join_method ............ in-order nested


TRAFODION_INSERT ==========================  SEQ_NO 5        NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
  max_card_est .......... 10
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  iud_type ............... trafodion_insert TRAFODION._MD_.OBJECTS  (implements
                             update of clustering key or unique index key)
  new_rec_expr ........... (TRAFODION."_MD_".OBJECTS.CATALOG_NAME assign
                             %('TRAFODION')), (TRAFODION."_MD_".OBJECTS.SCHEMA_
                             NAME assign %('SCH')), (TRAFODION."_MD_".OBJECTS.O
                             BJECT_NAME assign %('OBJECT1')),
                             (TRAFODION."_MD_".OBJECTS.OBJECT_TYPE assign
                             TRAFODION."_MD_".OBJECTS.OBJECT_TYPE),
                             (TRAFODION."_MD_".OBJECTS.OBJECT_UID assign
                             %(1234)), (TRAFODION."_MD_".OBJECTS.CREATE_TIME
                             assign TRAFODION."_MD_".OBJECTS.CREATE_TIME),
                             (TRAFODION."_MD_".OBJECTS.REDEF_TIME assign
                             TRAFODION."_MD_".OBJECTS.REDEF_TIME),
                             (TRAFODION."_MD_".OBJECTS.VALID_DEF assign
                             TRAFODION."_MD_".OBJECTS.VALID_DEF),
                             (TRAFODION."_MD_".OBJECTS.DROPPABLE assign
                             TRAFODION."_MD_".OBJECTS.DROPPABLE),
                             (TRAFODION."_MD_".OBJECTS.OBJECT_OWNER assign
                             TRAFODION."_MD_".OBJECTS.OBJECT_OWNER),
                             (TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER assign
                             TRAFODION."_MD_".OBJECTS.SCHEMA_OWNER),
                             (TRAFODION."_MD_".OBJECTS.FLAGS assign
                             TRAFODION."_MD_".OBJECTS.FLAGS)


SORT ======================================  SEQ_NO 4        ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  memory_quota ........... 0 MB
  max_card_est .......... 10
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  sort_type .............. full
  self_referencing_update  forced_sort
  sort_key ............... TRAFODION."_MD_".OBJECTS.OBJECT_TYPE


NESTED_ANTI_SEMI_JOIN =====================  SEQ_NO 3        CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
  max_card_est .......... 10
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  join_type .............. inner anti-semi
  join_method ............ nested


TRAFODION_VSBB_DELETE =====================  SEQ_NO 2        NO CHILDREN
TABLE_NAME ............... TRAFODION."_MD_".OBJECTS_UNIQ_IDX
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
  max_card_est .......... 10
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  iud_type ............... index_trafodion_vsbb_delete
                             TRAFODION."_MD_".OBJECTS_UNIQ_IDX
  begin_key .............. (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ =
                             %(1234))
  end_key ................ (TRAFODION."_MD_".OBJECTS_UNIQ_IDX.OBJECT_UID@ =
                             %(1234))


TRAFODION_DELETE ==========================  SEQ_NO 1        NO CHILDREN
TABLE_NAME ............... TRAFODION._MD_.OBJECTS
REQUESTS_IN .............. 1
ROWS_OUT ................ 10
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
DESCRIPTION
  max_card_est .......... 10
  fragment_id ............ 0
  parent_frag ............ (none)
  fragment_type .......... master
  iud_type ............... trafodion_delete TRAFODION._MD_.OBJECTS  (implements
                             update of clustering key or unique index key)
  columns ................ all
  begin_keys(incl)
  end_keys(incl)
  predicate .............. (TRAFODION."_MD_".OBJECTS.OBJECT_UID = %(1234))

--- SQL operation complete.


> 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)