Re: Logical replication 'invalid memory alloc request size 1585837200' after upgrading to 17.5

Christoph Berg <myon@debian.org>

From: Christoph Berg <myon@debian.org>
To: pgsql-bugs@lists.postgresql.org
Date: 2025-05-26T11:47:54Z
Lists: pgsql-bugs
Re: Duncan Sands
> PostgreSQL v17.5 (Ubuntu 17.5-1.pgdg24.04+1); Ubuntu 24.04.2 LTS (kernel
> 6.8.0); x86-64

Fwiw, one more field report from Debian:

> We had a severe issue after upgrading postgresql-16 from 16.8-1.pgdg110+1 to 16.9-1.pgdg110+1. The following error happened quickly on a logical replication (sorry for the French).
>
> ERREUR:  n'a pas pu recevoir des données du flux de WAL : ERROR:  invalid memory alloc request size 1196912896
>
> After trying several things, we finally managed to restart the replication after downgrading the pg-related packages on this host alone (the other servers were not impacted).

https://salsa.debian.org/postgresql/postgresql/-/issues/4

(no extra details in there, though)

Christoph



Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Fix cache-dependent test failures in logical decoding.

  2. Fix re-distributing previously distributed invalidation messages during logical decoding.

  3. Fix data loss in logical replication.