missing chunk number 0 for toast value ...

From: MIlos Prudek <prudek(at)bvx(dot)cz>
To: pgsql-admin(at)postgresql(dot)org
Subject: missing chunk number 0 for toast value ...
Date: 2006-05-03 20:02:57
Message-ID: 200605032202.57825.prudek@bvx.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello postgres wizards :-)

I have a problem with table info:

select * from info;
ERROR: missing chunk number 0 for toast value 190937

Dumping does not work either:

pg_dump db >db.unl
pg_dump: ERROR: missing chunk number 0 for toast value 190937
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "info" failed: PQendcopy()
failed.
pg_dump: Error message from server: pg_dump: The command was: COPY public.info
(idsection, idinfo, txt) TO stdout;

I googled, and using advice in an archived post I run the following command:
select relname from pg_class where oid =
(select reltoastrelid from pg_class where relname = 'info');

which resulted in one row with value pg_toast_61934

and then I ran

reindex table pg_toast.pg_toast_61934;

but it did not help.

What should I do to salvage the table?

--
Milos Prudek

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-05-03 20:40:17 Re: missing chunk number 0 for toast value ...
Previous Message Hogan, James F. Jr. 2006-05-03 19:39:51 audit table containing Select statements submitted