Skip site navigation (1) Skip section navigation (2)

How to repair 'could not access status of transaction '

From: "Lane Rollins" <laner(at)boyds(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How to repair 'could not access status of transaction '
Date: 2004-11-18 19:35:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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.



Lane Rollins         

Boyd Coffee Co.                                    

pgsql-admin by date

Next:From: Di Croce, TonyDate: 2004-11-19 00:23:50
Subject: Stamping rows...
Previous:From: Andrew SullivanDate: 2004-11-18 15:41:46
Subject: Re: Usenet Discussion Proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group