Re: Relation cache invalidation on replica - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Relation cache invalidation on replica
Date
Msg-id CANP8+jK7sG1=rbGqq-8unRSZj0SGDDLjVm5uOW0-bZAO3hR-+Q@mail.gmail.com
Whole thread Raw
In response to Re: Relation cache invalidation on replica  (Andres Freund <andres@anarazel.de>)
Responses Re: Relation cache invalidation on replica
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: Relation cache invalidation on replica
Next
From: Euler Taveira
Date:
Subject: Re: [PATCH] fix DROP OPERATOR to reset links to itself on commutator and negator