Re: logical decoding and replication of sequences - Mailing list pgsql-hackers

From Robert Haas
Subject Re: logical decoding and replication of sequences
Date
Msg-id CA+TgmoYozQaAdqU6h1P_u3ReTFHLBjBYG_3isjd6=sWYL4Xm0Q@mail.gmail.com
Whole thread Raw
In response to Re: logical decoding and replication of sequences  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: logical decoding and replication of sequences
List pgsql-hackers
On Tue, Aug 23, 2022 at 12:33 AM Thomas Munro <thomas.munro@gmail.com> wrote:
> On Tue, Aug 23, 2022 at 4:21 PM Michael Paquier <michael@paquier.xyz> wrote:
> > On Mon, Aug 08, 2022 at 06:15:46PM +1200, Thomas Munro wrote:
> > > The attached patch that simply moves the cache invalidation into
> > > report_invalid_record(), so that it's reached by the above code and
> > > everything else that reports an error, seems to fix the problem in
> > > src/bin/pg_ctl/t/003_promote.pl with Noah's spanner-in-the-works patch
> > > applied, and passes check-world without it.  I need to look at this
> > > some more, though, and figure out if it's the right fix.
> >
> > Thomas, where are you on this open item?  A potential PANIC at
> > promotion is bad.  One possible exit path would be to switch the
> > default of recovery_prefetch, though that's a kind of last-resort
> > option seen from here.
>
> I will get a fix committed this week -- I need to study
> Horiguchi-san's analysis...

Hi!

I haven't been paying attention to this thread, but my attention was
just drawn to it, and I'm wondering if the issue you're trying to
track down here is actually the same as what I reported yesterday
here:

https://www.postgresql.org/message-id/CA+TgmoY0Lri=fCueg7m_2R_bSspUb1F8OFycEGaHNJw_EUW-=Q@mail.gmail.com

-- 
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: SQL/JSON features for v15
Next
From: Jehan-Guillaume de Rorthais
Date:
Subject: [BUG] parenting a PK constraint to a self-FK one (Was: Self FK oddity when attaching a partition)