From: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: "invalid page header in block 597621 of relation..."error |
Date: | 2005-11-26 16:26:56 |
Message-ID: | BFAE3D50.52C67%awitney@sgul.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 26/11/05 4:14 pm, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Adam Witney <awitney(at)sgul(dot)ac(dot)uk> writes:
>> pg_dump: ERROR: unexpected chunk number 5153 (expected 21) for toast value
>> 245334402
>
>> measured_bioassay_base is always inserted at the same time as mba_data_base
>> (the table where I had the problem before) and it has a text field which is
>> very large..
>
> How large is "very large" ... on the order of 10Mb? If so I'd say this
> is the same problem as we saw in your table --- a lot of consecutive
> rows have gone missing. You could examine the toast table to confirm
> or deny this.
Yes, around 10Mb is about right.
I deleted the two datasets in mba_data_base that were affected by the empty
pages, I also deleted the relevant two rows in measured_bioassay_base... But
maybe it didn't do the right thing with the toast table for these two rows?
Where would I need to look to see what the problem is?
Thanks again for the help.
Adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-26 16:28:38 | Re: GRANT question |
Previous Message | Tom Lane | 2005-11-26 16:14:41 | Re: "invalid page header in block 597621 of relation..."error |