Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog
От
Michael Paquier
Тема
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog
Дата
Msg-id
CAB7nPqQthLP9GvD2242epHKOBkDMd+03tSuFvK3cVZsGarQyWA@mail.gmail.com
Ответ на
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog (wangchuanting)
Список
Дерево обсуждения
Re: [BUGS] BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog Tom Lane <tgl@sss.pgh.pa.us>
Re: [BUGS] BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog wangchuanting <wangchuanting@huawei.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Alvaro Herrera <alvherre@2ndquadrant.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog wangchuanting <wangchuanting@huawei.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog wangchuanting <wangchuanting@huawei.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog wangchuanting <wangchuanting@huawei.com>
Re: [BUGS] BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog wangchuanting <wangchuanting@huawei.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog wangchuanting <wangchuanting@huawei.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog Noah Misch <noah@leadboat.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog Noah Misch <noah@leadboat.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog Noah Misch <noah@leadboat.com>
Re: [BUGS] Re: BUG #14680: startup process on standby encounter adeadlock of TwoPhaseStateLock when redo 2PC xlog Alvaro Herrera <alvherre@2ndquadrant.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
[BUGS] Re: BUG #14680: startup process on standby encounter a deadlock ofTwoPhaseStateLock when redo 2PC xlog Michael Paquier <michael.paquier@gmail.com>
On Mon, Jun 5, 2017 at 8:32 PM, wangchuanting wrote: > I don't understand why the patch remove TwoPhaseStateLock in MarkAsPrepared. This one is on purpose, no low-level routines in this patch acquire TwoPhaseStateLock. Logically I agree that it does not change much but... You wrote something below about that. > if so: > 1. does it need remove lock acquire in MarkAsPreparing also? No, MarkAsPreparing() is used only in the non-redo code path. > 2. MarkAsPrepared will call ProcArrayAdd, and in ProcArrayAdd it acquires > ProcArrayLock, we should carefully handle the lock sequence about these two > locks. And this gives a reason to not complicate our lives. -- Michael -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
В списке pgsql-bugs по дате отправления
От: Andres Freund
Дата:
От: Mike Palmiotto
Дата: