diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/btree_index.out --- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-10-08 01:23:03.116901494 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/btree_index.out 2024-10-08 01:30:28.876878069 +0000 @@ -194,13 +194,10 @@ -- explain (costs off) select distinct hundred from tenk1 where hundred in (47, 48, 72, 82); - QUERY PLAN ------------------------------------------------------------------- - Unique - -> Index Only Scan using tenk1_hundred on tenk1 - Index Cond: (hundred = ANY ('{47,48,72,82}'::integer[])) -(3 rows) - +ERROR: deadlock detected +DETAIL: Process 42315 waits for AccessShareLock on relation 24390 of database 16387; blocked by process 42298. +Process 42298 waits for AccessExclusiveLock on relation 16421 of database 16387; blocked by process 42315. +HINT: See server log for query details. select distinct hundred from tenk1 where hundred in (47, 48, 72, 82); hundred ---------