Re: Nasty bug in heap_page_prune

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: Nasty bug in heap_page_prune
Дата
Msg-id 2e78013d0803070240p27cd1cadqd39cb8539c482a90@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Nasty bug in heap_page_prune  (Hannu Krosing <hannu@krosing.net>)
Список 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 по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Nasty bug in heap_page_prune
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: Grouped Index Tuples