| 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
>
>
| 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 |