Re: Assertion failure with barriers in parallel hash join

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Assertion failure with barriers in parallel hash join
Дата
Msg-id CA+hUKGJuQUK6j2EwJcv5gcLPUCZ=qk0o36VtjL+s-bMV0GURJw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Assertion failure with barriers in parallel hash join  (Thomas Munro <thomas.munro@gmail.com>)
Ответы Re: Assertion failure with barriers in parallel hash join  (Melanie Plageman <melanieplageman@gmail.com>)
Список 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.

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Why does PostgresNode.pm set such a low value of max_wal_senders?
Следующее
От: Masahiro Ikeda
Дата:
Сообщение: Re: New statistics for tuning WAL buffer size