SQL Node(API node) is not getting connected to MGMT node

[Srinivasan Umapathy]

Hi all,

I have downloaded and installed MySQL Cluster for the following configuration.

2xDB node, 1xmgmt node,1xSQL node.

Separate servers were used for the above configuration.

Both the data nodes are successfully connected to the mgmt node.

But i can't able to connect the SQL(API) node to the mgmt node. The following ERROR messages being displayed.

2014-07-01 18:23:56 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 1.0.0.113. Returned error: 'No free node id found for mysqld(API).'
2014-07-01 18:24:01 [MgmtSrvr] WARNING -- Failed to allocate nodeid for API at 1.0.0.113. Returned error: 'No free node id found for mysqld(API).'


But if we re-load the cluster manager nodes, I could see one of the data node IP address is as the SQL(API) node address.

Please find the mgmt output below:

[root@localhost mysql-cluster]# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @1.0.0.111 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0, *)
id=3 @1.0.0.112 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @1.0.0.114 (mysql-5.6.17 ndb-7.3.5)

[mysqld(API)] 1 node(s)
id=4 @1.0.0.112 (mysql-5.6.17 ndb-7.3.5)

[root@localhost mysql-cluster]#

my.cnf output for data nodes and sql nodes:

[mysqld]
ndbcluster
# IP address of the cluster management node
ndb-connectstring=1.0.0.114
[mysql_cluster]
# IP address of the cluster management node
ndb-connectstring=1.0.0.114


Please provide some pointers on the above.