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
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S1 (Critical)
• Version: 7.2.4
• OS: Any
• CPU Architecture: Any
• Tags: regression

[19 Mar 2012 18:49] kuntal basu

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

Closed.