RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder()

From: "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, "ocean_li_996(at)163(dot)com" <ocean_li_996(at)163(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>
Subject: RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder()
Date: 2023-09-07 12:10:52
Message-ID: OS0PR01MB5716DFC7D901742C5675471B94EEA@OS0PR01MB5716.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tuesday, September 5, 2023 7:31 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Fri, Aug 25, 2023 at 9:36 AM Zhijie Hou (Fujitsu) <houzj(dot)fnst(at)fujitsu(dot)com>
> wrote:
> >
> > On Wednesday, August 23, 2023 4:47 PM Amit Kapila
> <amit(dot)kapila16(at)gmail(dot)com> wrote:
> > >
> > > On Mon, Aug 21, 2023 at 11:57 PM Andres Freund <andres(at)anarazel(dot)de>
> > > wrote:
> > > >
> > > > -1. This makes things global concerns that shouldn't be.
> > > >
> > > > If we really need something to clean this up, I'd look at
> > > > MemoryContextRegisterResetCallback().
> > > >
> > >
> > > +1. This sounds like a better idea.
> >
> > Here is a small patch based on this idea.
> > I registered the callback under snapshot builder context and the
> > callback will reset the variables.
> >
>
> LGTM. Unless Andres or Sawada-San thinks otherwise, I would like to proceed
> with this fix.

Thanks, attach the patches for all support branches. I have confirmed that they can
pass the regression test and fix the issue.

Best Regards,
Hou zj

Attachment Content-Type Size
0001-PG14-Reset-InitialRunningXacts-at-memory-context-res.patch application/octet-stream 2.5 KB
0001-PG11-12-13-Reset-InitialRunningXacts-at-memory-context-res.patch application/octet-stream 2.4 KB
0001-PG15-Reset-InitialRunningXacts-at-memory-context-reset-ca.patch application/octet-stream 2.5 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2023-09-07 15:56:33 BUG #18094: max max_connections cannot be set
Previous Message David Rowley 2023-09-07 11:05:29 Re: BUG #18092: Unexpected Result by enable_seqscan