PostgreSQL Error Reference

Every error, explained

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

3659 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 3659 of 3659 errors

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

unexpected page type 0xn in BRIN index “…” block n — XX002

index_corrupted

PostgreSQL error "unexpected page type 0xn in BRIN index "…" block n" (SQLSTATE XX002, index_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX002 ERROR

index “…” has wrong hash version — XX002

index_corrupted

PostgreSQL error "index "…" has wrong hash version" (SQLSTATE XX002, index_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX002 ERROR

index “…” is not a hash index — XX002

index_corrupted

PostgreSQL error "index "…" is not a hash index" (SQLSTATE XX002, index_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX002 ERROR

right sibling’s left-link doesn’t match: block n links to n instead… — XX002

index_corrupted

PostgreSQL error "right sibling's left-link doesn't match: block n links to n instead of expected n in index "…"" (SQLSTATE XX002, index_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX002 ERROR

failed to re-find parent key in index “…” for split pages n/n — XX002

index_corrupted

PostgreSQL error "failed to re-find parent key in index "…" for split pages n/n" (SQLSTATE XX002, index_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX002 ERROR

index “…” is not a btree — XX002

index_corrupted

PostgreSQL error "index "…" is not a btree" (SQLSTATE XX002, index_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX002 ERROR

version mismatch in index “…”: file version n, current version n, m… — XX002

index_corrupted

PostgreSQL error "version mismatch in index "…": file version n, current version n, minimal supported version n" (SQLSTATE XX002, index_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX002 ERROR

target page left link unexpectedly changed from n to n in block n o… — XX002

index_corrupted

PostgreSQL error "target page left link unexpectedly changed from n to n in block n of index "…"" (SQLSTATE XX002, index_corrupted): what it means, common causes, and how to fix it.

Internal Error
XX002 ERROR

btree level n not found in index “…” — XX002

index_corrupted

PostgreSQL error "btree level n not found in index "…"" (SQLSTATE XX002, index_corrupted): 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