From: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
---|---|
To: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk>, 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 10:49:09 |
Message-ID: | BFADEE25.52C48%awitney@sgul.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 24/11/05 5:27 pm, "Adam Witney" <awitney(at)sgul(dot)ac(dot)uk> wrote:
> On 24/11/05 5:28 pm, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Adam Witney <awitney(at)sgul(dot)ac(dot)uk> writes:
>>> Does this help identifying what went wrong?
>>
>> At this point I think there's no question that your filesystem is
>> dropping blocks :-(. Might want to check for available kernel updates,
>> or contemplate changing to a different filesystem.
Ok I think this problem is not entirely fixed, my backups are failing now
with this:
pg_dump: ERROR: unexpected chunk number 5153 (expected 21) for toast value
245334402
pg_dump: SQL command to dump the contents of table "measured_bioassay_base"
failed: PQendcopy() failed.
pg_dump: Error message from server: 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.. I guess this is where the TOAST comes in.
Any ideas what is going on here?
Thanks again for any 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 | Együd Csaba (Freemail) | 2005-11-26 13:50:29 | Re: Syntax Error in COPY - worked around |
Previous Message | Wes | 2005-11-26 03:29:19 | Re: Deadlock Detected (revisited) |