MIME-Version: 1.0
References: 
 <CAN1ptcea4ZELQqF8=ZH3joQKO6f3krNfEHzLakQ51vgoaMdXBQ@mail.gmail.com>
 <3910290.1733761359@sss.pgh.pa.us>
In-Reply-To: <3910290.1733761359@sss.pgh.pa.us>
From: Rijesh TP <rijesh.tp@opsveda.com>
Date: Fri, 20 Dec 2024 15:48:02 +0530
Message-ID: 
 <CAN1ptccjjJ=D1ih2YxxKT-iTANKvij9dX7gBUuL87me+5voJ5g@mail.gmail.com>
Subject: Re: SSL SYSCALL error during logical replication
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org, Rajin Raj <rajin.raj@opsveda.com>,
	Srikar Vankadaru <srikar@opsveda.com>
Content-Type: multipart/alternative; boundary="000000000000e6ff570629b0f69d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN1ptccjjJ%3DD1ih2YxxKT-iTANKvij9dX7gBUuL87me%2B5voJ5g%40mail.gmail.com>
Precedence: bulk

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

Hi Tom,
Thanks for the reply.
On the source DB, we're seeing these messages coming up often, but there
aren't any other errors showing up.
All DB parameters including timeout we set to high, but no luck yet.
Pls advise on this

*user=3Dreplicator DEBUG:  failed to increase restart lsn: proposed
13EB/B420DE18, after 13EB/B420DE18, current candidate 13EB/B420DD70,
current after 13EB/B420DD70, flushed up to 13EB/B420DBB0*


Thanks & Regards,
Rijesh


On Mon, Dec 9, 2024 at 9:52=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Rijesh TP <rijesh.tp@opsveda.com> writes:
> > 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."*
>
> This seems to be a symptom of something going wrong on the sending
> side.  Have you looked into that postmaster's log file to see what
> happened?
>
>                         regards, tom lane
>

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

<div dir=3D"ltr">Hi=C2=A0Tom,<div>Thanks for the reply.</div><div>On the so=
urce DB,=20

we&#39;re seeing these messages coming up often, but there aren&#39;t any o=
ther errors showing up.

<br>All DB parameters including timeout we set to high, but no luck=C2=A0ye=
t.<br>Pls advise on this<br><br><b>user=3Dreplicator DEBUG: =C2=A0failed to=
 increase restart lsn: proposed 13EB/B420DE18, after 13EB/B420DE18, current=
 candidate 13EB/B420DD70, current after 13EB/B420DD70, flushed up to 13EB/B=
420DBB0</b></div><div><b><br></b></div><div><b><br></b></div><div>Thanks &a=
mp; Regards,</div><div>Rijesh</div><div><br></div><p>=C2=A0</p><div><br></d=
iv><div><br></div></div><br><div class=3D"gmail_quote gmail_quote_container=
"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Dec 9, 2024 at 9:52=E2=80=
=AFPM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Ri=
jesh TP &lt;<a href=3D"mailto:rijesh.tp@opsveda.com" target=3D"_blank">rije=
sh.tp@opsveda.com</a>&gt; writes:<br>
&gt; We are encountering an issue with logical replication on PostgreSQL ve=
rsion<br>
&gt; 15.10. The error message is as follows:<br>
<br>
&gt; *&quot;ERROR: could not receive data from WAL stream: SSL SYSCALL erro=
r: EOF<br>
&gt; detectedLOG: background worker &quot;logical replication worker&quot; =
(PID 3286)<br>
&gt; exited with exit code 1.&quot;*<br>
<br>
This seems to be a symptom of something going wrong on the sending<br>
side.=C2=A0 Have you looked into that postmaster&#39;s log file to see what=
<br>
happened?<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>

--000000000000e6ff570629b0f69d--