3222
MySQLERRORCommonReplicationMEDIUM confidence
Error reading master info (variant 2)
Production Risk
High — replication cannot start.
Why it happens
- 1The replication metadata repository (master_info) is corrupted or unreadable.
- 2Repository file or table is missing or contains invalid data.
How to reproduce
trigger — this will error
trigger — this will error
START REPLICA;
expected output
ERROR 3222 (HY000): Error reading master info.
Fix 1
Reset and reconfigure replication
Reset and reconfigure replication
RESET REPLICA ALL; CHANGE MASTER TO ...;
Why this works
Clears corrupted metadata and allows fresh replication configuration.
Fix 2
Restore master_info from backup
Restore master_info from backup
-- Restore relay log and master_info repository from backup.
Why this works
Restores known-good replication state.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3222 ER_MASTER_INFO2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev