55000

At a glance

55000 means the requested operation lacks a required object or server state. This page selects the session-local sequence prerequisite behind currval; preload, recovery, and invalid-index paths are separate mechanisms.

Meaning

currval is defined per backend session. Creating a sequence, or calling nextval in another session, does not initialize the current session. The fixed sequence template is currval of sequence "%s" is not yet defined in this session with ERROR severity.

Other fixed 55000 paths have different prerequisites. pg_stat_statements reports pg_stat_statements must be loaded via "shared_preload_libraries"; add the extension to that startup setting and restart the server through the normal configuration procedure. pg_surgery reports recovery is in progress with detail Heap surgery functions cannot be executed during recovery.; wait for recovery to finish or run the operation on the appropriate writable primary. pgstattuple reports index "%s" is not valid; inspect the index and rebuild it with the appropriate REINDEX or migration procedure before using that function. These are object or server-state checks, not permission failures and not interchangeable with the session-local sequence case.

Diagnosis

Check the exact object state and the backend session that owns it. For this path, identify the sequence and verify whether this backend has called nextval; a pooled connection that ran nextval is a different prerequisite state. In an explicit transaction, a failed currval aborts the transaction, so issue ROLLBACK or ROLLBACK TO SAVEPOINT before repairing it. For other 55000 paths inspect recovery, preload settings, index validity, or object-specific prerequisites.

Response

Call nextval in the same backend before currval, or pass an explicitly known value when that is the intended contract. In autocommit, reconnecting or issuing the next statement is possible because the failed statement's transaction has ended; inside an explicit transaction, recover with a rollback or savepoint before calling nextval. Do not treat this as a privilege failure or assume a successful call from a pool’s different connection initializes the current one.

Observed diagnostics

The selected source group is ERROR with the dynamic sequence-name template above. Runtime diagnostics named currval_sequence; after the failure the autocommit session stayed IDLE, and the same session then returned 10 from nextval and currval.

Representative case

The selected registry creates the sequence and then, on one autocommit backend, calls currval before any nextval, initializes the sequence with nextval (returning 10), and reads currval again (returning 10). The failing call, repair, and verification are therefore one session-scoped state transition; this case does not test a connection-pool handoff.

CREATE SEQUENCE sequence_identifier START WITH 10;
SELECT currval('sequence_regclass');
SELECT nextval('sequence_regclass');
SELECT currval('sequence_regclass')

The selected PostgreSQL 18.6 and 10.21 runs passed SQLSTATE, severity, state or disconnect recovery, repair, cleanup, and isolated-target stop assertions. See case JSON and authored evidence.

Versions

The locked catalogue records 55000 from 7.4 through the listed snapshots. The sequence-session case passed on 18.6 and 10.21; these observations do not cover the other 55000 branches or infer every intermediate implementation.

Related

• 55006
• 42501

Sources

• src.errcodes.18.6 — src/backend/utils/errcodes.txt at 724edf9bde9d356724ad384a2e196edc3c9f80f7; blob SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba (source).
• src.currval.18.6 — src/backend/commands/sequence.c at 724edf9bde9d356724ad384a2e196edc3c9f80f7; blob SHA-256 3e5afe17d5a84862fae502a5481211220368f1d639e9d07ba6f96ee8be92a8d8 (source).
• src.currval.10.23 — src/backend/commands/sequence.c at 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; blob SHA-256 5510e1266e8d8c548a4318d753392e92e689d348f3353a2aa53d8dea871c44ab (source).
• src.path.0 — contrib/pg_stat_statements/pg_stat_statements.c at 724edf9bde9d356724ad384a2e196edc3c9f80f7, the shared_preload_libraries guard (source).
• src.path.1 — contrib/pg_surgery/heap_surgery.c at 724edf9bde9d356724ad384a2e196edc3c9f80f7, the recovery guard and detail (source).
• src.path.2 — contrib/pgstattuple/pgstatindex.c at 724edf9bde9d356724ad384a2e196edc3c9f80f7, the invalid-index guard (source).
• src.calls.REL_18_6 / src.calls.REL_10_23 — fixed call scans, SHA-256 9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf / 00d16d3eb01b71ccf1b245c8f3102f9d0ec9f36fb02777b8dd1b99fcb263040c.
• manifest.55000 / snippet-registry.55000 — hashes are recorded in evidence/55000.json and each selected runtime record.

Source evidence

Evidence belongs to the frozen source and runtime versions listed here. It is not a runtime verification of the selected manual version.

• src/backend/utils/errcodes.txt · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• contrib/pg_stat_statements/pg_stat_statements.c · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• contrib/pg_surgery/heap_surgery.c · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• contrib/pgstattuple/pgstatindex.c · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• src/backend/commands/sequence.c · REL_18_6 ·
  724edf9bde9d356724ad384a2e196edc3c9f80f7
• src/backend/commands/sequence.c · REL_10_23 ·
  02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4
• verify/cases/55000/cases.json · ·
• verify/cases/55000/snippets.json · ·
• raw/calls/REL_18_6.jsonl · REL_18_6 ·
• raw/calls/REL_10_23.jsonl · REL_10_23 ·

Message templates

pg_stat_statements must be loaded via "shared_preload_libraries"

recovery is in progress

Heap surgery functions cannot be executed during recovery.

index "%s" is not valid

currval of sequence "%s" is not yet defined in this session

currval of sequence "%s" is not yet defined in this session

Reproduction & repair cases

Recorded runtime evidence

{
  "nextval": 10,
  "sequence": "\"c55000_currval_before_nextval\".\"currval_sequence\"",
  "diagnostic": {
    "text": "currval of sequence \"currval_sequence\" is not yet defined in this session",
    "context": null,
    "severity": "ERROR",
    "sqlstate": "55000",
    "table_name": null,
    "column_name": null,
    "schema_name": null,
    "source_file": "sequence.c",
    "source_line": "887",
    "message_hint": null,
    "datatype_name": null,
    "exception_type": "ObjectNotInPrerequisiteState",
    "internal_query": null,
    "message_detail": null,
    "constraint_name": null,
    "message_primary": "currval of sequence \"currval_sequence\" is not yet defined in this session",
    "source_function": "currval_oid",
    "internal_position": null,
    "statement_position": null,
    "severity_nonlocalized": "ERROR"
  },
  "failed_status": "IDLE",
  "repair_status": "IDLE",
  "session_scope": "CREATE SEQUENCE, the failing currval, nextval, and repaired currval all ran on one autocommit backend session.",
  "connection_autocommit": true,
  "currval_after_nextval": 10
}

{
  "nextval": 10,
  "sequence": "\"c55000_currval_before_nextval\".\"currval_sequence\"",
  "diagnostic": {
    "text": "currval of sequence \"currval_sequence\" is not yet defined in this session",
    "context": null,
    "severity": "ERROR",
    "sqlstate": "55000",
    "table_name": null,
    "column_name": null,
    "schema_name": null,
    "source_file": "sequence.c",
    "source_line": "840",
    "message_hint": null,
    "datatype_name": null,
    "exception_type": "ObjectNotInPrerequisiteState",
    "internal_query": null,
    "message_detail": null,
    "constraint_name": null,
    "message_primary": "currval of sequence \"currval_sequence\" is not yet defined in this session",
    "source_function": "currval_oid",
    "internal_position": null,
    "statement_position": null,
    "severity_nonlocalized": "ERROR"
  },
  "failed_status": "IDLE",
  "repair_status": "IDLE",
  "session_scope": "CREATE SEQUENCE, the failing currval, nextval, and repaired currval all ran on one autocommit backend session.",
  "connection_autocommit": true,
  "currval_after_nextval": 10
}