Re: out-of-order XID insertion in KnownAssignedXids - Mailing list pgsql-general

From Andres Freund
Subject Re: out-of-order XID insertion in KnownAssignedXids
Date
Msg-id 20161020203826.cmccyipkvfa2r2fn@alap3.anarazel.de
Whole thread Raw
In response to Re: out-of-order XID insertion in KnownAssignedXids  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: out-of-order XID insertion in KnownAssignedXids  (<fredrik@huitfeldt.com>)
List pgsql-general
On 2016-10-20 22:37:15 +0900, Michael Paquier wrote:
> On Thu, Oct 20, 2016 at 10:21 PM,  <fredrik@huitfeldt.com> wrote:
> > - remove a file called backup_label, but I am not certain that this file is
> > in fact there (any more).
>
> It is never a good idea when you are trying to restore from a backup,
> backup_label contains critical information when restoring from a
> backup, so you may finish with a corrupted data folder.

And this actually seems like a likely source of these errors.  Removing
a backup label unfortunately causes hard to diagnose errors, because
everything appears to be ok as long as there's no checkpoints while
taking the base backups (or when the control file was copied early
enough). But as soon as a second checkpoint happens before the control
file is copied...

Fredrik, how did you end up removing the label?

Greetings,

Andres Freund


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Postgresql apt repository naming scheme question
Next
From: Арсений Нестюк
Date:
Subject: Showing matrix with single query