Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673
Дата
Msg-id 26683.1231445085@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-bugs
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Thu, 2009-01-08 at 14:19 -0500, Tom Lane wrote:
>> If the btree in question is a critical system index, your value of
>> "work" is going to be pretty damn small.

> So if its a system index we can throw a PANIC, else just LOG. Whilst a
> corrupt index is annoying in the extreme, a total server outage is not
> something we should allow. IMHO.

I think an appropriate solution would be to institute some mechanism
that forces a reindex of the corrupted index at completion of recovery.
Merely fooling around with message severity levels doesn't fix anything
at all, it just opens the door to more trouble than you've already got.

Whether this is important enough to get done in the near future is
a different discussion...

            regards, tom lane

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: PANIC: failed to re-find parent key in "100924" for split pages 1606/1673
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #4494: Memory leak in pg_regress.c