[HACKERS] autovacuum: could not access status of transaction

[Nichlas Löfdahl]

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