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

Edit
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, 3 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