Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>, Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>, Максим Панченко <Panchenko(at)gw(dot)tander(dot)ru>, Сизов Сергей Павлович <sizov_sp(at)gw(dot)tander(dot)ru>, Tomonari Katsumata <katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp>
Subject: Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages
Date: 2013-12-20 19:34:30
Message-ID: 52B49BC6.3030406@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On 12/20/2013 01:13 AM, Sergey Konoplev wrote:
> On Thu, Dec 19, 2013 at 3:04 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
>> On 2013-12-19 14:37:04 -0800, Sergey Konoplev wrote:
>>> It was suffering from this problem on 9.2.4, mostly last couple of
>>> weeks when I had to rebuild the replica almost every 3 days, and I
>>> hoped it would be fixed in 9.2.6, but it is not.
>>
>> This actually is a separate bug from the one fixed. Not that the CONTEXT
>> message isn't talking about "visible" but about "vacuum".
>
> Oh, I see. I have completely lost in these bugs last several months.
>
> Are there anything I can do to prevent it except waiting for a patch?

I wonder if this might be the same bug Tomonari Katsumata reported
yesterday:
http://www.postgresql.org/message-id/E1VtTni-00082E-Jv@wrigleys.postgresql.org.
Since this keeps happening to you, could you try the patch he posted and
see if it helps?

- Heikki

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergey Konoplev 2013-12-20 20:01:55 Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages
Previous Message Heikki Linnakangas 2013-12-20 16:15:09 Re: BUG #8686: Standby could not restart.

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2013-12-20 19:36:20 Re: GIN improvements part 1: additional information
Previous Message Andres Freund 2013-12-20 19:33:52 Re: shared memory message queues