Avoid deadlock and concurrency during orphan temp table removal

Edit
ID 4753
Title Avoid deadlock and concurrency during orphan temp table removal
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Bug Fixes
Tags
Created 2023-12-31 15:04:45
Last modified 2024-04-02 18:59:59 (1 year ago)
Latest email 2024-04-04 09:51:48 (1 year ago)
Status
2024-03 (2024-03-01 – 2024-04-08): Committed
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
Target version 17
Authors Mikhail Zhilin (mizhka-at-pgpro)
Reviewers Akshat Jaimini (akshatj)Become reviewer
Committer Tom Lane (tgl)
Links
Emails
BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences
First at 2023-12-31 15:02:58 by Michael Zhilin <m.zhilin at postgrespro.ru>
Latest at 2024-04-04 09:51:48 by Akshat Jaimini <destrex271 at gmail.com>
Latest attachment (v2-0001-Avoid-deadlock-and-concurrency-during-orphan-temp.patch) at 2024-03-28 06:32:58 from "Andrey M. Borodin" <x4mmm at yandex-team.ru>
    Attachment (v2-0001-Avoid-deadlock-and-concurrency-during-orphan-temp.patch) at 2024-03-28 06:32:58 from "Andrey M. Borodin" <x4mmm at yandex-team.ru> (Patch: Yes)
    Attachment (create_temp_tables.sql) at 2023-12-31 15:02:58 from Michael Zhilin <m.zhilin at postgrespro.ru> (Patch: No)
History
When Who What
2024-04-02 18:59:59 Tom Lane (tgl) Closed in commitfest 2024-03 with status: Committed
2024-04-02 18:04:19 Tom Lane (tgl) Added tgl as committer
2024-03-29 10:31:01 Akshat Jaimini (akshatj) Posted review with messageid <171170826140.2046436.12738244831107414180.pgcf@coridan.postgresql.org>
2024-03-29 10:31:01 Akshat Jaimini (akshatj) New status: Ready for Committer
2024-03-28 05:51:07 Akshat Jaimini (akshatj) Posted comment with messageid <171160506729.2046434.11023887986424565034.pgcf@coridan.postgresql.org>
2024-03-12 06:40:14 Akshat Jaimini (akshatj) Added akshatj as reviewer
2024-02-01 16:38:25 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-31 15:05:04 Mikhail Zhilin (mizhka-at-pgpro) Changed authors to Mikhail Zhilin (mizhka-at-pgpro)
2023-12-31 15:05:04 Mikhail Zhilin (mizhka-at-pgpro) Changed targetversion to 17
2023-12-31 15:04:45 Mikhail Zhilin (mizhka-at-pgpro) Attached mail thread c43ce028-2bc2-4865-9b89-3f706246eed5@postgrespro.ru
2023-12-31 15:04:45 Mikhail Zhilin (mizhka-at-pgpro) Created patch record
Edit