Re: ERROR: catalog is missing 2 attribute(s) for relid 16584

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Prakash Itnal <prakash074(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: catalog is missing 2 attribute(s) for relid 16584
Date: 2012-05-22 13:22:12
Message-ID: CA+Tgmoa1xtofOU0SQD14MCxEiBA-xiFfEwWxqoSVg2mh=sLs6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, May 14, 2012 at 1:01 AM, Prakash Itnal <prakash074(at)gmail(dot)com> wrote:
> Recently we faced an issue with postgres server where it is throwing error:
>
> ERROR:  catalog is missing 2 attribute(s) for relid 16584
> CONTEXT:  automatic analyze of table "DBRNW.public.act_wsta"
>
> I checked in the database and found that this table is not present but the
> entry for the same is present in 'pg_tables'. This error is occuring when
> auto analyze is executed.
>
> I searched for the issue in postgres blogs and found that there is no way to
> recover from this situation except restore from last backup!! I wanted to
> confirm is there any way to recover at run time? because if we restore from
> last backup then we might loose some data that got updated after this error
> occurred.
>
> Any help would be appreciated.

It sounds like you are missing a couple of pg_attribute entries. You
might be able to figure out what's missing and put them back, but of
course whatever got your system into this state might have also caused
other corruption...

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Albe Laurenz 2012-05-22 13:27:50 Re: Changing the concept of a DATABASE
Previous Message Robert Haas 2012-05-22 13:20:58 Re: hot standby PSQL 9.1 Windows 2008 Servers