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