MIME-Version: 1.0
References: 
 <CAKgGyB_Rg-xcpeBDC8rq+BnkEto=ZO4fjbV=DchEjXF99ZQ==Q@mail.gmail.com>
 <CAKAnmmJWpM1eAcThK16my+064_7cKCPvp=WkGPP=EKP-rJww9g@mail.gmail.com>
In-Reply-To: 
 <CAKAnmmJWpM1eAcThK16my+064_7cKCPvp=WkGPP=EKP-rJww9g@mail.gmail.com>
From: KK CHN <kkchn.in@gmail.com>
Date: Mon, 22 Jun 2026 10:23:40 +0530
Message-ID: 
 <CAKgGyB9KF0JM4=avjinX2a8kKZhtzi_TEUuNzLXD7r1Ep3nErA@mail.gmail.com>
Subject: Re: PgbackRest : backup command end: aborted with exception [101]
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c994000654d0505f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKgGyB9KF0JM4%3DavjinX2a8kKZhtzi_TEUuNzLXD7r1Ep3nErA%40mail.gmail.com>
Precedence: bulk

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

it stopped full backup multiple times.  This time it succeeded, One
difference,  I have ran  the full backup script again immediately after the
full backup  failure happened after running for almost 20 Hours (2026-06-19
10:49:12.739 P00  ERROR: [101]: raised from remote-0 ssh protocol on
'10.140.0.202': NULL result required to complete request) .  After this
time stamp I scheduled the full backup again on   2026-06-19  11:19 Hrs and
it completed the next day 2026-06-20  05:20 Hrs.   (~=3D 18 Hrs).

I assume the full backup continues from the last point from where it
stopped , not afresh when you reschedule the full backup again ?

Here the time duration is observed.

full backup: 20260614-011004F
            timestamp start/stop: 2026-06-19 11:19:05+05:30 / 2026-06-20
05:20:17+05:30
            wal start/stop: 000000010000158A000000CA /
000000010000159A000000FE
            database size: 3876.8GB, database backup size: 3876.8GB
            repo1: backup size: 967.1GB

Almost 18 Hrs.


 diff backup: 20260614-011004F_20260621-030404D
            timestamp start/stop: 2026-06-21 03:04:04+05:30 / 2026-06-21
04:55:20+05:30
            wal start/stop: 00000001000015AD000000E7 /
00000001000015AF00000057
            database size: 3895.9GB, database backup size: 70.2GB
            repo1: backup size: 12.8GB
            backup reference list: 20260614-011004F


approx : 2 Hours

As suggested, add the       ServerAliveInterval 60
 ServerAliveCountMax 3   vars in sshd_config next time and observe the
difference.


Thank you,
Krshane.


On Sat, Jun 20, 2026 at 8:22=E2=80=AFPM Greg Sabino Mullane <htamfids@gmail=
.com>
wrote:

> Smells like a timeout of some sort to me. Could be a firewall dropping an
> "idle" connection. How long does the diff backup take to complete? How lo=
ng
> from when you kick off the full backup to the time it errors out? Is that
> timeout consistent? See if you have ServerAliveInterval set in your ssh
> config, and if not, consider adding it (and related vars).
>
> Cheers,
> Greg
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><div><br></div><div>it stopped full backu=
p multiple times.=C2=A0 This time it succeeded, One difference,=C2=A0 I hav=
e ran=C2=A0 the full backup script again immediately after the full backup=
=C2=A0 failure happened=C2=A0after running for almost 20 Hours (<span style=
=3D"background-color:transparent">2026-06-19 10:49:12.739 P00 =C2=A0ERROR: =
[101]: raised from remote-0 ssh protocol on &#39;10.140.0.202&#39;: NULL re=
sult required to complete request) .=C2=A0 After this time stamp I schedule=
d the full backup again on=C2=A0 =C2=A02026-06-19=C2=A0 11:19 Hrs and it co=
mpleted the next day 2026-06-20=C2=A0 05:20 Hrs.=C2=A0 =C2=A0(~=3D 18 Hrs).=
</span></div><div><span style=3D"background-color:transparent"><br></span><=
/div><div><span style=3D"background-color:transparent">I assume the full ba=
ckup continues from the last point from where it stopped , not afresh when =
you reschedule the full backup again ?=C2=A0</span></div><div><span style=
=3D"background-color:transparent"><br></span></div><div><span style=3D"back=
ground-color:transparent">Here the time duration is observed.=C2=A0 =C2=A0<=
/span></div><div><br></div><div>full backup: 20260614-011004F<br>=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 timestamp start/stop: 2026-06-19 11:19:05+0=
5:30 / 2026-06-20 05:20:17+05:30<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 wal start/stop: 000000010000158A000000CA / 000000010000159A000000FE<br>=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 database size: 3876.8GB, database=
 backup size: 3876.8GB<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 repo1: =
backup size: 967.1GB</div><div><br></div><div>Almost 18 Hrs.=C2=A0</div><di=
v><br></div><div><br></div><div>=C2=A0diff backup: 20260614-011004F_2026062=
1-030404D<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 timestamp start/stop=
: 2026-06-21 03:04:04+05:30 / 2026-06-21 04:55:20+05:30<br>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 wal start/stop: 00000001000015AD000000E7 / 0000=
0001000015AF00000057<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 database =
size: 3895.9GB, database backup size: 70.2GB<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 repo1: backup size: 12.8GB<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 backup reference list: 20260614-011004F</div><div><br></div><=
div><br><div>approx : 2 Hours</div><div><br></div><div>As suggested, add th=
e=C2=A0<span style=3D"background-color:transparent">=C2=A0 =C2=A0 =C2=A0 Se=
rverAliveInterval 60=C2=A0=C2=A0</span><span style=3D"background-color:tran=
sparent">=C2=A0 =C2=A0 =C2=A0ServerAliveCountMax 3=C2=A0 =C2=A0vars in sshd=
_config next time and observe the difference.=C2=A0</span></div><div><br></=
div><div><br></div><div><br></div><div>Thank you,</div><div>Krshane.</div><=
div><br></div></div></div><br><div class=3D"gmail_quote gmail_quote_contain=
er"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Jun 20, 2026 at 8:22=E2=
=80=AFPM Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids@gmail.com">htam=
fids@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">Smells like a timeout of so=
me sort to me. Could be a firewall dropping an &quot;idle&quot; connection.=
 How long does the diff backup take to complete? How long from when you kic=
k off the full backup to the time it errors out? Is that timeout consistent=
? See if you have ServerAliveInterval set in your ssh config, and if not, c=
onsider adding it (and related vars).<div><br></div><div>Cheers,</div><div>=
Greg</div><div><br></div></div>
</div>
</blockquote></div></div>

--000000000000c994000654d0505f--