David Wayne Birdsall created TRAFODION-2341:
-----------------------------------------------
Summary: 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)
