Open
Description
Добрый день.
При запуске полного бэкапа и который идёт дольше 10 минут, получаю ошибку в логе ниже, при этом же если бэкап идёт менее 10 минут то завершается без ошибок.
Guest OS Ubuntu 22.04.5 LTS
Backup VM pg_probackup-16 2.5.15 (PostgreSQL 16.2)
DB VM PostgreSQL 16.4
Postgresql.log
2024-12-18 12:48:55.354 MSK [2064846] WARNING: aborting backup due to backend exiting before pg_backup_stop was called
2024-12-18 12:51:02.506 MSK [2064920] LOG: unexpected EOF on standby connection
2024-12-18 12:51:02.506 MSK [2064920] STATEMENT: START_REPLICATION 694/CF000000 TIMELINE 43
pg_probackup log
VERBOSE: (query) SET client_min_messages = warning;
ERROR: query failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
query was: SET client_min_messages = warning;
WARNING: A backup is in progress, stopping it.
VERBOSE: (query) SET datestyle = 'ISO, DMY';
ERROR: query failed: no connection to the server
query was: SET datestyle = 'ISO, DMY';
VERBOSE: (query) SELECT pg_catalog.txid_snapshot_xmax(pg_catalog.txid_current_snapshot()), current_timestamp(0)::timestamptz, lsn, labelfile, spcmapfile FROM pg_catalog.pg_backup_stop(false)
WARNING: query failed: no connection to the server
query was: SELECT pg_catalog.txid_snapshot_xmax(pg_catalog.txid_current_snapshot()), current_timestamp(0)::timestamptz, lsn, labelfile, spcmapfile FROM pg_catalog.pg_backup_stop(false)
ERROR: Failed to send pg_backup_stop query
WARNING: Backup SOOO4S is running, setting its status to ERROR
Конфигурация pg_probackup
# Backup instance information
pgdata = /data/patroni
system-identifier = 7410756962539012540
xlog-seg-size = 16777216
# Connection parameters
pgdatabase = backupdb
pghost = db.domain.com
pgport = 5434
pguser = backup
# Replica parameters
replica-timeout = 5min
# Archive parameters
archive-timeout = 5min
# Logging parameters
log-level-console = VERBOSE
log-level-file = LOG
log-format-console = PLAIN
log-format-file = PLAIN
log-filename = pg_probackup.log
log-directory = /backup/log
log-rotation-size = 0TB
log-rotation-age = 0d
# Retention parameters
retention-redundancy = 2
retention-window = 14
wal-depth = 3
# Compression parameters
compress-algorithm = zlib
compress-level = 6
# Remote access parameters
remote-proto = ssh
remote-host = db.domain.com
remote-port = 2303
remote-user = postgres
Metadata
Metadata
Assignees
Labels
No labels