Bug #24748 closeTransaction can cause unnecessary round-trip
Submitted: 1 Dec 2006 10:22 Modified: 7 Dec 2006 4:31
Reporter: Jonas Oreland Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: NDB API Severity:S3 (Non-critical)
Version:4.1, 5.0, 5.1 OS:
Assigned to: Jonas Oreland CPU Architecture:Any

[1 Dec 2006 10:22] Jonas Oreland 
Description:
closeTransaction can cause unnecessary round-trip if transaction
  contained only committedRead and was not finished with either Rollback/Commit

How to repeat:
startTransaction()
committedRead
execute(NoCommit)
closeTransaction();

here closeTransaction will fire a ROLLBACK towards kernel,
  which is not needed

Suggested fix:
Work-around,
use execute(Commit) in example above...
[1 Dec 2006 10:36] 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:

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

ChangeSet@1.2275, 2006-12-01 11:24:37+01:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#24748
    Skip rollback if only committedRead in transaction
[5 Dec 2006 14:21] Jonas Oreland 
wont fix in 4.1
[7 Dec 2006 4:31] Jon Stephens 
No changes visible to end users, hence nothing to document. Closed.