MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Fri, 19 Jun 2026 11:24:08 +0530
Message-ID: 
 <CAKgGyB_Rg-xcpeBDC8rq+BnkEto=ZO4fjbV=DchEjXF99ZQ==Q@mail.gmail.com>
Subject: PgbackRest : backup command end: aborted with exception [101]
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000237288065494cf0d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKgGyB_Rg-xcpeBDC8rq%2BBnkEto%3DZO4fjbV%3DDchEjXF99ZQ%3D%3DQ%40mail.gmail.com>
Precedence: bulk

--000000000000237288065494cf0d
Content-Type: text/plain; charset="UTF-8"

List,

I am running pgbackrest 2.52.1  on RHEL 9.4  Postgres 16 for  backup to a
remote repository for the last 4 months. All works fine in the initial
months.

Recently the full backup always fails without completing the backup to Repo
Server.

Only differential backup is completing the process  as scheduled .
 Whenever a  full backup is scheduled,  after running for  hours it fails
with error as in the subject line.  Earlier it was working and the last
full backup was completed in April 2026 .  Rest of the period  differential
backup only  completes all full backup  processes failed till today.

Yesterday 18 June 2026 at 09:30 AM I ran the  full backup from a cron
scheduler explicitly to test, it runs almost 24 hours and today 19 June
10.49 AM it stopped the full backup,   Aborted the process.

*What may be the issue ? Any hints are much appreciated.  ** Any more
inputs required ? *


Thank you,
Krishane


*log trace below for reference. *

2026-06-19 10:49:12.499 P00  DEBUG:
command/backup/backup::backupJobResult: => void
2026-06-19 10:49:12.590 P00  DEBUG:
command/backup/backup::backupDbPing: (backupData: {BackupData}, force:
false)
2026-06-19 10:49:12.590 P00  DEBUG:     db/db::dbPing: (this: {client:
null, remoteClient: {name: remote-0 ssh protocol on '10.140.0.20', state:
idle}}, force: false)
2026-06-19 10:49:12.590 P00  DEBUG:     db/db::dbIsInRecovery: (this:
{client: null, remoteClient: {name: remote-0 ssh protocol on
'10.140.0.202', state: idle}})
2026-06-19 10:49:12.590 P00  DEBUG:     db/db::dbQueryColumn: (this:
{client: null, remoteClient: {name: remote-0 ssh protocol on
'10.140.0.202', state: idle}}, query: {"select
pg_catalog.pg_is_in_recovery()"})
2026-06-19 10:49:12.590 P00  DEBUG:     db/db::dbQuery: (this: {client:
null, remoteClient: {name: remote-0 ssh protocol on '10.140.0.202', state:
idle}}, resultType: column, query: {"select
pg_catalog.pg_is_in_recovery()"})
2026-06-19 10:49:12.739 P00  DEBUG:     command/exit::exitSafe: (result: 0,
error: true, signalType: 0)
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

--------------------------------------------------------------------
                                    If SUBMITTING AN ISSUE please provide
the following information:

                                    version: 2.52.1
                                    command: backup
                                    options: --delta
--exec-id=485653-6407012b --log-level-console=info --log-level-file=debug
--pg1-host=10.140.0.202 --pg1-host-user=postgres
--pg1-path=/var/postgres16/data --pg-version-force=16 --process-max=5
--repo1-block --repo1-bundle --repo1-cipher-pass=<redacted>
--repo1-cipher-type=aes-256-cbc --repo1-path=/data/DB_BACKUPS
--repo1-retention-diff=2 --repo1-retention-full=2 --stanza=Traffic_Repo
--start-fast --type=full

                                    stack trace:

postgres/client.c:pgClientQuery:348:(debug log level required for
parameters)
                                    db/protocol.c:dbQueryProtocol:(debug
log level required for parameters)

protocol/server.c:protocolServerProcess:(debug log level required for
parameters)

command/remote/remote.c:cmdRemote:(debug log level required for parameters)
                                    main.c:main:(debug log level required
for parameters)

--------------------------------------------------------------------
2026-06-19 10:49:12.740 P00   INFO: backup command end: aborted with
exception [101]
2026-06-19 10:49:12.740 P00  DEBUG:     command/exit::exitSafe: => 101

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

<div dir=3D"ltr">List,=C2=A0<div><br></div><div>I am running pgbackrest 2.5=
2.1=C2=A0 on RHEL 9.4=C2=A0 Postgres 16 for=C2=A0 backup to a remote reposi=
tory for the last 4 months. All works fine in the initial months.=C2=A0</di=
v><div><br></div><div>Recently the full backup always fails without complet=
ing the backup to Repo Server.</div><div><br></div><div>Only differential=
=C2=A0backup is completing the process=C2=A0 as scheduled=C2=A0.=C2=A0 =C2=
=A0Whenever a=C2=A0 full backup is scheduled,=C2=A0 after running for=C2=A0=
 hours it fails=C2=A0 with error as in the subject line.=C2=A0 Earlier it w=
as working and the last full backup was completed in April 2026 .=C2=A0 Res=
t of the period=C2=A0 differential backup only=C2=A0 completes all full bac=
kup=C2=A0 processes failed till today.=C2=A0</div><div><br></div><div>Yeste=
rday 18 June 2026 at 09:30 AM I ran the=C2=A0 full backup from a cron sched=
uler explicitly to test, it runs almost 24 hours and today 19 June=C2=A0 10=
.49 AM it stopped the full backup,=C2=A0 =C2=A0Aborted the process.=C2=A0</=
div><div><br></div><div><b>What may be the issue ? Any hints are much appre=
ciated.=C2=A0=C2=A0</b><b style=3D"background-color:transparent">=C2=A0Any =
more inputs required ?=C2=A0</b></div><div><br></div><div><br></div><div>Th=
ank you,</div><div>Krishane</div><div><br></div><div><br></div><div><b>log =
trace below for reference.=C2=A0</b></div><div><br></div><div>2026-06-19 10=
:49:12.499 P00 =C2=A0DEBUG: =C2=A0 =C2=A0 command/backup/backup::backupJobR=
esult: =3D&gt; void<br>2026-06-19 10:49:12.590 P00 =C2=A0DEBUG: =C2=A0 =C2=
=A0 command/backup/backup::backupDbPing: (backupData: {BackupData}, force: =
false)<br>2026-06-19 10:49:12.590 P00 =C2=A0DEBUG: =C2=A0 =C2=A0 db/db::dbP=
ing: (this: {client: null, remoteClient: {name: remote-0 ssh protocol on &#=
39;10.140.0.20&#39;, state: idle}}, force: false)<br>2026-06-19 10:49:12.59=
0 P00 =C2=A0DEBUG: =C2=A0 =C2=A0 db/db::dbIsInRecovery: (this: {client: nul=
l, remoteClient: {name: remote-0 ssh protocol on &#39;10.140.0.202&#39;, st=
ate: idle}})<br>2026-06-19 10:49:12.590 P00 =C2=A0DEBUG: =C2=A0 =C2=A0 db/d=
b::dbQueryColumn: (this: {client: null, remoteClient: {name: remote-0 ssh p=
rotocol on &#39;10.140.0.202&#39;, state: idle}}, query: {&quot;select pg_c=
atalog.pg_is_in_recovery()&quot;})<br>2026-06-19 10:49:12.590 P00 =C2=A0DEB=
UG: =C2=A0 =C2=A0 db/db::dbQuery: (this: {client: null, remoteClient: {name=
: remote-0 ssh protocol on &#39;10.140.0.202&#39;, state: idle}}, resultTyp=
e: column, query: {&quot;select pg_catalog.pg_is_in_recovery()&quot;})<br>2=
026-06-19 10:49:12.739 P00 =C2=A0DEBUG: =C2=A0 =C2=A0 command/exit::exitSaf=
e: (result: 0, error: true, signalType: 0)<br>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 result required to complete request<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 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 -----------------------------------------------=
---------------------<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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 If SUBMITTING AN ISSUE please provide the following information:<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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 version: 2.52.1<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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 command: backup<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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 options: --delta --exec-id=3D=
485653-6407012b --log-level-console=3Dinfo --log-level-file=3Ddebug --pg1-h=
ost=3D10.140.0.202 --pg1-host-user=3Dpostgres --pg1-path=3D/var/postgres16/=
data --pg-version-force=3D16 --process-max=3D5 --repo1-block --repo1-bundle=
 --repo1-cipher-pass=3D&lt;redacted&gt; --repo1-cipher-type=3Daes-256-cbc -=
-repo1-path=3D/data/DB_BACKUPS --repo1-retention-diff=3D2 --repo1-retention=
-full=3D2 --stanza=3DTraffic_Repo --start-fast --type=3Dfull<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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 stack trace:<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 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 postgres/client.c:pgClientQuery:348:=
(debug log level required for parameters)<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 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 db/protocol.c:dbQueryProtocol:(debug log level req=
uired for parameters)<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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 protocol/server.c:protocolServerProcess:(debug log level required for p=
arameters)<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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 command/=
remote/remote.c:cmdRemote:(debug log level required for parameters)<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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 main.c:main:(debug log lev=
el required for parameters)<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 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 ----------------------------------------------------------------=
----<br>2026-06-19 10:49:12.740 P00 =C2=A0 INFO: backup command end: aborte=
d with exception [101]<br>2026-06-19 10:49:12.740 P00 =C2=A0DEBUG: =C2=A0 =
=C2=A0 command/exit::exitSafe: =3D&gt; 101</div></div>

--000000000000237288065494cf0d--