Re: BUG #15721: FATAL: dsa_allocate could not find 97 free pages - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: BUG #15721: FATAL: dsa_allocate could not find 97 free pages
Date
Msg-id 4276531553798840@sas2-b4ed770db137.qloud-c.yandex.net
Whole thread Raw
In response to BUG #15721: FATAL: dsa_allocate could not find 97 free pages  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Hello

Thank you for report. This bug should be already fixed in stable branch and will be shipped in next minor release.
Untilthe 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 was here:
https://www.postgresql.org/message-id/flat/CAMAYy4%2Bw3NTBM5JLWFi8twhWK4%3Dk_5L4nV5%2BbYDSPu8r4b97Zg%40mail.gmail.com

regards, Sergei



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15721: FATAL: dsa_allocate could not find 97 free pages
Next
From: PG Bug reporting form
Date:
Subject: BUG #15722: 9000x performance regression on query starting PostgreSQL 10 due to bad query plan