You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:14:27 UTC

[jira] [Created] (TRAFODION-161) LP Bug: 1268028 - Update statistics returns transaction error 8841

Alice Chen created TRAFODION-161:
------------------------------------

             Summary: LP Bug: 1268028 - Update statistics returns transaction error 8841
                 Key: TRAFODION-161
                 URL: https://issues.apache.org/jira/browse/TRAFODION-161
             Project: Apache Trafodion
          Issue Type: Bug
          Components: dtm
            Reporter: Weishiun Tsai
            Assignee: Hans Zeller
            Priority: Critical


When running update statistics on 3 tables consecutively, it often returns transaction error 8841 on the 2nd or the 3rd table, as shown in the following example.  This is seen on the beta build 20140108-v36687 running on a workstation.

>>create table t1 (a int);

--- SQL operation complete.
>>insert into table t1 values (1);

--- 1 row(s) inserted.
>>update statistics for table t1 on every column;

--- SQL operation complete.
>>create table t2 (a int);

--- SQL operation complete.
>>insert into table t2 values (1);

--- 1 row(s) inserted.
>>update statistics for table t2 on every column;

--- SQL operation complete.
>>create table t3 (a int);

--- SQL operation complete.
>>insert into table t3 values (1);

--- 1 row(s) inserted.
>>update statistics for table t3 on every column;

*** ERROR[8841] User application committed or aborted a transaction started by SQL.  This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK.

--- SQL operation failed with errors.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)