PostgreSQL Error Reference

Every error, explained

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

3908 errors documentedFree diagnostics on every pageAll PG versions covered

Showing 3480 of 3908 errors

55000 ERROR

cannot acquire lock mode … on database objects while recovery is in… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot acquire lock mode … on database objects while recovery is in progress" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cursor can only scan forward — 55000

object_not_in_prerequisite_state

PostgreSQL error "cursor can only scan forward" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

data directory “…” has wrong ownership — 55000

object_not_in_prerequisite_state

PostgreSQL error "data directory "…" has wrong ownership" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

cannot connect to invalid database “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot connect to invalid database "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

WAL was generated with “wal_level=minimal”, cannot continue recovering — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL was generated with "wal_level=minimal", cannot continue recovering" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot use replication slot “…” for logical decoding — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot use replication slot "…" for logical decoding" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot create primary key on column “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot create primary key on column "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot attach table “…” as partition because it is referenced in pu… — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot attach table "…" as partition because it is referenced in publication … EXCEPT clause" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

index “…” is not valid — 55000

object_not_in_prerequisite_state

PostgreSQL error "index "…" is not valid" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

attempted to delete invisible tuple — 55000

object_not_in_prerequisite_state

PostgreSQL error "attempted to delete invisible tuple" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

attempted to update invisible tuple — 55000

object_not_in_prerequisite_state

PostgreSQL error "attempted to update invisible tuple" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

attempted to overwrite invisible tuple — 55000

object_not_in_prerequisite_state

PostgreSQL error "attempted to overwrite invisible tuple" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

index access method “…” does not have a handler — 55000

object_not_in_prerequisite_state

PostgreSQL error "index access method "…" does not have a handler" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

lost connection to parallel worker — 55000

object_not_in_prerequisite_state

PostgreSQL error "lost connection to parallel worker" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

could not map dynamic shared memory segment — 55000

object_not_in_prerequisite_state

PostgreSQL error "could not map dynamic shared memory segment" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

invalid magic number in dynamic shared memory segment — 55000

object_not_in_prerequisite_state

PostgreSQL error "invalid magic number in dynamic shared memory segment" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

prepared transaction with identifier “…” is busy — 55000

object_not_in_prerequisite_state

PostgreSQL error "prepared transaction with identifier "…" is busy" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

incorrect checksum in control file — 55000

object_not_in_prerequisite_state

PostgreSQL error "incorrect checksum in control file" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 FATAL

WAL ends before consistent recovery point — 55000

object_not_in_prerequisite_state

PostgreSQL error "WAL ends before consistent recovery point" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

a backup is already in progress in this session — 55000

object_not_in_prerequisite_state

PostgreSQL error "a backup is already in progress in this session" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

shared indexes cannot be created after initdb — 55000

object_not_in_prerequisite_state

PostgreSQL error "shared indexes cannot be created after initdb" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

… is already a member of extension “…” — 55000

object_not_in_prerequisite_state

PostgreSQL error "… is already a member of extension "…"" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

relation referenced by COPY statement has changed — 55000

object_not_in_prerequisite_state

PostgreSQL error "relation referenced by COPY statement has changed" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State
55000 ERROR

cannot drop extension “…” because it is being modified — 55000

object_not_in_prerequisite_state

PostgreSQL error "cannot drop extension "…" because it is being modified" (SQLSTATE 55000, object_not_in_prerequisite_state): what it means, common causes, and how to fix it.

Object Not In Prerequisite State