Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query
Дата
Msg-id 31541555076899@sas1-b3ec53dbc12b.qloud-c.yandex.net
обсуждение исходный текст
Ответ на Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query  (Sergei Kornilov <sk@zsrv.org>)
Список pgsql-bugs
Дерево обсуждения 
Hello

Just for archive purposes:

This bug should be already fixed in stable branch and will be shipped in next minor release (11.3 and 10.8). Until the
fixis released, the simplest workaround is to disable parallel query with SET max_parallel_workers_per_gather = 0 if
you'reaffected by the bug.
 
It's a rare timing bug, but some workloads seem to be more prone to it, so unfortunately it went undetected for a long
time.

Related discussion and patch was here:
https://www.postgresql.org/message-id/flat/20190207014719.GJ29720%40telsasoft.com

regards, Sergei

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

Предыдущее
От: Sergei Kornilov
Дата:
Сообщение: Re: BUG #15749: ERROR: dsa_area could not attach to segment | FATAL: cannot unpin a segment that is not pinned
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15726: parallel queries failed ERROR: invalid name syntax CONTEXT: parallel worker