Every error, explained
SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.
Showing 3864 of 3908 errors
XX001
PANIC
space reserved for WAL record does not match what was written — XX001
data_corrupted
PostgreSQL error "space reserved for WAL record does not match what was written" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
checksum verification failure during base backup — XX001
data_corrupted
PostgreSQL error "checksum verification failure during base backup" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
PANIC
replication slot file “…” has wrong magic number: n instead of n — XX001
data_corrupted
PostgreSQL error "replication slot file "…" has wrong magic number: n instead of n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
PANIC
replication slot file “…” has unsupported version n — XX001
data_corrupted
PostgreSQL error "replication slot file "…" has unsupported version n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
PANIC
replication slot file “…” has corrupted length n — XX001
data_corrupted
PostgreSQL error "replication slot file "…" has corrupted length n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
PANIC
replication slot checkpoint has wrong checksum n, expected n — XX001
data_corrupted
PostgreSQL error "replication slot checkpoint has wrong checksum n, expected n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
snapbuild state file “…” has wrong magic number: n instead of n — XX001
data_corrupted
PostgreSQL error "snapbuild state file "…" has wrong magic number: n instead of n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
snapbuild state file “…” has unsupported version: n instead of n — XX001
data_corrupted
PostgreSQL error "snapbuild state file "…" has unsupported version: n instead of n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
checksum mismatch for snapbuild state file “…”: is n, should be n — XX001
data_corrupted
PostgreSQL error "checksum mismatch for snapbuild state file "…": is n, should be n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
pg_largeobject entry for OID n, page n has invalid data field size n — XX001
data_corrupted
PostgreSQL error "pg_largeobject entry for OID n, page n has invalid data field size n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
PANIC
corrupted page pointers: lower = n, upper = n, special = n — XX001
data_corrupted
PostgreSQL error "corrupted page pointers: lower = n, upper = n, special = n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
corrupted line pointer: n — XX001
data_corrupted
PostgreSQL error "corrupted line pointer: n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
corrupted line pointer: offset = n, size = n — XX001
data_corrupted
PostgreSQL error "corrupted line pointer: offset = n, size = n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
PANIC
could not open critical system index n — XX001
data_corrupted
PostgreSQL error "could not open critical system index n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
multixact n from before cutoff n found to be still running — XX001
data_corrupted
PostgreSQL error "multixact n from before cutoff n found to be still running" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
found update xid n from before relfrozenxid n — XX001
data_corrupted
PostgreSQL error "found update xid n from before relfrozenxid n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
cannot freeze committed update xid n — XX001
data_corrupted
PostgreSQL error "cannot freeze committed update xid n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
found update xid n from before xid cutoff n — XX001
data_corrupted
PostgreSQL error "found update xid n from before xid cutoff n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
uncommitted xmin n from before xid cutoff n needs to be frozen — XX001
data_corrupted
PostgreSQL error "uncommitted xmin n from before xid cutoff n needs to be frozen" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
found xmax n (infomask 0xn) not frozen, not multi, not normal — XX001
data_corrupted
PostgreSQL error "found xmax n (infomask 0xn) not frozen, not multi, not normal" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
corrupted two-phase state file for transaction n — XX001
data_corrupted
PostgreSQL error "corrupted two-phase state file for transaction n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
corrupted two-phase state in memory for transaction n — XX001
data_corrupted
PostgreSQL error "corrupted two-phase state in memory for transaction n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
could not read from log segment …, offset n: read n of n — XX001
data_corrupted
PostgreSQL error "could not read from log segment …, offset n: read n of n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.
XX001
ERROR
corrupted item lengths: total n, available space n — XX001
data_corrupted
PostgreSQL error "corrupted item lengths: total n, available space n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.