Re: unable to dump database, toast errors

From: Lonni J Friedman <lfriedman(at)vasoftware(dot)com>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: unable to dump database, toast errors
Date: 2003-04-07 14:33:01
Message-ID: Pine.LNX.4.44.0304070716530.1680-100000@beefcake.hdqt.vasoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 7 Apr 2003, Manfred Koizar wrote:
> On Mon, 07 Apr 2003 07:34:47 -0400, Jan Wieck <JanWieck(at)Yahoo(dot)com>
> wrote:
> >Is there any of those other columns that could identify a single row
> >uniquely? If so, that could work as a key for this purpose.
> >
> >If you have that, let's call it <keycolumn>.
>
> Lonni,
>
> let me add that if there is no such *user* column, you can always use
> the system column ctid:
>
> SELECT ctid FROM artifact_file LIMIT 1 OFFSET 694;
>
> ctid
> --------
> (42,7)
>
> Now check whether this is really your broken tuple:
>
> SELECT length(bin_data) FROM artifact_file
> WHERE ctid = '(42,7)'; -- should give an ERROR
>
> ... and that all other tuples are ok as suggested by Jan:
>
> SELECT sum(length(bin_data)) FROM artifact_file
> WHERE NOT ctid = '(42,7)'; -- should work
>
> Note that you have to use 'NOT ctid =', because operator '!=' is not
> defined for datatype tid.

thanks for your reply.

# select ctid from artifact_file LIMIT 1 OFFSET 694;
ctid
---------
(16,33)

# select LENGTH(bin_data) from artifact_file where ctid='(16,33)';
ERROR: missing chunk number 1 for toast value 7685119

# select sum(length(bin_data)) from artifact_file where NOT
ctid='(16,33)';
sum
-----------
293963428

So, where do i go from here? Is it now just a matter of nullifying
bin_data for that particular row, or is it more involved? thanks.

-Lonni

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Langille 2003-04-07 14:40:53 Re: possible time change issue - known problem?
Previous Message Tom Lane 2003-04-07 14:32:36 Re: possible time change issue - known problem?