Add LSN to error messages reported for WAL file read/write/validate header failures and a new function pg_walfile_offset_lsn()

ID 3909

Title Add LSN to error messages reported for WAL file read/write/validate header failures and a new function pg_walfile_offset_lsn()

Topic Miscellaneous

Created 2022-09-20 16:24:58

Last modified 2022-12-20 05:05:26 (2 years ago)

Latest email 2022-12-23 17:07:04 (2 years ago)

Status

2023-01: Committed

2022-11: Moved to next CF

Target version 16

Authors Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy)

Reviewers Maxim Orlov (m.orlov)Become reviewer

Committer Michael Paquier (michael-kun)

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

Emails

Add LSN along with offset to error messages reported for WAL file read/write/validate header failures: First at 2022-09-19 13:56:57 by Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
Latest at 2022-12-23 17:07:04 by Magnus Hagander <magnus at hagander.net>
Latest attachment (v1-0001-Rename-pg_dissect_walfile_name-to-pg_split_walfil.patch) at 2022-12-20 12:34:40 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
    Attachment (v1-0001-Rename-pg_dissect_walfile_name-to-pg_split_walfil.patch) at 2022-12-20 12:34:40 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-utility-functions-to-disset-WAL-file-name-and.patch) at 2022-12-19 08:07:35 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v5-0001-Add-utility-functions-to-disset-WAL-file-name-and.patch) at 2022-12-13 16:02:19 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Emit-record-LSN-in-WAL-read-and-validate-error-me.patch) at 2022-12-03 03:37:38 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-LSN-along-with-offset-to-error-messages-repor.patch) at 2022-11-15 10:02:32 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-LSN-along-with-offset-to-error-messages-repor.patch) at 2022-10-27 09:28:08 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-LSN-along-with-offset-to-error-messages-repor.patch) at 2022-10-04 09:28:57 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-LSN-along-with-offset-to-error-messages-repor.patch) at 2022-09-29 14:13:28 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-introduce-pg_walfile_offset_lsn.patch) at 2022-09-20 03:32:38 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)

History

When	Who	What
2022-12-20 05:05:26	Michael Paquier (michael-kun)	Closed in commitfest 2023-01 with status: Committed
2022-12-13 16:02:36	Bharath Rupireddy (bharathrupireddy)	New status: Needs review
2022-12-05 01:04:45	Michael Paquier (michael-kun)	New status: Waiting on Author
2022-12-02 05:10:15	Michael Paquier (michael-kun)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-01 07:46:49	Michael Paquier (michael-kun)	Added michael-kun as committer
2022-11-17 08:50:54	Maxim Orlov (m.orlov)	New status: Ready for Committer
2022-11-11 11:15:29	Maxim Orlov (m.orlov)	Added m.orlov as reviewer
2022-10-04 04:00:29	Bharath Rupireddy (bharathrupireddy)	Changed name to Add LSN to error messages reported for WAL file read/write/validate header failures and a new function pg_walfile_offset_lsn()
2022-10-04 04:00:09	Bharath Rupireddy (bharathrupireddy)	Changed name to Add LSN along with offset to error messages reported for WAL file read/write/validate header failures and a new function pg_walfile_offset_lsn()
2022-10-04 03:20:00	Bharath Rupireddy (bharathrupireddy)	Changed authors to Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy)
2022-10-04 03:20:00	Bharath Rupireddy (bharathrupireddy)	Changed name to Add LSN along with offset to error messages reported for WAL file read/write/validate header failures and introduce pg_walfile_offset_lsn()
2022-09-20 16:25:08	Nathan Bossart (bossartn)	Changed authors to Nathan Bossart (bossartn)
2022-09-20 16:25:08	Nathan Bossart (bossartn)	Changed targetversion to 16
2022-09-20 16:24:59	Nathan Bossart (bossartn)	Attached mail thread CALj2ACWV=FCddsxcGbVOA=cvPyMr75YCFbSQT6g4KDj=gcJK4g@mail.gmail.com
2022-09-20 16:24:58	Nathan Bossart (bossartn)	Created patch record

Edit