Re: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog

From: wangchuanting <wangchuanting(at)huawei(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog
Date: 2017-06-02 01:59:32
Message-ID: 1496368772770-5964407.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi Michael,

appreciate for your quick response.

i look carefully on the patch, because of we removed TwoPhaseStateLock
lwlock acquire in `RemoveGXact' and let caller held lwlock, so i think:
1. xact_redo also need held lwlock before call PrepareRedoRemove
2. RecoverPreparedTransactions also need held lwlock before call
ProcessTwoPhaseBuffer

--
View this message in context: http://www.postgresql-archive.org/BUG-14680-startup-process-on-standby-encounter-a-deadlock-of-TwoPhaseStateLock-when-redo-2PC-xlog-tp5964069p5964407.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Langote 2017-06-02 02:18:30 Re: BUG #14682: row level security not work with partitioned table
Previous Message wangchuanting 2017-06-02 01:33:30 Re: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-06-02 02:05:09 Re: Patch: Add --no-comments to skip COMMENTs with pg_dump
Previous Message Andres Freund 2017-06-02 01:55:10 Re: Error while creating subscription when server is running in single user mode