From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: propagating replica identity to partitions
Date: Sat, 9 Feb 2019 11:27:41 -0300
Message-ID: <20190209142741.GA8147@alvherre.pgsql> (raw)
In-Reply-To: <CA+q6zcU7+t-G5nX1Pe607VyFfZLdL2vH+Jhu+_-naFH3bTC+Dg@mail.gmail.com>
On 2019-Feb-07, Dmitry Dolgov wrote:
> Could there be a race condition somewhere? The idea and the code looks
> reasonable, but when I'm testing ALTER TABLE ... REPLICA IDENTITY with this
> patch and concurrent partition creation, I've got the following error on ATTACH
> PARTITION:
>
> ERROR: 42P17: replica index does not exist in partition "test373"
> LOCATION: MatchReplicaIdentity, tablecmds.c:15018
>
> This error seems unstable, other time I've got a deadlock. And I don't observe
> this behaviour on the master.
Clearly there is a problem somewhere. I'll investigate. Thanks for
testing.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: alvherre@2ndquadrant.com, 9erthalion6@gmail.com, pgsql-hackers@lists.postgresql.org
Subject: Re: propagating replica identity to partitions
In-Reply-To: <20190209142741.GA8147@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox