"ERROR 1036 (HY000): Table 'table_name' is read only" error on ndb cluster sql node

[Nuri Burhanettin Sabuncu]

Hi,
We have got a mysql ndb cluster system on debian. Version of mysql is 5.1. the sql system we built consists of 8 sql nodes 2 data nodes and 1 management node. Our system is Active-active. One of our product's sql nodes had the error "Table is full". Somehow 4.5 million records were causing problem. so we decided to "truncate" the table. Truncate started but it didn't end even after a few hours. We terminated the process. Now when we connect to the sql node and try to insert update drop etc.. tables it gives "ERROR 1036 (HY000): Table 'table_name' is read only" error. The other sql node works fine.

Is there any way to fix the troubled sql node?



Edited 1 time(s). Last edit at 05/03/2011 07:05AM by Nuri Burhanettin Sabuncu.