Re: Duplicate values found when reindexing unique index

Поиск
Список
Период
Сортировка
От Mason Hale
Тема Re: Duplicate values found when reindexing unique index
Дата
Msg-id 8bca3aa10712311048m5bc9fff4kf5261ea444631270@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Duplicate values found when reindexing unique index  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Duplicate values found when reindexing unique index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Duplicate values found when reindexing unique index
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Duplicate values found when reindexing unique index