Skip site navigation (1) Skip section navigation (2)

Missing chunks from my toast...

From: "Scott Whitney" <swhitney(at)journyx(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Missing chunks from my toast...
Date: 2008-06-20 16:18:17
Message-ID: 20080620161501.2855E3E2165@mail.int.journyx.com (view raw or flat)
Thread:
Lists: pgsql-admin
There goes my breakfast...

pg_dump: ERROR:  missing chunk number 0 for toast value 110439697
pg_dump: SQL command to dump the contents of table "attachments" failed:
PQendcopy() failed.
pg_dump: Error message from server: ERROR:  missing chunk number 0 for toast
value 110439697
pg_dump: The command was: COPY public.attachments (id, transactionid,
parent, messageid, subject, filename, contenttype, contentencoding, content,
headers, creator, created) TO stdout;


I've tried reindexing this table (attachments), to no avail. Is there any
way I can fix this db. This is not on a mission-critical machine, but it is
a business-critical db. I can take it up and down as necessary.


Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2008-06-20 16:40:55
Subject: Re: Missing chunks from my toast...
Previous:From: GeoffreyDate: 2008-06-20 15:56:45
Subject: Re: where would I find the files I need?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group