Bug #51301 MySQL Cluster : DDL during 6.3->7.0 upgrade should fail
Submitted: 18 Feb 2010 23:38 Modified: 8 Apr 2010 16:51
Reporter: Frazer Clement Email Updates:
Status: Patch pending Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.1-telco-6.2 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[18 Feb 2010 23:38] Frazer Clement 
Description:
The 'traditional' upgrade procedure is to upgrade all MGMDs, then NDBDs, then API nodes.

This procedure can normally result in the following combinations of interactions between Api and data nodes :
1) Old Api talking to all old data nodes (Normal)
2) Old Api talking to mix of old and new data nodes (Mixed data nodes)
3) Old Api talking to all new data nodes (API backwards compatibility)
4) New Api talking to all new data nodes (Normal)

For the 6.3 -> 7.0 upgrade, DDL such as create table, drop table issued from a 6.3 Api node has odd results in configurations 2) and 3).

This should be fixed so that :
 - DDL is always cleanly rejected in mixed data node configurations
   (This appears to occur cleanly from 7.0 onwards)
 - DDL issued from 6.3 API nodes is rejected by 7.0 data nodes.

How to repeat:
Perform partial upgrades as shown above.

Attempt DDL such as create table, drop table.

Suggested fix:
Improve mixed node configuration checks in 6.3 kernel DDL processing.
Improve API version checking in 7.0 kernel DDL processing.
[8 Apr 2010 16:51] 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/105245

3495 Frazer Clement	2010-04-08
      testUpgrade (7.0) improvements for bug#51301
[8 Apr 2010 16:53] 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/105246

3177 Frazer Clement	2010-04-08
      testUpgrade improvements (6.3) for bug#51301