X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1F8B711F61C7 for ; Tue, 25 Apr 2006 05:06:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 48028-06 for ; Tue, 25 Apr 2006 05:06:52 -0300 (ADT) X-Greylist: delayed 00:06:38.300086 by SQLgrey- Received: from mailrly06.isp.novis.pt (mailrly06.isp.novis.pt [195.23.133.216]) by postgresql.org (Postfix) with ESMTP id 68C4111F61C2 for ; Tue, 25 Apr 2006 05:06:50 -0300 (ADT) Received: (qmail 28549 invoked from network); 25 Apr 2006 08:00:10 -0000 Received: from unknown (HELO mailfrt06.isp.novis.pt) ([195.23.133.198]) (envelope-sender ) by mailrly06.isp.novis.pt with compressed SMTP; 25 Apr 2006 08:00:10 -0000 Received: (qmail 31617 invoked from network); 25 Apr 2006 08:00:09 -0000 Received: from unknown (HELO mail.pt) ([195.23.131.50]) (envelope-sender ) by mailfrt06.isp.novis.pt with SMTP; 25 Apr 2006 08:00:09 -0000 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: binary MIME-Version: 1.0 Date: Tue, 25 Apr 2006 09:00:08 +0000 From: Bruno Cortes To: Tom Lane CC: Bruno Cortes , pgsql-admin@postgresql.org Reply-To: Bruno Cortes Subject: Re: FATAL: catalog is missing attributes X-Mailer: Mail.pt 2.0 Message-Id: <20060425080651.68C4111F61C2@postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/352 X-Sequence-Number: 21521 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 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 > --