— Deep dives into Databases —

55006 ERROR

aborting because lock on relation “…” is not available — 55006

object_in_use

PostgreSQL error "aborting because lock on relation "…" is not available" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55006 ERROR

directory “…” already in use as a tablespace — 55006

object_in_use

PostgreSQL error "directory "…" already in use as a tablespace" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55006 ERROR

current user cannot be dropped — 55006

object_in_use

PostgreSQL error "current user cannot be dropped" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55006 ERROR

session user cannot be dropped — 55006

object_in_use

PostgreSQL error "session user cannot be dropped" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55006 ERROR

could not drop replication origin with ID n, in use by PID n — 55006

object_in_use

PostgreSQL error "could not drop replication origin with ID n, in use by PID n" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55006 ERROR

replication origin with ID n is already active for PID n — 55006

object_in_use

PostgreSQL error "replication origin with ID n is already active for PID n" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55006 ERROR

replication origin with ID n is already active in another process — 55006

object_in_use

PostgreSQL error "replication origin with ID n is already active in another process" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55006 ERROR

replication origin with ID n is not active for PID n — 55006

object_in_use

PostgreSQL error "replication origin with ID n is not active for PID n" (SQLSTATE 55006, object_in_use): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55P02 ERROR

Cant Change Runtime Param — SQLSTATE 55P02

cant_change_runtime_param

SQLSTATE 55P02 (cant_change_runtime_param): The object is not in a state that permits the operation.

Object Not In Prerequisite State

55P02 ERROR

parameter “…” cannot be changed without restarting the server — 55P02

cant_change_runtime_param

PostgreSQL error "parameter "…" cannot be changed without restarting the server" (SQLSTATE 55P02): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55P02 ERROR

parameter “…” cannot be changed now — 55P02

cant_change_runtime_param

PostgreSQL error "parameter "…" cannot be changed now" (SQLSTATE 55P02): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55P02 ERROR

function can only be called when server is in binary upgrade mode — 55P02

cant_change_runtime_param

PostgreSQL error "function can only be called when server is in binary upgrade mode" (SQLSTATE 55P02, cant_change_runtime_param): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55P02 ERROR

parameter “…” cannot be changed — 55P02

cant_change_runtime_param

PostgreSQL error "parameter "…" cannot be changed" (SQLSTATE 55P02, cant_change_runtime_param): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55P03 ERROR

Lock Not Available — SQLSTATE 55P03

lock_not_available

A requested lock could not be obtained (NOWAIT or lock_timeout).

Object Not In Prerequisite State

55P03 ERROR

could not obtain lock on relation “…” — 55P03

lock_not_available

PostgreSQL error "could not obtain lock on relation "…"" (SQLSTATE 55P03): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55P03 ERROR

canceling statement due to lock timeout — 55P03

lock_not_available

PostgreSQL error "canceling statement due to lock timeout" (SQLSTATE 55P03): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

55P04 ERROR

Unsafe New Enum Value Usage — SQLSTATE 55P04

unsafe_new_enum_value_usage

A newly added enum value cannot be used yet in the same transaction.

Object Not In Prerequisite State

55P04 ERROR

unsafe use of new value “…” of enum type … — 55P04

unsafe_new_enum_value_usage

PostgreSQL error "unsafe use of new value "…" of enum type …" (SQLSTATE 55P04, unsafe_new_enum_value_usage): what it means, common causes, and how to fix it.

Object Not In Prerequisite State

57000 ERROR

Operator Intervention — SQLSTATE 57000

operator_intervention

SQLSTATE 57000 (operator_intervention): The statement or session was canceled or terminated by timeout, admin, or shutdown.

Operator Intervention

57014 ERROR

Query Canceled — SQLSTATE 57014

query_canceled

The statement was canceled — by a timeout or an explicit cancel.

Operator Intervention

57014 ERROR

canceling statement due to user request — 57014

query_canceled

PostgreSQL error "canceling statement due to user request" (SQLSTATE 57014): what it means, common causes, and how to fix it.

Operator Intervention

57014 ERROR

canceling statement due to statement timeout — 57014

query_canceled

PostgreSQL error "canceling statement due to statement timeout" (SQLSTATE 57014): what it means, common causes, and how to fix it.

Operator Intervention

57014 FATAL

canceling authentication due to timeout — 57014

query_canceled

PostgreSQL error "canceling authentication due to timeout" (SQLSTATE 57014, query_canceled): what it means, common causes, and how to fix it.

Operator Intervention

57014 ERROR

timed out while waiting for target LSN n/n to be replayed; current… — 57014

query_canceled

PostgreSQL error "timed out while waiting for target LSN n/n to be replayed; current standby_replay LSN n/n" (SQLSTATE 57014, query_canceled): what it means, common causes, and how to fix it.

Operator Intervention