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

[26 Jul 2006 11:45] Victoria Reznichenko
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
[26 Jul 2006 13:29] Victoria Reznichenko
log of management node

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

[26 Jul 2006 13:29] Victoria Reznichenko
data node log file

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

[2 Aug 2006 5:54] Stewart Smith
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
[13 Oct 2006 5:37] 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/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
[23 Mar 2007 1:57] Jon Stephens
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.