From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Alex Kliukin <alexk@hintbits.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: 'replication checkpoint has wrong magic' on the newly cloned replicas
Date: Wed, 29 Nov 2017 20:22:43 -0300
Message-ID: <20171129232243.vk5ik5szknppo3it@alvherre.pgsql> (raw)
In-Reply-To: <1511966240.1459861.1188109744.2D26AD08@webmail.messagingengine.com>
Alex Kliukin wrote:
> 2017-11-15 13:15:46.673 CET,,,15154,,5a0c2ff1.3b32,5,,2017-11-15
> 13:15:45 CET,,0,PANIC,XX000,"replication checkpoint has wrong magic
> 5714534 instead of 307747550",,,,,,,,,""
Uhh ... I had never heard of this "replication checkpoint" thing. It is
part of replication origins feature, which is fairly new stuff (see
src/backend/replication/logical/origin.c). I'd bet this problem is
related to a bug in logical replication "origins" code rather than any
procedural problems in your base-backup taking setup ...
I wonder if there is some truncation of the 0x1257DADE value that
produces the 5714534 value you're seeing -- something related to a
pg_logical/replorigin_checkpoint file being written partially while the
backup is being taken.
Another point towards not including pg_logical/ contents when taking a
base backup, I guess ...
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@alvh.no-ip.org, alexk@hintbits.com
Subject: Re: 'replication checkpoint has wrong magic' on the newly cloned replicas
In-Reply-To: <20171129232243.vk5ik5szknppo3it@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox