X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E5D6911F6B2D for ; Mon, 24 Apr 2006 17:53:57 -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 97748-01-5 for ; Mon, 24 Apr 2006 17:53:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx3.surnet.cl (mx3.surnet.cl [216.155.73.182]) by postgresql.org (Postfix) with ESMTP id E357211F6C98 for ; Mon, 24 Apr 2006 17:35:53 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx3.surnet.cl with ESMTP; 24 Apr 2006 16:35:52 -0400 X-IronPort-AV: i="4.04,152,1144036800"; d="scan'208"; a="6208983:sNHT20427256" Received: from alvh.no-ip.org (200.126.100.190) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 443B7DDC001C698B; Mon, 24 Apr 2006 16:35:52 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id B24E5C30F8E; Mon, 24 Apr 2006 16:35:52 -0400 (CLT) Date: Mon, 24 Apr 2006 16:35:52 -0400 From: Alvaro Herrera To: Daniel Caune Cc: pgsql-sql@postgresql.org Subject: Re: "could not open file" issue Message-ID: <20060424203552.GC18690@surnet.cl> Mail-Followup-To: Daniel Caune , pgsql-sql@postgresql.org References: <1E293D3FF63A3740B10AD5AAD88535D202132843@UBIMAIL1.ubisoft.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1E293D3FF63A3740B10AD5AAD88535D202132843@UBIMAIL1.ubisoft.org> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/164 X-Sequence-Number: 24973 Daniel Caune wrote: > > > De : Alvaro Herrera [mailto:alvherre@commandprompt.com] > > > > Daniel Caune wrote: > > > > > > select count(*) from eventplayerleaveroom; > > > ERROR: could not access status of transaction 3164404766 > > > DETAIL: could not open file "pg_clog/0BC9": No such file or directory > > > > Are the files in pg_clog close to the vicinity of 0BC9? > > I don't have any skill in PostgreSQL administration. However I took a > look at /var/lib/postgresql/8.1/main/pg_clog and there is no file > close to the vicinity of 0BC9 ; the last file in that directory is: > > -rw------- 1 postgres postgres 221184 2006-04-24 19:27 00C9 > > A bit far from 0BC9... Do you have any diagnostic? I'd say you have a corrupted table. How corrupted I don't know. You could try extracting a portion of the table, playing with LIMIT/OFFSET to find out the exact records that are corrupted. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support