Re: PgbackRest : backup command end: aborted with exception [101]

From: KK CHN <kkchn(dot)in(at)gmail(dot)com>
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PgbackRest : backup command end: aborted with exception [101]
Date: 2026-06-22 04:53:40
Message-ID: CAKgGyB9KF0JM4=avjinX2a8kKZhtzi_TEUuNzLXD7r1Ep3nErA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. (~= 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 PM Greg Sabino Mullane <htamfids(at)gmail(dot)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 long
> 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
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2026-06-22 05:44:15 RE: set failover=true on existing logical replication slot PG18
Previous Message Laurenz Albe 2026-06-20 22:05:58 Re: Idaho state government is vetting your solution