| From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: lockup in parallel hash join on dikkop (freebsd 14.0-current) |
| Date: | 2023-01-29 18:20:41 |
| Message-ID: | CA+hUKG+nmonh_zW+bh3LVc4bg_p2uTJtUyAEz_r9i3kwNq0n_Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Jan 30, 2023 at 7:08 AM Tomas Vondra
<tomas(dot)vondra(at)enterprisedb(dot)com> wrote:
> However, the other lockup I saw was when using serial_schedule, so I
> guess lower concurrency makes it more likely.
FWIW "psql db -f src/test/regress/sql/join_hash.sql | cat" also works
(I mean, it's self-contained and doesn't need anything else from make
check; pipe to cat just disables the pager); that's how I've been
trying (and failing) to reproduce this on various computers. I also
did a lot of "make -C src/test/module/test_shm_mq installcheck" loops,
at the same time, because that's where my animal hung.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-01-29 21:36:39 | Re: pub/sub - specifying optional parameters without values. |
| Previous Message | Tomas Vondra | 2023-01-29 18:08:36 | Re: lockup in parallel hash join on dikkop (freebsd 14.0-current) |