PostgreSQL Error Reference

Every error, explained

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

3910 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 3840 of 3910 errors

XX001 ERROR

invalid page in block N of relation … — XX001

data_corrupted

PostgreSQL error "invalid page in block N of relation …" (SQLSTATE XX001): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

could not access status of transaction N — XX001

data_corrupted

PostgreSQL error "could not access status of transaction N" (SQLSTATE XX001): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

catalog is missing N attribute(s) for relid N — XX001

data_corrupted

PostgreSQL error "catalog is missing N attribute(s) for relid N" (SQLSTATE XX001): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

missing chunk number N for toast value N in pg_toast_N — XX001

data_corrupted

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

Internal Error
XX001 ERROR

found xmin N from before relfrozenxid N — XX001

data_corrupted

PostgreSQL error "found xmin N from before relfrozenxid N" (SQLSTATE XX001): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

unexpected chunk number N (expected N) for toast value N — XX001

data_corrupted

PostgreSQL error "unexpected chunk number N (expected N) for toast value N" (SQLSTATE XX001): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

compressed pglz data is corrupt — XX001

data_corrupted

PostgreSQL error "compressed pglz data is corrupt" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

compressed lz4 data is corrupt — XX001

data_corrupted

PostgreSQL error "compressed lz4 data is corrupt" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

found multixact n from before relminmxid n — XX001

data_corrupted

PostgreSQL error "found multixact n from before relminmxid n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

found xmax n from before relfrozenxid n — XX001

data_corrupted

PostgreSQL error "found xmax n from before relfrozenxid n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

cannot freeze committed xmax n — XX001

data_corrupted

PostgreSQL error "cannot freeze committed xmax n" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

t_xmin n is uncommitted in tuple (n,n) to be updated in table “…” — XX001

data_corrupted

PostgreSQL error "t_xmin n is uncommitted in tuple (n,n) to be updated in table "…"" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

failed to find parent tuple for heap-only tuple at (n,n) in table “…” — XX001

data_corrupted

PostgreSQL error "failed to find parent tuple for heap-only tuple at (n,n) in table "…"" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX001 ERROR

unexpected chunk number n (expected n) for toast value n in … — XX001

data_corrupted

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

Internal Error
XX001 ERROR

unexpected chunk number n (out of range n..n) for toast value n in … — XX001

data_corrupted

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

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