Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher
От
Andres Freund
Тема
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher
Дата
Msg-id
20170601220518.553lfsh4l2wfjxnj@alap3.anarazel.de
Ответ на
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher (Peter Eisentraut)
Список
Дерево обсуждения
[HACKERS] logical replication and PANIC during shutdown checkpoint in publisher Fujii Masao <masao.fujii@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Fujii Masao <masao.fujii@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Andres Freund <andres@anarazel.de>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Pavan Deolasee <pavan.deolasee@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Petr Jelinek <petr.jelinek@2ndquadrant.com>
[HACKERS] Re: logical replication and PANIC during shutdown checkpoint inpublisher Noah Misch <noah@leadboat.com>
Re: [HACKERS] Re: logical replication and PANIC during shutdowncheckpoint in publisher Petr Jelinek <petr.jelinek@2ndquadrant.com>
[HACKERS] Re: logical replication and PANIC during shutdown checkpoint inpublisher Noah Misch <noah@leadboat.com>
Re: [HACKERS] Re: logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Re: logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Re: logical replication and PANIC during shutdowncheckpoint in publisher Noah Misch <noah@leadboat.com>
Re: [HACKERS] Re: logical replication and PANIC during shutdowncheckpoint in publisher Noah Misch <noah@leadboat.com>
Re: [HACKERS] Re: logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Re: logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Re: logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Fujii Masao <masao.fujii@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Fujii Masao <masao.fujii@gmail.com>
Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher Michael Paquier <michael.paquier@gmail.com>
On 2017-05-05 10:50:11 -0400, Peter Eisentraut wrote: > On 5/5/17 01:26, Michael Paquier wrote: > > The only code path doing HOT-pruning and generating WAL is > > heap_page_prune(). Do you think that we need to worry about FPWs as > > well? > > > > Attached is an updated patch, which also forbids the run of any > > replication commands when the stopping state is reached. > > I have committed this without the HOT pruning change. That can be > considered separately, and I think it could use another round of > thinking about it. I'm a unhappy how this is reusing SIGINT for WalSndLastCycleHandler. Normally INT is used cancel interrupts, and since walsender is now also working as a normal backend, this overlap is bad. Even for plain walsender backend this seems bad, because now non-superusers replication users will terminate replication connections when they do pg_cancel_backend(). For replication=dbname users it's especially bad because there can be completely legitimate uses of pg_cancel_backend(). - Andres
В списке pgsql-hackers по дате отправления
От: Thomas Munro
Дата:
От: Chapman Flack
Дата: