Re: [BUGS] BUG #14803: use receiverPtr as the endptr to callKeepLogSeg(endptr, &_logSegNo) in CreateRestartPoint - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: [BUGS] BUG #14803: use receiverPtr as the endptr to callKeepLogSeg(endptr, &_logSegNo) in CreateRestartPoint
Date
Msg-id CAB7nPqS-RsyiwvPywrOyuMpM-DhqUoo0ynuNGTLOY3M0uMnbsQ@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14803: use receiverPtr as the endptr to call KeepLogSeg(endptr,&_logSegNo) in CreateRestartPoint  (bret.shao@outlook.com)
List pgsql-bugs
On Thu, Sep 7, 2017 at 2:10 PM,  <bret.shao@outlook.com> wrote:
> when call KeepLogSeg to get the oldest xlog file in function
> CreateRestartPoint,
> I think the endptr shoule be the repalyPtr not the later one of receiverPtr
> and replayPtr.
>  endptr = (receivePtr < replayPtr) ? replayPtr : receivePtr;
>
> Because that if the endptr is the receiverPtr, it means that may be the xlog
> file that is being redo will be dropped.

There are timeline-related things to consider, in short when doing a
timeline jump you may finish with a segment that you did not expect to
be recycled. See the link to the discussion and the commit in
question:
https://www.postgresql.org/message-id/50D30851.2030509%40vmware.com
http://git.postgresql.org/pg/commitdiff/af275a12dfeecd621ed9899a9382f26a68310263
-- 
Michael


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: rani.renu@gmail.com
Date:
Subject: [BUGS] BUG #14805: Issue with Duplicate entry
Next
From: email@piotr-stefaniak.me
Date:
Subject: [BUGS] BUG #14806: WAL replay on standby: could not link file"pg_xlog/...4C" to "pg_xlog/...D1": File exists