Re: Nasty bug in heap_page_prune - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: Nasty bug in heap_page_prune
Date
Msg-id 2e78013d0803070240p27cd1cadqd39cb8539c482a90@mail.gmail.com
Whole thread Raw
In response to Re: Nasty bug in heap_page_prune  (Hannu Krosing <hannu@krosing.net>)
List pgsql-hackers
On Fri, Mar 7, 2008 at 3:42 PM, Hannu Krosing <hannu@krosing.net> wrote:

>
>  Is this something that happens only with concurrent VACUUM FULLs ?
>

No, its about VACUUM FULL on a system catalog which fails for some reason.
The VACUUM FULL may have changed CTID of a tuple because of line
pointer redirection collapse. But the change is non-transactional.
The current cache invalidation mechanism can only handle transactional changes
(since it does not broadcast invalidations if the transaction aborts). Hence
some other backend which has cached the tuple may not see the change
in CTID and fail when the cached tuple is accessed.

Thanks,
Pavan



-- 
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Nasty bug in heap_page_prune
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: Grouped Index Tuples