LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue

Edit
ID 6095
Title LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue
CI (CFBot) Summary
Stats (from CFBot) Patch version: v10, Patch count: 2, First patch: +130−24, All patches: +323−24
Topic Bug Fixes
Tags Bugfix Help - Bikeshedding
Created 2025-10-01 11:53:50
Last modified 2025-10-01 11:53:50 (3 weeks ago)
Latest email 2025-10-24 07:36:44 (1 hour ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
Target version
Authors Matheus Alcantara (matheus.alcantara)
Reviewers Arseniy Mukhin (amukhin)Become reviewer
Committer
Links
Emails
LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue
First at 2025-08-06 04:50:01 by Alexandra Wang <alexandra.wang.oss at gmail.com>
Latest at 2025-10-24 07:36:44 by Arseniy Mukhin <arseniy.mukhin.dev at gmail.com>
Latest attachment (v10-0001-Prevent-VACUUM-from-truncating-XIDs-still-presen.patch) at 2025-10-22 17:25:36 from "Matheus Alcantara" <matheusssilv97 at gmail.com>
    Attachment (v10-0001-Prevent-VACUUM-from-truncating-XIDs-still-presen.patch) at 2025-10-22 17:25:36 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Prevent-VACUUM-from-truncating-XIDs-still-present.patch) at 2025-10-22 15:23:42 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Make-AsyncQueueEntry-s-self-contained.patch) at 2025-10-20 12:37:24 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (fix_notify_datfrozenxid.txt) at 2025-10-19 17:14:07 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (v7-0001-Make-AsyncQueueEntry-s-self-contained.patch) at 2025-10-17 20:50:53 from Arseniy Mukhin <arseniy.mukhin.dev at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Make-AsyncQueueEntry-s-self-contained.patch) at 2025-10-02 12:06:38 from Arseniy Mukhin <arseniy.mukhin.dev at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Make-AsyncQueueEntry-s-self-contained.patch) at 2025-09-28 13:17:48 from Arseniy Mukhin <arseniy.mukhin.dev at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Make-AsyncQueueEntry-s-self-contained.patch) at 2025-09-24 19:23:08 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Make-AsyncQueueEntry-s-self-contained.patch) at 2025-09-23 22:39:57 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Reset-LISTEN-NOTIFY-QUEUE_HEAD-for-crashed-transa.patch) at 2025-09-22 13:09:20 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (0001-Adds-LISTEN-NOTIFY-aborted_tx_notification-TAP-test.patch) at 2025-09-19 12:34:21 from Arseniy Mukhin <arseniy.mukhin.dev at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Make-AsyncQueueEntry-s-self-contained.patch) at 2025-09-18 21:34:40 from Matheus Alcantara <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Consider-LISTEN-NOTIFY-min-xid-during-VACUUM-FREE.patch) at 2025-09-03 20:35:49 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Consider-LISTEN-NOTIFY-min-xid-during-VACUUM-FREE.patch) at 2025-08-28 22:31:35 from Matheus Alcantara <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (v0-0001-Consider-async-queue-min-xid-on-VACUUM-FREEZE.patch) at 2025-08-11 13:41:08 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (0001-Advance-tail-of-async-queue-before-updating-datfroze.patch.no-cfbot) at 2025-08-06 04:50:01 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
History
When Who What
2025-10-02 12:07:04 Arseniy Mukhin (amukhin) Added amukhin as reviewer
2025-10-01 11:53:50 Matheus Alcantara (matheus.alcantara) Attached mail thread CAK98qZ3wZLE-RZJN_Y+TFjiTRPPFPBwNBpBi5K5CU8hUHkzDpw@mail.gmail.com
2025-10-01 11:53:50 Matheus Alcantara (matheus.alcantara) Created patch record
Edit