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-30 13:57:11.601985533 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out	2024-11-30 14:07:30.454129867 +0000
@@ -2399,20 +2399,10 @@
                     where t2.unique1=unique1)
 where t1.unique1 < 10 and t2.unique1 < 10
 order by t1.unique1;
- unique1 | unique1 
----------+---------
-       0 |       0
-       1 |       1
-       2 |       2
-       3 |       3
-       4 |       4
-       5 |       5
-       6 |       6
-       7 |       7
-       8 |       8
-       9 |       9
-(10 rows)
-
+ERROR:  deadlock detected
+DETAIL:  Process 56011 waits for AccessShareLock on relation 25344 of database 16384; blocked by process 56016.
+Process 56016 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 56011.
+HINT:  See server log for query details.
 --
 -- checks for correct handling of quals in multiway outer joins
 --