Re: Assertion failure with barriers in parallel hash join - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Assertion failure with barriers in parallel hash join
Date
Msg-id CA+hUKGK3Vr_w0fyrvVj0-kCfJ_bEsXzrZsgG4Bxre+nFApQ3bA@mail.gmail.com
Whole thread Raw
In response to Re: Assertion failure with barriers in parallel hash join  (Melanie Plageman <melanieplageman@gmail.com>)
List pgsql-hackers
On Tue, Oct 13, 2020 at 12:15 PM Melanie Plageman
<melanieplageman@gmail.com> wrote:
> On Thu, Oct 1, 2020 at 8:08 PM Thomas Munro <thomas.munro@gmail.com> wrote:
>> On Tue, Sep 29, 2020 at 9:12 PM Thomas Munro <thomas.munro@gmail.com> wrote:
>> Here's a throw-away patch to add some sleeps that trigger the problem,
>> and a first draft fix.  I'll do some more testing of this next week
>> and see if I can simplify it.
>
> I was just taking a look at the patch and noticed the commit message
> says:
>
> > With unlucky timing and parallel_leader_participation off...
>
> Is parallel_leader_participation being off required to reproduce the
> issue?

Yeah, because otherwise the leader detaches last so the problem doesn't arise.



pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: Assertion failure with barriers in parallel hash join
Next
From: Masahiko Sawada
Date:
Subject: Re: Resetting spilled txn statistics in pg_stat_replication