Re: BUG #13822: Slave terminated - WAL contains references to invalid page

From: <Marek(dot)Petr(at)tieto(dot)com>
To: <michael(dot)paquier(at)gmail(dot)com>
Cc: <andres(at)anarazel(dot)de>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13822: Slave terminated - WAL contains references to invalid page
Date: 2016-01-05 13:46:25
Message-ID: d16c8f388628485f8c5aa9624b17254d@C105S135VM024.eu.tieto.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

No. Both cases ran in the same way and same machines.

Regards
Marek

-----Original Message-----
From: Michael Paquier [mailto:michael(dot)paquier(at)gmail(dot)com]
Sent: Tuesday, January 05, 2016 8:53 AM
To: Petr Marek <Marek(dot)Petr(at)tieto(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>; PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #13822: Slave terminated - WAL contains references to invalid page

On Thu, Dec 31, 2015 at 5:20 AM, <Marek(dot)Petr(at)tieto(dot)com> wrote:
> To be honest I don't understand why this second PITR finished without PANIC when previous attempt from the same base backup and archived wals failed.

I have no clue here either as the first PITR failed while the second completed correctly, replaying the same content. It seems that this relation block got corrupted in some way because of an issue with memory and/or disk, or presumably in the WAL segment itself. I would discard the possibility of a bug in the WAL replay based on this evidence... Is there actually something different in the way you ran the replay in both cases? Like on different servers?
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message paul 2016-01-05 15:02:27 BUG #13846: INSERT ON CONFLICT consumes sequencers on conflicts
Previous Message Feike Steenbergen 2016-01-05 13:32:43 Re: BUG #13845: Incorrect week number