MySQL Bugs: #47849: mysqld nodes are not getting connected.

Bug #47849	mysqld nodes are not getting connected.
Submitted:	6 Oct 2009 7:40	Modified:	16 Nov 2009 14:48
Reporter:	Manoj Burande	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	mysql-5.1.35 ndb-7.0.7	OS:	Linux (FC10)
Assigned to:	Gustaf Thorslund	CPU Architecture:	Any
Tags:	mysql-cluster

Description:
Hello There,

      Here I am providing the out put of "ndb_mgm -e show" command every command needed to start the complete MySQL-Cluster has been executed successfully. But still the command "ndb_mgm -e show" shows me mysql nodes are not connect why? Even I have gone through the logs but there is no error found in it. So please suggest am I doing anything wrong?

Here are the commands which I have carried out to start the MySQL-Cluster on each nodes,

On host "10.1.138.2":
---------------------
1] #ndb_mgmd -f config.ini  --ndb-nodeid=1 /var/lib/mysql-cluster/config.ini

On host "10.1.138.3":
---------------------
1] #ndb_mgmd -f config.ini  --ndb-nodeid=2 /var/lib/mysql-cluster/config.ini

On host "10.1.138.10":
----------------------
1] #ndbd -c 10.1.138.2 
2] #mysqld_safe --ndbcluster --ndb-connectstring=10.1.138.10 &

On host "10.1.138.11":
----------------------
1] #ndbd -c 10.1.138.2 
2] #mysqld_safe --ndbcluster --ndb-connectstring=10.1.138.10 & 

# ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=3	@10.1.138.10  (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0, Master)
id=4	@10.1.138.11  (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0)

[ndb_mgmd(MGM)]	2 node(s)
id=1	@10.1.138.2  (mysql-5.1.35 ndb-7.0.7)
id=2	@10.1.138.3  (mysql-5.1.35 ndb-7.0.7)

[mysqld(API)]	4 node(s)
id=5 (not connected, accepting connect from 10.1.138.10)
id=6 (not connected, accepting connect from 10.1.138.11)
id=7 (not connected, accepting connect from any host)
id=8 (not connected, accepting connect from any host)

Please help me.
Thanks in advance.

How to repeat:

mysqld_safe --ndbcluster --ndb-connectstring=10.1.138.10 &

Hi Manoj,

Got any logs to share? Also my.cnf and config.ini.

/Gustaf

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Problem has been solved using following command.....

# mysqld_safe --ndbcluster --ndb-connectstring=10.1.138.2 &
(Mysqld always connect to the management servers)