Re: walreceiver termination

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: walreceiver termination
Дата
Msg-id 10995.1587672413@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: walreceiver termination  (Justin King <kingpin867@gmail.com>)
Ответы Re: walreceiver termination
Список pgsql-general
Justin King <kingpin867@gmail.com> writes:
> I assume it would be related to the following:
> LOG:  incorrect resource manager data checksum in record at 2D6/C259AB90
> since the walreceiver terminates just after this - but I'm unclear
> what precisely this means.

What it indicates is corrupt data in the WAL stream.  When reading WAL
after crash recovery, we assume that that indicates end of WAL.  When
pulling live data from a source server, it suggests some actual problem
... but killing the walreceiver and trying to re-fetch the data might
be a reasonable response to that.  I'm not sure offhand what the startup
code thinks it's doing in this context.  It might either be attempting
to retry, or concluding that it's come to the end of WAL and it ought
to promote to being a live server.  If you don't see the walreceiver
auto-restarting then I'd suspect that the latter is happening.

            regards, tom lane



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

Предыдущее
От: Justin King
Дата:
Сообщение: Re: walreceiver termination
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Fw: Re: Could Not Connect To Server