diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/select_distinct.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out	2024-09-02 15:26:56.005767252 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/select_distinct.out	2024-09-02 15:34:28.108778149 +0000
@@ -310,11 +310,10 @@
 
 -- Ensure the above gives us the correct result
 SELECT DISTINCT four FROM tenk1 WHERE four = 0;
- four 
-------
-    0
-(1 row)
-
+ERROR:  deadlock detected
+DETAIL:  Process 49149 waits for AccessShareLock on relation 24365 of database 16384; blocked by process 49155.
+Process 49155 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 49149.
+HINT:  See server log for query details.
 -- Ensure we get a plan with a Limit 1
 EXPLAIN (COSTS OFF)
 SELECT DISTINCT four FROM tenk1 WHERE four = 0 AND two <> 0;
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/btree_index.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out	2024-09-02 15:26:55.933767251 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/btree_index.out	2024-09-02 15:34:30.740776854 +0000
@@ -176,13 +176,10 @@
 -- leaf page (the right sibling of the page scanned by the last test case):
 explain (costs off)
 select hundred, twenty from tenk1 where hundred <= 48 order by hundred desc limit 1;
-                       QUERY PLAN                       
---------------------------------------------------------
- Limit
-   ->  Index Scan Backward using tenk1_hundred on tenk1
-         Index Cond: (hundred <= 48)
-(3 rows)
-
+ERROR:  deadlock detected
+DETAIL:  Process 49150 waits for AccessShareLock on relation 24365 of database 16384; blocked by process 49155.
+Process 49155 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 49150.
+HINT:  See server log for query details.
 select hundred, twenty from tenk1 where hundred <= 48 order by hundred desc limit 1;
  hundred | twenty 
 ---------+--------