MySQL Forums
Forum List  »  NDB clusters

Re: Failed to allocate nodeid for mysqld
Posted by: Deepak Goel
Date: June 22, 2021 05:24AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Failed to allocate nodeid for mysqld
179
June 22, 2021 05:24AM


Sorry, only registered users may post in this forum.

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.