REPAIR TABLE Reports "Table 'X' is Read Only" Error On a MyISAM Table (Doc ID 1565168.1)

Last updated on MAY 05, 2016

Applies to:

MySQL Server - Version 4.0 and later
Information in this document applies to any platform.

Symptoms

When repairing a MyISAM table, what does the "Table 'x' is read only" error mean and how to fix it ?

mysql> repair table t;
+--------+--------+----------+------------------------+
| Table  | Op     | Msg_type | Msg_text               |
+--------+--------+----------+------------------------+
| test.t | repair | Error    | Table 't' is read only |
| test.t | repair | status   | Operation failed       |
+--------+--------+----------+------------------------+
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms