MIME-Version: 1.0
From: Rijesh TP <rijesh.tp@opsveda.com>
Date: Mon, 9 Dec 2024 12:54:58 +0530
Message-ID: 
 <CAN1ptcea4ZELQqF8=ZH3joQKO6f3krNfEHzLakQ51vgoaMdXBQ@mail.gmail.com>
Subject: SSL SYSCALL error during logical replication
To: pgsql-admin@lists.postgresql.org
Cc: Rajin Raj <rajin.raj@opsveda.com>, Srikar Vankadaru <srikar@opsveda.com>
Content-Type: multipart/alternative; boundary="000000000000c945e30628d14311"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN1ptcea4ZELQqF8%3DZH3joQKO6f3krNfEHzLakQ51vgoaMdXBQ%40mail.gmail.com>
Precedence: bulk

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

Hi Team,
We are encountering an issue with logical replication on PostgreSQL version
15.10. The error message is as follows:


*"ERROR: could not receive data from WAL stream: SSL SYSCALL error: EOF
detectedLOG: background worker "logical replication worker" (PID 3286)
exited with exit code 1."*

Logical replication had been working perfectly on version 15.8, and we
successfully completed multiple systems on that version. However, after
upgrading to PostgreSQL 15.10, this issue has arisen.
We=E2=80=99ve tried adjusting various parameters but haven=E2=80=99t had an=
y success.
We have also tried disabling the SSL and selinux etc, but no luck, same
error every time.
Replication fails at some point without any additional errors, leading us
to suspect a potential bug in logical replication for version 15.10.

Has anyone else reported a similar issue, or is there a known fix for this?
Please let us know if additional details are required.

PG Version : postgresql 15.10
OS Details : CentOS 7


Thanks & Regards,
Rijesh

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

<div dir=3D"ltr">Hi Team,<div>We are encountering an issue with logical rep=
lication on PostgreSQL version 15.10. The error message is as follows:<br><=
br><b>&quot;ERROR: could not receive data from WAL stream: SSL SYSCALL erro=
r: EOF detected<br>LOG: background worker &quot;logical replication worker&=
quot; (PID 3286) exited with exit code 1.&quot;</b><br><br>Logical replicat=
ion had been working perfectly on version 15.8, and we successfully complet=
ed multiple systems on that version. However, after upgrading to PostgreSQL=
 15.10, this issue has arisen.<br>We=E2=80=99ve tried adjusting various par=
ameters but haven=E2=80=99t had any success. <br>We have also tried disabli=
ng the SSL and selinux etc, but no luck, same error every time.<br>Replicat=
ion fails at some point without any additional errors, leading us to suspec=
t a potential bug in logical replication for version 15.10.<br><br>Has anyo=
ne else reported a similar issue, or is there a known fix for this? Please =
let us know if additional details are required.<br><br>PG Version : postgre=
sql 15.10<br>OS Details : CentOS 7<br><br><br><br>Thanks &amp;=C2=A0Regards=
,</div><div>Rijesh</div></div>

--000000000000c945e30628d14311--