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 EA9B13A4787 for ; Thu, 18 Nov 2004 19:35:45 +0000 (GMT) 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 11825-07 for ; Thu, 18 Nov 2004 19:35:42 +0000 (GMT) Received: from ns1.boyds.com (ns1.boyds.com [209.63.52.253]) by svr1.postgresql.org (Postfix) with ESMTP id C6E813A4783 for ; Thu, 18 Nov 2004 19:35:43 +0000 (GMT) Received: from mail.boyds.com by ns1.boyds.com via smtpd (for svr1.postgresql.org [200.46.204.71]) with ESMTP; Thu, 18 Nov 2004 11:35:43 -0800 Received: from lanerollins (10.0.3.42) by boyds.com with ESMTP (Eudora Internet Mail Server X 3.2.5) for ; Thu, 18 Nov 2004 11:35:42 -0800 From: "Lane Rollins" To: Subject: How to repair 'could not access status of transaction ' Date: Thu, 18 Nov 2004 11:35:38 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C4CD62.BA20B010" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcTNpcfbzEilbVeSTwSQGltyIGSThg== Message-ID: <1111315954-40710505@boyds.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_70_80, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200411/158 X-Sequence-Number: 15542 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C4CD62.BA20B010 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Currently on 7.4.2, I see that 7.4.6 seems to solve the problem. But I need to repair the database. I can survive the loss of a transaction or two. Bottom line is how do I repair the problem. Actual error message ERROR: could not access status of transaction 830358855 DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0317": No such file or directory The file does not exist. Thanks, Lane Rollins Boyd Coffee Co. ------=_NextPart_000_0005_01C4CD62.BA20B010 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Currently on 7.4.2, I see that 7.4.6 seems to solve = the problem. But I need to repair the database. I can survive the loss of a = transaction or two. Bottom line is how do I repair the = problem.

 

Actual error message

 

ERROR:  could not access status of transaction 830358855          &nbs= p;           

DETAIL:  could not open file "/var/lib/pgsql/data/pg_clog/0317": No such file or directory          &nbs= p;            = ;

 

The file does not exist.

 

Thanks,

Lane = Rollins        

Boyd Coffee = Co.           &nbs= p;            = ;           

------=_NextPart_000_0005_01C4CD62.BA20B010--