[
https://issues.apache.org/jira/browse/TRAFODION-2341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15678300#comment-15678300
]
ASF GitHub Bot commented on TRAFODION-2341:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/836
> UPDATE STATISTICS sometimes fails with error 8605
> -------------------------------------------------
>
> Key: TRAFODION-2341
> URL: https://issues.apache.org/jira/browse/TRAFODION-2341
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.1-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> Update statistics sometimes fails with error 8605, Committing a transaction
> which has not started, as in this example:
> SQL>update statistics for table mytable_47 on existing columns incremental
> where b>=0;
> *** ERROR[9200] UPDATE STATISTICS for table
> TRAFODION.UPDATESTATS_INCREMENTAL_NEW.MYTABLE_47 encountered an error (8605)
> from statement Process_Query. [2016-10-13 12:20:16]
> *** ERROR[8605] Committing a transaction which has not started. [2016-10-13
> 12:20:16]
> These failures are sporadic and non-deterministic. They can be reproduced by
> running two streams containing SQL statements to create, load (e.g. using
> UPSERT USING LOAD), update statistics persistent, inserts, and update
> statistics incremental. In the example I am working with, the two streams
> deal with separate sets of tables but in the same schema.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
