vacuum_defer_cleanup_age issue during the first epoch

4138

Title

Topic

Replication & Recovery

Created

2023-01-22 10:44:23

Last modified

2023-03-18 11:39:32 (1 year, 8 months ago)

Latest email

2023-03-11 23:41:21 (1 year, 8 months ago)

Status

2023-03: Committed

Target version

Authors

Andres Freund (andresfreund)

Reviewers

Michail Nikolaev (nkey)Become reviewer

Committer

Andres Freund (andresfreund)

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/4138
git checkout commitfest/cf/4138

Emails

BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE: First at 2023-01-05 13:12:32 by Michail Nikolaev <michail.nikolaev at gmail.com>
Latest at 2023-03-11 23:41:21 by Andres Freund <andres at anarazel.de>
Latest attachment (v1-0001-pg_amcheck-Minor-test-speedups.patch) at 2023-03-11 23:22:26 from Andres Freund <andres at anarazel.de>
    Attachment (v1-0001-pg_amcheck-Minor-test-speedups.patch) at 2023-03-11 23:22:26 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v5-0001-amcheck-Fix-ordering-bug-in-update_cached_xid_ran.patch) at 2023-03-09 00:15:58 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (0001-WIP-Fix-corruption-due-to-vacuum_defer_cleanup_age-u.patch) at 2023-02-04 12:21:15 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (gist-13-defer.sql) at 2023-02-04 10:57:03 from Andres Freund <andres at anarazel.de> (Patch: No)
    Attachment (v3-0001-WIP-Fix-corruption-due-to-vacuum_defer_cleanup_ag.patch) at 2023-01-30 20:19:32 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v2-0001-Fix-corruption-due-to-vacuum_defer_cleanup_age-un.patch) at 2023-01-09 19:34:26 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v1-0001-Prevent-underflow-of-xid8-epoch.patch) at 2023-01-09 16:50:10 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (reproduce.sh) at 2023-01-07 18:06:06 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: No)

History

When	Who	What
2023-03-18 11:39:32	Michail Nikolaev (nkey)	Closed in commitfest 2023-03 with status: Committed
2023-03-18 11:39:32	Michail Nikolaev (nkey)	Changed committer to andresfreund
2023-01-22 10:47:29	Michail Nikolaev (nkey)	Changed authors to Andres Freund (andresfreund)
2023-01-22 10:46:52	Michail Nikolaev (nkey)	Added nkey as reviewer
2023-01-22 10:44:24	Michail Nikolaev (nkey)	Attached mail thread CANtu0ojby3eBdMXfs4QmS+K1avBc7NcRq_Ot5bnzrbwM+uQ55w@mail.gmail.com
2023-01-22 10:44:23	Michail Nikolaev (nkey)	Created patch record