Postgres Pro
Downloads
Home   >   mailing lists

autovacuum: could not access status of transaction - Mailing list pgsql-hackers

From Nichlas Löfdahl
Subject autovacuum: could not access status of transaction
Date
Msg-id 073801c6529c$c13acd70$2201a8c0@n
Whole thread Raw
Responses Re: autovacuum: could not access status of transaction
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Shared memory
Next
From: Thomas Hallgren
Date:
Subject: Re: Shared memory