Re: BUG #7648: Momentary index corruption while in hot standby

From: Daniel Farina <daniel(at)heroku(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7648: Momentary index corruption while in hot standby
Date: 2012-11-10 00:29:27
Message-ID: CAAZKuFbXv=e=27-8-eeBoUCia5yYvqSa+GS52GwOCAMFvESVeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Nov 9, 2012 at 4:16 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> On 2012-11-09 15:57:06 -0800, Daniel Farina wrote:
>> This is the only known occurrence to me, ever, but given it's
>> incredibly ephemeral nature probably glossed over most of the time, I
>> can't say "it's the only time it's ever happened".
>
> I wish we had some way to easily discern such "something is wrong" error
> from other ERRORs that are expected during normal operation..

Me too. Database clients finding these unambiguously platform-level
problems and being relied upon to report them to receive treatment is
a long-standing embarrassment to me. However, I've been way too
swamped to even start thinking of how one would disentangle error
reporting suitable for physical issues from logical issues. Clearly
it is *possible* (most error sites are fairly clear being in one
category or the other), but the carefully considered upheaval to the
logging system is beyond my mind's reach for now.

It's a weakness we've kicked around the office here a few times with
much regret that nobody has the necessary remaining attention to
attack it.

--
fdr

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2012-11-10 11:47:28 Re: BUG #7648: Momentary index corruption while in hot standby
Previous Message Andres Freund 2012-11-10 00:16:26 Re: BUG #7648: Momentary index corruption while in hot standby