Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

pg_probackup gets error while taking backup #197

Closed
Milestone
@tengilim

Description

@tengilim

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2025 Movatter.jp