[
https://issues.apache.org/jira/browse/TRAFODION-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15904031#comment-15904031
]
David Wayne Birdsall commented on TRAFODION-2530:
-------------------------------------------------
The function CreateHistTables (ustat/hs_cli.cpp) calls
CmpSeabaseDDL::createHistogramTables to create histogram tables if needed.
Unfortunately, the latter method does not manage its own transaction, so this
logic is sensitive to autocommit settings. If the tdm_arkcmp process has
autocommit 'ON', all is well. But if autocommit happens to be 'OFF' the
transaction that gets started here is never committed in UPDATE STATISTICS.
Note: This issue was introduced by
https://github.com/apache/incubator-trafodion/pull/319. Formerly,
CreateHistTables would construct DDL statements itself and execute them,
explicity starting and committing its own transactions. The change was a good
change, though, as the DDL for the histograms tables was replicated in both the
ustats code and the CmpSeabaseDDL code. We just neglected to notice that
explicit begin/commit logic was still required.
> UPDATE STATISTICS is sensitive to tdm_arkcmp autocommit setting
> ---------------------------------------------------------------
>
> Key: TRAFODION-2530
> URL: https://issues.apache.org/jira/browse/TRAFODION-2530
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.1-incubating, 2.2-incubating
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
