Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query
Date
Msg-id 31541555076899@sas1-b3ec53dbc12b.qloud-c.yandex.net
Whole thread Raw
In response to Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query  (Sergei Kornilov <sk@zsrv.org>)
List 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 by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: BUG #15749: ERROR: dsa_area could not attach to segment | FATAL: cannot unpin a segment that is not pinned
Next
From: Tom Lane
Date:
Subject: Re: BUG #15726: parallel queries failed ERROR: invalid name syntax CONTEXT: parallel worker