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

From hubert depesz lubaczewski
Subject Re: corrupted item pointer:???
Date
Msg-id 9e4684ce0604140156j591abdfcm699a65bebfa013b8@mail.gmail.com
Whole thread Raw
In response to Re: corrupted item pointer:???  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: corrupted item pointer:???
List pgsql-general
On 4/13/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
pg_filedump will complain about a bad item pointer (looks like the
message will be something about "Error: Item contents extend beyond block")

the problematic table spans over 3 files (18026 18026.1 and 18026.2).
i made pg_filedump _FILE_ > ~/_FILE_.dump
it went fine
grep -i error ~/*.dump also didn't show anything.
the dumps are quite large:
pgdba@lab02:~$ ls -l *.dump
-rw-r--r--  1 pgdba pgdba 154631630 2006-04-14 18:03 18026.1.dump
-rw-r--r--  1 pgdba pgdba 108808017 2006-04-14 18:03 18026.2.dump
-rw-r--r--  1 pgdba pgdba 161625849 2006-04-14 18:01 18026.dump

what else can i look in it for?

best regards

hubert

pgsql-general by date:

Previous
From: "hubert depesz lubaczewski"
Date:
Subject: Re: corrupted item pointer:???
Next
From: Achilleus Mantzios
Date:
Subject: Kernel 2.4->2.6 upgrade results in PANIC: could not locate a valid checkpoint record