[jira] [Resolved] (TRAFODION-2674) Create index sees error 2006 internal assertion (keyColOffset == totalKeyLength)

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-2674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah resolved TRAFODION-2674.
---------------------------------------
    Resolution: Fixed

> Create index sees error 2006 internal assertion (keyColOffset == totalKeyLength)
> --------------------------------------------------------------------------------
>
>                 Key: TRAFODION-2674
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2674
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: any
>            Reporter: Suresh Subbiah
>            Assignee: Suresh Subbiah
>             Fix For: 2.3-incubating
>
>
> 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. 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)