Don't enter parallel mode when holding interrupts.
Noah Misch <noah@leadboat.com>
Don't enter parallel mode when holding interrupts. Doing so caused the leader to hang in wait_event=ParallelFinish, which required an immediate shutdown to resolve. Back-patch to v12 (all supported versions). Francesco Degrassi Discussion: https://postgr.es/m/CAC-SaSzHUKT=vZJ8MPxYdC_URPfax+yoA1hKTcF4ROz_Q6z0_Q@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/plan/planner.c | modified | +6 −0 |
| src/test/regress/expected/select_parallel.out | modified | +24 −0 |
| src/test/regress/sql/select_parallel.sql | modified | +31 −0 |
Discussion
- Leader backend hang on IPC/ParallelFinish when LWLock held at parallel query start 18 messages · 2024-09-16 → 2024-11-08