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 52A3A539AE for ; Mon, 2 May 2005 03:45:11 -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 45119-08 for ; Mon, 2 May 2005 06:45:02 +0000 (GMT) Received: from gw01.mail.saunalahti.fi (gw01.mail.saunalahti.fi [195.197.172.115]) by svr1.postgresql.org (Postfix) with ESMTP id F07C953987 for ; Mon, 2 May 2005 03:45:00 -0300 (ADT) Received: from [192.168.105.70] (unknown [195.197.242.66]) by gw01.mail.saunalahti.fi (Postfix) with ESMTP id 8A085DFF83 for ; Mon, 2 May 2005 09:19:28 +0300 (EEST) Subject: A nightmare From: Mauri Sahlberg To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: Claymountain Solutions Oy Date: Mon, 02 May 2005 09:19:28 +0300 Message-Id: <1115014768.8003.9.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/4 X-Sequence-Number: 17433 Hi, I'm starting to become desperate. On saturday I dumped all databases, wiped whole postgresql installation. Installed newest rpms for Fedora 1, restored databases. Recompiled client libraries and binaries. Restarted and after five hours of operation: May 1 21:34:19 claymountain postgres[6337]: [2-1] ERROR: could not access status of transaction 4250811410 May 1 21:34:19 claymountain postgres[6337]: [2-2] DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0FD5": No such file or directory Is there anything else I could do than dump, wipe, restore again? Isn't there anything I could do to try to get more detailed meaningful information on why this is happening? All that the log shows before this happening are a few unexpected client disconnections.