Re: BUG #15749: ERROR: dsa_area could not attach to segment | FATAL: cannot unpin a segment that is not pinned

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: BUG #15749: ERROR: dsa_area could not attach to segment | FATAL: cannot unpin a segment that is not pinned
Дата
Msg-id 104341555076677@sas1-063d61d846d8.qloud-c.yandex.net
обсуждение исходный текст
Ответ на BUG #15749: ERROR: dsa_area could not attach to segment | FATAL: cannot unpin a segment that is not pinned  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Hello

This bug should be already fixed in stable branch and will be shipped in next minor release. Until the fix is released,
thesimplest workaround is to disable parallel query with SET max_parallel_workers_per_gather = 0 if you're affected by
thebug.
 
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.

If you're interested, related discussion and patch was here:
https://www.postgresql.org/message-id/flat/20190207014719.GJ29720%40telsasoft.com

regards, Sergei



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

Предыдущее
От: Nikolay Samokhvalov
Дата:
Сообщение: On replicas, checkpoints_req is incremented even if restartpoint hasnot happened
Следующее
От: Sergei Kornilov
Дата:
Сообщение: Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query