Avoid deadlock and concurrency during orphan temp table removal

Title

Topic

Bug Fixes

Created

2023-12-31 15:04:45

Last modified

2024-04-02 18:59:59 (1 month ago)

Latest email

2024-04-04 09:51:48 (4 weeks, 1 day ago)

Status

2024-03: Committed

2024-01: Moved to next CF

Target version

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