From: Sergey Burladyan <eshkinkot@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: Dmitriy Sarafannikov <dsarafannikov@yandex.ru>
Cc: Vladimir Borodin <root@simply.name>
Subject: Re: Broken hint bits (freeze)
Date: Tue, 20 Jun 2017 13:10:26 +0300
Message-ID: <87h8zb6kbx.fsf@seb.koffice.internal> (raw)
In-Reply-To: <20170620033726.GB28277@momjian.us>
References: <C4ADB713-CF88-4A75-A3C3-10E4E0A750DB@simply.name>
<20170613193124.GQ13873@momjian.us>
<87mv98af8j.fsf@seb.koffice.internal>
<CAA4eK1JB=5gHNhRWgtVcqCQbUzGwR2LM9msYBQVULDfA+1ugUA@mail.gmail.com>
<20170616164641.GP11450@momjian.us>
<87fuezalc3.fsf@seb.koffice.internal>
<CAA4eK1KMxzg_q2-0rMRh22EMWGutQ0QbCtMqc_5GeuNVyJ8kmA@mail.gmail.com>
<20170619222113.GF3180@momjian.us>
<CAJ2ymdg=0knii-bavVLpKEGc9DanaZC+UXjnipx_n-gFvOkdcg@mail.gmail.com>
<20170620025919.GA28277@momjian.us>
<20170620033726.GB28277@momjian.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Bruce Momjian <bruce@momjian.us> writes:
> On Mon, Jun 19, 2017 at 10:59:19PM -0400, Bruce Momjian wrote:
> > On Tue, Jun 20, 2017 at 03:50:29AM +0300, Sergey Burladyan wrote:
> > > 20 июн. 2017 г. 1:21 пользователь "Bruce Momjian" <bruce@momjian.us> написал:
> > >
> > >
> > > We are saying that Log-Shipping should match "Latest checkpoint
> > > location", but the WAL for that will not be sent to the standby, so it
> > > will not match, but that is OK since the only thing in the non-shipped
> > > WAL file is the checkpoint record. How should we modify the wording on
> > > this?
> > >
> > >
> > > I am afraid that without this checkpoint record standby cannot make
> > > restartpoint
> > > and without restartpoint it does not sync shared buffers into disk at
> > > shutdown.
> >
> > Uh, as I understand it the rsync is going to copy the missing WAL file
> > from the new master to the standby, right, and I think pg_controldata
> > too, so it should be fine. Have you tested to see if it fails?
It need old WAL files from old version for correct restore heap
files. New WAL files from new version does not have this information.
> The point is that we are checking the "Latest checkpoint location" to
> make sure all the WAL was replayed. We are never going to start the
> old standby server. Rsync is going to copy the missing/changed files.
Only if missing/changed files changed in size, because rsync run with
--size-only it does not copy changed files with same size.
I have this test script and without copy_last_wal it make standby broken
in the first few loops, like:
=== run 1, cnt: 700000
=== run 2, cnt: 729450
PS: I think what with big shared_buffers I can make it broken more
quickly, but with big shared_buffers I cannot break it at all, hm...
--
Sergey Burladyan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackersAttachments:
[application/x-sh] test_rsync.sh (5.6K, ../87h8zb6kbx.fsf@seb.koffice.internal/2-test_rsync.sh)
download
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-hackers@postgresql.org
Cc: eshkinkot@gmail.com, bruce@momjian.us, amit.kapila16@gmail.com, dsarafannikov@yandex.ru, root@simply.name
Subject: Re: Broken hint bits (freeze)
In-Reply-To: <87h8zb6kbx.fsf@seb.koffice.internal>
* 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