Re: 8.2.3 PANIC with "corrupted item pointer"

Поиск
Список
Период
Сортировка
От Henk - CityWEB
Тема Re: 8.2.3 PANIC with "corrupted item pointer"
Дата
Msg-id Pine.LNX.4.58.0706212014070.16846@isp.org.za
обсуждение исходный текст
Ответ на Re: 8.2.3 PANIC with "corrupted item pointer"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Thu, 21 Jun 2007, Tom Lane wrote:

> "Henka" <henka@cityweb.co.za> writes:
> > I happened to notice this error in the log when my application was refused
> > a db connection (quite unexpectedly):
>
> > PANIC:  corrupted item pointer: offset = 3308, size = 28
> > LOG:  autovacuum process (PID 18165) was terminated by signal 6
>
> FWIW, the only occurrences of that specific message text are in
> PageIndexTupleDelete and PageIndexMultiDelete, so you can be pretty sure
> that this is just a corrupted-index problem.  Once you've identified
> which table has the problem, a REINDEX should fix it.
>
> I concur with the other comments that a crash with fsync off might well
> have allowed more corruption than just this to sneak in, though :-(

Thanks for the comments, Tom.  I've started the reindex on the offending
index, so let's see how it goes.

I think once that's done, and I'm able to dump-all without error, I'll
upgrade to 8.2.4 and perform a restore.  That process should
uncover any other funnies.

Regards
Henry

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

Предыдущее
От: Germán Hüttemann Arza
Дата:
Сообщение: Throwing exceptions
Следующее
От: Henk - CityWEB
Дата:
Сообщение: Re: 8.2.3 PANIC with "corrupted item pointer"