My Oracle Support Banner

NDB Cluster Manager Failure To Allocate NodeId (Doc ID 2084854.1)

Last updated on JULY 24, 2017

Applies to:

MySQL Cluster - Version 7.3 and later
Information 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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.