Bug #70448 mysql cluster Start failed. 22: Error
Submitted: 27 Sep 2013 3:22 Modified: 27 Sep 2013 5:12
Reporter: shunshuncool Dnie Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Tests: Cluster Severity:S7 (Test Cases)
Version:mysql-5.5.31 ndb-7.2.13 OS:Linux (bug)
Assigned to: CPU Architecture:Any
Tags: No contact with the process (dead ?).: Permanent error: Application error

[27 Sep 2013 3:22] shunshuncool Dnie 
Description:
-- NDB Cluster -- Management Client --
ndb_mgm> SHOW
Connected to Management Server at: 192.168.1.92:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=3    @192.168.1.94  (mysql-5.5.31 ndb-7.2.13, Nodegroup: 0, Master)
id=4    @192.168.1.95  (mysql-5.5.31 ndb-7.2.13, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=1    @192.168.1.92  (mysql-5.5.31 ndb-7.2.13)
id=2    @192.168.1.93  (mysql-5.5.31 ndb-7.2.13)

[mysqld(API)]   3 node(s)
id=5    @192.168.1.92  (mysql-5.5.31 ndb-7.2.13)
id=6    @192.168.1.93  (mysql-5.5.31 ndb-7.2.13)
id=7 (not connected, accepting connect from any host)

ndb_mgm> 3 RESTART;
Node 3: Node shutdown initiated
Node 3: Node shutdown completed, restarting, no start.
Node 3 is being restarted

ndb_mgm> Node 3: Start initiated (version 7.2.13)
Node 3: Started (version 7.2.13)

ndb_mgm> SHOW
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=3    @192.168.1.94  (mysql-5.5.31 ndb-7.2.13, Nodegroup: 0)
id=4    @192.168.1.95  (mysql-5.5.31 ndb-7.2.13, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 2 node(s)
id=1    @192.168.1.92  (mysql-5.5.31 ndb-7.2.13)
id=2    @192.168.1.93  (mysql-5.5.31 ndb-7.2.13)

[mysqld(API)]   3 node(s)
id=5    @192.168.1.92  (mysql-5.5.31 ndb-7.2.13)
id=6    @192.168.1.93  (mysql-5.5.31 ndb-7.2.13)
id=7 (not connected, accepting connect from any host)

ndb_mgm> 4 STOP
Node 4: Node shutdown initiated
Node 4: Node shutdown completed.
Node 4 has shutdown.

ndb_mgm> 4 START;
Start failed.
*    22: Error
*        No contact with the process (dead ?).: Permanent error: Application error

How to repeat:
ndb_mgm> 4 START;
Start failed.
*    22: Error
*        No contact with the process (dead ?).: Permanent error: Application error  

Suggested fix:
ndb_mgm> 4 START;
Start failed.
*    22: Error
*        No contact with the process (dead ?).: Permanent error: Application error
[27 Sep 2013 5:12] MySQL Verification Team 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

PS: The <id> START command starts nodes that already have the ndbd (storage node daemon) running and listening, since you already stopped i.e <id> STOP command stops a storage node (the ndbd process exits).. Please start ndbd process manually.