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-10-08 01:23:03.156941109 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out	2024-10-08 01:32:26.276624743 +0000
@@ -1909,21 +1909,10 @@
 where exists(select * from tenk1 c
              where b.twothousand = c.twothousand and b.fivethous <> c.fivethous)
       and a.tenthous = b.tenthous and a.tenthous < 5000;
-                  QUERY PLAN                   
------------------------------------------------
- Hash Semi Join
-   Hash Cond: (b.twothousand = c.twothousand)
-   Join Filter: (b.fivethous <> c.fivethous)
-   ->  Hash Join
-         Hash Cond: (b.tenthous = a.tenthous)
-         ->  Seq Scan on tenk1 b
-         ->  Hash
-               ->  Seq Scan on tenk1 a
-                     Filter: (tenthous < 5000)
-   ->  Hash
-         ->  Seq Scan on tenk1 c
-(11 rows)
-
+ERROR:  deadlock detected
+DETAIL:  Process 53779 waits for AccessShareLock on relation 24428 of database 16384; blocked by process 53771.
+Process 53771 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 53779.
+HINT:  See server log for query details.
 --
 -- More complicated constructs
 --