[jira] [Created] (TRAFODION-609) LP Bug: 1367426 - showddl cores on tables with large char salt key column

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-609:
------------------------------------

             Summary: LP Bug: 1367426 - showddl cores on tables with large char salt key column
                 Key: TRAFODION-609
                 URL: https://issues.apache.org/jira/browse/TRAFODION-609
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Suresh Subbiah


cqd tarf_num_of_salt_partns '16' ;

CREATE TABLE "OSSDBA"."WATCH"
   (    "LEGACY_ORDER_NO" VARCHAR2(30 bytes) character set utf8 NOT NULL,
        "WEBLOGIN" VARCHAR2(200 bytes) character set utf8 NOT NULL,
        "EXPIRE_DATE" TIMESTAMP(0),
        "VISITE_DATE" TIMESTAMP(0),
        "CREATION_DATE" TIMESTAMP(0),
        "OPTIONS" VARCHAR2(200),
        "TIMING" VARCHAR2(10),
        "USERS" VARCHAR2(200),
        "FORMAT" VARCHAR2(200),
         PRIMARY KEY ("LEGACY_ORDER_NO", "WEBLOGIN"));

showddl ossdba.watch ;
-- will produce a core file with this stack

(gdb) bt
#0  0x000000309f4328a5 in raise () from /lib64/libc.so.6
#1  0x000000309f434085 in abort () from /lib64/libc.so.6
#2  0x00007ffff6ec9455 in os::abort(bool) ()
   from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#3  0x00007ffff7029717 in VMError::report_and_die() ()
   from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#4  0x00007ffff6eccf60 in JVM_handle_linux_signal ()
   from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#5  <signal handler called>
#6  0x00007ffff12b04f8 in NACollection<ItemExpr*>::entries (this=0x0)
    at ../common/Collections.h:335
#7  0x00007fffefabd74e in RangePartitionBoundaries::completePartitionBoundaries
    (this=0x7fffd8ad5820, partitioningKeyOrder=..., 
    encodedBoundaryKeyLength=234, isSQLMPTable=0)
    at ../optimizer/PartFunc.cpp:3545
#8  0x00007fffefabff64 in RangePartitioningFunction::createPartitioningFunctionForIndexDesc (this=0x7fffd7738158, idesc=0x7fffd8ad0a78)
    at ../optimizer/PartFunc.cpp:4226
#9  0x00007fffef84f41f in IndexDesc::IndexDesc (this=0x7fffd8ad0a78, tdesc=
    0x7fffd8adb8d8, fileSet=0x7fffd77383d0, cmpContext=0x7fffe851e090)
    at ../optimizer/IndexDesc.cpp:237
#10 0x00007fffef6f5c3b in createTableDesc2 (bindWA=0x7ffffffede00, naTable=
    0x7fffd8aff0d0, corrName=..., hint=0x0)
---Type <return> to continue, or q <return> to quit---
    at ../optimizer/BindRelExpr.cpp:1582
#11 0x00007fffef6f622a in BindWA::createTableDesc (this=0x7ffffffede00, 
    naTable=0x7fffd8aff0d0, corrName=..., catmanCollectUsages=0, hint=0x0)
    at ../optimizer/BindRelExpr.cpp:1660
#12 0x00007ffff122996a in CmpDescribeSeabaseTable (dtName=..., type=2, 
    outbuf=@0x7fffd8b14110, outbuflen=@0x7fffd8b14108, heap=0x7fffe90b5c18, 
    pkeyStr=0x0, withPartns=1, noTrailingSemi=0)
    at ../sqlcomp/CmpDescribe.cpp:2453
#13 0x00007ffff1223bed in CmpDescribe (query=0x7fffd8b19088 "showddl watch ;", 
    queryExpr=0x7fffd8ad4180, outbuf=@0x7fffd8b14110, 
    outbuflen=@0x7fffd8b14108, heap=0x7fffe90b5c18)
    at ../sqlcomp/CmpDescribe.cpp:801
#14 0x00007ffff581b893 in CmpStatement::process (this=0x7fffd8b16378, 
    statement=...) at ../arkcmp/CmpStatement.cpp:977
#15 0x00007ffff580eb6c in CmpContext::compileDirect (this=0x7fffe851e090, 
    data=0x7fffe90cbab8 "showddl watch ;", data_len=15, 
    outHeap=0x7fffe9b25660, charset=15, op=CmpMessageObj::DESCRIBE, 
    gen_code=@0x7fffe90b9660, gen_code_len=@0x7fffe90b9668, parserFlags=0, 
    diagsArea=0x7fffe90e4970) at ../arkcmp/CmpContext.cpp:736
#16 0x00007ffff4fae976 in ExDescribeTcb::work (this=0x7fffe90b9338)
    at ../executor/ex_ddl.cpp:583
#17 0x00007ffff4fc158f in ex_tcb::sWork (tcb=0x7fffe90b9338)
    at ../executor/ex_tcb.h:99
---Type <return> to continue, or q <return> to quit---
#18 0x00007ffff50c2c33 in ExSubtask::work (this=0x7fffe90b9d30)
    at ../executor/ExScheduler.cpp:751
#19 0x00007ffff50c1ff6 in ExScheduler::work (this=0x7fffe90b8ea0, 
    prevWaitTime=0) at ../executor/ExScheduler.cpp:328
#20 0x00007ffff500134b in ex_root_tcb::execute (this=0x7fffe90b9db0, 
    cliGlobals=0xb90480, glob=0x7fffe90c44c8, input_desc=0x7fffe90d2998, 
    diagsArea=@0x7fffffff3330, reExecute=0) at ../executor/ex_root.cpp:1025
#21 0x00007ffff625d211 in CliStatement::execute (this=0x7fffe90e5ec8, 
    cliGlobals=0xb90480, input_desc=0x7fffe90d2998, diagsArea=..., 
    execute_state=CliStatement::INITIAL_STATE_, fixupOnly=0, cliflags=0)
    at ../cli/Statement.cpp:4740
#22 0x00007ffff620280f 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=0xb90480, tasks=4882, 
    statement_id=0xd09a50, input_descriptor=0x162f900, output_descriptor=0x0, 
    num_input_ptr_pairs=0, num_output_ptr_pairs=0, ap=0x7fffffff3900, 
    input_ptr_pairs=0x0, output_ptr_pairs=0x0) at ../cli/Cli.cpp:3269
#23 0x00007ffff6203180 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *, Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *) (
    cliGlobals=0xb90480, statement_id=0xd09a50, input_descriptor=0x162f900, 
    num_ptr_pairs=0, ap=0x7fffffff3900, ptr_pairs=0x0) at ../cli/Cli.cpp:3516
#24 0x00007ffff62702d6 in SQL_EXEC_Exec (statement_id=0xd09a50, 
    input_descriptor=0x162f900, num_ptr_pairs=0) at ../cli/CliExtern.cpp:2062

If the weblogin column is something smaller like 20 bytes then the core is not seen.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)