Date: Tue, 28 Aug 2018 14:08:33 +0900
User-Agent: K-9 Mail for Android
In-Reply-To: <20180828024409.GB29157@paquier.xyz>
References: 
 <CA+q6zcVjv1Lp-3=prBbpq2CbBioK91SHarfw3F8FHuUN4EwcUA@mail.gmail.com>
 <20180822175034.lnvwk5js32k6mjyz@alvherre.pgsql>
 <20180823041420.GA1158@paquier.xyz>
 <CAFh8B==4gpwor6ODercru0iifqwd0nQrdRvXzmorWkMRQa4q=g@mail.gmail.com>
 <CAFh8B=nHdsX83hTZMqGqbht39ud+DRQOv4_Te+xu3DuPssQbZA@mail.gmail.com>
 <CAFh8B=mYGP1J8ueHKU40Dr4bNBUPJj1rTbZ6Wpg4gR30uCRunA@mail.gmail.com>
 <20180828024409.GB29157@paquier.xyz>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
Subject: Re: BUG #15346: Replica fails to start after the crash
To: pgsql-bugs@lists.postgresql.org,Michael Paquier
 <michael@paquier.xyz>,Alexander Kukushkin <cyberdemn@gmail.com>
CC: Alvaro Herrera <alvherre@2ndquadrant.com>,Dmitry Dolgov
 <9erthalion6@gmail.com>
From: Andres Freund <andres@anarazel.de>
Message-ID: <3B69F535-FD81-461B-97E9-657D4C99EDB4@anarazel.de>
Precedence: bulk


On August 28, 2018 11:44:09 AM GMT+09:00, Michael Paquier <michael@paquier=
=2Exyz> wrote:
>On Sat, Aug 25, 2018 at 09:54:39AM +0200, Alexander Kukushkin wrote:
>> Why the number of tuples in the xlog is greater than the number of
>> tuples on the index page?
>> Because this page was already overwritten and its LSN is HIGHER than
>> the current LSN!
>
>That's annoying=2E  Because that means that the control file of your
>server maps to a consistent point which is older than some of the
>relation pages=2E  How was the base backup of this node created?  Please
>remember that when taking a base backup from a standby, you should
>backup the control file last, as there is no control of end backup with
>records available=2E  So it seems to me that the origin of your problem
>comes from an incorrect base backup expectation?=20

Uh, where is that "control file last" bit coming from?

Andres
--=20
Sent from my Android device with K-9 Mail=2E Please excuse my brevity=2E