- Notifications
You must be signed in to change notification settings - Fork86
Description
Hi;
I try to use pg_probackup on my prod. But some backup operations get en error on some cluster. pg_probackup could not get any backup on this server so far. The logs at the end of backup below
INFO: PGDATA size: 685GB
INFO: Start transferring data files
INFO: Backup start, pg_probackup version: 2.2.7, instance: xxxx, backup ID: Q9AVD1, backup mode: FULL, wal mode: STREAM, remote: true, compress
-algorithm: none, compress-level: 1
WARNING: This PostgreSQL instance was initialized without data block checksums. pg_probackup have no way to detect data block corruption without the
m. Reinitialize PGDATA with option '--data-checksums'.
INFO: PGDATA size: 684GB
INFO: Start transferring data files
INFO: Data files are transferred
ERROR: query failed: could not receive data from server: Connection timed out
query was: SET client_min_messages = warning;
WARNING: backup in progress, stop backup
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;
ERROR: query failed: no connection to the server
query was: SET datestyle = 'ISO, DMY';
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 F
ROM pg_catalog.pg_stop_backup(false, false)
ERROR: Failed to send pg_stop_backup query
WARNING: Backup Q9AVD1 is running, setting its status to ERROR
INFO: Data files are transferred
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: backup in progress, stop backup
ERROR: query failed: no connection to the server
query was: SET client_min_messages = warning;
ERROR: query failed: no connection to the server
query was: SET datestyle = 'ISO, DMY';
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 F
ROM pg_catalog.pg_stop_backup(false, false)
ERROR: Failed to send pg_stop_backup query
WARNING: Backup Q9AVCA is running, setting its status to ERROR
what is the problem?