Re: Confusing recovery message when target not hit

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Thom Brown <thom(at)linux(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Confusing recovery message when target not hit
Date: 2016-06-13 05:50:46
Message-ID: CAB7nPqS5t9JgUvQMtKvGXHWV-u6eDGNRsQE50EyV=fVX9+1Big@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 13, 2016 at 9:53 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 12 June 2016 at 12:51, Michael Paquier <michael(dot)paquier(at)gmail(dot)com> wrote:
>>
>> On Sun, Jun 12, 2016 at 7:52 PM, Thom Brown <thom(at)linux(dot)com> wrote:
>> > Aren't those already set by recoveryStopsBefore()?
>>
>> It is possible to exit the main redo loop if a NULL record is found
>> after calling ReadRecord, in which case those would not be set, no?
>
>
> I'm apprehensive about initialising those values myself as I don't want to
> set them at a point where they may potentially already be set.

As your patch relies on checks on the variables holding the recovery
stop information as not being set, initializing them before entering
in the REDO phase (say just before 6435:xlog.c on HEAD) is the safest
thing to do IMO.
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2016-06-13 06:52:08 Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Previous Message Tatsuro Yamada 2016-06-13 05:42:17 Re: ERROR: ORDER/GROUP BY expression not found in targetlist