diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/src/test/regress/results/btree_index.out --- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-09-29 20:40:44.908096597 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/btree_index.out 2024-09-29 20:45:36.751202607 +0000 @@ -212,13 +212,10 @@ explain (costs off) select distinct hundred from tenk1 where hundred in (47, 48, 72, 82) order by hundred desc; - QUERY PLAN ------------------------------------------------------------------- - Unique - -> Index Only Scan Backward using tenk1_hundred on tenk1 - Index Cond: (hundred = ANY ('{47,48,72,82}'::integer[])) -(3 rows) - +ERROR: deadlock detected +DETAIL: Process 23009 waits for AccessShareLock on relation 24389 of database 16384; blocked by process 23023. +Process 23023 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 23009. +HINT: See server log for query details. select distinct hundred from tenk1 where hundred in (47, 48, 72, 82) order by hundred desc; hundred ---------