]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix possibility of self-deadlock in ResolveRecoveryConflictWithBufferPin().
authorAndres Freund <andres@anarazel.de>
Tue, 3 May 2022 01:25:00 +0000 (18:25 -0700)
committerAndres Freund <andres@anarazel.de>
Tue, 3 May 2022 01:29:52 +0000 (18:29 -0700)
commitedfc03ec91f2ec2574e6aa7d22d3a198c3490ee5
treee73f398a5dade816839cd5d9925c5a50e3230262
parent5c8b14a71d318a15c4db4fd3eb209d5c24934a43
Fix possibility of self-deadlock in ResolveRecoveryConflictWithBufferPin().

The tests added in 9f8a050f68d failed nearly reliably on FreeBSD in CI, and
occasionally on the buildfarm. That turns out to be caused not by a bug in the
test, but by a longstanding bug in recovery conflict handling.

The standby timeout handler, used by ResolveRecoveryConflictWithBufferPin(),
executed SendRecoveryConflictWithBufferPin() inside a signal handler. A bad
idea, because the deadlock timeout handler (or a spurious latch set) could
have interrupted ProcWaitForSignal(). If unlucky that could cause a
self-deadlock on ProcArrayLock, if the deadlock check is in
SendRecoveryConflictWithBufferPin()->CancelDBBackends().

To fix, set a flag in StandbyTimeoutHandler(), and check the flag in
ResolveRecoveryConflictWithBufferPin().

Subsequently the recovery conflict tests will be backpatched.

Discussion: https://postgr.es/m/20220413002626.udl7lll7f3o7nre7@alap3.anarazel.de
Backpatch: 10-
src/backend/storage/ipc/standby.c