pgsql: Rethink PROCSIGNAL_BARRIER_SMGRRELEASE. - Mailing list pgsql-committers

From Thomas Munro
Subject pgsql: Rethink PROCSIGNAL_BARRIER_SMGRRELEASE.
Date
Msg-id E1nnCQd-000NTM-I7@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Rethink PROCSIGNAL_BARRIER_SMGRRELEASE.

With sufficiently bad luck, it was possible for IssuePendingWritebacks()
to reopen a file after we'd processed PROCSIGNAL_BARRIER_SMGRRELEASE and
before the file was unlinked by some other backend.  That left a small
hole in commit 4eb21763's plan to fix all spurious errors from DROP
TABLESPACE and similar on Windows.

Fix by closing md.c's segments, instead of just closing fd.c's
descriptors, and then teaching smgrwriteback() not to open files that
aren't already open.

Reported-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Discussion: https://postgr.es/m/20220209220004.kb3dgtn2x2k2gtdm%40alap3.anarazel.de

Branch
------
master

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

Modified Files
--------------
src/backend/storage/smgr/md.c   | 22 +++++++++++---------
src/backend/storage/smgr/smgr.c | 45 +++++++++++++++++++++++++++++++++--------
src/include/storage/md.h        |  1 -
src/include/storage/smgr.h      |  2 ++
4 files changed, 52 insertions(+), 18 deletions(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pgsql: Remove command checks in tests of pg_basebackup and pg_receivewa
Next
From: Noah Misch
Date:
Subject: pgsql: Under has_wal_read_bug, skip contrib/bloom/t/001_wal.pl.