Best way to fix Error: could not access status of transaction?

From: "Paul McGarry" <paul(at)paulmcgarry(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Best way to fix Error: could not access status of transaction?
Date: 2008-01-08 06:48:46
Message-ID: a056b1d40801072248x1b6483b9j68c3c0f03df2f26c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a database (8.1.10 via Ubuntu) that has started reporting:

<2008-01-08 08:51:14 EST|>ERROR: could not access status of
transaction 707406378
<2008-01-08 08:51:14 EST|>DETAIL: could not open file "pg_clog/02A2":
No such file or directory

when trying to do an autovacuum.

By vacuuming tables individually I have determined that the problem
occurs in a table that doesn't contain critical data (basically log
information that is kept for a month in case it is useful).

Posts I have found in the archive seem to advocate manually trying to
create the missing pg_clog file however I would prefer not to fiddle
with it manually if there is another way to clear the error.

Bearing in mind that I don't particularly need the data in that table
can I simply truncate it or drop/recreate it to clear the above error?

Paul

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rihad 2008-01-08 06:50:18 need to dump/restore data for 8.3beta2 -> 8.3RC1 upgrade?
Previous Message Devrim GÜNDÜZ 2008-01-08 06:20:19 Re: Announcing PostgreSQL RPM Buildfarm