Re: 7.2.3 vacuum bug - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: 7.2.3 vacuum bug
Date
Msg-id 1036095788.94263.47.camel@jester
Whole thread Raw
In response to Re: 7.2.3 vacuum bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, 2002-10-31 at 13:03, Tom Lane wrote:
> Rod Taylor <rbt@rbt.ca> writes:
> > Found another:
> > ERROR:  cannot find attribute 2 of relation pg_temp_12100_0
> 
> Can you reproduce that?
> 
> It could be that this just represents someone's temp table deletion
> committing while VACUUM is partway through trying to build a relcache
> entry to open the relation.  If so, it is only another manifestation
> of the should-lock-before-relation-open problem.

Yes, but not easily (very timing dependent), takes a lot of worker
processes to throw it. So it's likely a part of the locking issue.

--  Rod Taylor



pgsql-hackers by date:

Previous
From: "Robert E. Bruccoleri"
Date:
Subject: Re: Test of PG7.3.2b2 on SGI Irix
Next
From: Tom Lane
Date:
Subject: Re: Test of PG7.3.2b2 on SGI Irix