MIME-Version: 1.0
From: Soni M <diptatapa@gmail.com>
Date: Sun, 6 Jul 2025 16:40:55 +0700
Message-ID: <CAAMgDXkrDTZwo3v=vcGd0=axjEg9BV09LL=f2+n=DShFBmAV9Q@mail.gmail.com>
Subject: Logical Replication 08P01 invalid memory alloc request size 1095736448
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b6e8ab06393f86a5"
Archived-At: <https://www.postgresql.org/message-id/CAAMgDXkrDTZwo3v%3DvcGd0%3DaxjEg9BV09LL%3Df2%2Bn%3DDShFBmAV9Q%40mail.gmail.com>
Precedence: bulk

--000000000000b6e8ab06393f86a5
Content-Type: text/plain; charset="UTF-8"

Hello All,
we have this set up :
Postgres 15.13 on RHEL 9.6

Logical Master also have 2 streaming replica
Logical Replica also have 1 streaming replica

We just do patch updates from 15.12 to 15.13, restart Logical Master and
then Logical Replica, and suddenly Logical replication stops working.
Streaming replication of both are fine.

The message on Logical Replica :
ERROR,08P01,"could not receive data from WAL stream: ERROR:  invalid memory
alloc request size 1095736448",,,,,,,,,"","logical replication worker",,0

The message on Logical Master :
"START_REPLICATION", LOG,00000,"starting logical decoding for slot
""_subscription""","Streaming transactions committing after 33D45/373C2D98,
reading WAL from 33D44/EF3219B0.",,,,,"START_REPLICATION SLOT
""_subscription"" LOGICAL 33D45/373C2D98 (proto_version '3',
publication_names '""_publication""')",,,"_subscription","walsender",,0

"START_REPLICATION", ,LOG,00000,"logical decoding found consistent point at
33D44/EF3219B0","Logical decoding will begin using saved
snapshot.",,,,,"START_REPLICATION SLOT ""_subscription"" LOGICAL
33D45/373C2D98 (proto_version '3', publication_names
'""_publication""')",,,"_subscription","walsender",,0

Checking at error code 08P01 is protocol_violation.

Is there any idea on what causing this and how to resolve ?

-- 
Regards,

Soni Maula Harriz

--000000000000b6e8ab06393f86a5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>Hello All,</div><div>we have this se=
t up :<br>Postgres 15.13 on RHEL 9.6<br><br>Logical Master also have 2 stre=
aming replica<br>Logical Replica also have 1 streaming replica</div><div><b=
r></div><div>We just do patch updates from 15.12 to 15.13, restart Logical =
Master and then Logical Replica, and suddenly Logical replication stops wor=
king. Streaming replication of both are fine.<br><br>The message on Logical=
 Replica :=C2=A0<br>ERROR,08P01,&quot;could not receive data from WAL strea=
m: ERROR: =C2=A0invalid memory alloc request size 1095736448&quot;,,,,,,,,,=
&quot;&quot;,&quot;logical replication worker&quot;,,0</div><div><br></div>=
<div>The message on Logical Master :</div><div>&quot;START_REPLICATION&quot=
;, LOG,00000,&quot;starting logical decoding for slot &quot;&quot;_subscrip=
tion&quot;&quot;&quot;,&quot;Streaming transactions committing after 33D45/=
373C2D98, reading WAL from 33D44/EF3219B0.&quot;,,,,,&quot;START_REPLICATIO=
N SLOT &quot;&quot;_subscription&quot;&quot; LOGICAL 33D45/373C2D98 (proto_=
version &#39;3&#39;, publication_names &#39;&quot;&quot;_publication&quot;&=
quot;&#39;)&quot;,,,&quot;_subscription&quot;,&quot;walsender&quot;,,0<br><=
br></div><div>&quot;START_REPLICATION&quot;, ,LOG,00000,&quot;logical decod=
ing found consistent point at 33D44/EF3219B0&quot;,&quot;Logical decoding w=
ill begin using saved snapshot.&quot;,,,,,&quot;START_REPLICATION SLOT &quo=
t;&quot;_subscription&quot;&quot; LOGICAL 33D45/373C2D98 (proto_version =
9;3&#39;, publication_names &#39;&quot;&quot;_publication&quot;&quot;&#39;)=
&quot;,,,&quot;_subscription&quot;,&quot;walsender&quot;,,0<br><br></div><d=
iv>Checking at error code 08P01 is protocol_violation.</div><div><br></div>=
<div>Is there any idea on what causing this and how to resolve ?</div><div>=
<br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"=
ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=
=3D"ltr"><div>Regards,</div><div><br></div>Soni Maula Harriz</div></div></d=
iv>
</div>

--000000000000b6e8ab06393f86a5--