Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2674

Create index sees error 2006 internal assertion (keyColOffset == totalKeyLength)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • any
    • 2.3
    • sql-cmp
    • None

    Description

      Problem was discovered by Weishiun Tsai. This JIRA is being created on Weishiun's behalf.
      As shown below, the 2nd create index sees an internal error 2006 with assertion failure (keyColOffset == totalKeyLength) in file ../optimizer/NATable.cpp Once it occurs, all of the following create index starts to fail with the same error as well. Sometimes the assertion is different. It could also be *** ERROR[2006] Internal error: assertion failure (*bufLen >= vcLenHdrSize + valBufLen) in file ../common/CharType.cpp at line 1189.

      To reproduce

      create table partsupp (
      ps_partkey int not null not droppable,
      ps_suppkey int not null not droppable,
      ps_availqty int,
      ps_supplycost numeric(12, 2),
      ps_comment varchar(199),
      primary key (ps_partkey, ps_suppkey))
      salt using 8 partitions;

      create index myidx_partsupp_2 on partsupp (ps_partkey, ps_suppkey, ps_availqty, ps_supplycost, ps_comment) salt like table;

      create index myidx_partsupp_3 on partsupp (ps_partkey, ps_suppkey, ps_availqty, ps_supplycost, ps_comment) salt like table;

      create unique index myidx_partsupp_6 on partsupp (ps_partkey, ps_suppkey);

      showddl partsupp;

      Errors seen are

      >>create index myidx_partsupp_3 on partsupp (ps_partkey, ps_suppkey, ps_availqty, ps_supplycost, ps_comment) salt like table;

          • ERROR[2006] Internal error: assertion failure (*bufLen >= vcLenHdrSize + valBufLen) in file ../common/CharType.cpp at line 1189.
          • ERROR[8822] The statement was not prepared.
          • ERROR[1081] Loading of index TRAFODION.SEABASE.MYIDX_PARTSUPP_3 failed unexpectedly.

      OR

          • ERROR[2006] Internal error: assertion failure (keyColOffset == totalKeyLength) in file ../optimizer/NATable.cpp at line 1750.
          • ERROR[8822] The statement was not prepared.
          • ERROR[1081] Loading of index TRAFODION.SEABASE.MYIDX_PARTSUPP_3 failed unexpectedly.

      — SQL operation failed with errors.

      Attachments

        Issue Links

          Activity

            People

              suresh_subbiah Suresh Subbiah
              suresh_subbiah Suresh Subbiah
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: