Postgres Pro
Downloads
Home   >   mailing lists

Re: SKIP LOCKED assert triggered - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: SKIP LOCKED assert triggered
Date
Msg-id CANbhV-Ek8nbeyOxGVUgpnj6TFwj8aZDJsQf-8z-FP1Sx3vK6FA@mail.gmail.com
Whole thread Raw
In response to Re: SKIP LOCKED assert triggered  ("Bossart, Nathan" <bossartn@amazon.com>)
Responses Re: SKIP LOCKED assert triggered  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Tree view 
On Wed, 1 Dec 2021 at 14:33, Bossart, Nathan <bossartn@amazon.com> wrote:
>
> On 11/12/21, 8:56 AM, "Simon Riggs" <simon.riggs@enterprisedb.com> wrote:
> > The combination of these two statements in a transaction hits an
> > Assert in heapam.c at line 4770 on REL_14_STABLE
>
> I've been unable to reproduce this.  Do you have any tips for how to
> do so?  Does there need to be some sort of concurrent workload?

That path is only ever taken when there are multiple sessions, and as
I said, pgbench finds this reliably. I guess I didn't say "use -c 2"

-- 
Simon Riggs                http://www.EnterpriseDB.com/

pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: SKIP LOCKED assert triggered
Next
From: "Bossart, Nathan"
Date:
Subject: O(n) tasks cause lengthy startups and checkpoints