Standby cannot catch up primary after pg

Standby cannot catch up primary after pg_rewind

Title

Standby cannot catch up primary after pg_rewind

Topic

Bug Fixes

Created

2018-02-28 08:17:23

Last modified

2018-03-28 19:06:00 (6 years, 8 months ago)

Latest email

2018-03-29 00:05:27 (6 years, 8 months ago)

Status

2018-03: Committed

Target version

Authors

Takayuki Tsunakawa (maumau)

Reviewers

Michael Paquier (michael-kun)Become reviewer

Committer

Fujii Masao (masaofujii)

Links

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

Emails

[bug fix] pg_rewind creates corrupt WAL files, and the standby cannot catch up the primary: First at 2018-03-01 01:26:32 by "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com>
Latest at 2018-03-29 00:05:27 by Michael Paquier <michael at paquier.xyz>
Latest attachment (0001-Fix-handling-of-removed-files-on-target-server-with-.patch) at 2018-03-11 14:04:01 from Michael Paquier <michael at paquier.xyz>
    Attachment (0001-Fix-handling-of-removed-files-on-target-server-with-.patch) at 2018-03-11 14:04:01 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (pg_rewind_corrupt_wal_v2.patch) at 2018-03-09 08:22:49 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)
    Attachment (pg_rewind_corrupt_wal.patch) at 2018-03-01 01:26:32 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)

History

When	Who	What
2018-03-28 19:06:00	Fujii Masao (masaofujii)	Closed in commitfest 2018-03 with status: Committed
2018-03-27 19:47:10	Fujii Masao (masaofujii)	Added masaofujii as committer
2018-03-11 14:04:12	Michael Paquier (michael-kun)	New status: Ready for Committer
2018-03-09 07:16:28	Michael Paquier (michael-kun)	New status: Waiting on Author
2018-03-08 23:55:25	Michael Paquier (michael-kun)	Changed reviewers to Michael Paquier (michael-kun)
2018-03-01 01:42:50	Takayuki Tsunakawa (maumau)	Detached mail thread 0A3221C70F24FB45833433255569204D1F8D6C7A@G01JPEXMBYT05
2018-03-01 01:42:06	Takayuki Tsunakawa (maumau)	Attached mail thread 0A3221C70F24FB45833433255569204D1F8DAAA2@G01JPEXMBYT05
2018-02-28 08:17:35	Takayuki Tsunakawa (maumau)	Changed authors to Takayuki Tsunakawa (maumau)
2018-02-28 08:17:23	Takayuki Tsunakawa (maumau)	Attached mail thread 0A3221C70F24FB45833433255569204D1F8D6C7A@G01JPEXMBYT05
2018-02-28 08:17:23	Takayuki Tsunakawa (maumau)	Created patch record