From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Alexander Kukushkin <cyberdemn(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15346: Replica fails to start after the crash |
Date: | 2018-08-28 12:21:50 |
Message-ID: | 20180828122150.GC3326@tamriel.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Greetings,
* Michael Paquier (michael(at)paquier(dot)xyz) 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. Because that means that the control file of your
> server maps to a consistent point which is older than some of the
> relation pages. 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. So it seems to me that the origin of your problem
> comes from an incorrect base backup expectation?
Yeah, we really need to know how this system was built. If it was built
using the low-level pg_start/stop_backup, then which API was used- the
old one that creates a backup_label file, or the new API which requires
the user to create the backup_label file? I haven't followed this
thread very closely, but I wonder if maybe the new API was used, but no
backup_label file was created, making PG think it was doing crash
recovery instead of restoring from a file-level backup...
Thanks!
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2018-08-28 12:23:11 | Re: BUG #15346: Replica fails to start after the crash |
Previous Message | Antti Koskinen | 2018-08-28 09:20:34 | Wrong GROUP BY semantics with postgres_fdw |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2018-08-28 12:23:11 | Re: BUG #15346: Replica fails to start after the crash |
Previous Message | Surafel Temesgen | 2018-08-28 12:14:43 | Re: FETCH FIRST clause PERCENT option |