Re: Incorrect snapshots while promoting hot standby node when 2PC is used

From: Andres Freund <andres(at)anarazel(dot)de>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: pgsql-hackers(at)postgresql(dot)org, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Subject: Re: Incorrect snapshots while promoting hot standby node when 2PC is used
Date: 2021-10-06 06:09:41
Message-ID: 20211006060941.awmkcygozn2tetl2@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2021-10-04 17:27:44 +0900, Michael Paquier wrote:
> On Fri, Oct 01, 2021 at 02:11:15PM +0900, Michael Paquier wrote:
> > A couple of months later, I have looked back at this thread and this
> > report. I have rechecked all the standby handling and snapshot builds
> > involving KnownAssignedXids and looked at all the phases that are
> > getting called until we call ShutdownRecoveryTransactionEnvironment()
> > to release these, and I don't think that there is a problem with the
> > solution proposed here. So I propose to move on and apply this
> > patch. Please let me know if there are any objections.
>
> Okay, I have worked more on that today, did more tests and applied the
> fix as of 8a42379.

Thanks for remembering this!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2021-10-06 06:10:12 Re: A test for replay of regression tests
Previous Message Alexander Lakhin 2021-10-06 06:00:00 Re: BUG #17212: pg_amcheck fails on checking temporary relations