Re: Vacuumdb message: AbortTransaction and not in-progress ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuumdb message: AbortTransaction and not in-progress ...
Дата
Msg-id 14967.990634260@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuumdb message: AbortTransaction and not in-progress ...  (Gabriel Fernandez <gabi@unica.edu>)
Список pgsql-general
Gabriel Fernandez <gabi@unica.edu> writes:
> We have some db's in our server. When executing a vacuumdb, ONLY FOR
> SOME of them, the following message is shown:

> AbortTransaction and not in in-progress state

What postgres version?

> After this, the vacuum process is aborted, so we cannot vacuum these
> 'problematic' db's.

The above notice is a consequence of a problem, not its cause.  What
other messages show up in the postmaster log?

            regards, tom lane

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

Предыдущее
От: "Ian Harding"
Дата:
Сообщение: Re: Incrementing a date type.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: ZeroFill(.../pg_xlog/xlogtemp.20148) failed: No such file or directory