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

Reply via email to