NDB Cluster Manager Failure To Allocate NodeId
(Doc ID 2084854.1)
Last updated on SEPTEMBER 24, 2020
Applies to:
MySQL Cluster - Version 7.3 and laterInformation in this document applies to any platform.
Symptoms
Typically in a new MySQL Cluster Environment, or potentially after a configuration change , the management node will issue an error on a cluster start ( rolling or otherwise ) similar to;
2015-11-18 21:00:55 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.16.22.91. Returned error: 'Id 111 already allocated by another node.'
This error is misleading.
2015-11-18 21:00:55 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.16.22.91. Returned error: 'Id 111 already allocated by another node.'
2015-11-18 21:00:58 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.16.22.91. Returned error: 'Id 111 already allocated by another node.'
2015-11-18 21:01:00 [MgmtSrvr] INFO -- Nodeid 1 allocated for NDB at 172.16.22.22
2015-11-18 21:01:00 [MgmtSrvr] ALERT -- Node 1: Forced node shutdown completed, restarting. Occured during startphase 0. Initiated by signal 6.
2015-11-18 21:01:01 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.16.22.91. Returned error: 'Id 111 already allocated by another node.'
2015-11-18 21:01:02 [MgmtSrvr] INFO -- Nodeid 2 allocated for NDB at 172.16.22.22
2015-11-18 21:01:03 [MgmtSrvr] ALERT -- Node 2: Forced node shutdown completed, restarting. Occured during startphase 0. Initiated by signal 6.
2015-11-18 21:01:05 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.16.22.91. Returned error: 'Id 111 already a
2015-11-18 21:00:58 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.16.22.91. Returned error: 'Id 111 already allocated by another node.'
2015-11-18 21:01:00 [MgmtSrvr] INFO -- Nodeid 1 allocated for NDB at 172.16.22.22
2015-11-18 21:01:00 [MgmtSrvr] ALERT -- Node 1: Forced node shutdown completed, restarting. Occured during startphase 0. Initiated by signal 6.
2015-11-18 21:01:01 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.16.22.91. Returned error: 'Id 111 already allocated by another node.'
2015-11-18 21:01:02 [MgmtSrvr] INFO -- Nodeid 2 allocated for NDB at 172.16.22.22
2015-11-18 21:01:03 [MgmtSrvr] ALERT -- Node 2: Forced node shutdown completed, restarting. Occured during startphase 0. Initiated by signal 6.
2015-11-18 21:01:05 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.16.22.91. Returned error: 'Id 111 already a
Changes
Potentially a new MySQL Cluster environment is being setup or a recent Cluster config change has been made.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| the cluster node startup sequence |
| Bad Config value |
| Solution |
| References |