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 AD7C511F8B94 for ; Mon, 24 Apr 2006 17:00:07 -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 82688-03-2 for ; Mon, 24 Apr 2006 16:59:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by postgresql.org (Postfix) with ESMTP id 6CEE411F78EC for ; Mon, 24 Apr 2006 16:21:41 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 24 Apr 2006 15:21:41 -0400 X-IronPort-AV: i="4.04,152,1144036800"; d="scan'208"; a="56248869:sNHT20167296" Received: from alvh.no-ip.org (200.126.100.190) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 443B7DDC001C11C8; Mon, 24 Apr 2006 15:21:40 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 49B32C30F8E; Mon, 24 Apr 2006 15:21:40 -0400 (CLT) Date: Mon, 24 Apr 2006 15:21:40 -0400 From: Alvaro Herrera To: Daniel Caune Cc: pgsql-sql@postgresql.org Subject: Re: "could not open file" issue Message-ID: <20060424192140.GG16134@surnet.cl> Mail-Followup-To: Daniel Caune , pgsql-sql@postgresql.org References: <1E293D3FF63A3740B10AD5AAD88535D20213249A@UBIMAIL1.ubisoft.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1E293D3FF63A3740B10AD5AAD88535D20213249A@UBIMAIL1.ubisoft.org> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/162 X-Sequence-Number: 24971 Daniel Caune wrote: > Hi, > > Is there any way to solve the following issue without dropping the > table? > > 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? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.