pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
7+ messages / 4 participants
[nested] [flat]
* Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
@ 2011-05-03 09:02 Sethu Prasad <sethuprasad.in@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Sethu Prasad @ 2011-05-03 09:02 UTC (permalink / raw)
To: pgsql-performance
Hi,
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?!
Regards,
Sethu Prasad. G.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
@ 2011-05-04 18:44 Josh Berkus <josh@agliodbs.com>
parent: Sethu Prasad <sethuprasad.in@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Josh Berkus @ 2011-05-04 18:44 UTC (permalink / raw)
To: pgsql-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?!
What were you doing when you got this error?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
@ 2011-05-05 07:47 Sethu Prasad <sethuprasad.in@gmail.com>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 7+ messages in thread
From: Sethu Prasad @ 2011-05-05 07:47 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance
I did the hot standby configured earlier and at that time I started
using(querying) the standby database.
May be something missed on the archive command.
On Wed, May 4, 2011 at 8:44 PM, Josh Berkus <josh@agliodbs.com> wrote:
>
> > 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?!
>
> What were you doing when you got this error?
>
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
@ 2011-05-08 09:08 Simon Riggs <simon@2ndQuadrant.com>
parent: Sethu Prasad <sethuprasad.in@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Simon Riggs @ 2011-05-08 09:08 UTC (permalink / raw)
To: Sethu Prasad <sethuprasad.in@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
@ 2011-05-09 23:30 Josh Berkus <josh@agliodbs.com>
parent: Sethu Prasad <sethuprasad.in@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Josh Berkus @ 2011-05-09 23:30 UTC (permalink / raw)
To: Sethu Prasad <sethuprasad.in@gmail.com>; +Cc: pgsql-performance
On 5/5/11 12:47 AM, Sethu Prasad wrote:
> I did the hot standby configured earlier and at that time I started
> using(querying) the standby database.
>
> May be something missed on the archive command.
Most likely, yes. PostgreSQL shouldn't start up under such
circumstances, but apparently you fooled it.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
@ 2011-05-10 07:23 Sethu Prasad <sethuprasad.in@gmail.com>
parent: Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 1 reply; 7+ messages in thread
From: Sethu Prasad @ 2011-05-10 07:23 UTC (permalink / raw)
To: Simon Riggs <simon@2ndquadrant.com>; +Cc: pgsql-performance
Yes it has something to do with Hot Standby, if you omit some parts on the
archive then the standby instance will not have the necessary stuff and
complain like this..
I kept the FusionIO drive in my checklist while attending to this issue, as
we tried it looking for performance combined with read-only hot standby and
in doubt I thought that the recovery is not successful on this drive safely.
so I pointed that Fio Drive here.
Straight to say, I missed the pg_clog directory on archive.
seq_page_cost = 1.0
random_page_cost = 1.0
Is the above settings are fine when we deal with Fio and Performance, as I
have the advice earlier stating that read and write are treated same with
Fio drives.
Any suggestions on configuration changes to have read-only hot standby
faster on READs.
- Sethu
On Sun, May 8, 2011 at 11:08 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> 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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226
@ 2011-05-15 20:34 Robert Haas <robertmhaas@gmail.com>
parent: Sethu Prasad <sethuprasad.in@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Robert Haas @ 2011-05-15 20:34 UTC (permalink / raw)
To: Sethu Prasad <sethuprasad.in@gmail.com>; +Cc: Simon Riggs <simon@2ndquadrant.com>; pgsql-performance
On Tue, May 10, 2011 at 3:23 AM, Sethu Prasad <sethuprasad.in@gmail.com> wrote:
> Yes it has something to do with Hot Standby, if you omit some parts on the
> archive then the standby instance will not have the necessary stuff and
> complain like this..
If you omit some parts of the archive, it won't start at all. To get
it to complain like this, you need something more than accidental
misconfiguration.
> I kept the FusionIO drive in my checklist while attending to this issue, as
> we tried it looking for performance combined with read-only hot standby and
> in doubt I thought that the recovery is not successful on this drive safely.
> so I pointed that Fio Drive here.
>
> Straight to say, I missed the pg_clog directory on archive.
>
> seq_page_cost = 1.0
>
> random_page_cost = 1.0
>
> Is the above settings are fine when we deal with Fio and Performance, as I
> have the advice earlier stating that read and write are treated same with
> Fio drives.
I would think more like 0.1 than 1.0.
> Any suggestions on configuration changes to have read-only hot standby
> faster on READs.
effective_io_concurrency?
Adjust OS readahead?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2011-05-15 20:34 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-03 09:02 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>
2011-05-04 18:44 ` Josh Berkus <josh@agliodbs.com>
2011-05-05 07:47 ` Sethu Prasad <sethuprasad.in@gmail.com>
2011-05-09 23:30 ` Josh Berkus <josh@agliodbs.com>
2011-05-08 09:08 ` Simon Riggs <simon@2ndQuadrant.com>
2011-05-10 07:23 ` Sethu Prasad <sethuprasad.in@gmail.com>
2011-05-15 20:34 ` Robert Haas <robertmhaas@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox