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

Edit
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 (1 month, 3 weeks ago)
Latest email 2022-08-29 06:17:28 (1 month 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
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