From 46651ce6fe013220ed397add242004d764fc0153 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:15:05 +0200 Subject: Adding upstream version 14.5. Signed-off-by: Daniel Baumann --- src/test/isolation/expected/deadlock-parallel.out | 68 +++++++++++++++++++++++ 1 file changed, 68 insertions(+) create mode 100644 src/test/isolation/expected/deadlock-parallel.out (limited to 'src/test/isolation/expected/deadlock-parallel.out') diff --git a/src/test/isolation/expected/deadlock-parallel.out b/src/test/isolation/expected/deadlock-parallel.out new file mode 100644 index 0000000..6fe5e24 --- /dev/null +++ b/src/test/isolation/expected/deadlock-parallel.out @@ -0,0 +1,68 @@ +Parsed test spec with 4 sessions + +starting permutation: d1a1 d2a2 e1l e2l d1a2 d2a1 d1c e1c d2c e2c +step d1a1: SELECT lock_share(1,x), lock_excl(3,x) FROM bigt LIMIT 1; +lock_share|lock_excl +----------+--------- + 1| 1 +(1 row) + +step d2a2: select lock_share(2,x) FROM bigt LIMIT 1; +lock_share +---------- + 1 +(1 row) + +step e1l: SELECT lock_excl(1,x) FROM bigt LIMIT 1; +step e2l: SELECT lock_excl(2,x) FROM bigt LIMIT 1; +step d1a2: SET force_parallel_mode = on; + SET parallel_setup_cost = 0; + SET parallel_tuple_cost = 0; + SET min_parallel_table_scan_size = 0; + SET parallel_leader_participation = off; + SET max_parallel_workers_per_gather = 3; + SELECT sum(lock_share(2,x)) FROM bigt; +step d2a1: SET force_parallel_mode = on; + SET parallel_setup_cost = 0; + SET parallel_tuple_cost = 0; + SET min_parallel_table_scan_size = 0; + SET parallel_leader_participation = off; + SET max_parallel_workers_per_gather = 3; + SELECT sum(lock_share(1,x)) FROM bigt; + SET force_parallel_mode = off; + RESET parallel_setup_cost; + RESET parallel_tuple_cost; + SELECT lock_share(3,x) FROM bigt LIMIT 1; +step d1a2: <... completed> + sum +----- +10000 +(1 row) + +step d1c: COMMIT; +step e1l: <... completed> +lock_excl +--------- + 1 +(1 row) + +step d2a1: <... completed> + sum +----- +10000 +(1 row) + +lock_share +---------- + 1 +(1 row) + +step e1c: COMMIT; +step d2c: COMMIT; +step e2l: <... completed> +lock_excl +--------- + 1 +(1 row) + +step e2c: COMMIT; -- cgit v1.2.3