Re: Failed to allocate nodeid for mysqld

[Deepak Goel]

The funny thing is:

When I run (mysql -u root -p) and run the command "SHOW ENGINE NDB STATUS \G", I get the following output:

------------------------------------------------------------------------------
Type: ndbcluster
Name: connection
Status: cluster_node_id=0, connected_host=172.31.63.143, connected_port=1186, number_of_data_nodes=0, number_of_ready_data_nodes=0, connect_count=0
------------------------------------------------------------------------------

However when I run the command "ndb_mgm (show)", I get the following output:
------------------------------------------------------------------------------
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=2 @172.31.50.227 (mysql-5.7.22 ndb-7.6.6, Nodegroup: 0)
id=3 @172.31.48.145 (mysql-5.7.22 ndb-7.6.6, Nodegroup: 0, *)
id=4 @172.31.52.45 (mysql-5.7.22 ndb-7.6.6, Nodegroup: 1)
id=5 @172.31.49.125 (mysql-5.7.22 ndb-7.6.6, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @172.31.63.143 (mysql-5.7.22 ndb-7.6.6)

[mysqld(API)] 13 node(s)
id=6 @172.31.63.143 (mysql-5.7.22 ndb-7.6.6)
id=7 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=8 @172.31.49.54 (mysql-5.7.22 ndb-7.6.6)
id=9 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=10 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=11 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=12 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=13 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=14 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=15 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=16 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=17 @172.31.55.144 (mysql-5.7.22 ndb-7.6.6)
id=18 @172.31.49.54 (mysql-5.7.22 ndb-7.6.6)

------------------------------------------------------------------------------

Thanks!



Edited 1 time(s). Last edit at 06/22/2021 05:41AM by Deepak Goel.