Re: Assertion failure with barriers in parallel hash join

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Assertion failure with barriers in parallel hash join
Дата
Msg-id CA+hUKGJoj-nad5n6N0H=0N4ZMOQmJzAzMJ55Fmdaun8Zrjwosg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Assertion failure with barriers in parallel hash join  (David Geier <geidav.pg@gmail.com>)
Ответы Re: Assertion failure with barriers in parallel hash join  (David Geier <geidav.pg@gmail.com>)
Список pgsql-hackers
On Thu, Jun 2, 2022 at 9:31 PM David Geier <geidav.pg@gmail.com> wrote:
> We recently encountered the same bug in the field. Oleksii Kozlov managed to come up with reproduction steps, which
reliablytrigger it. Interestingly, the bug does not only manifest as failing assertion, but also as segmentation fault;
inbuilds with disabled and with enabled (!) assertions. So it can crash production environments. We applied the
proposedpatch v3 from Melanie to the REL_14_3 branch and can confirm that with the patch neither the assertion nor the
segmentationfault still occur. 

Thanks for the report, testing, and for creating the CF entry.

I assume you are using parallel_leader_participation=off, and the
reason we haven't heard more about this is because few people do that.
By coincidence I was just about to restart a bunch of hash join
projects and have been paging the topic area back into my brain, so
I'll start with another round of testing/analysis of this bug/patch
next week.



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

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: Proposal: adding a better description in psql command about large objects
Следующее
От: Jacob Champion
Дата:
Сообщение: Re: [PATCH] Compression dictionaries for JSONB