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

["Atanu Mishra (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696213#comment-14696213 ] 

Atanu Mishra commented on TRAFODION-161:
----------------------------------------

Hans Zeller (hans-zeller) wrote on 2014-02-13:	#1
I can't reproduce this issue anymore, neither on the beta release nor on datalake_64_1. Looks like this got fixed already. Will close the bug if I don't see it in the near future. Wei-Shiun, have you seen this recently?

Changed in trafodion:
status:	New → In Progress
Hans Zeller (hans-zeller) wrote on 2014-02-13:	#2
Wei-Shiun also verified that it works now. It got fixed, but we don't know exactly when and by whom.

Changed in trafodion:
status:	In Progress → Fix Released


> 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
>             Fix For: 1.0 (pre-incubation)
>
>
> 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)