55000 — 对象未处于前置状态

对象或服务器未处于操作所需的前置状态。

英文手册覆盖始于 PostgreSQL 8.1. 来源历史与运行验证各自保留独立版本边界。

当前阅读 PG 18·选择有来源记录的版本

8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

aliases: 未知
class name: Object Not In Prerequisite State
condition name: object_not_in_prerequisite_state
lang: en
sqlstate: 55000

版本定义 PG 18

55000 — 对象未处于前置状态

速览 {#at-a-glance}

55000 表示请求的操作缺少某个必要的对象或服务器状态。本页选择 currval 所需的会话级序列前提；预加载、恢复和无效索引是不同机制。

含义 {#meaning}

currval 按后端会话记录状态。创建序列，或在另一个会话调用 nextval，都不会初始化当前会话。固定序列模板为 currval of sequence "%s" is not yet defined in this session，严重级别为 ERROR。

其他固定的 55000 路径有不同前提：pg_stat_statements 报 pg_stat_statements must be loaded via "shared_preload_libraries"，应按正常配置流程加入启动参数并重启服务；pg_surgery 报 recovery is in progress，detail 为 Heap surgery functions cannot be executed during recovery.，应等待恢复完成，或在合适的可写 primary 上执行；pgstattuple 报 index "%s" is not valid，应先检查索引，并按适当的 REINDEX 或迁移流程重建后再调用。它们都是对象或服务器状态检查，不是权限错误，也不能与会话级序列案例互相替代。

诊断 {#diagnosis}

先确认对象状态以及对象所属的后端会话。对本路径，确认序列并检查这个 backend 是否调用过 nextval；连接池中另一个连接调用过也不满足当前会话前提。在显式事务中，失败的 currval 会使事务中止，因此修复前要执行 ROLLBACK 或 ROLLBACK TO SAVEPOINT。其他 55000 路径还要检查恢复状态、预加载设置、索引有效性或对象自身前提。

处理 {#response}

在同一 backend 先调用 nextval 再调用 currval；如果业务契约如此设计，也可以传入明确已知的值。自动提交时失败语句的事务已结束，可以重新发起下一条语句；显式事务中则先回滚或回滚到保存点，再调用 nextval。不要把它当作权限错误，也不要假设连接池中另一个连接的成功调用会初始化当前连接。

实测诊断 {#messages}

选定源码组为 ERROR，使用上述动态序列名模板。实测诊断中的序列名为 currval_sequence；错误后自动提交会话仍为 IDLE，同一会话随后通过 nextval 和 currval 返回 10。

代表案例 {#case}

选定注册表在一个自动提交 backend 上创建序列，然后在尚未调用 nextval 时调用 currval，再用 nextval（返回 10）初始化并再次读取 currval（返回 10）。失败调用、修复和验证属于同一会话状态转换；本案例不测试连接池切换。

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

选定的 PostgreSQL 18.6 与 10.21 运行均通过 SQLSTATE、严重级别、状态或断开恢复、修复、清理和一次性实例停止断言。详见 案例 JSON 与 作者证据。

版本 {#versions}

锁定目录从 7.4 起记录 55000。18.6 与 10.21 的序列会话案例均通过；这不覆盖其他 55000 分支，也不推断所有中间版本。

来源 {#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 的 shared_preload_libraries 检查（来源）。
src.path.1 — contrib/pg_surgery/heap_surgery.c at 724edf9bde9d356724ad384a2e196edc3c9f80f7 的恢复状态检查与 detail（来源）。
src.path.2 — contrib/pgstattuple/pgstatindex.c at 724edf9bde9d356724ad384a2e196edc3c9f80f7 的无效索引检查（来源）。
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.

比较版本

SQLSTATE 证据与已记录的运行版本

cases · currval_before_nextval

{
  "assertions": [
    "SQLSTATE is 55000 with ERROR severity",
    "The diagnostic says currval is not yet defined in this session",
    "The failed autocommit session remains IDLE",
    "nextval initializes currval on the same backend and both values are 10"
  ],
  "case_id": "currval_before_nextval",
  "cleanup": "Close all runner connections and drop the case schema with an owner connection.",
  "has_snippet": true,
  "position": 0,
  "preconditions": [
    "A runner-owned sequence exists.",
    "The trigger and repair use one backend session."
  ],
  "repair": "Use nextval in the same session before currval, or pass an explicitly known value; creating the sequence in another session does not initialize this session’s currval state.",
  "trigger": "Call currval for a sequence before this backend has called nextval, then initialize and read it.",
  "versions": [
    "10",
    "18"
  ]
}

claims · identity

{
  "claim_id": "identity",
  "limits": "",
  "method": "Read fixed definition.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "55000 is object_not_in_prerequisite_state in SQLSTATE Class 55."
}

claims · resolved-paths

{
  "claim_id": "resolved-paths",
  "limits": "Source confirmation is not natural runtime.",
  "method": "Read complete fixed source contexts.",
  "position": 1,
  "runtime": [],
  "sources": [
    "src.path.0",
    "src.path.1",
    "src.path.2"
  ],
  "statement": "The cited PostgreSQL 18.6 source paths support the representative resource and object-state mechanisms described."
}

claims · history

{
  "claim_id": "history",
  "limits": "",
  "method": "Use catalogue boundary.",
  "position": 2,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "The locked catalogue records 55000 from 7.4; that boundary does not prove exact implementation introduction."
}

claims · mechanism.currval-session

{
  "claim_id": "mechanism.currval-session",
  "limits": "Other 55000 paths represent different object or server states.",
  "method": "Read fixed sequence.c source-call records and compare same-session registry assertions.",
  "position": 3,
  "runtime": [],
  "sources": [
    "src.currval.18.6",
    "src.currval.10.23"
  ],
  "statement": "The sequence currval path requires a prior nextval call in the same backend session and reports 55000 before that prerequisite exists; creating the sequence does not initialize the session-local last-value state."
}

claims · runtime.representative-case

{
  "claim_id": "runtime.representative-case",
  "limits": "Scope is limited to sequence session state and does not cover recovery, preload, or invalid-index branches.",
  "method": "Execute the shared registry and inspect SQLSTATE, severity, session state, repair, cleanup, and target stop.",
  "position": 4,
  "runtime": [
    "runtime.ops-55000-latest-1.latest",
    "runtime.ops-55000-pg10-1.pg10"
  ],
  "sources": [
    "manifest.55000",
    "snippet-registry.55000"
  ],
  "statement": "The currval_before_nextval case passed on isolated PostgreSQL 18.6 and 10.21 targets; nextval initialized currval on the same session and returned 10."
}

messages · message.0

{
  "limits": "",
  "message_id": "message.0",
  "path": "",
  "position": 0,
  "raw": {
    "id": "message.0",
    "primary_template": "pg_stat_statements must be loaded via \"shared_preload_libraries\"",
    "severity_source": "ERROR",
    "sources": [
      "src.path.0"
    ],
    "sqlstate": "55000"
  },
  "severity": "ERROR",
  "sources": [
    "src.path.0"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "pg_stat_statements must be loaded via \"shared_preload_libraries\"",
      "position": 0,
      "role": "",
      "template": "pg_stat_statements must be loaded via \"shared_preload_libraries\""
    }
  ]
}

messages · message.1

{
  "limits": "",
  "message_id": "message.1",
  "path": "",
  "position": 1,
  "raw": {
    "detail_template": "Heap surgery functions cannot be executed during recovery.",
    "id": "message.1",
    "primary_template": "recovery is in progress",
    "severity_source": "ERROR",
    "sources": [
      "src.path.1"
    ],
    "sqlstate": "55000"
  },
  "severity": "ERROR",
  "sources": [
    "src.path.1"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "recovery is in progress",
      "position": 0,
      "role": "",
      "template": "recovery is in progress"
    },
    {
      "kind": "detail",
      "literal": "Heap surgery functions cannot be executed during recovery.",
      "position": 1,
      "role": "",
      "template": "Heap surgery functions cannot be executed during recovery."
    }
  ]
}

messages · message.2

{
  "limits": "",
  "message_id": "message.2",
  "path": "",
  "position": 2,
  "raw": {
    "id": "message.2",
    "primary_template": "index \"%s\" is not valid",
    "severity_source": "ERROR",
    "sources": [
      "src.path.2"
    ],
    "sqlstate": "55000"
  },
  "severity": "ERROR",
  "sources": [
    "src.path.2"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "index \" \" is not valid",
      "position": 0,
      "role": "",
      "template": "index \"%s\" is not valid"
    }
  ]
}

messages · message.currval.18.6

{
  "limits": "",
  "message_id": "message.currval.18.6",
  "path": "",
  "position": 3,
  "raw": {
    "id": "message.currval.18.6",
    "primary_template": "currval of sequence \"%s\" is not yet defined in this session",
    "severity_source": "ERROR",
    "sources": [
      "src.currval.18.6"
    ],
    "sqlstate": "55000"
  },
  "severity": "ERROR",
  "sources": [
    "src.currval.18.6"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "currval of sequence \" \" is not yet defined in this session",
      "position": 0,
      "role": "",
      "template": "currval of sequence \"%s\" is not yet defined in this session"
    }
  ]
}

messages · message.currval.10.23

{
  "limits": "",
  "message_id": "message.currval.10.23",
  "path": "",
  "position": 4,
  "raw": {
    "id": "message.currval.10.23",
    "primary_template": "currval of sequence \"%s\" is not yet defined in this session",
    "severity_source": "ERROR",
    "sources": [
      "src.currval.10.23"
    ],
    "sqlstate": "55000"
  },
  "severity": "ERROR",
  "sources": [
    "src.currval.10.23"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "currval of sequence \" \" is not yet defined in this session",
      "position": 0,
      "role": "",
      "template": "currval of sequence \"%s\" is not yet defined in this session"
    }
  ]
}

runtimes · runtime.ops-55000-latest-1.latest · 18.6 (Homebrew) · passed

{
  "cases": [
    "currval_before_nextval"
  ],
  "limits": "",
  "position": 0,
  "raw": {
    "assertions": [
      {
        "expected": "55000",
        "name": "55000 SQLSTATE",
        "observed": "55000",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "55000 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "currval of sequence ... is not yet defined in this session",
        "name": "currval diagnostic identifies missing session sequence state",
        "observed": "currval of sequence \"currval_sequence\" is not yet defined in this session",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "currval prerequisite error leaves session usable",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "currval": 10,
          "nextval": 10,
          "status": "IDLE"
        },
        "name": "nextval initializes currval in the same session",
        "observed": {
          "currval": 10,
          "nextval": 10,
          "status": "IDLE"
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.55000",
      "kind": "local_artifact",
      "path": "verify/cases/55000/cases.json",
      "sha256": "25edfc0a289a49187779b25fba339dead0ffad950c1cbaba6eccb517dc7000a9",
      "source_role": "case_manifest"
    },
    "cases": [
      "currval_before_nextval"
    ],
    "cleanup": {
      "errors": [],
      "passed": true
    },
    "environment": {
      "TimeZone": "Asia/Shanghai",
      "backend_pid": 43655,
      "binary": {
        "bindir": "/opt/homebrew/Cellar/postgresql@18/18.6/bin",
        "pg_config": "/opt/homebrew/bin/pg_config",
        "pg_config_version": "PostgreSQL 18.6 (Homebrew)",
        "postgres": "/opt/homebrew/Cellar/postgresql@18/18.6/bin/postgres"
      },
      "connection_scope": "runner-owned localhost port",
      "current_user": "runner",
      "docker": {},
      "lc_messages": "C",
      "libpq_version": "18.6",
      "locale": "C.UTF-8",
      "log_destination": "csvlog,jsonlog",
      "log_error_verbosity": "verbose",
      "log_min_error_statement": "error",
      "log_min_messages": "error",
      "logging_collector": "on",
      "machine": "arm64",
      "max_connections": "100",
      "platform": "macOS-26.6.2-arm64-arm-64bit-Mach-O",
      "psycopg_version": "3.3.5",
      "python_version": "3.14.6 (main, Jun 10 2026, 10:03:53) [Clang 21.0.0 (clang-2100.0.123.102)]",
      "server_encoding": "UTF8",
      "server_version": "18.6 (Homebrew)",
      "server_version_num": "180006",
      "target_kind": "latest",
      "wal_level": "logical"
    },
    "id": "runtime.ops-55000-latest-1.latest",
    "observed": {
      "connection_autocommit": true,
      "currval_after_nextval": 10,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "ObjectNotInPrerequisiteState",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "currval of sequence \"currval_sequence\" is not yet defined in this session",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "sequence.c",
        "source_function": "currval_oid",
        "source_line": "887",
        "sqlstate": "55000",
        "statement_position": null,
        "table_name": null,
        "text": "currval of sequence \"currval_sequence\" is not yet defined in this session"
      },
      "failed_status": "IDLE",
      "nextval": 10,
      "repair_status": "IDLE",
      "sequence": "\"c55000_currval_before_nextval\".\"currval_sequence\"",
      "session_scope": "CREATE SEQUENCE, the failing currval, nextval, and repaired currval all ran on one autocommit backend session."
    },
    "raw": "verify/results/ops-55000-latest-1/latest/raw.jsonl",
    "raw_sha256": "9bf2c7a30cef4b96d2203f81b22b9a06f6745120d0ba545168ae0038dce10ae3",
    "run_id": "ops-55000-latest-1",
    "server_version": "18.6 (Homebrew)",
    "server_version_num": 180006,
    "snippet_registry": {
      "id": "snippet-registry.55000",
      "kind": "local_artifact",
      "path": "verify/cases/55000/snippets.json",
      "sha256": "bef69304c57466de39bcdbc198b0a0042095b77f1d3c45bef45b829084b32ccb",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/ops-55000-latest-1/latest/summary.json",
    "summary_sha256": "74a401cf3c5923c127ffdabd8310679fee09d18da3b7df93a696faca7884df5f",
    "target": "latest",
    "target_stop": {
      "argv": [
        "/opt/homebrew/Cellar/postgresql@18/18.6/bin/pg_ctl",
        "-D",
        "/Users/vonng/pgcenter/err-code/.cache/runtime/ops-55000-latest-1/latest/data",
        "-m",
        "fast",
        "-w",
        "stop"
      ],
      "elapsed_seconds": 0.111,
      "returncode": 0,
      "stderr": "",
      "stdout": "waiting for server to shut down.... done\nserver stopped\n"
    }
  },
  "run_id": "ops-55000-latest-1",
  "runtime_id": "runtime.ops-55000-latest-1.latest",
  "server_version": "18.6 (Homebrew)",
  "status": "passed",
  "target": "latest"
}

runtimes · runtime.ops-55000-pg10-1.pg10 · 10.21 (Debian 10.21-1.pgdg90+1) · passed

{
  "cases": [
    "currval_before_nextval"
  ],
  "limits": "",
  "position": 1,
  "raw": {
    "assertions": [
      {
        "expected": "55000",
        "name": "55000 SQLSTATE",
        "observed": "55000",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "55000 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "currval of sequence ... is not yet defined in this session",
        "name": "currval diagnostic identifies missing session sequence state",
        "observed": "currval of sequence \"currval_sequence\" is not yet defined in this session",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "currval prerequisite error leaves session usable",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "currval": 10,
          "nextval": 10,
          "status": "IDLE"
        },
        "name": "nextval initializes currval in the same session",
        "observed": {
          "currval": 10,
          "nextval": 10,
          "status": "IDLE"
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.55000",
      "kind": "local_artifact",
      "path": "verify/cases/55000/cases.json",
      "sha256": "25edfc0a289a49187779b25fba339dead0ffad950c1cbaba6eccb517dc7000a9",
      "source_role": "case_manifest"
    },
    "cases": [
      "currval_before_nextval"
    ],
    "cleanup": {
      "errors": [],
      "passed": true
    },
    "environment": {
      "TimeZone": "Etc/UTC",
      "backend_pid": 79,
      "binary": {},
      "connection_scope": "runner-owned localhost port",
      "current_user": "postgres",
      "docker": {
        "architecture": "arm64",
        "command": "/usr/local/bin/docker",
        "digest": "sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc",
        "id": "sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc",
        "image": "postgres:10",
        "image_created": "2022-06-23T09:11:18.374607054Z",
        "image_ref": "postgres@sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc",
        "log_destination": "csvlog",
        "os": "linux",
        "repo_digests": [
          "postgres@sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc"
        ]
      },
      "lc_messages": "en_US.utf8",
      "libpq_version": "18.6",
      "locale": "C.UTF-8",
      "log_destination": "csvlog",
      "log_error_verbosity": "verbose",
      "log_min_error_statement": "error",
      "log_min_messages": "error",
      "logging_collector": "on",
      "machine": "arm64",
      "max_connections": "100",
      "platform": "macOS-26.6.2-arm64-arm-64bit-Mach-O",
      "psycopg_version": "3.3.5",
      "python_version": "3.14.6 (main, Jun 10 2026, 10:03:53) [Clang 21.0.0 (clang-2100.0.123.102)]",
      "server_encoding": "UTF8",
      "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
      "server_version_num": "100021",
      "target_kind": "pg10",
      "wal_level": "logical"
    },
    "id": "runtime.ops-55000-pg10-1.pg10",
    "observed": {
      "connection_autocommit": true,
      "currval_after_nextval": 10,
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "ObjectNotInPrerequisiteState",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "currval of sequence \"currval_sequence\" is not yet defined in this session",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "sequence.c",
        "source_function": "currval_oid",
        "source_line": "840",
        "sqlstate": "55000",
        "statement_position": null,
        "table_name": null,
        "text": "currval of sequence \"currval_sequence\" is not yet defined in this session"
      },
      "failed_status": "IDLE",
      "nextval": 10,
      "repair_status": "IDLE",
      "sequence": "\"c55000_currval_before_nextval\".\"currval_sequence\"",
      "session_scope": "CREATE SEQUENCE, the failing currval, nextval, and repaired currval all ran on one autocommit backend session."
    },
    "raw": "verify/results/ops-55000-pg10-1/pg10/raw.jsonl",
    "raw_sha256": "5d6d1b4d1ee72b5088e9d1d83383b071c0883ddea65477e35807a80553131458",
    "run_id": "ops-55000-pg10-1",
    "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
    "server_version_num": 100021,
    "snippet_registry": {
      "id": "snippet-registry.55000",
      "kind": "local_artifact",
      "path": "verify/cases/55000/snippets.json",
      "sha256": "bef69304c57466de39bcdbc198b0a0042095b77f1d3c45bef45b829084b32ccb",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/ops-55000-pg10-1/pg10/summary.json",
    "summary_sha256": "12c1a769e979b44f214ef9741fe2774c401d5e8871112cbc350ec501dd2f282f",
    "target": "pg10",
    "target_stop": {
      "cleanup": {
        "argv": [
          "/usr/local/bin/docker",
          "rm",
          "-f",
          "-v",
          "sqlstate55000_ops55000pg101_pg10"
        ],
        "elapsed_seconds": 0.297,
        "returncode": 0,
        "stderr": "",
        "stdout": "sqlstate55000_ops55000pg101_pg10\n"
      },
      "inspect": {
        "argv": [
          "/usr/local/bin/docker",
          "inspect",
          "sqlstate55000_ops55000pg101_pg10"
        ],
        "elapsed_seconds": 0.027,
        "returncode": 0,
        "stderr": "",
        "stdout": "[\n    {\n        \"Id\": \"5947a11f0be0c5882298918f5d9176581faaed03f9537a3bc5a2747bbeb51fc2\",\n        \"Created\": \"2026-09-09T17:10:54.898257629Z\",\n        \"Path\": \"docker-entrypoint.sh\",\n        \"Args\": [\n            \"postgres\",\n            \"-c\",\n            \"listen_addresses=*\",\n            \"-c\",\n            \"log_destination=csvlog\",\n            \"-c\",\n            \"logging_collector=on\",\n            \"-c\",\n            \"log_directory=log\",\n            \"-c\",\n            \"log_filename=postgresql-%Y%m%d%H%M%S.log\",\n            \"-c\",\n            \"log_min_messages=error\",\n            \"-c\",\n            \"log_min_error_statement=error\",\n            \"-c\",\n            \"log_error_verbosity=verbose\",\n            \"-c\",\n            \"wal_level=logical\",\n            \"-c\",\n            \"max_wal_senders=10\",\n            \"-c\",\n            \"max_replication_slots=10\"\n        ],\n        \"State\": {\n            \"Status\": \"running\",\n            \"Running\": true,\n            \"Paused\": false,\n            \"Restarting\": false,\n            \"OOMKilled\": false,\n            \"Dead\": false,\n            \"Pid\": 64384,\n            \"ExitCode\": 0,\n            \"Error\": \"\",\n            \"StartedAt\": \"2026-09-09T17:10:54.967511504Z\",\n            \"FinishedAt\": \"0001-01-01T00:00:00Z\"\n        },\n        \"Image\": \"sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc\",\n        \"ResolvConfPath\": \"/var/lib/docker/containers/5947a11f0be0c5882298918f5d9176581faaed03f9537a3bc5a2747bbeb51fc2/resolv.conf\",\n        \"HostnamePath\": \"/var/lib/docker/containers/5947a11f0be0c5882298918f5d9176581faaed03f9537a3bc5a2747bbeb51fc2/hostname\",\n        \"HostsPath\": \"/var/lib/docker/containers/5947a11f0be0c5882298918f5d9176581faaed03f9537a3bc5a2747bbeb51fc2/hosts\",\n        \"LogPath\": \"/var/lib/docker/containers/5947a11f0be0c5882298918f5d9176581faaed03f9537a3bc5a2747bbeb51fc2/5947a11f0be0c5882298918f5d9176581faaed03f9537a3bc5a2747bbeb51fc2-json.log\",\n        \"Name\": \"/sqlstate55000_ops55000pg101_pg10\",\n        \"RestartCount\": 0,\n        \"Driver\": \"overlayfs\",\n        \"Platform\": \"linux\",\n        \"MountLabel\": \"\",\n        \"ProcessLabel\": \"\",\n        \"AppArmorProfile\": \"\",\n        \"ExecIDs\": null,\n        \"HostConfig\": {\n            \"Binds\": null,\n            \"ContainerIDFile\": \"\",\n            \"LogConfig\": {\n                \"Type\": \"json-file\",\n                \"Config\": {}\n            },\n            \"NetworkMode\": \"bridge\",\n            \"PortBindings\": {\n                \"5432/tcp\": [\n                    {\n                        \"HostIp\": \"127.0.0.1\",\n                        \"HostPort\": \"\"\n                    }\n                ]\n            },\n            \"RestartPolicy\": {\n                \"Name\": \"no\",\n                \"MaximumRetryCount\": 0\n            },\n            \"AutoRemove\": false,\n            \"VolumeDriver\": \"\",\n            \"VolumesFrom\": null,\n            \"ConsoleSize\": [\n                0,\n                0\n            ],\n            \"CapAdd\": null,\n            \"CapDrop\": null,\n            \"CgroupnsMode\": \"private\",\n            \"Dns\": null,\n            \"DnsOptions\": [],\n            \"DnsSearch\": [],\n            \"ExtraHosts\": null,\n            \"GroupAdd\": null,\n            \"IpcMode\": \"private\",\n            \"Cgroup\": \"\",\n            \"Links\": null,\n            \"OomScoreAdj\": 0,\n            \"PidMode\": \"\",\n            \"Privileged\": false,\n            \"PublishAllPorts\": false,\n            \"ReadonlyRootfs\": false,\n            \"SecurityOpt\": null,\n            \"UTSMode\": \"\",\n            \"UsernsMode\": \"\",\n            \"ShmSize\": 67108864,\n            \"Runtime\": \"runc\",\n            \"Isolation\": \"\",\n            \"CpuShares\": 0,\n            \"Memory\": 0,\n            \"NanoCpus\": 0,\n            \"CgroupParent\": \"\",\n            \"BlkioWeight\": 0,\n            \"BlkioWeightDevice\": [],\n            \"BlkioDeviceReadBps\": [],\n            \"BlkioDeviceWriteBps\": [],\n            \"BlkioDeviceReadIOps\": [],\n            \"BlkioDeviceWriteIOps\": [],\n            \"CpuPeriod\": 0,\n            \"CpuQuota\": 0,\n            \"CpuRealtimePeriod\": 0,\n            \"CpuRealtimeRuntime\": 0,\n            \"CpusetCpus\": \"\",\n            \"CpusetMems\": \"\",\n            \"Devices\": [],\n            \"DeviceCgroupRules\": null,\n            \"DeviceRequests\": null,\n            \"MemoryReservation\": 0,\n            \"MemorySwap\": 0,\n            \"MemorySwappiness\": null,\n            \"OomKillDisable\": null,\n            \"PidsLimit\": null,\n            \"Ulimits\": [],\n            \"CpuCount\": 0,\n            \"CpuPercent\": 0,\n            \"IOMaximumIOps\": 0,\n            \"IOMaximumBandwidth\": 0,\n            \"MaskedPaths\": [\n                \"/proc/acpi\",\n                \"/proc/asound\",\n                \"/proc/interrupts\",\n                \"/proc/kcore\",\n                \"/proc/keys\",\n                \"/proc/latency_stats\",\n                \"/proc/sched_debug\",\n                \"/proc/scsi\",\n                \"/proc/timer_list\",\n                \"/proc/timer_stats\",\n                \"/sys/devices/virtual/powercap\",\n                \"/sys/firmware\"\n            ],\n            \"ReadonlyPaths\": [\n                \"/proc/bus\",\n                \"/proc/fs\",\n                \"/proc/irq\",\n                \"/proc/sys\",\n                \"/proc/sysrq-trigger\"\n            ]\n        },\n        \"Storage\": {\n            \"RootFS\": {\n                \"Snapshot\": {\n                    \"Name\": \"overlayfs\"\n                }\n            }\n        },\n        \"Mounts\": [\n            {\n                \"Type\": \"volume\",\n                \"Name\": \"18148e70b4d9a2d7565e0d0ee2d609310628107f03007fac32acc343936d300d\",\n                \"Source\": \"/var/lib/docker/volumes/18148e70b4d9a2d7565e0d0ee2d609310628107f03007fac32acc343936d300d/_data\",\n                \"Destination\": \"/var/lib/postgresql/data\",\n                \"Driver\": \"local\",\n                \"Mode\": \"\",\n                \"RW\": true,\n                \"Propagation\": \"\"\n            }\n        ],\n        \"Config\": {\n            \"Hostname\": \"5947a11f0be0\",\n            \"Domainname\": \"\",\n            \"User\": \"\",\n            \"AttachStdin\": false,\n            \"AttachStdout\": false,\n            \"AttachStderr\": false,\n            \"ExposedPorts\": {\n                \"5432/tcp\": {}\n            },\n            \"Tty\": false,\n            \"OpenStdin\": false,\n            \"StdinOnce\": false,\n            \"Env\": [\n                \"POSTGRES_HOST_AUTH_METHOD=trust\",\n                \"PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/10/bin\",\n                \"GOSU_VERSION=1.14\",\n                \"LANG=en_US.utf8\",\n                \"PG_MAJOR=10\",\n                \"PG_VERSION=10.21-1.pgdg90+1\",\n                \"PGDATA=/var/lib/postgresql/data\"\n            ],\n            \"Cmd\": [\n                \"postgres\",\n                \"-c\",\n                \"listen_addresses=*\",\n                \"-c\",\n                \"log_destination=csvlog\",\n                \"-c\",\n                \"logging_collector=on\",\n                \"-c\",\n                \"log_directory=log\",\n                \"-c\",\n                \"log_filename=postgresql-%Y%m%d%H%M%S.log\",\n                \"-c\",\n                \"log_min_messages=error\",\n                \"-c\",\n                \"log_min_error_statement=error\",\n                \"-c\",\n                \"log_error_verbosity=verbose\",\n                \"-c\",\n                \"wal_level=logical\",\n                \"-c\",\n                \"max_wal_senders=10\",\n                \"-c\",\n                \"max_replication_slots=10\"\n            ],\n            \"Image\": \"postgres@sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc\",\n            \"Volumes\": {\n                \"/var/lib/postgresql/data\": {}\n            },\n            \"WorkingDir\": \"\",\n            \"Entrypoint\": [\n                \"docker-entrypoint.sh\"\n            ],\n            \"Labels\": {},\n            \"StopSignal\": \"SIGINT\",\n            \"StopTimeout\": 1\n        },\n        \"NetworkSettings\": {\n            \"SandboxID\": \"ffc9c28ffe9c2a369693a78df5f2a02e509ab6b428cdc33b84421bae58128404\",\n            \"SandboxKey\": \"/var/run/docker/netns/ffc9c28ffe9c\",\n            \"Ports\": {\n                \"5432/tcp\": [\n                    {\n                        \"HostIp\": \"127.0.0.1\",\n                        \"HostPort\": \"57917\"\n                    }\n                ]\n            },\n            \"Networks\": {\n                \"bridge\": {\n                    \"IPAMConfig\": null,\n                    \"Links\": null,\n                    \"Aliases\": null,\n                    \"DriverOpts\": null,\n                    \"GwPriority\": 0,\n                    \"NetworkID\": \"aed51554f8cd8bac69ecd4f073e41e147fda7b458e9d95be2af472651f2e825c\",\n                    \"EndpointID\": \"269393effcd12fd755212621c6caa6c263dd5315ca0a93ffc22c936e6ffe4567\",\n                    \"Gateway\": \"172.17.0.1\",\n                    \"IPAddress\": \"172.17.0.53\",\n                    \"MacAddress\": \"46:dd:fa:a8:3c:dc\",\n                    \"IPPrefixLen\": 16,\n                    \"IPv6Gateway\": \"\",\n                    \"GlobalIPv6Address\": \"\",\n                    \"GlobalIPv6PrefixLen\": 0,\n                    \"DNSNames\": null\n                }\n            }\n        },\n        \"ImageManifestDescriptor\": {\n            \"mediaType\": \"application/vnd.docker.distribution.manifest.v2+json\",\n            \"digest\": \"sha256:52aada7978f1eef3b6b52a51afb7a3defd69254d00c946cb90d2ceb32b8ffce7\",\n            \"size\": 3246,\n            \"platform\": {\n                \"architecture\": \"arm64\",\n                \"os\": \"linux\",\n                \"variant\": \"v8\"\n            }\n        }\n    }\n]\n"
      }
    }
  },
  "run_id": "ops-55000-pg10-1",
  "runtime_id": "runtime.ops-55000-pg10-1.pg10",
  "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
  "status": "passed",
  "target": "pg10"
}

sources · src.errcodes.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/utils/errcodes.txt",
  "position": 0,
  "sha256": "6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba",
  "source_id": "src.errcodes.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/utils/errcodes.txt#L424"
}

sources · src.path.0

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/pg_stat_statements/pg_stat_statements.c",
  "position": 1,
  "sha256": "5a732a7c5b124ba98f2e3939c2458b85757c49fdb7846276f6b96ceeb833e74b",
  "source_id": "src.path.0",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/contrib/pg_stat_statements/pg_stat_statements.c#L1685"
}

sources · src.path.1

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/pg_surgery/heap_surgery.c",
  "position": 2,
  "sha256": "561c7bf6579ec62f3931ea9ccbd31694c53661e1e09b55f92d29a6472e1b6a1d",
  "source_id": "src.path.1",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/contrib/pg_surgery/heap_surgery.c#L99"
}

sources · src.path.2

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "contrib/pgstattuple/pgstatindex.c",
  "position": 3,
  "sha256": "87857af9f79eddf4986f5aaf9eb1a69f7040038aee89c9944d8dac1342edd4f9",
  "source_id": "src.path.2",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/contrib/pgstattuple/pgstatindex.c#L244"
}

sources · src.currval.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/commands/sequence.c",
  "position": 4,
  "sha256": "3e5afe17d5a84862fae502a5481211220368f1d639e9d07ba6f96ee8be92a8d8",
  "source_id": "src.currval.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/sequence.c#L884-L887"
}

sources · src.currval.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/commands/sequence.c",
  "position": 5,
  "sha256": "5510e1266e8d8c548a4318d753392e92e689d348f3353a2aa53d8dea871c44ab",
  "source_id": "src.currval.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/commands/sequence.c#L845-L848"
}

sources · manifest.55000

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/55000/cases.json",
  "position": 6,
  "sha256": "25edfc0a289a49187779b25fba339dead0ffad950c1cbaba6eccb517dc7000a9",
  "source_id": "manifest.55000",
  "tag": "",
  "url": ""
}

sources · snippet-registry.55000

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/55000/snippets.json",
  "position": 7,
  "sha256": "bef69304c57466de39bcdbc198b0a0042095b77f1d3c45bef45b829084b32ccb",
  "source_id": "snippet-registry.55000",
  "tag": "",
  "url": ""
}

sources · src.calls.REL_18_6

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "raw/calls/REL_18_6.jsonl",
  "position": 8,
  "sha256": "9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf",
  "source_id": "src.calls.REL_18_6",
  "tag": "REL_18_6",
  "url": ""
}

sources · src.calls.REL_10_23

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "raw/calls/REL_10_23.jsonl",
  "position": 9,
  "sha256": "00d16d3eb01b71ccf1b245c8f3102f9d0ec9f36fb02777b8dd1b99fcb263040c",
  "source_id": "src.calls.REL_10_23",
  "tag": "REL_10_23",
  "url": ""
}

来源引用

原始手册引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:b62ab945a2e0256dd6720eb74f71380eda9eb2ec24626bcedb11fee8d7148898

正文语言: zh-Hans · english-manuals:b62ab945a2e0256dd6720eb74f71380eda9eb2ec24626bcedb11fee8d7148898

55000 — 对象未处于前置状态

版本定义 PG 18

55000 — 对象未处于前置状态

速览 {#at-a-glance}

含义 {#meaning}

诊断 {#diagnosis}

处理 {#response}

实测诊断 {#messages}

代表案例 {#case}

版本 {#versions}

相关 {#related}

来源 {#sources}

比较版本

SQLSTATE 证据与已记录的运行版本

来源引用