Re: ProcessStandbyHSFeedbackMessage can make global xmin go backwards - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ProcessStandbyHSFeedbackMessage can make global xmin go backwards
Date
Msg-id 11236.1319212779@sss.pgh.pa.us
Whole thread Raw
In response to Re: ProcessStandbyHSFeedbackMessage can make global xmin go backwards  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
Merlin Moncure <mmoncure@gmail.com> writes:
> On Wed, Oct 19, 2011 at 6:04 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> ProcessStandbyHSFeedbackMessage has a race condition: it thinks it can
>> call GetOldestXmin and then the result will politely hold still while
>> it considers what to do next.

> curious: are these bugs in production, and what would be the user
> visible symptoms of seeing them in the wild?

There's no bug so far as data integrity on the master goes.  The risk
is that you'd see queries failing with replication conflicts on a
hot-standby slave even though you thought you'd protected them by
setting hot_standby_feedback = on.  That would happen if any rows
actually got vacuumed despite the standby's attempt to set an xmin
that would protect them.  This is possible anyway at walsender
startup, but I think the logic errors made it more probable.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: pg_comments (was: Allow \dd to show constraint comments)
Next
From: Florian Pflug
Date:
Subject: Re: Synchronized snapshots versus multiple databases