Error 1194: Table is marked as crashed and should be repaired
| Error Code | SQLSTATE | Error | Description |
|---|---|---|---|
| 1194 | HY000 | ER_CRASHED_ON_USAGE | Table '%s' is marked as crashed and should be repaired |
Contents
Possible Causes and Solutions
This error occurs, in particular to MyISAM, Aria, Archive or CSV tables, if the table is marked as crashed. This can occur for a number of reasons, for example:
- running out of disk space
- sudden shutdown while the table was in use
Fixing the problem can usually be done by running a REPAIR TABLE statement, or one of the similar scripts, aria_chk, myisamchk or mariadb-check.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
