Avoid deadlock and concurrency during orphan temp table removal

ID 4753

Title Avoid deadlock and concurrency during orphan temp table removal

Topic Bug Fixes

Created 2023-12-31 15:04:45

Last modified 2024-04-02 18:59:59 (8 months ago)

Latest email 2024-04-04 09:51:48 (7 months, 4 weeks ago)

Status

2024-03: Committed

2024-01: Moved to next CF

Target version 17

Authors Mikhail Zhilin (mizhka-at-pgpro)

Reviewers Akshat Jaimini (akshatj)Become reviewer

Committer Tom Lane (tgl)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4753
git checkout commitfest/cf/4753

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