From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
---|---|
To: | Floris Van Nee <florisvannee(at)optiver(dot)com> |
Cc: | Sergei Kornilov <sk(at)zsrv(dot)org>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: parallel query hangs - impossible to cancel |
Date: | 2019-03-26 00:42:40 |
Message-ID: | CA+hUKGL+JUk6pADTCkJaaVaZct0Kcd7GKaE8y3GwihVy1eH+fQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Mar 26, 2019 at 2:17 AM Floris Van Nee <florisvannee(at)optiver(dot)com> wrote:
> Thank you! I indeed saw another thread that looked like it, but I wasn't aware that the problem had been fixed already. This indeed seems similar to my stack trace.
Hi Floris,
I should probably highlight something that is buried in one of those
long threads Sergei posted: 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. In
theory you could also make it vanishingly rare by finding a way to
call srandom(getpid()) in every forked process with an extension.
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.
--
Thomas Munro
https://enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2019-03-26 01:15:32 | Re: BUG #15668: Server crash in transformPartitionRangeBounds |
Previous Message | Stephen Frost | 2019-03-25 20:27:23 | Re: BUG #15708: RLS 'using' running as wrong user when called from a view |