Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 - Mailing list pgsql-performance

From Simon Riggs
Subject Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
Date
Msg-id BANLkTikYU9QhkSmVG-H_RMRWZHvef5V5Xw@mail.gmail.com
Whole thread Raw
In response to Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226  (Sethu Prasad <sethuprasad.in@gmail.com>)
Responses Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226  (Sethu Prasad <sethuprasad.in@gmail.com>)
List pgsql-performance
On Tue, May 3, 2011 at 10:02 AM, Sethu Prasad <sethuprasad.in@gmail.com> wrote:

> I tried with the PostgreSQL 9.0.4 + Hot Standby and running the database
> from Fusion IO Drive to understand the PG Performance.
>
> While doing so I got the "Query failed ERROR: catalog is missing 1
> attribute(s) for relid 172226". Any idea on this error? Is that combination
> PG + HotSB + Fusion IO Drive is not advisable?!

Why I wonder do you think this might have anything to do with Hot
Standby and/or FusionIO drives?

This indicates either catalog or catalog index corruption of some kind.

Did you only get this error once?

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: REINDEX takes half a day (and still not complete!)
Next
From: Mark
Date:
Subject: Re: Query improvement