Re: Vacuum Error - Relation Deleted while still in use

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum Error - Relation Deleted while still in use
Дата
Msg-id 15688.1252076168@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuum Error - Relation Deleted while still in use  ("Thorne, Francis" <thornef@cromwell.co.uk>)
Список pgsql-admin
"Thorne, Francis" <thornef@cromwell.co.uk> writes:
> Last night I got the error
> Error Relation 41036649 deleted while still in use

This is not particularly surprising in 8.1 --- it has some race
conditions that can result in that type of error if vacuum (or anything
else) tries to open a table just as something else is deleting it.
We fixed that around 8.2, but it's really just a cosmetic issue
(you'd rather the message was "relation foo does not exist" ...)
I don't see any reason to worry.

            regards, tom lane

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

Предыдущее
От: "Thorne, Francis"
Дата:
Сообщение: Is Vacuum Working ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is Vacuum Working ?