pgsql: Ensure snapshot is registered within ScanPgRelation(). - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Ensure snapshot is registered within ScanPgRelation().
Date
Msg-id E1jIH9b-0002jL-QB@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Ensure snapshot is registered within ScanPgRelation().

In 9.4 I added support to use a historical snapshot in
ScanPgRelation(), while adding logical decoding. Unfortunately a
conflict with the concurrent removal of SnapshotNow was incorrectly
resolved, leading to an unregistered snapshot being used.

It is not correct to use an unregistered (or non-active) snapshot for
anything non-trivial, because catalog invalidations can cause the
snapshot to be invalidated.

Luckily it seems unlikely to actively cause problems in practice, as
ScanPgRelation() requires that we already have a lock on the relation,
we only look for a single row, and we don't appear to rely on the
result's tid to be correct. It however is clearly wrong and potential
negative consequences would likely be hard to find. So it seems worth
backpatching the fix, even without a concrete hazard.

Discussion: https://postgr.es/m/20200229052459.wzhqnbhrriezg4v2@alap3.anarazel.de
Backpatch: 9.5-

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/a0e2a178c6409db195e8e902e4ac279ad60777cb

Modified Files
--------------
src/backend/utils/cache/relcache.c | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: Ensure snapshot is registered within ScanPgRelation().
Next
From: Andres Freund
Date:
Subject: pgsql: Ensure snapshot is registered within ScanPgRelation().