From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Missing chunks from my toast...
Date: Fri, 20 Jun 2008 12:40:55 -0400
Message-ID: <20568.1213980055@sss.pgh.pa.us> (raw)
In-Reply-To: <20080620161501.2855E3E2165@mail.int.journyx.com>
References: <20080620161501.2855E3E2165@mail.int.journyx.com>
"Scott Whitney" <swhitney@journyx.com> writes:
> 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.
You forgot the attachments, but did you reindex the table itself, or its
toast table? The former cannot fix this, the latter might possibly.
Easiest way to get the toast table name is
select reltoastrelid::regclass from pg_class where relname = 'mytable';
(if you've got more than one table with the same name, obviously you
need to add a condition on schema as well). You'll probably need to be
superuser to reindex it.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, swhitney@journyx.com
Subject: Re: Missing chunks from my toast...
In-Reply-To: <20568.1213980055@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox