diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/arrays.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out	2024-09-16 03:07:07.295301323 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/arrays.out	2024-09-16 03:10:54.554018126 +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 32013 waits for AccessShareLock on relation 24362 of database 16387; blocked by process 32016.
+Process 32016 waits for AccessExclusiveLock on relation 16421 of database 16387; blocked by process 32013.
+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            
 ---------------------------------