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: Heikki Linnakangas <hlinnakangas(at)vmware(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 23:07:37
Message-ID: CAL_0b1tVmywdzJn=yA2dBY0sEF--rcrBAfZGCco3yFQRQ9wLLw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Fri, Dec 20, 2013 at 12:09 PM, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:
> On 2013-12-20 12:01:55 -0800, Sergey Konoplev wrote:
>> For me it looks like something completely different from the
>> Tomonari's bug. I does not have problems with restarting and it always
>> has something to do with vacuum. The error message is the same every
>> time it breaks down:
>
> Well, you didn't mention that it wasn't related to restarts before. You
> said that you just had re-cloned the standby, so assuming a restart
> isn't unreasonable.

I tried to reproduce the Tomonari's bug after Heikki pointed me on it,
and nothing like described in those thread has happened.

>> Also, the issue is reproducible on the production site of a big
>> enterprise company and it is always a long lasting pain to negotiate
>> and deploy even a little patch. So I would like to ask you to review
>> this issue more carefully before I start the negotiation process,
>> please.
>
> I have to say, attitude-wise, I find that statement a bit
> problematic. You're working with the community here, not somebody you're
> paying.

Sure, I realize it. I am from the open-source world a little bit too.
Just wanted to make sure that everything that could be done is done.
Sorry if I said something wrong.

--
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Greg Stark 2013-12-21 01:11:39 Re: Duplicate key violates unique constraint
Previous Message cbfgterfdy 2013-12-20 21:12:11 Re: BUG #8662: psql -H and ts_headline

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Flower 2013-12-20 23:09:03 Re: make_interval ??
Previous Message Peter Geoghegan 2013-12-20 22:11:41 Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE