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 7586111F72B8 for ; Mon, 24 Apr 2006 18:47:31 -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 06257-05 for ; Mon, 24 Apr 2006 18:46:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 0DE3311F6B5D for ; Mon, 24 Apr 2006 18:46:56 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id C3E0756435; Mon, 24 Apr 2006 16:46:55 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 24 Apr 2006 16:46:55 -0500 Date: Mon, 24 Apr 2006 16:46:55 -0500 From: "Jim C. Nasby" To: Bruno Cortes , pgsql-admin@postgresql.org Subject: Re: FATAL: catalog is missing attributes Message-ID: <20060424214654.GN48010@pervasive.com> References: <444BDF18.5010608@mail.pt> <20060424124326.GB13361@surnet.cl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060424124326.GB13361@surnet.cl> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060424:bcc@mail.pt::XewLnDlde97g+K82:00000010mj X-Hashcash: 1:20:060424:pgsql-admin@postgresql.org::kmTwER0O1aQwEofH:00000000000 00000000000000000000000068m7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/253 X-Sequence-Number: 21422 On Mon, Apr 24, 2006 at 08:43:26AM -0400, Alvaro Herrera wrote: > Bruno Cortes wrote: > > Hi, > > > > I was trying to make a dump from a database in postgresql 7.4.2-1. I was > > enable to do so because of a cache lookup problem. > > To solve it, I enter the database as superuser and execute VACUUM ALL. > > 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. Look for "transaction Xid wraparound" for possible > suggestions. For example look at > > http://archives.postgresql.org/pgsql-bugs/2005-05/msg00079.php Could this also be due to data corruption? From my limited understanding of the relevant code in backend/utils/cache/relcache.c it seems this error indicates that there's a mismatch between the number of columns found in a tuple and what's supposed to be there according to the catalog tables... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461