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

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: 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>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Subject: Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages
Date: 2013-12-19 23:13:25
Message-ID: CAL_0b1tL-mciZZ8GyZj4HVbny5fPO0ZN8XkJ+RTyJb9oisyBYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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?

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Stark 2013-12-20 00:19:16 Re: BUG #8656: Duplicate data violating unique constraints
Previous Message Andres Freund 2013-12-19 23:04:07 Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages

Browse pgsql-hackers by date

  From Date Subject
Next Message Adrian Klaver 2013-12-19 23:19:32 Re: pg_upgrade & tablespaces
Previous Message Andres Freund 2013-12-19 23:09:38 Re: clang's -Wmissing-variable-declarations shows some shoddy programming