- Notifications
You must be signed in to change notification settings - Fork86
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 called2024-12-18 12:51:02.506 MSK [2064920] LOG: unexpected EOF on standby connection2024-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 serverquery 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 serverquery 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 queryWARNING: Backup SOOO4S is running, setting its status to ERROR
Конфигурация pg_probackup
# Backup instance informationpgdata = /data/patronisystem-identifier = 7410756962539012540xlog-seg-size = 16777216# Connection parameterspgdatabase = backupdbpghost = db.domain.compgport = 5434pguser = backup# Replica parametersreplica-timeout = 5min# Archive parametersarchive-timeout = 5min# Logging parameterslog-level-console = VERBOSElog-level-file = LOGlog-format-console = PLAINlog-format-file = PLAINlog-filename = pg_probackup.loglog-directory = /backup/loglog-rotation-size = 0TBlog-rotation-age = 0d# Retention parametersretention-redundancy = 2retention-window = 14wal-depth = 3# Compression parameterscompress-algorithm = zlibcompress-level = 6# Remote access parametersremote-proto = sshremote-host = db.domain.comremote-port = 2303remote-user = postgres
Metadata
Metadata
Assignees
Labels
No labels