Re: Assertion failure with summarize_wal enabled during pg_createsubscriber - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Assertion failure with summarize_wal enabled during pg_createsubscriber
Date
Msg-id CA+TgmoY9QC_CUA0F8febGj_5AgnCk8rG7AkX4rhJPvvHeshYtQ@mail.gmail.com
Whole thread Raw
In response to Re: Assertion failure with summarize_wal enabled during pg_createsubscriber  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Assertion failure with summarize_wal enabled during pg_createsubscriber
List 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

Attachment

pgsql-hackers by date:

Previous
From: "Euler Taveira"
Date:
Subject: Re: improve performance of pg_dump with many sequences
Next
From: Robert Haas
Date:
Subject: Re: Parent/child context relation in pg_get_backend_memory_contexts()