MySQL Forums
Forum List  »  NDB clusters

mgm node refuses db nodes
Posted by: Balasubramanian Azhagappan
Date: April 12, 2005 06:16AM

Hello all,
Initially i had the following configuration.

10.1.2.25 node3,node5
10.1.2.26 node2,node4
10.1.2.62 mgm node.

I filled the cluster database with some 1 Million records.
Then the ip address of the two machines, that was holding the database nodes, was changed and the configuration was like this

10.1.2.24 node3,node5
10.1.2.29 node2,node4
10.1.2.62 mgm node.

I looked in the management console... it shows like this....

ndb_mgm> show
Connected to Management Server at: 10.1.2.62:1801
Cluster Configuration
---------------------
[ndbd(NDB)] 4 node(s)
id=2 (not connected, accepting connect from 10.1.2.29)
id=3 (not connected, accepting connect from 10.1.2.24)
id=4 (not connected, accepting connect from 10.1.2.29)
id=5 (not connected, accepting connect from 10.1.2.24)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.1.2.62 (Version: 5.0.3)

[mysqld(API)] 2 node(s)
id=6 (not connected, accepting connect from 10.1.2.29)
id=7 (not connected, accepting connect from 10.1.2.24)

ndb_mgm>

But when i try to connect a management node, say node 3, from 10.1.2.24.. i get the logs in ndb_1_cluster.log as

2005-04-12 15:06:37 [MgmSrvr] WARNING -- Allocate nodeid (3) failed. Connection from ip 10.1.2.24. Returned error string "Id 3 already allocated by another node."
2005-04-12 15:06:37 [MgmSrvr] INFO -- Mgmt server state: node id's 1 3 not connected but reserved
2005-04-12 15:06:37 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 freed, m_reserved_nodes 0000000000000002.
2005-04-12 15:06:40 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 reserved for ip 10.1.2.24, m_reserved_nodes 000000000000000a.

I tried the same with version 4.1.9. but i get the same error.

I am not sure...whats going wrong here. can any one help me...

regards,
Bala

Options: ReplyQuote


Subject
Views
Written By
Posted
mgm node refuses db nodes
2922
April 12, 2005 06:16AM


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.