Re: Vacuum Error - Relation Deleted while still in use - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum Error - Relation Deleted while still in use
Date
Msg-id 15688.1252076168@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum Error - Relation Deleted while still in use  ("Thorne, Francis" <thornef@cromwell.co.uk>)
List 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 by date:

Previous
From: "Thorne, Francis"
Date:
Subject: Is Vacuum Working ?
Next
From: Tom Lane
Date:
Subject: Re: Is Vacuum Working ?