Re: corrupted item pointer:??? - Mailing list pgsql-general

From Tom Lane
Subject Re: corrupted item pointer:???
Date
Msg-id 19986.1144939639@sss.pgh.pa.us
Whole thread Raw
In response to Re: corrupted item pointer:???  ("hubert depesz lubaczewski" <depesz@gmail.com>)
Responses Re: corrupted item pointer:???  ("hubert depesz lubaczewski" <depesz@gmail.com>)
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: table as hashtable
Next
From: "Peter L. Berghold"
Date:
Subject: Re: posting request