Bug #59562 mysqld failed to start for new Cluster
Submitted: 17 Jan 2011 17:31 Modified: 18 Jan 2011 9:20
Reporter: Andrew Morgan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Cluster Manager: Agent Severity:S3 (Non-critical)
Version:MCM1.1.0 OS:Linux (Fedora 14)
Assigned to: CPU Architecture:Any

[17 Jan 2011 17:31] Andrew Morgan
Description:
When I created a new Cluster with MCM1.1.0 (all nodes on the same host) one of the mysqld processes failed to start....

mysql> create site --hosts=192.168.1.5 mysite;
+---------------------------+
| Command result            |
+---------------------------+
| Site created successfully |
+---------------------------+
1 row in set (0.74 sec)

mysql> add package -b /usr/local/mysql-cluster-gpl-7.1.9-linux-x86_64-glibc23 7_1_9;
+----------------------------+
| Command result             |
+----------------------------+
| Package added successfully |
+----------------------------+
1 row in set (0.89 sec)

mysql> create cluster --package=7_1_9 --processhosts=ndb_mgmd@192.168.1.5,ndbd@192.168.1.5,ndbd@192.168.1.5,mysqld@192.168.1.5,mysqld@192.168.1.5 mycluster;
+------------------------------+
| Command result               |
+------------------------------+
| Cluster created successfully |
+------------------------------+
1 row in set (4.00 sec)

mysql> start cluster mycluster;
ERROR 7006 (00MGR): Process id 5 (mysqld) terminated unexpectedly: proc_info->exitstatus=256 proc_info->lastoutput=`forked pid 3095 is running
' proc_report->errormsg=`process ospid 3095 exited, exitcode 256' 

mysql> show status -r mycluster;
+------+----------+-------------+---------+-----------+
| Id   | Process  | Host        | Status  | Nodegroup |
+------+----------+-------------+---------+-----------+
| 1    | ndb_mgmd | 192.168.1.5 | running |           |
| 2    | ndbd     | 192.168.1.5 | running | 0         |
| 3    | ndbd     | 192.168.1.5 | running | 0         |
| 4    | mysqld   | 192.168.1.5 | running |           |
| 5    | mysqld   | 192.168.1.5 | failed  |           |
+------+----------+-------------+---------+-----------+
5 rows in set (0.92 sec)

How to repeat:
Follow the steps described above
[18 Jan 2011 9:20] Kari Juul Wedde
In order to start two mysqlds on the same machine they have to run on different ports.