EC
1181
MySQLERRORCommonTransactionHIGH confidence

Got error during ROLLBACK

Production Risk

Critical — failed rollback leaves data in inconsistent state.

What this means

ER_ERROR_DURING_ROLLBACK (1181, SQLSTATE HY000) is raised when MySQL encounters an error while trying to roll back a transaction. This is unusual and typically indicates a serious storage engine or I/O problem.

Why it happens
  1. 1Storage engine failure during undo log application
  2. 2Disk I/O error while reverting changes
  3. 3InnoDB undo tablespace corruption
How to reproduce
trigger — this will error
trigger — this will error
-- Forced by storage-level failure
ROLLBACK;  -- fails if undo log unreadable

expected output

ERROR 1181 (HY000): Got error during ROLLBACK

Fix

Check InnoDB status and disk health

Check InnoDB status and disk health
SHOW ENGINE INNODB STATUS;

Why this works

Identify undo log or I/O errors. May require crash recovery or restoring from backup.

Sources
Official documentation ↗

MySQL 8.0 — 1181 ER_ERROR_DURING_ROLLBACK

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

← All MySQL errors