autovacuum: could not access status of transaction

From: Nichlas Löfdahl <crotalus(at)acc(dot)umu(dot)se>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: autovacuum: could not access status of transaction
Date: 2006-03-28 19:21:01
Message-ID: 073801c6529c$c13acd70$2201a8c0@n
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello!

PostgreSQL 8.1.1 on x86_64-pc-linux-gnu

I've been running a server with autovacuum enabled for quite a while now (months) without problems. But recently the server slowed down and after investigation I found the following repeated error messsage in the log:

LOG: autovacuum: processing database "template0"
ERROR: could not access status of transaction 3541181801
DETAIL: could not open file "pg_clog/0D31": No such file or directory

I assume that the avac-process halts at this point which means no vacuum and/or analyze for the other databases? Which would explain the slowdown.

What is the best way to proceed with this? Stop the postmaster, create a zero-filled pg_clog/0D31 and restart?

Regards
Nichlas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Hallgren 2006-03-28 19:21:11 Re: Shared memory
Previous Message Thomas Hallgren 2006-03-28 19:11:47 Re: Shared memory