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

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: "torrey(at)interactiveshift(dot)com" <torrey(at)interactiveshift(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15749: ERROR: dsa_area could not attach to segment | FATAL: cannot unpin a segment that is not pinned
Date: 2019-04-12 13:44:37
Message-ID: 104341555076677@sas1-063d61d846d8.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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, the simplest workaround is to disable parallel query with SET max_parallel_workers_per_gather = 0 if you're affected 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.

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

regards, Sergei

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergei Kornilov 2019-04-12 13:48:19 Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query
Previous Message Nikolay Samokhvalov 2019-04-12 13:43:40 On replicas, checkpoints_req is incremented even if restartpoint has not happened