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

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Sethu Prasad <sethuprasad(dot)in(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
Date: 2011-05-08 09:08:20
Message-ID: BANLkTikYU9QhkSmVG-H_RMRWZHvef5V5Xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, May 3, 2011 at 10:02 AM, Sethu Prasad <sethuprasad(dot)in(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Florian Weimer 2011-05-09 07:57:18 Re: indexes ignored when querying the master table
Previous Message Mark 2011-05-07 10:39:52 Re: Query improvement