showddl cores on tables with large char salt key column

Bug #1367426 reported by Suresh Subbiah on 2014-09-09
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Incomplete
Medium
Unassigned

Bug Description

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.

Changed in trafodion:
importance: Undecided → Medium
tags: added: sql-cmp
Anoop Sharma (anoop-sharma) wrote :

Which system did this problem show up? Workstation or cluster? Which release?
Any other cqds that need to be set to reproduce it?
Running these commands on a workstation with latest code does
not show this issue.

>> cqd traf_num_of_salt_partns '16';

--- SQL operation complete.
>>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"));

--- SQL operation complete.
>>
>>showddl ossdba.watch;

CREATE TABLE TRAFODION.OSSDBA.WATCH
  (
    LEGACY_ORDER_NO VARCHAR(30 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
  , WEBLOGIN VARCHAR(200 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
  , EXPIRE_DATE TIMESTAMP(0) DEFAULT NULL
  , VISITE_DATE TIMESTAMP(0) DEFAULT NULL
  , CREATION_DATE TIMESTAMP(0) DEFAULT NULL
  , OPTIONS VARCHAR(200) CHARACTER SET ISO88591
      COLLATE DEFAULT DEFAULT NULL
  , TIMING VARCHAR(10) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT NULL
  , USERS VARCHAR(200) CHARACTER SET ISO88591
      COLLATE DEFAULT DEFAULT NULL
  , FORMAT VARCHAR(200) CHARACTER SET ISO88591
      COLLATE DEFAULT DEFAULT NULL
  , PRIMARY KEY (LEGACY_ORDER_NO ASC, WEBLOGIN ASC)
  )
  SALT USING 16 PARTITIONS
;

--- SQL operation complete.
>>

Changed in trafodion:
status: New → Incomplete
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers