Re: Duplicate values found when reindexing unique index - Mailing list pgsql-bugs

From Mason Hale
Subject Re: Duplicate values found when reindexing unique index
Date
Msg-id 8bca3aa10712311048m5bc9fff4kf5261ea444631270@mail.gmail.com
Whole thread Raw
In response to Re: Duplicate values found when reindexing unique index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Duplicate values found when reindexing unique index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
>
> Something else interesting about that: the apparent interloper page
> contains just a single WAL record, which appears to be a shutdown
> checkpoint bearing the timestamp "Thu Dec 27 2007, 16:55:01 EST".
> Not sure if Mason can correlate that with any recent activity...
>

Nothing jumps to mind, but I'll crawl through the logs looking for anything
interesting.

I'm starting to think that Occam's razor says you've got hardware
> problems.  Or maybe a kernel-level bug that is causing writes to get
> discarded.
>

For what its worth, we do closely monitor the server for RAID and kernel
errors and haven't seen either variety reported in quite some time.

If it is some mysterious hardware or kernel error -- any suggestions for how
I should go about narrowing that down?

Finally, if it would help to see the full wal segment files, let me know and
I will email individually. (I assume the list doesn't want 32MB of
attachments).

Mason

pgsql-bugs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Duplicate values found when reindexing unique index
Next
From: Tom Lane
Date:
Subject: Re: Duplicate values found when reindexing unique index