[
https://issues.apache.org/jira/browse/TRAFODION-2674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16072744#comment-16072744
]
ASF GitHub Bot commented on TRAFODION-2674:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1159#discussion_r125332529
--- Diff: core/sql/sqlcomp/nadefaults.cpp ---
@@ -2839,7 +2839,7 @@ SDDkwd__(ISO_MAPPING, (char
*)SQLCHARSETSTRING_ISO88591),
DD_____(PCODE_DEBUG_LOGDIR, "" ), // Pathname of log directory
for PCode work
DDint__(PCODE_EXPR_CACHE_CMP_ONLY, "0" ), // PCode Expr Cache
compare-only mode
DDint__(PCODE_EXPR_CACHE_DEBUG, "0" ), // PCode Expr Cache debug (set
to 1 to enable dbg logging)
- DDint__(PCODE_EXPR_CACHE_ENABLED, "1" ), // PCode Expr Cache Enabled
(set to 0 to disable the cache)
+ DDint__(PCODE_EXPR_CACHE_ENABLED, "0" ), // PCode Expr Cache Enabled
(set to 0 to disable the cache)
--- End diff --
Right. That was my screw-up. I had run compGeneral/TEST023 without running
core/TEST000 first, which sets the default schema. I had fixed that issue, but
the non-determinism in sample table name still causes random failures due to
the line wrap issue.
> 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)
