| From: | "hubert depesz lubaczewski" <depesz(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Richard Huxton" <dev(at)archonet(dot)com>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: corrupted item pointer:??? |
| Date: | 2006-04-14 08:56:21 |
| Message-ID: | 9e4684ce0604140156j591abdfcm699a65bebfa013b8@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/13/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2006-04-14 10:26:02 | Kernel 2.4->2.6 upgrade results in PANIC: could not locate a valid checkpoint record |
| Previous Message | hubert depesz lubaczewski | 2006-04-14 08:49:39 | Re: corrupted item pointer:??? |