Re: Relation cache invalidation on replica

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Relation cache invalidation on replica
Дата
Msg-id CANP8+jK7sG1=rbGqq-8unRSZj0SGDDLjVm5uOW0-bZAO3hR-+Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Relation cache invalidation on replica  (Andres Freund <andres@anarazel.de>)
Ответы Re: Relation cache invalidation on replica  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On 27 February 2016 at 00:29, Andres Freund <andres@anarazel.de> wrote:
On 2016-02-26 18:05:55 +0300, Konstantin Knizhnik wrote:
> The reason of the problem is that invalidation messages are not delivered to
> replica after the end of concurrent create index.
> Invalidation messages are included in xlog as part of transaction commit
> record.
> Concurrent index create is split into three transaction, last of which is
> just performing inplace update of index tuple, marking it as valid and
> invalidating cache. But as far as this transaction is not assigned XID, no
> transaction record is created in WAL and send to replicas. As a result,
> replica doesn't receive this invalidation messages.

Ugh, that's a fairly ugly bug.

Looking now. 

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Relation cache invalidation on replica
Следующее
От: Euler Taveira
Дата:
Сообщение: Re: [PATCH] fix DROP OPERATOR to reset links to itself on commutator and negator