MySQL Forums
Forum List  »  NDB clusters

mysqld doesn't know when ndbd alive.
Posted by: Komtanoo Pinpimai
Date: August 02, 2006 03:13PM

Hi,

I'm new to mysql-cluster, I've just set up my cluster with mysql5.11, 3 machines, 1st machine is mgm, 2nd and 3rd are data nodes + mysqld nodes.

Then I killed ndbd processes in 2nd and 3rd machine and restart them. However, in many circumstances the mysqld in both machines don't know the ndbds are back. Here is what it shows in the mgm console:

ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.2.91 (Version: 5.1.11, Nodegroup: 0, Master)
id=3 @192.168.2.92 (Version: 5.1.11, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.2.90 (Version: 5.1.11)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.2.91)
id=5 (not connected, accepting connect from 192.168.2.92)

ndb_mgm>

--------------

And when I did queries on an mysqld, it always displays the following error:

Database changed
mysql> select * from City;
ERROR 1015 (HY000): Can't lock file (errno: 4009)
mysql>

--------------

Do I need to add any special configuration for the mysqld to refresh link between the ndbd ?

-thanks
kem

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqld doesn't know when ndbd alive.
1518
August 02, 2006 03:13PM


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.