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

Ahsan Hadi <ahsan.hadi@gmail.com>

From: ahsan hadi <ahsan.hadi@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Bertrand Drouvot <bdrouvot@amazon.com>, "Minsoo (Mike) Oh" <minsoo@amazon.com>
Date: 2021-05-07T11:50:24Z
Lists: pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  tested, passed
Implements feature:       tested, passed
Spec compliant:           tested, passed
Documentation:            not tested

I have also seen this error with logical replication using pglogical extension, will this patch also address similar problem with pglogical?

Commits

  1. Fix the incorrect assertion introduced in commit 7f13ac8123.

  2. Fix catalog lookup with the wrong snapshot during logical decoding.

  3. Clean up assorted failures under clang's -fsanitize=undefined checks.