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

Не идут бэкапы с флагом --stream #335

Open
@Guzya

Description

@Guzya

Приветствую!
Имеются сервера pg-node1-test и pg-archive-test
Ранее была установлена версия 2.4.2.
После переустановки ос на pg-archive-test произвел установку версии 2.4.10 на оба сервера.
При выполнении рк с флагом --stream процесс зависает на моменте досылки wal

INFO: Backup start, pg_probackup version: 2.4.10, instance: pg-node-test, backup ID: QP10QN, backup mode: DELTA, 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 them. Reinitialize PGDATA with option '--data-checksums'.
WARNING: Backup QP103F has status: RUNNING. Cannot be a parent.
INFO: Parent backup: QP0Z9E
(null): could not send replication command "TIMELINE_HISTORY": ERROR: could not open file "pg_wal/00000011.history": No such file or directory
ERROR: Problem in receivexlog
INFO: PGDATA size: 362MB
INFO: Start transferring data files
INFO: Data files are transferred, time elapsed: 4s
INFO: wait for pg_stop_backup()
INFO: pg_stop backup() successfully executed
INFO: Wait for LSN 5B1/D5000160 in streamed WAL segment /archive/pg_probackup/backups/pg-node-test/QP10QN/database/pg_wal/00000011000005B1000000D5
ERROR: WAL segment 00000011000005B1000000D5 could not be streamed in 300 seconds

На стороне pg-node1-test

2021-02-24 05:23:16 AST [11877]: [1-1]: INFO: pg_probackup archive-push WAL file: 00000011000005B1000000D5, threads: 1/1, batch: 1/1, compression: none
2021-02-24 05:23:16 AST [11877]: [1-1]: LOG: pushing file "00000011000005B1000000D5"
2021-02-24 05:23:16 AST [11877]: [1-1]: VERBOSE: Temp WAL file successfully created: "/archive/pg_probackup/wal/pg-node-test/00000011000005B1000000D5.part"
2021-02-24 05:23:16 AST [11877]: [1-1]: VERBOSE: Rename "/archive/pg_probackup/wal/pg-node-test/00000011000005B1000000D5.part" to "/archive/pg_probackup/wal/pg-node-test/00000011000005B1000000D5"
2021-02-24 05:23:16 AST [11877]: [1-1]: LOG: SSH process 11878 is terminated with status 0
2021-02-24 05:23:16 AST [11877]: [1-1]: INFO: pg_probackup archive-push completed successfully, pushed: 1, skipped: 0, time elapsed: 381ms
2021-02-24 05:23:16 AST [11891]: [1-1]: INFO: pg_probackup archive-push WAL file: 00000011000005B1000000D5.00000028.backup, threads: 1/1, batch: 1/1, compression: none
2021-02-24 05:23:16 AST [11891]: [1-1]: LOG: pushing file "00000011000005B1000000D5.00000028.backup"
2021-02-24 05:23:16 AST [11891]: [1-1]: VERBOSE: Temp WAL file successfully created: "/archive/pg_probackup/wal/pg-node-test/00000011000005B1000000D5.00000028.backup.part"
2021-02-24 05:23:16 AST [11891]: [1-1]: VERBOSE: Rename "/archive/pg_probackup/wal/pg-node-test/00000011000005B1000000D5.00000028.backup.part" to "/archive/pg_probackup/wal/pg-node-test/00000011000005B1000000D5.00000028.backup"
2021-02-24 05:23:16 AST [11891]: [1-1]: LOG: SSH process 11892 is terminated with status 0
2021-02-24 05:23:16 AST [11891]: [1-1]: INFO: pg_probackup archive-push completed successfully, pushed: 1, skipped: 0, time elapsed: 6ms
2021-02-24 05:24:00.000 AST [8629] LOG: cron job 1 starting: select cron.ins_data_session_history()
2021-02-24 05:24:00.109 AST [8629] LOG: cron job 1 completed: 1 row
2021-02-24 05:28:18.134 AST [11709] backup@backupdb LOG: could not receive data from client: Connection reset by peer
2021-02-24 05:28:18.134 AST [11731] backup@[unknown] LOG: could not receive data from client: Connection reset by peer

Без --stream бэкап снимается

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2025 Movatter.jp