I have pg segfaults on two boxes, a DL160G6 and a DL380g5.
I've just checked their memory with memtest86+ v2.11
No errors were detected.
We also monitor the boxes via IPMI, and there are no signs
of HW failures.
Regards,
Daniel
Tom Lane wrote:
> Nagy Daniel <nagy.daniel@telekom.hu> writes:
>> I ran "select * from" on both tables. All rows were returned
>> successfully, no error logs were produced during the selects.
>
> Well, that would seem to eliminate the initial theory of on-disk
> corruption, except that these *other* symptoms that you just mentioned
> for the first time look a lot like index corruption. I concur with
> Pavel that intermittent hardware problems are looking more and more
> likely. Try a memory test first --- a patch of bad RAM could easily
> produce symptoms like this.
>
>> Apart from that, I think that pg shouldn't crash in case of
>> on-disk corruptions, but log an error message instead.
>
> There is very little that software can do to protect itself from
> flaky hardware :-(
>
> regards, tom lane