All pages
Powered by GitBook
1 of 1

Loading...

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

Possible Causes and Solutions

This error occurs, in particular to , , or 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 statement, or one of the similar scripts, , or .

MyISAM
Aria
Archive
CSV
REPAIR TABLE
aria_chk
myisamchk
mariadb-check

This page is licensed: CC BY-SA / Gnu FDL