[jira] [Commented] (TRAFODION-2530) UPDATE STATISTICS is sensitive to tdm_arkcmp autocommit setting

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

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