Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 80DFC9FB3BA for ; Wed, 31 Jan 2007 17:08:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 56324-03 for ; Wed, 31 Jan 2007 17:07:46 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.229]) by postgresql.org (Postfix) with ESMTP id 51C009FA66C for ; Wed, 31 Jan 2007 17:08:07 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 68so348721wra for ; Wed, 31 Jan 2007 13:08:06 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=ZJz/ktKUQLEmLnjQ5zm3yAhbjIBYVnis5xeNMdbK+b/ES68m3g8VxMWuNzfho1KlaElPI5egi3OC+yi1ppdfOl/hwLwSFtOrXqTQiZNTWh6GGtfQ4ejUyki/asw/lbX7RyXGMsKrDO47jpFbilIm42I2qFuRwyE0TIuTkr09kTE= Received: by 10.90.68.15 with SMTP id q15mr1905206aga.1170277686183; Wed, 31 Jan 2007 13:08:06 -0800 (PST) Received: by 10.90.69.18 with HTTP; Wed, 31 Jan 2007 13:08:06 -0800 (PST) Message-ID: <1d219a6f0701311308n3c90bd1i1b7168b055f506d5@mail.gmail.com> Date: Wed, 31 Jan 2007 16:08:06 -0500 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: 8.1.3 Problem MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10957_21409081.1170277686161" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.394 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_00_10, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200701/303 X-Sequence-Number: 24459 ------=_Part_10957_21409081.1170277686161 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I am starting to have some significant problems with one of my 8.1.3databases. I am getting more and more of these errors: wbd,20552,dholton,2007-01-31 15:32:27.137 EST,45c0fcb4.5048,16,2007-01-31 15:31:48 EST,342126177,UPDATE,ERROR: could not access status of transaction 253762136 wbd,20552,dholton,2007-01-31 15:32:27.137 EST,45c0fcb4.5048,17,2007-01-31 15:31:48 EST,342126177,UPDATE,DETAIL: could not open file "pg_clog/00F2": No such file or directory This is happening more and more, and on seeming random databases. Any idea what is going on? I have already dumped and reloaded 2-3 of my databases and now have about 3 more suffering from this. Right now, I can't upgrade to 8.1.6 until around March (have to wait until the current release of our application is released). I have 7 databases running 8.1.3 (6 prod and 1 test/dev) and only the test/dev is exhibiting this problem Any help/ideas on what is going on and how to fix would be appreciated. Chris ------=_Part_10957_21409081.1170277686161 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I am starting to have some significant problems with one of my 8.1.3 databases.  I am getting more and more of these errors:
wbd,20552,dholton,2007-01-31 15:32:27.137 EST,45c0fcb4.5048,16,2007-01-31 15:31:48 EST,342126177,UPDATE,ERROR:  could not access status of transaction 253762136
wbd,20552,dholton,2007-01-31 15:32:27.137 EST,45c0fcb4.5048,17,2007-01-31 15:31:48 EST,342126177,UPDATE,DETAIL:  could not open file "pg_clog/00F2": No such file or directory


This is happening more and more, and on seeming random databases.  Any idea what is going on?  I have already dumped and reloaded 2-3 of my databases and now have about 3 more suffering from this.

Right now, I can't upgrade to 8.1.6 until around March (have to wait until the current release of our application is released).  I have 7 databases running 8.1.3 (6 prod and 1 test/dev) and only the test/dev is exhibiting this problem

Any help/ideas on what is going on and how to fix would be appreciated.

Chris
------=_Part_10957_21409081.1170277686161--