Re: BUG #18942: walsender memory allocation failure adding snapshot and invalidations to logical replica w/PG 16.9

Laurence Parry <greenreaper@hotmail.com>

From: Laurence Parry <greenreaper@hotmail.com>

To: Masahiko Sawada <sawada.mshk@gmail.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>

Date: 2025-06-17T20:10:07Z

Lists: pgsql-bugs

> I pushed the fix for this issue yesterday[1].
>
> Regards,
>
> [1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=d87d07b7ad3b782cb74566cd771ecdb2823adf6a

Thank you. I have installed snapshot version 16.9-1.pgdg120+~20250617.0700.gb2ae077 over 16.8 which I had rolled back to, and the issue *appears* to be resolved (at least, it has not fallen over immediately upon restarting replication, which it used to, nor in 30 minutes).

Regards,
--
Laurence Parry
https://inkbunny.net

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix re-distributing previously distributed invalidation messages during logical decoding.
- d87d07b7ad3b 18.0 landed
- 45c357e0e85d 17.6 landed
- b2ae077205e1 16.10 landed
- fc0fb77c550f 15.14 landed
- 983b3636259b 14.19 landed
- 1230be12f086 13.22 landed
Fix AlignedAllocRealloc to cope sanely with OOM.
- 6aa33afe6da1 18.0 cited
Fix data loss in logical replication.
- 4909b38af034 18.0 cited
- 9a2f8b4f01d5 16.9 cited