{"already_in_source_count":0,"candidate_count":2,"cross_major":false,"cve_available":true,"cve_count":0,"cves":[],"duplicate_count":0,"excluded_count":0,"exclusions":[],"from_release":null,"groups":[{"age_days":4140,"build":"9.2.13","changes_count":2,"compatibility_count":0,"content_hash":"b9bf85851a7093f90f95160001b96aabef37d894d4efc810f622f87a815f75ea","date":"2015-06-12","date_text":"2015-06-12","doc_git":"","doc_loaded_at":"2026-09-26T02:56:46.946617","entries":[{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":[],"commit_groups":[],"commits":[],"cves":[],"db_id":"62f6eb8f9354ed2084e2a04aba92b9a4","html":"\u003cp\u003e     修复罕见的未能使关系缓存 init 文件失效的问题（Tom Lane）\n    \u003c/p\u003e\u003cp\u003e     在并发活动时序恰好不对的情况下，对系统目录执行\u003ccode\u003eVACUUM FULL\u003c/code\u003e可能无法更新用于避免新会话缓存加载工作的\u003cspan\u003e“\u003cspan\u003einit 文件\u003c/span\u003e”\u003c/span\u003e。这将导致后续会话完全无法访问该目录。这是一个非常古老的缺陷，但它极难触发，直到最近才出现可复现的案例。\n    \u003c/p\u003e","id":"9.2.13-2138cf0f137fffce","identity_text":"Fix rare failure to invalidate relation cache init file (Tom Lane) With just the wrong timing of concurrent activity, a VACUUM FULL on a system catalog might fail to update the init file that's used to avoid cache-loading work for new sessions. This would result in later sessions being unable to access that catalog at all. This is a very ancient bug, but it's so hard to trigger that no reproducible case had been seen until recently.","part":"changes","patch_ids":[],"related_changes":[{"db_id":"e08881035a5c62a2921de58daddb199c","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"},"kind":"equivalent","label":"9.4.4","source_url":"/docs/release/9.4.4/#id-1.11.6.27.5","title":"修复罕见的未能使关系缓存 init 文件失效的问题","url":"/docs/compare/?release=9.4.4#9.4.4-2138cf0f137fffce","version":"9.4.4"},{"db_id":"d00ab3b80fd0fe3a84d1b02a94bfcd79","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"},"kind":"equivalent","label":"9.3.9","source_url":"/docs/release/9.3.9/#id-1.11.6.21.5","title":"修复罕见的未能使关系缓存 init 文件失效的问题","url":"/docs/compare/?release=9.3.9#9.3.9-2138cf0f137fffce","version":"9.3.9"},{"db_id":"421f0e5f53c1b534c1a5d7e5c3ddaeb1","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"},"kind":"equivalent","label":"9.1.18","source_url":"/docs/release/9.1.18/#id-1.11.6.11.5","title":"修复罕见的未能使关系缓存 init 文件失效的问题","url":"/docs/compare/?release=9.1.18#9.1.18-2138cf0f137fffce","version":"9.1.18"},{"db_id":"56559e80e5e318ceb4a1514c01179a96","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"},"kind":"equivalent","label":"9.0.22","source_url":"/docs/release/9.0.22/#id-1.11.6.6.6","title":"修复罕见的未能使关系缓存 init 文件失效的问题","url":"/docs/compare/?release=9.0.22#9.0.22-2138cf0f137fffce","version":"9.0.22"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"},"rule":2,"target":"421f0e5f53c1b534c1a5d7e5c3ddaeb1","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"},"rule":2,"target":"56559e80e5e318ceb4a1514c01179a96","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"},"rule":2,"target":"d00ab3b80fd0fe3a84d1b02a94bfcd79","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d"},"rule":2,"target":"e08881035a5c62a2921de58daddb199c","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":[],"source_entry_id":"9.2.13/changes/001","source_hash":"6bec1b27e4a7c93b00f27640abe8cfeea45f0bff3dcdb265af25580efcb2a989","source_url":"/docs/release/9.2.13/#id-1.11.6.16.5","statement_hash":"cbd29ab3677162dd8eee0c8fdae7218663c03b789800db751346403cb4a7e91d","text":"修复罕见的未能使关系缓存 init 文件失效的问题（Tom Lane） 在并发活动时序恰好不对的情况下，对系统目录执行VACUUM FULL可能无法更新用于避免新会话缓存加载工作的“init 文件”。这将导致后续会话完全无法访问该目录。这是一个非常古老的缺陷，但它极难触发，直到最近才出现可复现的案例。","title":"修复罕见的未能使关系缓存 init 文件失效的问题","variants":[],"version":"9.2.13"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":[],"commit_groups":[],"commits":[],"cves":[],"db_id":"29b698d5466f021dc8611d5d25ef7a31","html":"\u003cp\u003e     避免传入会话与\u003ccode\u003eCREATE/DROP DATABASE\u003c/code\u003e之间的死锁（Tom Lane）\n    \u003c/p\u003e\u003cp\u003e     在作为\u003ccode\u003eDROP DATABASE\u003c/code\u003e命令目标或\u003ccode\u003eCREATE DATABASE\u003c/code\u003e命令模板的数据库中启动的新会话，可能导致该命令等待五秒后失败，即使新会话本会在此之前退出。\n    \u003c/p\u003e","id":"9.2.13-bf7732cf950a1492","identity_text":"Avoid deadlock between incoming sessions and CREATE/DROP DATABASE (Tom Lane) A new session starting in a database that is the target of a DROP DATABASE command, or is the template for a CREATE DATABASE command, could cause the command to wait for five seconds and then fail, even if the new session would have exited before that.","part":"changes","patch_ids":[],"related_changes":[{"db_id":"c17918b133f9aac5297f7d0675245278","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"},"kind":"equivalent","label":"9.4.4","source_url":"/docs/release/9.4.4/#id-1.11.6.27.5","title":"避免传入会话与CREATE/DROP DATABASE之间的死锁","url":"/docs/compare/?release=9.4.4#9.4.4-bf7732cf950a1492","version":"9.4.4"},{"db_id":"324abd755d98fe477c7962eab7502c58","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"},"kind":"equivalent","label":"9.3.9","source_url":"/docs/release/9.3.9/#id-1.11.6.21.5","title":"避免传入会话与CREATE/DROP DATABASE之间的死锁","url":"/docs/compare/?release=9.3.9#9.3.9-bf7732cf950a1492","version":"9.3.9"},{"db_id":"7f208fa7a3abd0837b1466c4a8f65e61","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"},"kind":"equivalent","label":"9.1.18","source_url":"/docs/release/9.1.18/#id-1.11.6.11.5","title":"避免传入会话与CREATE/DROP DATABASE之间的死锁","url":"/docs/compare/?release=9.1.18#9.1.18-bf7732cf950a1492","version":"9.1.18"},{"db_id":"9bfc180a71dd7d167b27c33f605fed9e","evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"},"kind":"equivalent","label":"9.0.22","source_url":"/docs/release/9.0.22/#id-1.11.6.6.6","title":"避免传入会话与CREATE/DROP DATABASE之间的死锁","url":"/docs/compare/?release=9.0.22#9.0.22-bf7732cf950a1492","version":"9.0.22"}],"relations":[{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"},"rule":2,"target":"324abd755d98fe477c7962eab7502c58","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"},"rule":2,"target":"7f208fa7a3abd0837b1466c4a8f65e61","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"},"rule":2,"target":"9bfc180a71dd7d167b27c33f605fed9e","type":"equivalent"},{"evidence":{"patch_ids":[],"same_day":true,"statement_hash":"9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496"},"rule":2,"target":"c17918b133f9aac5297f7d0675245278","type":"equivalent"}],"section":"变更","section_path":["变更"],"source_commits":[],"source_entry_id":"9.2.13/changes/002","source_hash":"5955b77e7598b41a798cbf651d54231093f0a28da1857ce4d5be305b763ca703","source_url":"/docs/release/9.2.13/#id-1.11.6.16.5","statement_hash":"9cfac8d41ed5419bd18a7efcbaf8feb78254029ffd3c6f0dd8c9d0f63a21a496","text":"避免传入会话与CREATE/DROP DATABASE之间的死锁（Tom Lane） 在作为DROP DATABASE命令目标或CREATE DATABASE命令模板的数据库中启动的新会话，可能导致该命令等待五秒后失败，即使新会话本会在此之前退出。","title":"避免传入会话与CREATE/DROP DATABASE之间的死锁","variants":[],"version":"9.2.13"}],"entry_count":2,"eol":"2017-11-09","eol_date":"2017-11-09","label":"9.2.13","major":"9.2","manual":"9.2","manual_build":"9.2.24","manual_url":"/docs/9.2/release-9-2-13.html","migration_html":"\u003cp\u003e    对于运行 9.2.X 的用户，不需要进行转储/恢复。\u003c/p\u003e\u003cp\u003e    不过，如果你是从早于 9.2.11 的版本升级，请参见\u003ca href=\"/docs/9.2/release-9-2-11.html\" title=\"E.14. 版本 9.2.11\"\u003e第 E.14 节\u003c/a\u003e。\u003c/p\u003e","minor":13,"placeholder":false,"source_as_of":"","source_url":"/docs/release/9.2.13/","status":"stable","status_label":"Historical","support_days":-3259,"supported":false,"version":"9.2.13"}],"mode":"release","release_count":1,"remaining_cves":[],"security_as_of":"2026-09-26","security_regressions":[],"source_as_of":"2026-09-26","stats":[{"count":2,"key":"all","label":"All changes"},{"count":0,"key":"feature","label":"Features"},{"count":2,"key":"bugfix","label":"Bug fixes"},{"count":0,"key":"security","label":"Security"},{"count":0,"key":"performance","label":"Performance"},{"count":0,"key":"compatibility","label":"Compatibility"},{"count":0,"key":"improvement","label":"Improvements"}],"to_release":{"age_days":4140,"build":"9.2.13","changes_count":2,"compatibility_count":0,"content_hash":"b9bf85851a7093f90f95160001b96aabef37d894d4efc810f622f87a815f75ea","date":"2015-06-12","date_text":"2015-06-12","doc_git":"","doc_loaded_at":"2026-09-26T02:56:46.946617","entry_count":2,"eol":"2017-11-09","eol_date":"2017-11-09","label":"9.2.13","major":"9.2","manual":"9.2","manual_build":"9.2.24","manual_url":"/docs/9.2/release-9-2-13.html","migration_html":"\u003cp\u003e    对于运行 9.2.X 的用户，不需要进行转储/恢复。\u003c/p\u003e\u003cp\u003e    不过，如果你是从早于 9.2.11 的版本升级，请参见\u003ca href=\"/docs/9.2/release-9-2-11.html\" title=\"E.14. 版本 9.2.11\"\u003e第 E.14 节\u003c/a\u003e。\u003c/p\u003e","minor":13,"placeholder":false,"source_as_of":"","source_url":"/docs/release/9.2.13/","status":"stable","status_label":"Historical","support_days":-3259,"supported":false,"version":"9.2.13"},"total":2,"warnings":[]}