Re: Assertion failure in walreceiver

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Assertion failure in walreceiver
Дата
Msg-id 3f0b79eb1002241833g31a1f28fy82dce25f9ad1cc7c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Assertion failure in walreceiver  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Assertion failure in walreceiver  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Thu, Feb 25, 2010 at 5:29 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> Hmm, interesting corner case. That assertion is checking that the
> streaming starting point is initialized correctly, but 0/0 is actually a
> valid value when you start streaming from the very first WAL segment.
>
> I guess we can just remove the assertion. If an incorrect zero value
> finds its way there due to some bug, nothing particularly bad will
> happen; you'll just get an error because the WAL segment most likely
> doesn't exist in the primary anymore.

And we need to remove the following code from XLogSend(). This code is
useless now since the initial CopyData message is guaranteed to arrive
at the primary before doing XLogSend().

> /*
>  * Invalid position means that we have not yet received the initial
>  * CopyData message from the slave that indicates where to start the
>  * streaming.
>  */
> if (sentPtr.xlogid == 0 &&
>     sentPtr.xrecoff == 0)
>     return true;


I have one question. Do we support starting an archive recovery and
standby server from a cold backup (not a base backup taken by online
backup)? Though I think they would work and be very useful, I'm not
sure they are safe.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_stop_backup does not complete
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: pg_stop_backup does not complete