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
|
Список | 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
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: