PostgreSQL Error Reference

Every error, explained

SQLSTATE codes, condition names, root causes, diagnostic queries, and recovery steps — structured for engineers running PostgreSQL in production.

3549 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 3504 of 3549 errors

XX001 ERROR

unexpected chunk size n (expected n) in chunk n of n for toast valu… — XX001

data_corrupted

PostgreSQL error "unexpected chunk size n (expected n) in chunk n of n for toast value n in …" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

missing chunk number n for toast value n in … — XX001

data_corrupted

PostgreSQL error "missing chunk number n for toast value n in …" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

MultiXact n has invalid next offset — XX001

data_corrupted

PostgreSQL error "MultiXact n has invalid next offset" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

incorrect size of file “…”: n byte — XX001

data_corrupted

PostgreSQL error "incorrect size of file "…": n byte" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

incorrect alignment of CRC offset for file “…” — XX001

data_corrupted

PostgreSQL error "incorrect alignment of CRC offset for file "…"" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

invalid magic number stored in file “…” — XX001

data_corrupted

PostgreSQL error "invalid magic number stored in file "…"" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

invalid size stored in file “…” — XX001

data_corrupted

PostgreSQL error "invalid size stored in file "…"" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

calculated CRC checksum does not match value stored in file “…” — XX001

data_corrupted

PostgreSQL error "calculated CRC checksum does not match value stored in file "…"" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 PANIC

could not read file “…”: read n of …u — XX001

data_corrupted

PostgreSQL error "could not read file "…": read n of …u" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 FATAL

control file contains invalid checkpoint location — XX001

data_corrupted

PostgreSQL error "control file contains invalid checkpoint location" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 FATAL

control file contains invalid database cluster state — XX001

data_corrupted

PostgreSQL error "control file contains invalid database cluster state" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error
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.

Internal Error