Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
To: simon(dot)riggs(at)enterprisedb(dot)com
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, nathandbossart(at)gmail(dot)com, dgrowleyml(at)gmail(dot)com, kuzmin(dot)db4(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records
Date: 2022-10-11 06:48:24
Message-ID: 20221011.154824.2222289551494538331.horikyota.ntt@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

> On Wed, 5 Oct 2022 at 16:30, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > One other point to discuss: should we consider back-patching? I've
> > got mixed feelings about that myself. I don't think that cases where
> > this helps significantly are at all mainstream, so I'm kind of leaning
> > to "patch HEAD only".

At Mon, 10 Oct 2022 13:24:34 +0100, Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> wrote in
> It looks fine to eventually backpatch, since StandbyReleaseLockTree()
> was optimized to only be called when the transaction had actually done
> some AccessExclusiveLocks.
>
> So the performance loss is minor and isolated to the users of such
> locks, so I see no problems with it.

At Wed, 5 Oct 2022 12:00:55 -0700, Nathan Bossart <nathandbossart(at)gmail(dot)com> wrote in
> +1. It can always be back-patched in the future if there are additional
> reports.

The third +1 from me.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Japin Li 2022-10-11 09:12:04 Re: BUG #17632: a potential bug of memory leak
Previous Message PG Bug reporting form 2022-10-11 02:33:34 BUG #17632: a potential bug of memory leak

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2022-10-11 07:36:55 Re: Add common function ReplicationOriginName.
Previous Message Peter Smith 2022-10-11 06:30:37 Re: create subscription - improved warning message