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) Needs rebase! Needs rebase since 2 days. Failing since 2 days.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Topic Bug Fixes
Tags Bugfix Help - Bikeshedding
Created 2025-10-01 11:53:50
Last modified 2025-10-01 11:53:50 (1 month ago)
Latest email 2025-11-12 19:39:47 (3 days 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-11-12 19:39:47 by Heikki Linnakangas <hlinnaka at iki.fi>
Latest attachment (skip-TransactionIdDidCommit-on-first-listen.patch.txt) at 2025-11-07 08:10:25 from Heikki Linnakangas <hlinnaka at iki.fi>
    Attachment (skip-TransactionIdDidCommit-on-first-listen.patch.txt) at 2025-11-07 08:10:25 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (start-listen-from-min.patch.txt) at 2025-11-06 12:05:59 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v3-0001-Escalate-ERRORs-during-async-notify-processing-to.patch) at 2025-11-06 10:05:20 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v2-0001-Fix-bug-where-we-truncated-CLOG-that-was-still-ne.patch) at 2025-11-04 12:09:58 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (stat-master.txt) at 2025-11-03 21:45:00 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (async-notify-test-1.c) at 2025-11-03 11:02:32 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: No)
    Attachment (0001-Fix-bug-where-we-truncated-CLOG-that-was-still-neede.patch) at 2025-10-31 16:40:03 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v2-pg_bench_lino.c) at 2025-10-30 23:27:11 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (pg_bench_lino.c) at 2025-10-30 23:08:04 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (v12-vacuum_notify_queue_cleanup-without-code-dup.txt) at 2025-10-25 18:01:56 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (v12-0002-Add-test-for-listen-notify.patch) at 2025-10-25 13:08:41 from Arseniy Mukhin <arseniy.mukhin.dev at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Prevent-VACUUM-from-truncating-XIDs-still-presen.patch) at 2025-10-25 00:32:54 from "Matheus Alcantara" <matheusssilv97 at gmail.com> (Patch: Yes)
    Attachment (vacuum_notify_queue_cleanup-without-code-dup.txt) at 2025-10-24 12:12:01 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    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-11-14 00:47:22 CFbot Patch needs rebase
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