Re: lockup in parallel hash join on dikkop (freebsd 14.0-current) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)
Date
Msg-id 3169669.1674766169@sss.pgh.pa.us
Whole thread Raw
In response to lockup in parallel hash join on dikkop (freebsd 14.0-current)  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)
List pgsql-hackers
Tomas Vondra <tomas.vondra@enterprisedb.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



pgsql-hackers by date:

Previous
From: Brar Piening
Date:
Subject: Re: doc: add missing "id" attributes to extension packaging page
Next
From: Robert Haas
Date:
Subject: Re: New strategies for freezing, advancing relfrozenxid early