X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 87529D1B442 for ; Thu, 1 Jul 2004 19:13:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22165-01 for ; Thu, 1 Jul 2004 22:13:15 +0000 (GMT) Received: from mpls-qmqp-02.inet.qwest.net (mpls-qmqp-02.inet.qwest.net [63.231.195.113]) by svr1.postgresql.org (Postfix) with SMTP id 57079D1B37B for ; Thu, 1 Jul 2004 19:13:11 -0300 (ADT) Received: (qmail 48639 invoked by uid 0); 1 Jul 2004 21:03:49 -0000 Received: from mpls-pop-10.inet.qwest.net (63.231.195.10) by mpls-qmqp-02.inet.qwest.net with QMQP; 1 Jul 2004 21:03:49 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-10.inet.qwest.net with SMTP; 1 Jul 2004 22:13:12 -0000 Date: Thu, 01 Jul 2004 16:14:09 -0600 Message-Id: <1088720049.14882.12.camel@localhost.localdomain> From: "Scott Marlowe" To: "Sandro Dentella" Cc: pgsql-admin@postgresql.org Subject: Re: pg_clog error after crash In-Reply-To: <20040630155919.GA3174@bluff> References: <20040630155919.GA3174@bluff> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/27 X-Sequence-Number: 14095 On Wed, 2004-06-30 at 09:59, Sandro Dentella wrote: > After a crash of the (frozen) system, postgreSQL issues a message: > > 2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia > 2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129 > DETAIL: could not open file "/var/lib/postgres/data/pg_clog/0EF1": No such file or directory > > > when trying to acces a db. > > I'm really clueless as I didn't find anything usefull with google to fix > it. The db is very little, and I'm the only one that writes on it, so I know > there shouldn't be real problems ignoring the transaction, but I don't know > what to say postgreSQL to ingore it. > > Should I recreate an empty file? What version are you running?