Bug #64697 transaction_allow_batching variable is missing in mysql cluster 7.2.4
Submitted: 19 Mar 2012 18:49 Modified: 13 Apr 2012 12:41
Reporter: kuntal basu Email Updates:
Status: Closed Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S1 (Critical)
Version:7.2.4 OS:Any
Assigned to: CPU Architecture:Any
Tags: regression

[19 Mar 2012 18:49] kuntal basu
we are trying to upgrade mysql cluster from 5.1.56-ndb-7.1.15a to cluster 5.5.19-ndb-7.2.4..

We had used variable "transaction_allow_batching" inside our code at session level. Now when we are running the same code in the cluster 5.5.19-ndb-7.2.4.. it is throwing unable to find system variable 'transaction_allow_batching' error

How to repeat:
1. Install  cluster 5.5.19-ndb-7.2.4.
2. Try to set session variable transaction_allow_batching to 1.

The error can be repeated.
[21 Mar 2012 8:12] Valeriy Kravchuk
Verified by code review. This variable is mentioned in mysql.info, tests, comments and in sql/ha_ndbcluster.cc, but is not processed/mentioned otherwise in the code.
[22 Mar 2012 6:14] kuntal basu
Any workaround or tentative fix. Without this we will not be able to upgrade to 7.2.4
[2 Apr 2012 10:30] kuntal basu
Any update please..
[12 Apr 2012 18:02] Magnus BlÄudd
Will be added back
[13 Apr 2012 12:41] Jon Stephens
Fixed in NDB 7.2.6. Documented as follows in the NDB 7.2.6 changelog:

      The transaction_allow_batching server system variable was 
      inadvertently removed from the NDB 7.2 codebase prior to General 
      Availability. This fix restores the variable.