Error 1194: Table is marked as crashed and should be repaired

Error CodeSQLSTATEErrorDescription
1194HY000ER_CRASHED_ON_USAGETable '%s' is marked as crashed and should be repaired

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.


Comments loading...
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.