Re: Assertion failure with summarize_wal enabled during pg_createsubscriber

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Assertion failure with summarize_wal enabled during pg_createsubscriber
Дата
Msg-id CA+TgmoY9QC_CUA0F8febGj_5AgnCk8rG7AkX4rhJPvvHeshYtQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Assertion failure with summarize_wal enabled during pg_createsubscriber  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Wed, Jul 3, 2024 at 1:07 PM Robert Haas <robertmhaas@gmail.com> wrote:
> I think the problem here is that the WAL summarizer believes that when
> a new timeline appears, it should pick up from where the old timeline
> ended. And here, that doesn't happen: the new timeline branches off
> before the end of the old timeline, because of the recovery target.
>
> I'm not yet sure what should be done about this. The obvious answer is
> "remove the assertion," and maybe that is all we need to do. However,
> I'm not quite sure what the actual behavior will be if we just do
> that, so I think more investigation is needed. I'll keep looking at
> this, although given the US holiday I may not have results until next
> week.

Here is a draft patch that attempts to fix this problem. I'm not
certain that it's completely correct, but it does seem to fix the
reported issue.

--
Robert Haas
EDB: http://www.enterprisedb.com

Вложения

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

Предыдущее
От: "Euler Taveira"
Дата:
Сообщение: Re: improve performance of pg_dump with many sequences
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Parent/child context relation in pg_get_backend_memory_contexts()