55006 — 对象正在使用

对象正被使用，操作与进行中的占用冲突。

英文手册覆盖始于 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_in_use
lang: en
sqlstate: 55006

版本定义 PG 18

55006 — 对象正在使用

速览 {#at-a-glance}

55006 表示请求的对象操作与正在进行的使用冲突。本页选择显式事务中同一会话的活动 cursor 占用表；数据库用户、逻辑复制和待处理触发器事件是不同路径。

含义 {#meaning}

选定的表命令模板为 cannot %s "%s" because it is being used by active queries in this session。关系引用计数指向同一 backend 的活动 portal 或扫描，不是一般权限问题。同一个表使用检查还有当前事务排队的 AFTER trigger 分支：cannot %s "%s" because it has pending trigger events。其他 55006 报文可能指明数据库用户或逻辑复制槽等不同阻塞者。

诊断 {#diagnosis}

确认对象和持有使用状态的具体会话或服务器状态。本案例检查显式事务与命名 cursor；若是待处理 trigger event，应完成或回滚排队它们的事务。遇到数据库或复制路径时，应在终止任何会话前检查 pg_stat_activity、复制槽、订阅和维护归属。当前 backend 的 cursor 与其他用户 backend 或逻辑复制槽不是同一种阻塞。

处理 {#response}

回滚失败的显式事务，让事务拥有的 cursor 和待处理 trigger event 释放，再在明确的维护边界重做 DDL。数据库用户阻塞要协调持有会话，逻辑复制槽则处理订阅/slot 生命周期。不要把 CASCADE 或终止无关会话当作通用处理。

实测诊断 {#messages}

选定源码组为 ERROR，操作和关系名是动态字段。实测主报文为 cannot DROP TABLE "cursor_drop_table" because it is being used by active queries in this session；事务进入 INERROR，回滚后恢复为 IDLE。

代表案例 {#case}

注册表创建一张空表，在同一后端开启事务、声明并 FETCH 命名 cursor，再尝试 DROP TABLE；即使没有行，活动 cursor 仍会触发同会话 active-query 分支。真实 55006 后，处理程序在同一连接回滚，再次删除表并确认关系已消失。本案例不代替其他数据库用户、逻辑复制槽或待处理 AFTER-trigger event 路径。

CREATE TABLE cursor_drop_table(id integer PRIMARY KEY);
BEGIN;
DECLARE active_cursor CURSOR FOR SELECT id FROM cursor_drop_table;
FETCH active_cursor;
DROP TABLE cursor_drop_table;
ROLLBACK;
DROP TABLE cursor_drop_table;
SELECT to_regclass('cursor_drop_table_regclass')

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

版本 {#versions}

锁定目录从 7.4 起记录 55006。18.6 与 10.21 的活动 cursor DDL 案例均通过；这不代表数据库、复制或待处理触发器路径。

来源 {#sources}

src.errcodes.18.6 — src/backend/utils/errcodes.txt at 724edf9bde9d356724ad384a2e196edc3c9f80f7; blob SHA-256 6e8de346643ba84aa3c9c6a73360acfc7b2dfb89162c06c08ce9bf5bcd5bbcba (source).
src.active-cursor.18.6 — src/backend/commands/tablecmds.c at 724edf9bde9d356724ad384a2e196edc3c9f80f7; blob SHA-256 422dc8e833df4940755973c757e338295822ba3e4c7266c40669f49f96eb15a9 (source).
src.pending-trigger.18.6 — 同一 tablecmds.c 检查待处理 AFTER-trigger event，并在 4439-4444 发出 cannot %s "%s" because it has pending trigger events (source)。
src.active-cursor.10.23 — src/backend/commands/tablecmds.c at 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4; blob SHA-256 6de441c88496c6cf57a836898388085ec08bf69afd70d07acdafd6089b9b5f8c (source).
src.calls.REL_18_6 / src.calls.REL_10_23 — fixed call scans, SHA-256 9ee8a0e81d8f0825c5c1ae45583439859a26e602bdd4ce2f2a62aa278867ccbf / 00d16d3eb01b71ccf1b245c8f3102f9d0ec9f36fb02777b8dd1b99fcb263040c.
manifest.55006 / snippet-registry.55006 — hashes are recorded in evidence/55006.json and each selected runtime record.

比较版本

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

cases · active_cursor_drop

{
  "assertions": [
    "SQLSTATE is 55006 with ERROR severity",
    "The diagnostic says the table is used by active queries in this session",
    "The failed DROP leaves the explicit transaction INERROR",
    "ROLLBACK releases the transaction-owned cursor and the same session can DROP the table"
  ],
  "case_id": "active_cursor_drop",
  "cleanup": "Close all runner connections and drop the case schema with an owner connection.",
  "has_snippet": true,
  "position": 0,
  "preconditions": [
    "A runner-owned empty table exists; a cursor can still hold the relation in active use.",
    "The table cursor and DROP run on one backend session."
  ],
  "repair": "Rollback the failed transaction to release its cursor and then repeat the DDL; do not hide an active-session dependency with CASCADE.",
  "trigger": "Declare and use a cursor on a table in an explicit transaction, then attempt to DROP that table from the same session.",
  "versions": [
    "10",
    "18"
  ]
}

claims · identity

{
  "claim_id": "identity",
  "limits": "",
  "method": "Read fixed definition.",
  "position": 0,
  "runtime": [],
  "sources": [
    "src.errcodes.18.6"
  ],
  "statement": "55006 is object_in_use 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 55006 from 7.4; that boundary does not prove exact implementation introduction."
}

claims · mechanism.active-cursor

{
  "claim_id": "mechanism.active-cursor",
  "limits": "Other 55006 branches cover databases, logical replication, and pending trigger events.",
  "method": "Read fixed tablecmds.c source-call records and compare the explicit transaction/cursor case.",
  "position": 3,
  "runtime": [],
  "sources": [
    "src.active-cursor.18.6",
    "src.active-cursor.10.23"
  ],
  "statement": "The selected table-command path reports 55006 when the same session attempts DROP while its transaction-owned cursor still uses the table."
}

claims · runtime.representative-case

{
  "claim_id": "runtime.representative-case",
  "limits": "Scope is one same-session cursor/table path; it does not establish behavior for unrelated database or replication blockers.",
  "method": "Execute the shared registry and inspect SQLSTATE, severity, INERROR to IDLE recovery, DDL repair, cleanup, and target stop.",
  "position": 4,
  "runtime": [
    "runtime.ops-55006-latest-2.latest",
    "runtime.ops-55006-pg10-1.pg10"
  ],
  "sources": [
    "manifest.55006",
    "snippet-registry.55006"
  ],
  "statement": "The active_cursor_drop case passed on isolated PostgreSQL 18.6 and 10.21; rollback released the cursor transaction and the same session then dropped the table."
}

messages · message.0

{
  "limits": "",
  "message_id": "message.0",
  "path": "",
  "position": 0,
  "raw": {
    "id": "message.0",
    "primary_template": "source database \"%s\" is being accessed by other users",
    "severity_source": "ERROR",
    "sources": [
      "src.path.0"
    ],
    "sqlstate": "55006"
  },
  "severity": "ERROR",
  "sources": [
    "src.path.0"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "source database \" \" is being accessed by other users",
      "position": 0,
      "role": "",
      "template": "source database \"%s\" is being accessed by other users"
    }
  ]
}

messages · message.1

{
  "limits": "",
  "message_id": "message.1",
  "path": "",
  "position": 1,
  "raw": {
    "id": "message.1",
    "primary_template": "database \"%s\" is used by an active logical replication slot",
    "severity_source": "ERROR",
    "sources": [
      "src.path.1"
    ],
    "sqlstate": "55006"
  },
  "severity": "ERROR",
  "sources": [
    "src.path.1"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "database \" \" is used by an active logical replication slot",
      "position": 0,
      "role": "",
      "template": "database \"%s\" is used by an active logical replication slot"
    }
  ]
}

messages · message.2

{
  "limits": "",
  "message_id": "message.2",
  "path": "",
  "position": 2,
  "raw": {
    "id": "message.2",
    "primary_template": "cannot %s \"%s\" because it is being used by active queries in this session",
    "severity_source": "ERROR",
    "sources": [
      "src.path.2"
    ],
    "sqlstate": "55006"
  },
  "severity": "ERROR",
  "sources": [
    "src.path.2"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "cannot \" \" because it is being used by active queries in this session",
      "position": 0,
      "role": "",
      "template": "cannot %s \"%s\" because it is being used by active queries in this session"
    }
  ]
}

messages · message.3

{
  "limits": "This is a separate current-transaction branch from the active-query reference-count branch.",
  "message_id": "message.3",
  "path": "",
  "position": 3,
  "raw": {
    "id": "message.3",
    "limits": "This is a separate current-transaction branch from the active-query reference-count branch.",
    "primary_template": "cannot %s \"%s\" because it has pending trigger events",
    "severity_source": "ERROR",
    "sources": [
      "src.path.2"
    ],
    "sqlstate": "55006"
  },
  "severity": "ERROR",
  "sources": [
    "src.path.2"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "cannot \" \" because it has pending trigger events",
      "position": 0,
      "role": "",
      "template": "cannot %s \"%s\" because it has pending trigger events"
    }
  ]
}

messages · message.active-cursor.18.6

{
  "limits": "",
  "message_id": "message.active-cursor.18.6",
  "path": "",
  "position": 4,
  "raw": {
    "id": "message.active-cursor.18.6",
    "primary_template": "cannot %s \"%s\" because it is being used by active queries in this session",
    "severity_source": "ERROR",
    "sources": [
      "src.active-cursor.18.6"
    ],
    "sqlstate": "55006"
  },
  "severity": "ERROR",
  "sources": [
    "src.active-cursor.18.6"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "cannot \" \" because it is being used by active queries in this session",
      "position": 0,
      "role": "",
      "template": "cannot %s \"%s\" because it is being used by active queries in this session"
    }
  ]
}

messages · message.active-cursor.10.23

{
  "limits": "",
  "message_id": "message.active-cursor.10.23",
  "path": "",
  "position": 5,
  "raw": {
    "id": "message.active-cursor.10.23",
    "primary_template": "cannot %s \"%s\" because it is being used by active queries in this session",
    "severity_source": "ERROR",
    "sources": [
      "src.active-cursor.10.23"
    ],
    "sqlstate": "55006"
  },
  "severity": "ERROR",
  "sources": [
    "src.active-cursor.10.23"
  ],
  "templates": [
    {
      "kind": "primary",
      "literal": "cannot \" \" because it is being used by active queries in this session",
      "position": 0,
      "role": "",
      "template": "cannot %s \"%s\" because it is being used by active queries in this session"
    }
  ]
}

runtimes · runtime.ops-55006-latest-2.latest · 18.6 (Homebrew) · passed

{
  "cases": [
    "active_cursor_drop"
  ],
  "limits": "",
  "position": 0,
  "raw": {
    "assertions": [
      {
        "expected": "55006",
        "name": "55006 SQLSTATE",
        "observed": "55006",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "55006 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "cannot drop ... because it is being used by active queries in this session",
        "name": "active cursor blocks table drop",
        "observed": "cannot DROP TABLE \"cursor_drop_table\" because it is being used by active queries in this session",
        "passed": true
      },
      {
        "expected": "INTRANS",
        "name": "cursor transaction is active before DDL",
        "observed": "INTRANS",
        "passed": true
      },
      {
        "expected": "INERROR",
        "name": "failed DROP aborts transaction",
        "observed": "INERROR",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "rollback releases cursor and transaction",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "remaining": null,
          "status": "IDLE"
        },
        "name": "released cursor permits same-session DROP",
        "observed": {
          "remaining": null,
          "status": "IDLE"
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.55006",
      "kind": "local_artifact",
      "path": "verify/cases/55006/cases.json",
      "sha256": "ba1f597f1250488a70187cce54fb5ee3b5271cc59c8bf14ccb89fc2580155577",
      "source_role": "case_manifest"
    },
    "cases": [
      "active_cursor_drop"
    ],
    "cleanup": {
      "errors": [],
      "passed": true
    },
    "environment": {
      "TimeZone": "Asia/Shanghai",
      "backend_pid": 43851,
      "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-55006-latest-2.latest",
    "observed": {
      "connection_autocommit": true,
      "cursor": "active_cursor_9a6f4bbd",
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "ObjectInUse",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "cannot DROP TABLE \"cursor_drop_table\" because it is being used by active queries in this session",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "tablecmds.c",
        "source_function": "CheckTableNotInUse",
        "source_line": "4435",
        "sqlstate": "55006",
        "statement_position": null,
        "table_name": null,
        "text": "cannot DROP TABLE \"cursor_drop_table\" because it is being used by active queries in this session"
      },
      "repair": "ROLLBACK releases the transaction-owned cursor, then DROP TABLE succeeds on the same connection.",
      "statuses": {
        "after_error": "INERROR",
        "after_repair": "IDLE",
        "after_rollback": "IDLE",
        "before_drop": "INTRANS"
      },
      "table": "\"c55006_active_cursor_drop\".\"cursor_drop_table\""
    },
    "raw": "verify/results/ops-55006-latest-2/latest/raw.jsonl",
    "raw_sha256": "1338c25d5b5349269a08a72f37669e6dce5801bbd4864c135586a10c0c836a0b",
    "run_id": "ops-55006-latest-2",
    "server_version": "18.6 (Homebrew)",
    "server_version_num": 180006,
    "snippet_registry": {
      "id": "snippet-registry.55006",
      "kind": "local_artifact",
      "path": "verify/cases/55006/snippets.json",
      "sha256": "7df91ab045a8fe307bc2f025c17f53d6e107fa392afe2b45dbb457c42fbcd74e",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/ops-55006-latest-2/latest/summary.json",
    "summary_sha256": "877c2f2da43a65ff859b4ee888da5a19d357c8ee0341216c0359c65b1997cb74",
    "target": "latest",
    "target_stop": {
      "argv": [
        "/opt/homebrew/Cellar/postgresql@18/18.6/bin/pg_ctl",
        "-D",
        "/Users/vonng/pgcenter/err-code/.cache/runtime/ops-55006-latest-2/latest/data",
        "-m",
        "fast",
        "-w",
        "stop"
      ],
      "elapsed_seconds": 0.11,
      "returncode": 0,
      "stderr": "",
      "stdout": "waiting for server to shut down.... done\nserver stopped\n"
    }
  },
  "run_id": "ops-55006-latest-2",
  "runtime_id": "runtime.ops-55006-latest-2.latest",
  "server_version": "18.6 (Homebrew)",
  "status": "passed",
  "target": "latest"
}

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

{
  "cases": [
    "active_cursor_drop"
  ],
  "limits": "",
  "position": 1,
  "raw": {
    "assertions": [
      {
        "expected": "55006",
        "name": "55006 SQLSTATE",
        "observed": "55006",
        "passed": true
      },
      {
        "expected": "ERROR",
        "name": "55006 ERROR severity",
        "observed": "ERROR",
        "passed": true
      },
      {
        "expected": "cannot drop ... because it is being used by active queries in this session",
        "name": "active cursor blocks table drop",
        "observed": "cannot DROP TABLE \"cursor_drop_table\" because it is being used by active queries in this session",
        "passed": true
      },
      {
        "expected": "INTRANS",
        "name": "cursor transaction is active before DDL",
        "observed": "INTRANS",
        "passed": true
      },
      {
        "expected": "INERROR",
        "name": "failed DROP aborts transaction",
        "observed": "INERROR",
        "passed": true
      },
      {
        "expected": "IDLE",
        "name": "rollback releases cursor and transaction",
        "observed": "IDLE",
        "passed": true
      },
      {
        "expected": {
          "remaining": null,
          "status": "IDLE"
        },
        "name": "released cursor permits same-session DROP",
        "observed": {
          "remaining": null,
          "status": "IDLE"
        },
        "passed": true
      }
    ],
    "case_manifest": {
      "id": "manifest.55006",
      "kind": "local_artifact",
      "path": "verify/cases/55006/cases.json",
      "sha256": "ba1f597f1250488a70187cce54fb5ee3b5271cc59c8bf14ccb89fc2580155577",
      "source_role": "case_manifest"
    },
    "cases": [
      "active_cursor_drop"
    ],
    "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-55006-pg10-1.pg10",
    "observed": {
      "connection_autocommit": true,
      "cursor": "active_cursor_cfa19ef4",
      "diagnostic": {
        "column_name": null,
        "constraint_name": null,
        "context": null,
        "datatype_name": null,
        "exception_type": "ObjectInUse",
        "internal_position": null,
        "internal_query": null,
        "message_detail": null,
        "message_hint": null,
        "message_primary": "cannot DROP TABLE \"cursor_drop_table\" because it is being used by active queries in this session",
        "schema_name": null,
        "severity": "ERROR",
        "severity_nonlocalized": "ERROR",
        "source_file": "tablecmds.c",
        "source_function": "CheckTableNotInUse",
        "source_line": "3077",
        "sqlstate": "55006",
        "statement_position": null,
        "table_name": null,
        "text": "cannot DROP TABLE \"cursor_drop_table\" because it is being used by active queries in this session"
      },
      "repair": "ROLLBACK releases the transaction-owned cursor, then DROP TABLE succeeds on the same connection.",
      "statuses": {
        "after_error": "INERROR",
        "after_repair": "IDLE",
        "after_rollback": "IDLE",
        "before_drop": "INTRANS"
      },
      "table": "\"c55006_active_cursor_drop\".\"cursor_drop_table\""
    },
    "raw": "verify/results/ops-55006-pg10-1/pg10/raw.jsonl",
    "raw_sha256": "e35d02729b81bf70d7f20c812d12e6049c5613254cf291dacee97f0b13c50dc5",
    "run_id": "ops-55006-pg10-1",
    "server_version": "10.21 (Debian 10.21-1.pgdg90+1)",
    "server_version_num": 100021,
    "snippet_registry": {
      "id": "snippet-registry.55006",
      "kind": "local_artifact",
      "path": "verify/cases/55006/snippets.json",
      "sha256": "7df91ab045a8fe307bc2f025c17f53d6e107fa392afe2b45dbb457c42fbcd74e",
      "source_role": "snippet_registry"
    },
    "status": "passed",
    "summary": "verify/results/ops-55006-pg10-1/pg10/summary.json",
    "summary_sha256": "c92d34e3a4796ec4d721660566424ebcffd0dd19ab4381e22eef089267142a38",
    "target": "pg10",
    "target_stop": {
      "cleanup": {
        "argv": [
          "/usr/local/bin/docker",
          "rm",
          "-f",
          "-v",
          "sqlstate55006_ops55006pg101_pg10"
        ],
        "elapsed_seconds": 0.29,
        "returncode": 0,
        "stderr": "",
        "stdout": "sqlstate55006_ops55006pg101_pg10\n"
      },
      "inspect": {
        "argv": [
          "/usr/local/bin/docker",
          "inspect",
          "sqlstate55006_ops55006pg101_pg10"
        ],
        "elapsed_seconds": 0.017,
        "returncode": 0,
        "stderr": "",
        "stdout": "[\n    {\n        \"Id\": \"839d8d08b076745b3253bd79457d70b3acf5fc5aded8e1c76cabf404473e70d0\",\n        \"Created\": \"2026-09-09T17:11:05.029829009Z\",\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\": 64557,\n            \"ExitCode\": 0,\n            \"Error\": \"\",\n            \"StartedAt\": \"2026-09-09T17:11:05.096534051Z\",\n            \"FinishedAt\": \"0001-01-01T00:00:00Z\"\n        },\n        \"Image\": \"sha256:b2baf8998630663d21370da06387c950e587071bdd307ee34e661cdcc7442bcc\",\n        \"ResolvConfPath\": \"/var/lib/docker/containers/839d8d08b076745b3253bd79457d70b3acf5fc5aded8e1c76cabf404473e70d0/resolv.conf\",\n        \"HostnamePath\": \"/var/lib/docker/containers/839d8d08b076745b3253bd79457d70b3acf5fc5aded8e1c76cabf404473e70d0/hostname\",\n        \"HostsPath\": \"/var/lib/docker/containers/839d8d08b076745b3253bd79457d70b3acf5fc5aded8e1c76cabf404473e70d0/hosts\",\n        \"LogPath\": \"/var/lib/docker/containers/839d8d08b076745b3253bd79457d70b3acf5fc5aded8e1c76cabf404473e70d0/839d8d08b076745b3253bd79457d70b3acf5fc5aded8e1c76cabf404473e70d0-json.log\",\n        \"Name\": \"/sqlstate55006_ops55006pg101_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\": \"01ab825d5cecdce48ba964a52f36043a0f441e32e41aa4ebcbdf85573b43e9cc\",\n                \"Source\": \"/var/lib/docker/volumes/01ab825d5cecdce48ba964a52f36043a0f441e32e41aa4ebcbdf85573b43e9cc/_data\",\n                \"Destination\": \"/var/lib/postgresql/data\",\n                \"Driver\": \"local\",\n                \"Mode\": \"\",\n                \"RW\": true,\n                \"Propagation\": \"\"\n            }\n        ],\n        \"Config\": {\n            \"Hostname\": \"839d8d08b076\",\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\": \"bbf6b564334edf67af6427d14467ba63430612f08485b07cf13f60a2ae19a15e\",\n            \"SandboxKey\": \"/var/run/docker/netns/bbf6b564334e\",\n            \"Ports\": {\n                \"5432/tcp\": [\n                    {\n                        \"HostIp\": \"127.0.0.1\",\n                        \"HostPort\": \"57946\"\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\": \"b3a144adc411c0ed3bab17eeae957a54ef048406de3dab6042b142802019646b\",\n                    \"Gateway\": \"172.17.0.1\",\n                    \"IPAddress\": \"172.17.0.53\",\n                    \"MacAddress\": \"12:d2:e3:dc:02:23\",\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-55006-pg10-1",
  "runtime_id": "runtime.ops-55006-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#L425"
}

sources · src.path.0

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/commands/dbcommands.c",
  "position": 1,
  "sha256": "64b77d2197dce16eb1ad19d8168382459d621a03df0b00be157f7db39ca22acf",
  "source_id": "src.path.0",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/dbcommands.c#L1407"
}

sources · src.path.1

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/commands/dbcommands.c",
  "position": 2,
  "sha256": "64b77d2197dce16eb1ad19d8168382459d621a03df0b00be157f7db39ca22acf",
  "source_id": "src.path.1",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/dbcommands.c#L1752"
}

sources · src.path.2

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/commands/tablecmds.c",
  "position": 3,
  "sha256": "422dc8e833df4940755973c757e338295822ba3e4c7266c40669f49f96eb15a9",
  "source_id": "src.path.2",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L4431"
}

sources · src.active-cursor.18.6

{
  "commit": "724edf9bde9d356724ad384a2e196edc3c9f80f7",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/commands/tablecmds.c",
  "position": 4,
  "sha256": "422dc8e833df4940755973c757e338295822ba3e4c7266c40669f49f96eb15a9",
  "source_id": "src.active-cursor.18.6",
  "tag": "REL_18_6",
  "url": "https://github.com/postgres/postgres/blob/724edf9bde9d356724ad384a2e196edc3c9f80f7/src/backend/commands/tablecmds.c#L4431-L4435"
}

sources · src.active-cursor.10.23

{
  "commit": "02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4",
  "docs_url": "",
  "kind": "upstream_source",
  "location": "",
  "path": "src/backend/commands/tablecmds.c",
  "position": 5,
  "sha256": "6de441c88496c6cf57a836898388085ec08bf69afd70d07acdafd6089b9b5f8c",
  "source_id": "src.active-cursor.10.23",
  "tag": "REL_10_23",
  "url": "https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/commands/tablecmds.c#L3072-L3077"
}

sources · manifest.55006

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

sources · snippet-registry.55006

{
  "commit": "",
  "docs_url": "",
  "kind": "local_artifact",
  "location": "",
  "path": "verify/cases/55006/snippets.json",
  "position": 7,
  "sha256": "7df91ab045a8fe307bc2f025c17f53d6e107fa392afe2b45dbb457c42fbcd74e",
  "source_id": "snippet-registry.55006",
  "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:384601ed176a3096794d96f93862327f8999569f3a7d9b5ed8e3d4dd9dad42be

正文语言: zh-Hans · english-manuals:384601ed176a3096794d96f93862327f8999569f3a7d9b5ed8e3d4dd9dad42be

55006 — 对象正在使用

版本定义 PG 18

55006 — 对象正在使用

速览 {#at-a-glance}

含义 {#meaning}

诊断 {#diagnosis}

处理 {#response}

实测诊断 {#messages}

代表案例 {#case}

版本 {#versions}

相关 {#related}

来源 {#sources}

比较版本

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

来源引用