[
https://issues.apache.org/jira/browse/TRAFODION-2674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16071815#comment-16071815
]
ASF GitHub Bot commented on TRAFODION-2674:
-------------------------------------------
GitHub user sureshsubbiah opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1159
[TRAFODION-2674] Create index sees error 2006 internal assertion
RangePartitionFunction was missing region boundaries for indexes and using
table's
boundaries incorrectly
Turned OFF OPT_PCODE_CACHE to avoid mem leak.
Unrelated testware change for compGeneral/TEST023
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sureshsubbiah/incubator-trafodion 3403
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1159.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1159
----
commit f47c26136d70b275d14a97e8b9cd1cacb3d6dedd
Author: Suresh Subbiah <[email protected]>
Date: 2017-07-02T20:59:25Z
[TRAFODION-2674] Create index sees error 2006 internal assertion
RangePartitionFunction was missing region boundaries for indexes and using
table's
boundaries incorrectly
Turned OFF OPT_PCODE_CACHE to avoid mem leak.
Unrelated testware change for compGeneral/TEST023
----
> 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)
