Re: unable to dump database, toast errors

On Thu, 3 Apr 2003, Tom Lane wrote:
> Lonni J Friedman <lfriedman(at)vasoftware(dot)com> writes:
> >> The real question is did pg_dump get any better after you did this?
>
> > unfortunately, no.

thanks for your reply.

> Oh well. Have you checked that the reportedly-broken index is in fact
> the index for the TOAST table associated with the artifact_file table?
> (artifact_file's pg_class row will have the OID of its toast table in
> reltoastrelid, and then the reltoastidxid field of the toast table's
> row is the OID of its index.) It could be that you've got more than
> one problem :-(

i'm not sure that i'm following you 100% here. I'm able to dig this up:

# select * from pg_class where relname='artifact_file';
relname | reltype | relowner | relam | relfilenode | relpages |
reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared |
relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys |
relrefs | relhasoids | relhaspkey | relhasrules | relhassubclass | relacl
---------------+---------+----------+-------+-------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+--------
artifact_file | 302324 | 100 | 0 | 302323 | 20 |
786 | 302325 | 0 | t | f | r
| 9 | 0 | 0 | 0 | 0 | 0 | t
| t | f | f |

so, am i off base?

> If you've actually lost a chunk from a toast value, as seems probable,
> I can't think of much to do except manually insert a substitute chunk.
> It would run something like
>
> insert into pg_toast_302323 values (7685119, 0, '');

oddly on today's dump attempt, it fails with the following:
pg_dump: ERROR: missing chunk number 1 for toast value 7685119

so i tried:
insert into pg_toast_302323 values (7685119, 1, '');

but that fails:
ERROR: You can't change toast relation pg_toast_302323

> I am somewhat curious as to what happened to the missing chunk, but
> I dunno how much effort you want to spend on investigation. A minimum
> bit of prudence would be to update this installation to 7.2.4; we don't
> make dot-releases just for amusement.

yea, i know. unfortunately, this is a customer's server, and its been an
uphill battle to get them to do any sane maintanence.

thanks for your help,
Lonni