EC
1194
MariaDBERRORCommonTable / StorageHIGH confidence

Table is marked as crashed and should be repaired

Production Risk

High — table is inaccessible until repaired; data loss possible.

What this means

ER_CRASHED_ON_USAGE (1194, SQLSTATE HY000) indicates that a MyISAM table has been marked as crashed and is unusable until repaired. This typically results from an unclean shutdown, power loss, or hardware failure.

Why it happens
  1. 1Unclean MySQL shutdown (crash, power loss) while MyISAM table was being written
  2. 2Disk I/O error corrupting the MyISAM index or data file
  3. 3Bug in older MySQL versions causing table corruption
How to reproduce
trigger — this will error
trigger — this will error
SELECT * FROM crashed_table;  -- returns error if table is marked crashed

expected output

ERROR 1194 (HY000): Table 'crashed_table' is marked as crashed and should be repaired

Fix 1

Repair the table

Repair the table
REPAIR TABLE crashed_table;

Why this works

REPAIR TABLE rebuilds the MyISAM index file and attempts to recover rows. For InnoDB, use CHECK TABLE and consider crash recovery.

Fix 2

Check table for errors first

Check table for errors first
CHECK TABLE crashed_table;

Why this works

Identifies the extent of corruption before attempting repair.

Version notes

Sources
Official documentation ↗

MySQL 8.0 — 1194 ER_CRASHED_ON_USAGE

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors