autovacuum: could not access status of transaction

Поиск

Список

Период

Сортировка

От	Nichlas Löfdahl
Тема	autovacuum: could not access status of transaction
Дата	28 марта 2006 г. 16:27:39
Msg-id	073801c6529c$c13acd70$2201a8c0@n обсуждение исходный текст
Ответы	Re: autovacuum: could not access status of transaction
Список	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

В списке pgsql-hackers по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

autovacuum: could not access status of transaction