diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out	2024-11-08 06:41:03.268944565 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out	2024-11-08 06:50:10.267823094 +0000
@@ -2238,11 +2238,10 @@
   x.unique1 in (select a.f1 from int4_tbl a,float8_tbl b where a.f1=b.f1) and
   x.unique1 = 0 and
   x.unique1 in (select aa.f1 from int4_tbl aa,float8_tbl bb where aa.f1=bb.f1);
- count 
--------
-     1
-(1 row)
-
+ERROR:  deadlock detected
+DETAIL:  Process 54468 waits for AccessShareLock on relation 24504 of database 16384; blocked by process 54482.
+Process 54482 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 54468.
+HINT:  See server log for query details.
 -- try that with GEQO too
 begin;
 set geqo = on;