]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix temporary object cleanup failing due to toast access without snapshot.
authorAndres Freund <andres@anarazel.de>
Sat, 19 Feb 2022 20:27:20 +0000 (12:27 -0800)
committerAndres Freund <andres@anarazel.de>
Mon, 21 Feb 2022 17:57:05 +0000 (09:57 -0800)
commit7bbfe5994165aef9e903b1919d625fe87d4f146e
tree22207f9ee5a5b55fc79f74d62e2a45fb55d14fca
parent8b5cd373ba033977ef0100f52871dd6b38b7239e
Fix temporary object cleanup failing due to toast access without snapshot.

When cleaning up temporary objects during process exit the cleanup could fail
with:
  FATAL: cannot fetch toast data without an active snapshot

The bug is caused by RemoveTempRelationsCallback() not setting up a
snapshot. If an object with toasted catalog data needs to be cleaned up,
init_toast_snapshot() could fail with the above error.

Most of the time however the the problem is masked due to cached catalog
snapshots being returned by GetOldestSnapshot(). But dropping an object can
cause catalog invalidations to be emitted. If no further catalog accesses are
necessary between the invalidation processing and the next toast datum
deletion, the bug becomes visible.

It's easy to miss this bug because it typically happens after clients
disconnect and the FATAL error just ends up in the log.

Luckily temporary table cleanup at the next use of the same temporary schema
or during DISCARD ALL does not have the same problem.

Fix the bug by pushing a snapshot in RemoveTempRelationsCallback(). Also add
isolation tests for temporary object cleanup, including objects with toasted
catalog data.

A future HEAD only commit will add more assertions.

Reported-By: Miles Delahunty
Author: Andres Freund
Discussion: https://postgr.es/m/CAOFAq3BU5Mf2TTvu8D9n_ZOoFAeQswuzk7yziAb7xuw_qyw5gw@mail.gmail.com
Backpatch: 10-
src/backend/catalog/namespace.c
src/test/isolation/expected/temp-schema-cleanup.out [new file with mode: 0644]
src/test/isolation/isolation_schedule
src/test/isolation/specs/temp-schema-cleanup.spec [new file with mode: 0644]