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+hUKGJuQUK6j2EwJcv5gcLPUCZ=qk0o36VtjL+s-bMV0GURJw@mail.gmail.com
Whole thread Raw
In response to Re: Assertion failure with barriers in parallel hash join  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: Assertion failure with barriers in parallel hash join  (Melanie Plageman <melanieplageman@gmail.com>)
List pgsql-hackers
On Tue, Sep 29, 2020 at 9:12 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> On Tue, Sep 29, 2020 at 7:11 PM Michael Paquier <michael@paquier.xyz> wrote:
> > #2  0x00000000009027d2 in ExceptionalCondition
> > (conditionName=conditionName@entry=0xa80846 "!barrier->static_party",
>
> > #4  0x0000000000682ebf in ExecParallelHashJoinNewBatch
>
> Thanks.  Ohhh.  I think I see how that condition was reached and what
> to do about it, but I'll need to look more closely.  I'm away on
> vacation right now, and will update in a couple of days when I'm back
> at a real computer.

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.

Attachment

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Why does PostgresNode.pm set such a low value of max_wal_senders?
Next
From: Masahiro Ikeda
Date:
Subject: Re: New statistics for tuning WAL buffer size