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

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [BUGS] BUG #14803: use receiverPtr as the endptr to callKeepLogSeg(endptr, &_logSegNo) in CreateRestartPoint
Дата
Msg-id CAB7nPqS-RsyiwvPywrOyuMpM-DhqUoo0ynuNGTLOY3M0uMnbsQ@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14803: use receiverPtr as the endptr to call KeepLogSeg(endptr,&_logSegNo) in CreateRestartPoint  (bret.shao@outlook.com)
Список 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 по дате отправления:

Предыдущее
От: rani.renu@gmail.com
Дата:
Сообщение: [BUGS] BUG #14805: Issue with Duplicate entry
Следующее
От: email@piotr-stefaniak.me
Дата:
Сообщение: [BUGS] BUG #14806: WAL replay on standby: could not link file"pg_xlog/...4C" to "pg_xlog/...D1": File exists