Re: 'Cluster Failure' from NDB. Could not acquire global schema lock

[Andrew Morgan]

I'm a little confused bt the following...

Quote

Datanode output for global status: 

mysql> show global status like 'ndb_number_of%'; 
+--------------------------------+-------+ 
| Variable_name | Value | 
+--------------------------------+-------+ 
| Ndb_number_of_data_nodes | 2 | 
| Ndb_number_of_ready_data_nodes | 0 | 
+--------------------------------+-------+ 
2 rows in set (0.00 sec) 

mysql> 

SQL node output for global status: 

mysql> show global status like 'ndb_number_of%'; 
+--------------------------------+-------+ 
| Variable_name | Value | 
+--------------------------------+-------+ 
| Ndb_number_of_data_nodes | 2 | 
| Ndb_number_of_ready_data_nodes | 2 | 
+--------------------------------+-------+ 
2 rows in set (0.00 sec) 

Both of these commands were executed on a MySQL Server - the same one? If not then one of them can't be connected to the Cluster as the ndb_mgm output is only showing a single slot.