| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
| Subject: | Re: lockup in parallel hash join on dikkop (freebsd 14.0-current) |
| Date: | 2023-01-26 20:49:29 |
| Message-ID: | 3169669.1674766169@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> writes:
> I received an alert dikkop (my rpi4 buildfarm animal running freebsd 14)
> did not report any results for a couple days, and it seems it got into
> an infinite loop in REL_11_STABLE when building hash table in a parallel
> hashjoin, or something like that.
> It seems to be progressing now, probably because I attached gdb to the
> workers to get backtraces, which does signals etc.
That reminds me of cases that I saw several times on my now-deceased
animal florican:
https://www.postgresql.org/message-id/flat/2245838.1645902425%40sss.pgh.pa.us
There's clearly something rotten somewhere in there, but whether
it's our bug or FreeBSD's isn't clear.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2023-01-26 20:54:17 | Re: New strategies for freezing, advancing relfrozenxid early |
| Previous Message | Brar Piening | 2023-01-26 20:48:54 | Re: doc: add missing "id" attributes to extension packaging page |