diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/regress/results/subselect.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out	2024-09-18 00:26:05.028629042 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/subselect.out	2024-09-18 00:30:57.479853034 +0000
@@ -1023,15 +1023,10 @@
 explain (costs off)
 select count(*) from tenk1 t
 where (exists(select 1 from tenk1 k where k.unique1 = t.unique2) or ten < 0);
-                                QUERY PLAN                                
---------------------------------------------------------------------------
- Aggregate
-   ->  Seq Scan on tenk1 t
-         Filter: ((ANY (unique2 = (hashed SubPlan 2).col1)) OR (ten < 0))
-         SubPlan 2
-           ->  Index Only Scan using tenk1_unique1 on tenk1 k
-(5 rows)
-
+ERROR:  deadlock detected
+DETAIL:  Process 23403 waits for AccessShareLock on relation 24329 of database 16384; blocked by process 23390.
+Process 23390 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 23403.
+HINT:  See server log for query details.
 select count(*) from tenk1 t
 where (exists(select 1 from tenk1 k where k.unique1 = t.unique2) or ten < 0);
  count 
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out /tmp/cirrus-ci-build/src/test/regress/results/arrays.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out	2024-09-18 00:26:04.944629040 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/arrays.out	2024-09-18 00:30:57.219853271 +0000
@@ -2227,11 +2227,10 @@
 
 -- array_agg(anynonarray)
 select array_agg(unique1) from (select unique1 from tenk1 where unique1 < 15 order by unique1) ss;
-              array_agg               
---------------------------------------
- {0,1,2,3,4,5,6,7,8,9,10,11,12,13,14}
-(1 row)
-
+ERROR:  deadlock detected
+DETAIL:  Process 23407 waits for AccessShareLock on relation 24329 of database 16384; blocked by process 23390.
+Process 23390 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 23407.
+HINT:  See server log for query details.
 select array_agg(ten) from (select ten from tenk1 where unique1 < 15 order by unique1) ss;
             array_agg            
 ---------------------------------