EC
1183
MySQLERRORNotableStorage EngineHIGH confidence

Got error during CHECKPOINT

Production Risk

High — checkpoint failures can lead to data loss on crash.

What this means

ER_ERROR_DURING_CHECKPOINT (1183, SQLSTATE HY000) is raised when MySQL cannot complete an internal checkpoint operation, which flushes dirty pages from the buffer pool to disk. This typically indicates I/O problems.

Why it happens
  1. 1Disk I/O error during InnoDB checkpoint flush
  2. 2Disk full preventing dirty page writes
  3. 3Storage hardware failure
How to reproduce
trigger — this will error
trigger — this will error
-- Internal operation; not directly triggered by user SQL

expected output

ERROR 1183 (HY000): Got error during CHECKPOINT

Fix

Investigate InnoDB status and disk health

Investigate InnoDB status and disk health
SHOW ENGINE INNODB STATUS;

Why this works

Identify the I/O error. Resolve disk space or hardware issues, then restart MySQL if necessary.

Sources
Official documentation ↗

MySQL 8.0 — 1183 ER_ERROR_DURING_CHECKPOINT

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

← All MySQL errors