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

From Andres Freund
Subject Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)
Date
Msg-id 20230128034247.fqaxx3npu6ceads4@awork3.anarazel.de
Whole thread Raw
In response to Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)
List pgsql-hackers
Hi,

On 2023-01-27 22:23:58 +1300, Thomas Munro wrote:
> After 1000 make check loops, and 1000 make -C src/test/modules/test_shm_mq
> check loops, on the same FBSD 13.1 machine as elver which has failed
> like this once before, I haven't been able to reproduce this on
> REL_12_STABLE.

Did you use the same compiler / compilation flags as when elver hit it?
Clearly Tomas' case was with at least some optimizations enabled.

Except that you're saying that you hit this on elver (amd64), I think it'd be
interesting that we see the failure on an arm host, which has a less strict
memory order model than x86.

IIUC elver previously hit this on 12?

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Something is wrong with wal_compression
Next
From: Andres Freund
Date:
Subject: Re: Something is wrong with wal_compression