Description:
show cluster status:
mysql> show status -r mycluster;
+--------+----------+---------------+---------+-----------+---------+
| NodeId | Process | Host | Status | Nodegroup | Package |
+--------+----------+---------------+---------+-----------+---------+
| 49 | ndb_mgmd | 192.168.75.42 | running | | 7.2.5 |
| 50 | ndb_mgmd | 192.168.75.43 | running | | 7.2.5 |
| 1 | ndbd | 192.168.75.42 | running | 0 | 7.2.5 |
| 2 | ndbd | 192.168.75.43 | running | 0 | 7.2.5 |
| 3 | ndbd | 192.168.75.44 | running | 0 | 7.2.5 |
| 51 | mysqld | 192.168.75.42 | running | | 7.2.5 |
| 52 | mysqld | 192.168.75.43 | running | | 7.2.5 |
| 53 | mysqld | 192.168.75.44 | running | | 7.2.5 |
+--------+----------+---------------+---------+-----------+---------+
8 rows in set (0.07 sec)
show host status:
mysql> list hosts mysite;
+---------------+-------------+---------+
| Host | Status | Version |
+---------------+-------------+---------+
| 192.168.75.42 | Available | 1.1.5 |
| 192.168.75.43 | Unavailable | Unknown |
| 192.168.75.44 | Available | 1.1.5 |
+---------------+-------------+---------+
3 rows in set (0.01 sec)
The second agent is unavailable. When I started it, a little while it failed again.
error log:
[root@localhost ~]# tail -f /home/cluster/mcm/mcmd.log
2012-08-10 09:34:44.041: (message) [T0x7fd74c003800 RECFG]: wait recovery
2012-08-10 09:34:45.065: (warning) [T0x222dd40 CMGR ]: Procopstatus does not match any operation
2012-08-10 09:34:45.893: (message) last message repeated 86 times
2012-08-10 09:34:45.893: (message) [T0x21e1010 chass]: xcom recovery completed
2012-08-10 09:34:45.893: (message) [T0x222dd40 CMGR ]: cluster manager recovery completed
2012-08-10 09:34:45.893: (message) [T0x7fd74c003800 RECFG]: Starting reconfigurator thread
2012-08-10 09:34:45.943: (warning) [T0x222dd40 CMGR ]: Procopstatus does not match any operation
2012-08-10 09:34:46.295: (message) last message repeated 2 times
2012-08-10 09:34:46.295: (message) [T0x7fd74c003800 RECFG]: reconfig recovery completed
2012-08-10 09:34:46.452: (warning) [T0x7fd74c003800 RECFG@process_actions.c:165]: Assertion `(pcount)[ng]<=(nofr)' failed: ng=0 (pcount)[ng]=3 nofr=2
why? Help me.
How to repeat:
Restart the sencond agent again.