Re: corrupted item pointer:???

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: corrupted item pointer:???
Дата
Msg-id 19986.1144939639@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: corrupted item pointer:???  ("hubert depesz lubaczewski" <depesz@gmail.com>)
Ответы Re: corrupted item pointer:???  ("hubert depesz lubaczewski" <depesz@gmail.com>)
Список pgsql-general
"hubert depesz lubaczewski" <depesz@gmail.com> writes:
> On 4/13/06, Richard Huxton <dev@archonet.com> wrote:
>> Hmm - I believe that means a data/index block was corrupted.

> indices were recreated (reindex table), so i think this is data related
> problem.

AFAICS, the only non-index-related occurrence of that error message
is in PageRepairFragmentation, which is invoked by VACUUM.  I'd say
it indicates a real problem and you shouldn't ignore it.  You might
try using pg_filedump or some such to examine the table and see if
there's anything obvious about what happened to the corrupted page.

            regards, tom lane

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: table as hashtable
Следующее
От: "Peter L. Berghold"
Дата:
Сообщение: Re: posting request