Re: BUG #7710: Xid epoch is not updated properly during checkpoint - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #7710: Xid epoch is not updated properly during checkpoint
Date
Msg-id 13206.1354466672@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #7710: Xid epoch is not updated properly during checkpoint  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: BUG #7710: Xid epoch is not updated properly during checkpoint
List pgsql-bugs
Simon Riggs <simon@2ndQuadrant.com> writes:
> On 2 December 2012 15:25, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> This coding was ill-considered from the word go.

> Agreed, but then I don't have a clear reason why it is that way and
> yet I'm sure I did it for some reason.

I think you just did it because it looked easy, and you didn't think
very hard about the consequences.

As far as the concern about new bugs is concerned: if we start replay
from this checkpoint, we will certainly not consider that the DB is
consistent until we reach the checkpoint's physical position.  And by
that point we'll have replayed the XLOG_RUNNING_XACTS record emitted by
LogStandbySnapshot, so our idea of the nextXid should be fully up to
date anyway.  The same goes for checkpoints encountered later in the
replay run --- they'd just be duplicative of the preceding
XLOG_RUNNING_XACTS record.  There is no reason to put the same XID into
the checkpoint record.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: BUG #7710: Xid epoch is not updated properly during checkpoint
Next
From: Simon Riggs
Date:
Subject: Re: BUG #7710: Xid epoch is not updated properly during checkpoint