Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns

ID 3041

Title Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns

Topic Bug Fixes

Created 2021-03-15 16:41:26

Last modified 2022-08-12 13:35:49 (2 years, 3 months ago)

Latest email 2022-08-29 06:17:28 (2 years, 2 months ago)

Status

2022-09: Committed

2022-07: Moved to next CF

2022-03: Moved to next CF

2022-01: Moved to next CF

2021-11: Moved to next CF

2021-09: Moved to next CF

2021-07: Moved to next CF

Target version

Authors Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1)

Reviewers Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi)Become reviewer

Committer Amit Kapila (amitkapila)

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

Emails

[BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns: First at 2021-03-15 16:34:56 by "Oh, Mike" <minsoo at amazon.com>
Latest at 2022-08-29 06:17:28 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (v2-0001-Fix-the-incorrect-assertion-introduced-in-commit-.patch) at 2022-08-27 10:24:24 from Amit Kapila <amit.kapila16 at gmail.com>
    Attachment (v2-0001-Fix-the-incorrect-assertion-introduced-in-commit-.patch) at 2022-08-27 10:24:24 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (fix_purge_catchange_xacts_1.patch) at 2022-08-27 06:56:16 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (REL15_v13-0001-Fix-catalog-lookup-with-the-wrong-snapshot-durin.patch) at 2022-08-03 07:49:24 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (REL13_v12-0001-Fix-catalog-lookup-with-the-wrong-snapshot-durin.patch) at 2022-08-03 04:05:30 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (master_v11-0001-Fix-catalog-lookup-with-the-wrong-snapshot-durin.patch) at 2022-08-01 14:31:00 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (REL15_v10-0001-Fix-catalog-lookup-with-the-wrong-snapshot-durin.patch) at 2022-08-01 02:16:21 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (master_v9_amit.diff.patch) at 2022-07-28 09:53:54 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (REL15_v9-0001-Fix-catalog-lookup-with-the-wrong-snapshot-during.patch) at 2022-07-27 11:33:21 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (master-v9-0001-Add-catalog-modifying-transactions-to-logical-dec.patch) at 2022-07-26 07:51:33 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (performance_test.png) at 2022-07-25 10:57:43 from "shiy.fnst at fujitsu.com" <shiy.fnst at fujitsu.com> (Patch: No)
    Attachment (REL15-v8-0001-Fix-catalog-lookup-with-the-wrong-snapshot-during.patch) at 2022-07-25 05:55:45 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (REL14-v8-0001-Fix-catalog-lookup-with-the-wrong-snapshot-during.patch) at 2022-07-25 01:45:46 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v7-0001-diff-amit.patch) at 2022-07-23 11:32:02 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (poc_mark_top_txn_has_inval.patch) at 2022-07-22 06:17:50 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (REL13-v6-0001-Fix-catalog-lookup-with-the-wrong-snapshot-during.patch) at 2022-07-17 12:58:36 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-catalog-modifying-transactions-to-logical-dec.patch) at 2022-07-15 14:39:00 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-catalog-modifying-transactions-to-logical-dec.patch) at 2022-07-14 01:30:31 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (backtrace.txt) at 2022-07-12 08:58:50 from "shiy.fnst at fujitsu.com" <shiy.fnst at fujitsu.com> (Patch: No)
    Attachment (bench.spec) at 2022-07-12 06:07:25 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (master-v3-0001-Add-catalog-modifying-transactions-to-logical-dec.patch) at 2022-07-12 00:48:52 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (REL14-v1-0001-Fix-catalog-lookup-with-the-wrong-snapshot-during.patch) at 2022-07-11 13:54:19 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-catalog-modifying-transactions-to-logical-dec.patch) at 2022-07-08 01:14:25 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0001-Add-catalog-modifying-transactions-to-logical-decodi.patch) at 2022-07-06 06:48:40 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (poc_add_regression_tests_v2.patch) at 2022-06-15 01:34:02 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (poc_add_running_catchanges_xacts_to_serialized_snapshot.patch) at 2022-05-30 05:42:56 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (poc_mark_all_txns_catalog_change.patch) at 2022-02-21 10:29:51 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (poc_mark_all_txns_catalog_change.patch) at 2021-10-11 06:27:41 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (poc_remember_last_running_xacts.patch) at 2021-10-07 04:20:14 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (logical_decoding_xact_bookkeep.patch) at 2021-03-15 16:34:56 from "Oh, Mike" <minsoo at amazon.com> (Patch: Yes)

History

When	Who	What
2022-08-12 13:35:49	Bertrand Drouvot (bdrouvot)	Closed in commitfest 2022-09 with status: Committed
2022-08-12 13:35:49	Bertrand Drouvot (bdrouvot)	Changed committer to amitkapila
2022-08-01 16:52:27	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-18 22:49:14	Jacob Champion (jchampion)	Changed reviewers to Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi)
2022-07-15 18:59:58	Jacob Champion (jchampion)	Changed reviewers to Masahiko Sawada (masahikosawada)
2022-06-16 03:57:49	Masahiko Sawada (masahikosawada)	Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:20:04	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2021-12-02 13:37:10	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2021-11 with status: Moved to next CF
2021-10-04 16:24:27	Jaime Casanova (jcasanov)	Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-03 02:18:25	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-07-29 09:22:01	Masahiko Sawada (masahikosawada)	Added masahikosawada as reviewer
2021-05-07 11:50:24	ahsan hadi (ahsan.hadi)	Posted review with messageid <162038822425.16755.16394090984207683374.pgcf@coridan.postgresql.org>
2021-05-07 11:45:11	ahsan hadi (ahsan.hadi)	Added ahsan.hadi as reviewer
2021-04-08 15:51:58	David Steele (dsteele)	Changed targetversion to None
2021-03-15 16:47:45	Minsoo (Mike) Oh (minsoo1)	Changed topic to Bug Fixes
2021-03-15 16:47:12	Minsoo (Mike) Oh (minsoo1)	Changed authors to Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1)
2021-03-15 16:44:55	Minsoo (Mike) Oh (minsoo1)	Changed targetversion to 14
2021-03-15 16:41:26	Minsoo (Mike) Oh (minsoo1)	Attached mail thread 81D0D8B0-E7C4-4999-B616-1E5004DBDCD2@amazon.com
2021-03-15 16:41:26	Minsoo (Mike) Oh (minsoo1)	Created patch record

Edit