PgbackRest : backup command end: aborted with exception [101] - Mailing list pgsql-general
| From | KK CHN |
|---|---|
| Subject | PgbackRest : backup command end: aborted with exception [101] |
| Date | |
| Msg-id | CAKgGyB_Rg-xcpeBDC8rq+BnkEto=ZO4fjbV=DchEjXF99ZQ==Q@mail.gmail.com Whole thread |
| Responses |
Re: PgbackRest : backup command end: aborted with exception [101]
|
| List | pgsql-general |
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
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
pgsql-general by date: