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

From Sergei Kornilov
Subject Re: BUG #15749: ERROR: dsa_area could not attach to segment | FATAL: cannot unpin a segment that is not pinned
Date
Msg-id 104341555076677@sas1-063d61d846d8.qloud-c.yandex.net
Whole thread Raw
In response to 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>)
List 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 by date:

Previous
From: Nikolay Samokhvalov
Date:
Subject: On replicas, checkpoints_req is incremented even if restartpoint hasnot happened
Next
From: Sergei Kornilov
Date:
Subject: Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query