MySQL Bugs: #21296: Cluster requires upgrade of ndb

Bug #21296	Cluster requires upgrade of ndb_mgmd before upgrading data node
Submitted:	26 Jul 2006 11:45	Modified:	23 Mar 2007 1:57
Reporter:	Victoria Reznichenko	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Linux (SuSe 10.1)
Assigned to:	li zhou	CPU Architecture:	Any

Description:
According our manual there is upgrade/downgrade compatibility between 5.1.7 and 5.1.11 versions. However you can not upgrade ndbd from 5.1.17 to 5.1.11 without upgrading ndb_mgmd first.

./bin/ndbd
error=2350
2006-07-26 15:23:05 [ndbd] INFO     -- Error handler restarting system
2006-07-26 15:23:05 [ndbd] INFO     -- Error handler shutdown completed - exiting
sphase=0
exit=-1

If I upgrade ndb_mgmd to 5.1.11, I can start 5.1.11 ndbd without any problem.

How to repeat:
1. set up 5.1.7 cluster
2. shutdown 1 data node
3. run ndbd v5.1.11. It fails to start
4. stop managment node
5. run ndb_mgmd v5.1.11
6. run ndbd v 5.1.11

log of management node

Attachment: ndb_1_cluster.log (text/x-log), 30.65 KiB.

data node log file

Attachment: ndb_2_out.log (text/x-log), 6.83 KiB.

Quoting from http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-rolling-restart.html:

 The process for performing a rolling restart may be generalised as follows:

   1.

      Stop, reconfigure, then restart each cluster management node (ndb_mgmd process) in turn
   2.

      Stop, reconfigure, then restart each cluster data node (ndbd process) in turn
   3.

      Stop, reconfigure, then restart each cluster SQL node (mysqld process) in turn

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/13641

ChangeSet@1.2299, 2006-10-13 13:48:04+00:00, lzhou@dev3-138.dev.cn.tlan +1 -0
  BUG#21296 Add error messages when upgrading data node

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented fix in 5.1.17 changelog.

Added warning to Rolling Restarts section of Cluster chapter in 4.1/5.0/5.1 Manual.