Re: Problems with vacuum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with vacuum
Дата
Msg-id 1331.976300728@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problems with vacuum  ("Timothy H. Keitt" <Timothy.Keitt@SUNYSB.Edu>)
Список pgsql-general
"Timothy H. Keitt" <Timothy.Keitt@SUNYSB.Edu> writes:
> NOTICE:  Rel bbs_counts: TID 6257/6: OID IS INVALID. TUPGONE 1.
> NOTICE:  Rel bbs_counts: TID 6257/7: OID IS INVALID. TUPGONE 1.
> NOTICE:  Rel bbs_counts: TID 6257/8: OID IS INVALID. TUPGONE 1.
> NOTICE:  Rel bbs_counts: TID 6257/9: OID IS INVALID. TUPGONE 1.
> NOTICE:  Rel bbs_counts: TID 6257/11: OID IS INVALID. TUPGONE 1.

Hmm.  Looks like you've got a clobbered page in that relation.
Page 6257 to be exact (remember these are 8K pages, and the first page
in the table is page zero).  Can you dump it out with dd and od,
or some similar tools, and see what's there?

Has anything unusual happened lately in this database?  Crashes, etc?

            regards, tom lane

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

Предыдущее
От: "Timothy H. Keitt"
Дата:
Сообщение: Problems with vacuum
Следующее
От: "Mayers, Philip J"
Дата:
Сообщение: Help interpreting the output of EXPLAIN