Re: BUG #19521: After a minor PostgreSQL update from 14.22 to 14.23, the database goes into an infinite loop. - Mailing list pgsql-bugs

From Andrey Borodin
Subject Re: BUG #19521: After a minor PostgreSQL update from 14.22 to 14.23, the database goes into an infinite loop.
Date
Msg-id 416ADEE5-0410-488A-BCFF-C3D8E1D3E6A0@yandex-team.ru
Whole thread
In response to Re: BUG #19521: After a minor PostgreSQL update from 14.22 to 14.23, the database goes into an infinite loop.  (Álvaro Herrera <alvherre@kurilemu.de>)
List pgsql-bugs

> On 16 Jun 2026, at 23:36, Álvaro Herrera <alvherre@kurilemu.de> wrote:
>
> On 2026-Jun-15, Andrey Borodin wrote:
>
>>> On 15 Jun 2026, at 18:39, PG Bug reporting form <noreply@postgresql.org> wrote:
>>>
>>> After rolling back to version 14.22, everything works as intended.
>>
>> Hi! Thanks for the report. Can you please give a bit more logs? This excerpt is
>> missing errors from the startup process. And message from this process could shed
>> a light on a root cause.
>
> I suspect e35e466f61b [1] might be related.  That's a bug that was
> fixed in 2bb60eb4fea [2], just after 14.23.
>
> [1] https://postgr.es/c/e35e466f61b
> [2] https://postgr.es/c/2bb60eb4fea
>
> If not, some data from pg_waldump around the problem area might be useful.

Yeah, that was my concern. But that bug manifests as startup process failure.
I've contacted Sergey offlist, he observed hanging

postgres: data: startup recovering 000000060000C29100000016

so it's hard to tell what's going on without backtrace...


Best regards, Andrey Borodin.


pgsql-bugs by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: BUG #19521: After a minor PostgreSQL update from 14.22 to 14.23, the database goes into an infinite loop.
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: [BUG] Assert failure in ReorderBufferReturnTXN during logical decoding due to leaked specinsert change