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