PostgreSQL Error Reference

Every error, explained

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

927 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 927 of 927 errors

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.

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

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

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

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

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

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

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

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 ERROR

uncommitted xmin n needs to be frozen — XX001

data_corrupted

PostgreSQL error "uncommitted xmin n needs to be frozen" (SQLSTATE XX001, data_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX002 PANIC

Index Corrupted — SQLSTATE XX002

index_corrupted

An index is corrupted.

Internal Error
XX002 ERROR

index “…” contains unexpected zero page at block N — XX002

index_corrupted

PostgreSQL error "index "…" contains unexpected zero page at block N" (SQLSTATE XX002): what it means, common causes, and how to fix it.

Internal Error
XX002 ERROR

heap tid from index tuple (n,n) points past end of heap page line p… — XX002

index_corrupted

PostgreSQL error "heap tid from index tuple (n,n) points past end of heap page line pointer array at offset n of block n in index "…"" (SQLSTATE XX002, index_corrupted): what it means, common causes, and how to fix it.

Internal Error