pg_upgrade: copy the source oldestXid

ID 3105

Title pg_upgrade: copy the source oldestXid

Topic Bug Fixes

Created 2021-05-04 08:20:48

Last modified 2021-08-03 12:49:44 (3 years, 4 months ago)

Latest email 2021-08-15 14:44:55 (3 years, 3 months ago)

Status

2021-09: Committed

2021-07: Moved to next CF

Target version stable

Authors Bertrand Drouvot (bdrouvot)

Reviewers Become reviewer

Committer Bruce Momjian (bmomjian)

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

Emails

pg_upgrade can result in early wraparound on databases with high transaction load: First at 2019-05-20 10:10:17 by Jason Harvey <jason at reddit.com>
Latest at 2021-07-27 12:50:02 by Bruce Momjian <bruce at momjian.us>
Latest attachment (v1-0002-pg-upgrade-keep-oldestxid.patch) at 2021-05-18 11:26:38 from "Drouvot, Bertrand" <bdrouvot at amazon.com>
Attachment (v1-0002-pg-upgrade-keep-oldestxid.patch) at 2021-05-18 11:26:38 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
Attachment (v1-0001-pg-upgrade-keep-oldestxid.patch) at 2021-05-04 08:17:49 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619: First at 2020-11-23 10:10:31 by Heikki Linnakangas <hlinnaka at iki.fi>
Latest at 2021-08-15 14:44:55 by Justin Pryzby <pryzby at telsasoft.com>
Latest attachment (0001-prion-failed-with-ERROR-missing-chunk-number-0-for-t.patch) at 2021-07-06 19:06:13 from Justin Pryzby <pryzby at telsasoft.com>
    Attachment (0001-prion-failed-with-ERROR-missing-chunk-number-0-for-t.patch) at 2021-07-06 19:06:13 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (visibility-assertions.patch) at 2021-05-16 20:23:02 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (trigger-missing-chunk-number.patch) at 2021-05-15 22:21:13 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)

History

When	Who	What
2021-08-03 12:49:44	Bertrand Drouvot (bdrouvot)	Closed in commitfest 2021-09 with status: Committed
2021-08-03 12:49:44	Bertrand Drouvot (bdrouvot)	Changed committer to bmomjian
2021-08-03 02:18:37	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-07-16 00:22:45	Justin Pryzby (justinpryzby)	Changed name to pg_upgrade: copy the source oldestXid
2021-07-06 20:04:13	Justin Pryzby (justinpryzby)	Changed topic to Bug Fixes
2021-07-06 19:06:27	Justin Pryzby (justinpryzby)	Attached mail thread f03ea04a-9b77-e371-9ab9-182cb35db1f9@iki.fi
2021-05-04 08:21:16	Bertrand Drouvot (bdrouvot)	Changed authors to Bertrand Drouvot (bdrouvot)
2021-05-04 08:21:16	Bertrand Drouvot (bdrouvot)	Changed targetversion to stable
2021-05-04 08:20:48	Bertrand Drouvot (bdrouvot)	Attached mail thread CALSof1GM6i21BLr8PsFiRYazakojvesdc+_MiR-L_V5NNkRuWg@mail.gmail.com
2021-05-04 08:20:48	Bertrand Drouvot (bdrouvot)	Created patch record