No free node id found for mysqld(API)
Posted by: Jan Millar
Date: August 13, 2011 06:10AM

Executing the following C code:

ndb_init();

Ndb_cluster_connection cluster_connection("192.168.0.3");

cluster_connection.connect(4, 5, 1));

Results in the error:

"Configuration error: Error : Could not alloc node id at 192.168.0.3 port 1186: No free node id found for mysqld(API)."


My config.ini is:

[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M

[NDB_MGMD]
hostname=192.168.0.3
datadir=/var/lib/mysql-cluster
NodeId=30

[NDBD]
hostname=192.168.0.3
#datadir=/usr/local/mysql/data
datadir=/mysql-cl.test
NodeId=3

[NDBD]
hostname=192.168.0.2
datadir=/mysql-cl.test2
NodeId=4

[MYSQLD]
hostname=192.168.0.3


> ndb_mgm -e show
Connected to Management Server at: 192.168.0.3:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 @192.168.0.3 (mysql-5.1.44 ndb-7.1.3, Nodegroup: 0, Master)
id=4 @192.168.0.2 (mysql-5.1.44 ndb-7.1.3, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=30 @192.168.0.3 (mysql-5.1.44 ndb-7.1.3)

[mysqld(API)] 1 node(s)
id=5 @192.168.0.3 (mysql-5.1.44 ndb-7.1.3)


O/S Mandriva 2010.2


There are no errors reported on daemon startup.

What is wrong with my configuration (ignoring ndb_mgmd running on same host as node 3 - its a test rig)?

Thanks,

Jan

Options: ReplyQuote


Subject
Views
Written By
Posted
No free node id found for mysqld(API)
3722
August 13, 2011 06:10AM


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.