Re: relation 71478240 deleted while still in use on 8.1

Grzegorz Jaskiewicz wrote:
> I got :
>
> 2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still in
> use
> 2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still in
> use
> 2007-03-21 20:56:17 CET ERROR: relation 71478240 deleted while still in
> use
>
> on 8.1.8 my production server here.
> some inserts/updates, selects, and pg_dump was running.
> there's a chance cluster was running in
> http://dupa.privatepaste.com/d317KYXt5n
>
> It is repeatable, if I run pg_dump. Guess that has something to do, with
> slowing down db server - and some race cond occurs.
> Any ideas ?
> should I add it as a bug ? or perhaps someone already knows about that
> kinda issue

Which transaction gets the error, pg_dump or the one you copied to that
web page? Is there anything else running? How often does it happen,
always? Can you reduce it to a self-contained test case that doesn't
require dblink?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com