Re: Data problem - error "invalid attribute number # for <tablename>"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sebastien Boisvert <sebastienboisvert(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Data problem - error "invalid attribute number # for <tablename>"
Date: 2009-09-29 18:03:07
Message-ID: 20482.1254247387@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Sebastien Boisvert <sebastienboisvert(at)yahoo(dot)com> writes:
>> Hmm, no sign of any such row here ... try reindexing pg_attribute.

> It gets more interesting:

> MCS=# reindex table pg_attribute;
> ERROR: could not access status of transaction 276828288
> DETAIL: Could not open file "pg_subtrans/1080": No such file or directory.

So you've got some amount of corruption in pg_attribute --- probably
more than just one row affected. You're fortunate that only one table
was not dumpable.

If you have a reasonably recent backup for that table, I agree that
further effort probably isn't warranted.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aras Angelo 2009-09-29 18:42:49 high loads, fine tuning
Previous Message Sebastien Boisvert 2009-09-29 17:54:11 Re: Data problem - error "invalid attribute number # for <tablename>"