From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Query stuck with wait event IPC / ParallelFinish |
Date: | 2024-03-05 04:12:28 |
Message-ID: | 0f64b4c7fc200890f2055ce4d6650e9c2191fac2.camel@j-davis.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
If the attached test patch is applied (no code changes) to master, and
the "amcheck" target is run with debug_parallel_query = regress, I see
the following stuck query:
# select
application_name,
now() - state_change AS duration,
wait_event_type,
wait_event,
state,
query
from pg_stat_activity
where pid<>pg_backend_pid() and backend_type='client backend';
application_name | 004_verify_nbtree_unique.pl
duration | 00:12:29.456255
wait_event_type | IPC
wait_event | ParallelFinish
state | active
query | DELETE FROM bttest_unique3 WHERE 380 <= i
AND i <= 420;
I found this while fixing a parallel query problem with 2af07e2f74, but
the problem can be observed on an earlier version of master as well
(2c29e7fc95) so it's unrelated to my change.
I haven't investigated much, but I don't see an explanation other than
a bug. It reproduces on my local machine consistently.
Regards,
Jeff Davis
Attachment | Content-Type | Size |
---|---|---|
v1-0001-IPC-ParallelFinish-not-finishing.patch | text/x-patch | 5.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tender Wang | 2024-03-05 06:21:49 | Re: BUG #18314: PARALLEL UNSAFE function does not prevent parallel index build |
Previous Message | Alexander Lakhin | 2024-03-05 04:00:00 | Re: BUG #18369: logical decoding core on AssertTXNLsnOrder() |