Failed to allocate nodeid for mysqld
Hello
I created a NDB cluster of 4 data nodes, 1 management node, 3 server nodes. When I try to start my cluster, I get the following error:
----------------------------------------------------
2021-06-21 18:36:01 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.31.63.143. Returned error: 'No free node id found for mysqld(API).' - Repeated 2 times
2021-06-21 18:36:01 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.31.49.54. Returned error: 'No free node id found for mysqld(API).'
2021-06-21 18:36:01 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.31.49.54. Returned error: 'No free node id found for mysqld(API).'
2021-06-21 18:36:01 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 172.31.55.144. Returned error: 'No free node id found for mysqld(API).'
----------------------------------------------------
How can I resolve this?
Thanks!
Deepak
My Config file:
------------------------
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=3500M # How much memory to allocate for data storage
IndexMemory=1000M # How much memory to allocate for index storage
MaxNoOfConcurrentOperations=1048576
MaxNoOfConcurrentTransactions= 1048576
MaxNoOfLocalOperations=1048576
MaxNoOfConcurrentIndexOperations=16384
MaxNoOfConcurrentScans=500
[ndb_mgmd]
# Management process options:
hostname=172.31.63.143 # Hostname of the manager
datadir=/var/lib/mysql-cluster # Directory for the log files
[ndbd]
hostname=172.31.50.227 # Hostname/IP of the first data node
NodeId=2 # Node ID for this data node
datadir=/usr/local/mysql/data # Remote directory for the data files
[ndbd]
hostname=172.31.48.145 # Hostname/IP of the second data node
NodeId=3 # Node ID for this data node
datadir=/usr/local/mysql/data # Remote directory for the data files
[ndbd]
hostname=172.31.52.45 # Hostname/IP of the second data node
NodeId=4 # Node ID for this data node
datadir=/usr/local/mysql/data # Remote directory for the data files
[ndbd]
hostname=172.31.49.125 # Hostname/IP of the second data node
NodeId=5 # Node ID for this data node
datadir=/usr/local/mysql/data # Remote directory for the data files
[mysqld]
# SQL node options:
hostname=172.31.63.143 # In our case the MySQL server/client is on the same Droplet as the cluster manager
[mysqld]
# SQL node options:
hostname=172.31.55.144 # In our case the MySQL server/client is not on the same Droplet as the cluster manager
[mysqld]
# SQL node options:
hostname=172.31.49.54 # In our case the MySQL server/client is not on the same Droplet as the cluster manager
------------------------
Subject
Views
Written By
Posted
Failed to allocate nodeid for mysqld
1962
June 21, 2021 12:44PM
772
June 21, 2021 01:17PM
686
June 21, 2021 01:59PM
734
June 22, 2021 05:24AM
742
June 22, 2021 06:47AM
767
June 22, 2021 06:49AM
705
June 22, 2021 08:16AM
732
June 23, 2021 04:48AM
688
June 23, 2021 05:58AM
595
July 03, 2021 09:12AM
639
July 03, 2021 11:20AM
557
July 06, 2021 04:27AM
595
July 06, 2021 06:34AM
681
July 06, 2021 10:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.