Re: logical replication and PANIC during shutdown checkpoint in publisher
Michael Paquier <michael.paquier@gmail.com>
From: Michael Paquier <michael.paquier@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Petr Jelinek <petr.jelinek@2ndquadrant.com>,
Fujii Masao <masao.fujii@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2017-06-06T01:07:24Z
Lists: pgsql-hackers
On Tue, Jun 6, 2017 at 9:47 AM, Andres Freund <andres@anarazel.de> wrote: > On 2017-06-05 15:30:38 +0900, Michael Paquier wrote: >> I think that it would be interesting to be able to >> trigger a feedback message using SIGHUP in WAL receivers, refactoring >> at the same time SIGHUP handling for WAL receivers. It is possible for >> example to abuse SIGHUP in autovacuum for cost parameters. > > Could you clarify a bit here, I can't follow? Do you think it's > actually a good idea to combine that with the largely mechanical patch? Sort of. The thought here is to be able to trigger XLogWalRcvSendReply() using a SIGHUP, even if force_reply is not enforced. But looking again at the code, XLogWalRcvSendReply() is processed only if data is received so sending multiple times the same message to server would be pointless. Still, don't you think that it would be helpful to wake up the WAL receiver at will on SIGHUP by setting its latch? XLogWalRcvSendHSFeedback() could be triggered at will using that. ProcessWalRcvInterrupts() could include the checks for SIGHUP by the way... -- Michael
Commits
-
Prevent possibility of panics during shutdown checkpoint.
- 862204aaceb1 9.6.4 landed
- 50581f2e74fa 9.5.8 landed
- 1cdc0ab9c180 9.4.13 landed
- c6c333436491 10.0 landed
-
Revert "Prevent panic during shutdown checkpoint"
- 703f148e98ec 10.0 landed
-
Prevent panic during shutdown checkpoint
- 086221cf6b17 10.0 cited