Re: How is this possible "publication does not exist" - Mailing list pgsql-bugs

From Amit Kapila
Subject Re: How is this possible "publication does not exist"
Date
Msg-id CAA4eK1KJb9PFV6j=Gzm0jFmrfKnMPo571SpUoL0H521QEip6nA@mail.gmail.com
Whole thread Raw
In response to Re: How is this possible "publication does not exist"  (operations i <ioperations.c@gmail.com>)
Responses Re: How is this possible "publication does not exist"
List pgsql-bugs
On Wed, May 25, 2022 at 9:32 AM operations i <ioperations.c@gmail.com> wrote:
During a detailed test , I've found the order of replication slot creation and publication creation is not the key point , but after replication slot creation , there should not be any insertion to the table,so I wonder why the change ( my case insert) will lead to src/backend/catalog/pg_publication:1040 GetSysCacheOid1() cache miss.

It is due to the reason that both slot creation and 'insert' are before "CREATE PUBLICATION". Without inserts, it won't try to decode anything before the publication is created. Can you test it with the patch provided in the email [1] and if possible join that thread for discussion on this topic.


--
With Regards,
Amit Kapila.

pgsql-bugs by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Next
From: Andres Freund
Date:
Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY