Re: BUG #8347: PANIC: heap_insert_redo: failed to add tuple when applying WAL - Mailing list pgsql-bugs

From Klaus Ita
Subject Re: BUG #8347: PANIC: heap_insert_redo: failed to add tuple when applying WAL
Date
Msg-id CAK9oVJzi12t+fkrmNzJ3kA-TZeBNibFocoBOUevb+-VygCGG+Q@mail.gmail.com
Whole thread Raw
In response to Re: BUG #8347: PANIC: heap_insert_redo: failed to add tuple when applying WAL  (Maciek Sakrejda <maciek@heroku.com>)
Responses Re: BUG #8347: PANIC: heap_insert_redo: failed to add tuple when applying WAL
List pgsql-bugs
Isn't it a funny coincidence, that we also had a corruption of that
same/similar type?

my disk was quite confidently not tampered. I am wondering: Does PG sign,
or checksum wal_files? Is the integrity of wal_files ensured by any
mechanism? Because if it IS, then - in our case - it's a corruption caused
BY the postgres master server. I can replay the wal's and re-create the
same error over and over.

lg,k


On Thu, Aug 1, 2013 at 11:13 PM, Maciek Sakrejda <maciek@heroku.com> wrote:

> On Tue, Jul 30, 2013 at 9:28 PM, Andres Freund <andres@2ndquadrant.com>wrote:
>
>> Any chance you could https://github.com/snaga/xlogdump that and the
>> neighbouring segments? That might tell us whether we're dealing with
>> broken locking or possibly disk corruption (doesn't sound too likely).
>>
>
> Actually, we did find what looks like some pretty crazy disk corruption
> after I reported this (heap tuple data in pg_clog files). I'm surprised
> Postgres did not wig out more, actually. I can run xlogdump later this week
> if it's still of interest, but I'm pretty satisfied that this was not
> Postgres' fault.
>
> Incidentally, the system performed admirably in the course of the
> recovery, considering the severely compromised state of heap and clog data.
> I'm really glad we're using Postgres.
>

pgsql-bugs by date:

Previous
From: Vik Fearing
Date:
Subject: Re: BUG #8352: Using UPPER in ON clause of JOIN
Next
From: Daniel Farina
Date:
Subject: Re: BUG #8347: PANIC: heap_insert_redo: failed to add tuple when applying WAL