MySQL Bugs: #44578: Cannot start ndb_mgmd with preallocated nodes for online add node

Bug #44578	Cannot start ndb_mgmd with preallocated nodes for online add node
Submitted:	30 Apr 2009 16:20	Modified:	17 Mar 2010 14:43
Reporter:	Alexander Yu	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S2 (Serious)
Version:	mysql-5.1-telco-7.0	OS:	Any (Darwin ender.local 9.6.0 Darwin Kernel Version 9.6.0: Mon Nov 24 17:37:00 PST 2008; root:xnu-1228.9.)
Assigned to:	Jon Stephens	CPU Architecture:	Any
Tags:	MySQL Cluster, nodegroup, online add node

Description:
According to the ref manual, preallocating nodes can be done by using the nodegroup parameter set to 65535. It does not work.

--
$ ndb_mgmd --initial --reload -f etc/2-to-4-nodes.ini 
2009-04-30 18:11:23 [MgmSrvr] INFO     -- NDB Cluster Management Server. mysql-5.1.32 ndb-7.0.6
2009-04-30 18:11:23 [MgmSrvr] INFO     -- Reading cluster configuration from 'etc/2-to-4-nodes.ini'
2009-04-30 18:11:23 [MgmSrvr] ERROR    -- at line 66: Invalid nodegroup 65535 for node 4

2009-04-30 18:11:23 [MgmSrvr] ERROR    -- Could not load configuration from 'etc/2-to-4-nodes.ini'

How to repeat:
[ndbd default]
DataMemory = 128M
IndexMemory = 32M
NoOfReplicas = 2
DataDir: /Users/alyu/Projects/db/data/cluster
FileSystemPath: /Users/alyu/Projects/db/data/cluster

[ndbd]
Id = 1
HostName = localhost

[ndbd]
Id = 2
HostName = localhost

[mgm]
Id=3
HostName = localhost

[ndbd]
Id = 4
HostName = localhost
NodeGroup = 65535

[ndbd]
Id = 5
HostName = localhost
NodeGroup = 65535

[api]
Id=20
HostName = localhost

[api]
Id=21
HostName = localhost

[api]
[api]
[api]
[api]

Thank you for the report.

Verified as described.

mysql-5.1.32 ndb-7.0.6

This is a docs bug, the nodegroup should 65536 not 65535

Corrected Category/Lead.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.