Re: Bug in ProcArrayApplyRecoveryInfo for snapshots crossing 4B, breaking replicas - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Bug in ProcArrayApplyRecoveryInfo for snapshots crossing 4B, breaking replicas
Date
Msg-id Ye9tn5imsHLLuLmK@paquier.xyz
Whole thread Raw
In response to Re: Bug in ProcArrayApplyRecoveryInfo for snapshots crossing 4B, breaking replicas  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: Bug in ProcArrayApplyRecoveryInfo for snapshots crossing 4B, breaking replicas
List pgsql-hackers
On Mon, Jan 24, 2022 at 10:45:48PM +0100, Tomas Vondra wrote:
> On 1/24/22 22:28, Bossart, Nathan wrote:
>>> Attached patch is fixing this by just sorting the XIDs logically. The
>>> xidComparator is meant for places that can't do logical ordering. But
>>> these XIDs come from RUNNING_XACTS, so they actually come from the same
>>> wraparound epoch (so sorting logically seems perfectly fine).
>>
>> The patch looks reasonable to me.
>
> Thanks!

Could it be possible to add a TAP test?  One idea would be to rely on
pg_resetwal -x and -e close to the 4B limit to set up a node before
stressing the scenario of this bug, so that would be rather cheap.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: row filtering for logical replication
Next
From: "Shinoda, Noriyoshi (PN Japan FSIP)"
Date:
Subject: RE: refactoring basebackup.c