diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_distinct.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out	2024-09-08 13:02:27.645155571 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_distinct.out	2024-09-08 13:07:32.352501482 +0000
@@ -232,18 +232,10 @@
 -- Ensure we get a parallel plan
 EXPLAIN (costs off)
 SELECT DISTINCT four FROM tenk1;
-                     QUERY PLAN                     
-----------------------------------------------------
- Unique
-   ->  Gather Merge
-         Workers Planned: 2
-         ->  Sort
-               Sort Key: four
-               ->  HashAggregate
-                     Group Key: four
-                     ->  Parallel Seq Scan on tenk1
-(8 rows)
-
+ERROR:  deadlock detected
+DETAIL:  Process 34065 waits for AccessShareLock on relation 24292 of database 16387; blocked by process 34053.
+Process 34053 waits for AccessExclusiveLock on relation 16421 of database 16387; blocked by process 34065.
+HINT:  See server log for query details.
 -- Ensure the parallel plan produces the correct results
 SELECT DISTINCT four FROM tenk1;
  four