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

Title

Topic

Bug Fixes

Created

2021-03-15 16:41:26

Last modified

2022-08-12 13:35:49 (3 months, 2 weeks ago)

Latest email

2022-08-29 06:17:28 (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

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