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:
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

[1 Sep 2008 15:59] Joerg Bruehe
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
+ERROR HY000: Got error 4350 'Transaction already aborted' from NDBCLUSTER
 select * from t1 order by f1;
 select * from t2 order by f2;
 select * from t3 order by f3;
 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.
[7 Sep 2010 7:59] Jonas Oreland
This is sort of a duplicate of Bug#32656, which has been fixed
reenabling testcase...

No need for docs.
[7 Sep 2010 8:01] Bugs System
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:


3284 Jonas Oreland	2010-09-07
      ndb - bug#39162 - reenable test
[7 Sep 2010 10:15] Bugs System
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)
[7 Sep 2010 10:15] Bugs System
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)