MySQL Bugs: #39162: "insert ; commit" fails due to 'Transaction already aborted' from NDBCLUSTER

Bug #39162	"insert ; commit" fails due to 'Transaction already aborted' from NDBCLUSTER
Submitted:	1 Sep 2008 15:59	Modified:	7 Sep 2010 10:17
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S1 (Critical)
Version:	mysql-5.1-telco-6.3	OS:	Any
Assigned to:	Jonas Oreland	CPU Architecture:	Any
Tags:	mysql-5.1-telco-6.3 -> 6.3.17

Description:
This test failure occurs on *all* platforms during the build of cluster 6.3.17 (perfectly reproducible):

=====
funcs_1.ndb_trig_1011ext       [ fail ]

--- /PATH/mysql-test/suite/funcs_1/r/ndb_trig_1011ext.result
+++ /PATH/mysql-test/suite/funcs_1/r/ndb_trig_1011ext.reject
@@ -384,16 +384,14 @@
 insert into t1 values (1);
 ERROR 22003: Out of range value for column 'f4' at row 1
 commit;
+ERROR HY000: Got error 4350 'Transaction already aborted' from NDBCLUSTER
 select * from t1 order by f1;
 f1
 1
-1
 select * from t2 order by f2;
 f2
-2
 select * from t3 order by f3;
 f3
-3
 drop trigger tr1;
 drop trigger tr2;
 drop trigger tr3;
=====

The command directly preceding the "insert" is a "start transaction", so it is a single-command transaction.

How to repeat:
Run the *full* test suite.

Suggested fix:
Run the *full* test suite during development.

If the transaction abort is intentional after a range violation,
then maintain the result files.

This is sort of a duplicate of Bug#32656, which has been fixed
reenabling testcase...

No need for docs.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/117671

3284 Jonas Oreland	2010-09-07
      ndb - bug#39162 - reenable test

Pushed into mysql-5.1-telco-6.3 5.1.47-ndb-6.3.38 (revid:jonas@mysql.com-20100907101036-qolf8gskc2j2ec1f) (version source revid:jonas@mysql.com-20100907075829-wbulreqqzxx3uqyc) (merge vers: 5.1.47-ndb-6.3.38) (pib:21)

Pushed into mysql-5.1-telco-7.0 5.1.47-ndb-7.0.19 (revid:jonas@mysql.com-20100907101306-bj322y2kx6ju7hvk) (version source revid:jonas@mysql.com-20100907101306-bj322y2kx6ju7hvk) (merge vers: 5.1.47-ndb-7.0.19) (pib:21)