MySQL Forums
Forum List  »  NDB clusters

Failed to allocate nodeid, error: 'Error: Could not alloc node id at .. : Connection done from wrong host
Posted by: Lars Holmström
Date: July 10, 2017 05:02AM

I intend to build a 5 node cluster but have a slight issue I need assistance to have resolved;

All nodes are running Ubuntu 14.04 and MySQL 5.7.18 ndb 7.5..6

I start my single management node without any problem

Mgmt # ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 (not connected, accepting connect from 10.215.2.70)
id=2 (not connected, accepting connect from 10.215.2.71)

[ndb_mgmd(MGM)] 1 node(s)
id=5 @10.215.2.74 (mysql-5.7.18 ndb-7.5.6)

[mysqld(API)] 2 node(s)
id=3 (not connected, accepting connect from 10.215.2.72)
id=4 (not connected, accepting connect from 10.215.2.73)

Mgmt #

Next the two SQL-nodes join nicely
SQL1# sudo ndbd
2017-07-10 10:50:09 [ndbd] INFO -- Angel connected to '10.215.2.74:1186'
2017-07-10 10:50:24 [ndbd] INFO -- Angel allocated nodeid: 1
SQL1#

SQL2# ndb_mgm -e show
Connected to Management Server at: 10.215.2.74:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 @10.215.2.70 (mysql-5.7.18 ndb-7.5.6, Nodegroup: 0, *)
id=2 @10.215.2.71 (mysql-5.7.18 ndb-7.5.6, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=5 @10.215.2.74 (mysql-5.7.18 ndb-7.5.6)

[mysqld(API)] 2 node(s)
id=3 (not connected, accepting connect from 10.215.2.72)
id=4 (not connected, accepting connect from 10.215.2.73)

SQL2#

Issue
-----
But my two remaining does not join.
Data1 # sudo ndbd
2017-07-10 10:54:04 [ndbd] INFO -- Angel connected to '10.215.2.74:1186'
2017-07-10 10:54:04 [ndbd] ERROR -- Failed to allocate nodeid, error: 'Error: Could not alloc node id at 10.215.2.74 port 1186: Connection done from wrong host ip 10.215.2.72.'
Data1 #
Data1 #

Following is my config.ini file that are identical on all 5 nodes
----------------------------------------------------------------
Data1 #
Data1 # cat /var/lib/mysql-cluster/config.ini
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataMemory=80M # How much memory to allocate for data storage
IndexMemory=18M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example NDB Cluster setup.
ServerPort=2202 # This the default value; however, you can use any
# port that is free for all the hosts in the cluster
# Note1: It is recommended that you do not specify the port
# number at all and simply allow the default value to be used
# instead
# Note2: The port was formerly specified using the PortNumber
# TCP parameter; this parameter is no longer available in NDB
# Cluster 7.5.

[ndb_mgmd]
# Management process options:
HostName=10.215.2.74 # Hostname or IP address of MGM node
DataDir=/var/lib/mysql-cluster # Directory for MGM node log files

[ndbd]
# Options for data node "A":
# (one [ndbd] section per data node)
HostName=10.215.2.72 # Hostname or IP address
NodeId=2 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files

[ndbd]
# Options for data node "B":
HostName=10.215.2.73 # Hostname or IP address
NodeId=3 # Node ID for this data node
DataDir=/usr/local/mysql/data # Directory for this data node's data files

[mysqld]
# SQL node options:
HostName=10.215.2.70 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)

[mysqld]
# SQL node options:
HostName=10.215.2.71 # Hostname or IP address
# (additional mysqld connections can be
# specified for this node for various
# purposes such as running ndb_restore)

[mysqld]
[mysqld]
Data1 #


All assistance is appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Failed to allocate nodeid, error: 'Error: Could not alloc node id at .. : Connection done from wrong host
355
July 10, 2017 05:02AM


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.