could not open file "pg_clog/0BFF"

From: "Patrick Lindeman" <patrick(at)my-mac(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: could not open file "pg_clog/0BFF"
Date: 2007-08-22 12:54:03
Message-ID: 52322.85.12.39.193.1187787243.squirrel@mail.kickuh.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

While checking the logfiles of our postgresql server I noticed the error
mentioned in the subject:

ERROR: could not access status of transaction 3221180546
DETAIL: could not open file "pg_clog/0BFF": No such file or directory

Searching on google told me that this could be solved by creating the file
mentioned in the error using /dev/zero as input.

After I have done that and taking another look at the login I also noticed
that this error started to show up in the loggin since the 1st of August
and from the same date the autovacuum was only vacuuming the 'template0'
database.

Right now I have created the "pg_clog/0BFF" file and manually started a
vacuum.

And now my questions:

Are those mentioned steps the appropriate steps or should we do anything
else?

What could have caused the error "could not access status of transaction
3221180546" and is it more than just coincidence that since that moment
the vacuum stopped running?

Is there anything we can do to prevent this in future use?

Besides we are using PostgreSQL 8.1.3.

Any help would be appreciated.

Regards,
Patrick Lindeman

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Amiel 2007-08-22 13:04:16 Re: could not open file "pg_clog/0BFF"
Previous Message Bill Thoen 2007-08-22 12:44:51 Re: PG Seg Faults Performing a Query