From: | Sergey Burladyan <eshkinkot(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Running from 9.6 backups sometimes fails with fatal error |
Date: | 2019-02-21 12:11:54 |
Message-ID: | 87a7ipe3xx.fsf@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
I need help with investigation what happened here. I have two different master servers with standby,
version: PostgreSQL 9.6.10 on x86_64-pc-linux-gnu (Debian 9.6.10-1.pgdg90+1), compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
and I create backups with pg_basebackup from theirs standbys, but sometimes backup check fails,
it just cannot start, for example:
server 1:
2019-02-18 14:18:51 MSK [11901-2] LOG: checkpoint starting: end-of-recovery immediate wait
2019-02-18 14:18:51 MSK [11901-3] DEBUG: performing replication slot checkpoint
2019-02-18 14:18:51 MSK [11901-4] LOG: request to flush past end of generated WAL; request 44B/7E5DAB28, currpos 44B/7305B560
2019-02-18 14:18:51 MSK [11901-5] CONTEXT: writing block 0 of relation base/16506/16891_vm
2019-02-18 14:18:51 MSK [11901-6] ERROR: xlog flush request 44B/7E5DAB28 is not satisfied --- flushed only to 44B/7305B560
2019-02-18 14:18:51 MSK [11901-7] CONTEXT: writing block 0 of relation base/16506/16891_vm
2019-02-18 14:18:51 MSK [11858-110] FATAL: checkpoint request failed
server 2:
2019-02-07 16:07:40 MSK [7911-37] LOG: checkpoint starting: end-of-recovery immediate wait
2019-02-07 16:07:40 MSK [7911-38] DEBUG: performing replication slot checkpoint
2019-02-07 16:07:41 MSK [7911-39] LOG: request to flush past end of generated WAL; request 1CB/8E94EE90, currpos 1CB/8A195210
2019-02-07 16:07:41 MSK [7911-40] CONTEXT: writing block 0 of relation base/18413/18529_vm
2019-02-07 16:07:41 MSK [7911-41] ERROR: xlog flush request 1CB/8E94EE90 is not satisfied --- flushed only to 1CB/8A195210
2019-02-07 16:07:41 MSK [7911-42] CONTEXT: writing block 0 of relation base/18413/18529_vm
2019-02-07 16:07:41 MSK [7868-665] FATAL: checkpoint request failed
backup checked with: PostgreSQL 9.6.11 on x86_64-pc-linux-gnu (Debian 9.6.11-1.pgdg90+1), compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
recovery.conf:
restore_command = '/usr/local/bin/restore_cmd /mnt/wals %f %p'
recovery_target = 'immediate'
postgresql.conf:
wal_log_hints = on
How can I debug this?
--
Sergey Burladyan
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Carlos Ericksson Richter | 2019-02-21 14:27:16 | Re: Barman disaster recovery solution |
Previous Message | Andreas Kretschmer | 2019-02-21 08:54:10 | Re: Barman disaster recovery solution |