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

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Tags

Bugfix

Created

2021-03-15 16:41:26

Last modified

2022-08-12 13:35:49 (4 years ago)

Latest email

2022-08-29 06:17:28 (4 years ago)

Status

2022-09 (2022-09-01 – 2022-09-30): Committed

2022-07 (2022-07-01 – 2022-07-31): Moved to different CF

2022-03 (2022-03-01 – 2022-03-31): Moved to different CF

2022-01 (2022-01-01 – 2022-01-31): Moved to different CF

2021-11 (2021-11-01 – 2021-11-30): Moved to different CF

2021-09 (2021-09-01 – 2021-09-30): Moved to different CF

2021-07 (2021-07-01 – 2021-07-31): Moved to different CF

Target version

Authors

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

Reviewers

Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi) Log in to 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