Bug #33549 Crash of Cluster when the master node is shutdown
Submitted: 28 Dec 2007 9:14 Modified: 29 Dec 2007 6:29
Reporter: Azeddine ESSAI Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S1 (Critical)
Version:5.0 OS:Linux (REDHAT ES4)
Assigned to: CPU Architecture:Any
Tags: Cluster Arbitration

[28 Dec 2007 9:14] Azeddine ESSAI
Description:
I have the following configuration :

Connected to Management Server at: cer69-sathd2:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=11   @165.3.21.21  (Version: 5.0.45, Nodegroup: 0)
id=12   @165.3.21.22  (Version: 5.0.45, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 2 node(s)
id=1    @165.3.21.21  (Version: 5.0.45)
id=2    @165.3.21.22  (Version: 5.0.45)

[mysqld(API)]   4 node(s)
id=31   @165.3.21.21  (Version: 5.0.45)
id=32   @165.3.21.22  (Version: 5.0.45)

2 servers on each one a manager node, a storage node and an sql node
when I reboot (or halt) the node not master the cluter work good, but
when I reboot (or halt) the master node the cluter crash and I have this message :

2007-12-27 14:58:27 [MgmSrvr] ALERT    -- Node 12: Forced node shutdown completed. Caused by error 2305: 'Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s)(Arbitration error). Temporary error, restart node'.

thanks tor you help

How to repeat:
Automaticly when the master node is rebooted or halted
[28 Dec 2007 9:24] Azeddine ESSAI
report file

Attachment: ndb_error_report_20071228092228.tar.bz2 (application/octet-stream, text), 84.95 KiB.

[29 Dec 2007 6:29] Hartmut Holzgraefe
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.

Check the manual on cluster arbitration, also check the warnings that ndb_mgmd prints on startup. Running the management node(s) on the same machine as data nodes is the problem here.

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.