Re: Corrupted index file after restoring WAL on warm spare server

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Corrupted index file after restoring WAL on warm spare server
Дата
Msg-id 20079.1180036593@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Corrupted index file after restoring WAL on warm spare server  ("Michael Nolan" <htfoot@gmail.com>)
Ответы Re: Corrupted index file after restoring WAL on warm spare server
Список pgsql-general
"Michael Nolan" <htfoot@gmail.com> writes:
> Howevever, when I go to access one table, the index appears to be corrupted
> because the record I get for one query doesn't match the record key I give.

> Reindexing that table on the warm spare system fixes the problem.

> I redid setting up the warm spare server a second time to see if it was a
> one-time anomaly, but I have the exact same condition again.

> What could be causing this?  If this is a bug, what can I do to help track
> it down?

It sounds like you have a reproducible test case --- can you make it
available to someone else?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "A.M."
Дата:
Сообщение: Re: why postgresql over other RDBMS
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: why postgresql over other RDBMS