From: Bruno Cortes <bcc@mail.pt>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruno Cortes <bcc@mail.pt>
Cc: pgsql-admin@postgresql.org
Subject: Re: FATAL: catalog is missing attributes
Date: Tue, 25 Apr 2006 09:00:08 +0000
Message-ID: <20060425080651.68C4111F61C2@postgresql.org> (raw)
Yes I suppose that was the problem...the harwdare failure was responsible
for the corrupted pg_attribute.
But I was suprise because I had a RAID 0/1 and the data got corrupted on
the second disk as well.
I am now trying to restore things from last backup and transaction logs.
Thanks all.
Regards
Bruno Cortes
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Bruno Cortes wrote:
> >> This was even worse than the previous error. Right now I cannot enter
> >> the database neither make a dump. When I execute a command such as
"psql
> >> -U postgres center-01" I get the error:
> >> psql: FATAL: catalog is missing 10 attribute(s) for relid 1262
>
> > Sounds very much like you haven't been doing the required vacuum on all
> > system catalogs.
>
> I don't think so --- that error is coming out of the relcache/syscache
> layer, and that code uses SnapshotNow; so it's only going to care
> whether the tuples are marked committed, not whether they've wrapped
> around.
>
> I'm afraid that Bruno has lost some pages of pg_attribute (eg, they went
> to zeroes). That's not too surprising given his previous reports
> suggesting hardware problems.
>
> If the pages in question held only rows for system catalogs then it
> might be possible to copy correct values from elsewhere, but if they
> held rows for user tables then he's got serious problems :-(. My advice
> would be to start thinking about restoring from backup.
>
> regards, tom lane
>
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bcc@mail.pt, tgl@sss.pgh.pa.us
Subject: Re: FATAL: catalog is missing attributes
In-Reply-To: <20060425080651.68C4111F61C2@postgresql.org>
References: <20060425080651.68C4111F61C2@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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