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

Re: Missing chunks from my toast...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Scott Whitney" <swhitney(at)journyx(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Missing chunks from my toast...
Date: 2008-06-20 16:40:55
Message-ID: 20568.1213980055@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Scott Whitney" <swhitney(at)journyx(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Scott WhitneyDate: 2008-06-20 17:08:13
Subject: Re: Missing chunks from my toast...
Previous:From: Scott WhitneyDate: 2008-06-20 16:18:17
Subject: Missing chunks from my toast...

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