From: | Chris Purcell <chris(dot)purcell(dot)39(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | Sunir Shah <sunir(at)sunir(dot)org> |
Subject: | Unexpected chunk number |
Date: | 2006-09-12 10:43:48 |
Message-ID: | CF8C8965-5629-488D-A6CB-DBBCF669FF38@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
On running pg_dump, I am consistently getting the following errors:
pg_dump: ERROR: unexpected chunk number 2 (expected 0) for toast
value 223327
pg_dump: SQL command to dump the contents of table "pagecache"
failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR: unexpected chunk number 2
(expected 0) for toast value 223327
pg_dump: The command was: COPY meatballwiki.pagecache (page,
lastmodified, response) TO stdout;
I am running psql 8.1.4. The disk storing the database was recently
corrupted, and we restored from an old image; I appreciate this is
likely to have triggered the error. What I'm interested in is how to
fix it!
I've tried a simple `VACUUM ANALYZE FULL`, I've done `REINDEX
DATABASE foo`, and I've stopped and started postmaster (all in that
order). Nothing has helped. I've looked at the pgsql mailing list
archives, but so far can find no solution that fits; for instance, I
cannot find any tables under pg_toast., so cannot use the thread at
http://archives.postgresql.org/pgsql-admin/2005-09/msg00057.php
Any help would be most appreciated!
Cheers,
Chris Purcell
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Kaltenbrunner | 2006-09-12 10:48:44 | Re: Unexpected chunk number |
Previous Message | stig erikson | 2006-09-11 19:32:38 | Re: bitmap index scan problem? |