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-09-18 00:26:04.980629041 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out	2024-09-18 00:35:09.871666796 +0000
@@ -2264,12 +2264,10 @@
 select aa, bb, unique1, unique1
   from tenk1 right join b_star on aa = unique1
   where bb < bb and bb is null;
-        QUERY PLAN        
---------------------------
- Result
-   One-Time Filter: false
-(2 rows)
-
+ERROR:  deadlock detected
+DETAIL:  Process 53002 waits for AccessShareLock on relation 24436 of database 16384; blocked by process 53013.
+Process 53013 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 53002.
+HINT:  See server log for query details.
 select aa, bb, unique1, unique1
   from tenk1 right join b_star on aa = unique1
   where bb < bb and bb is null;