diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 12:15:05 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 12:15:05 +0000 |
| commit | 46651ce6fe013220ed397add242004d764fc0153 (patch) | |
| tree | 6e5299f990f88e60174a1d3ae6e48eedd2688b2b /src/test/isolation/expected/deadlock-parallel.out | |
| parent | Initial commit. (diff) | |
| download | postgresql-14-46651ce6fe013220ed397add242004d764fc0153.tar.xz postgresql-14-46651ce6fe013220ed397add242004d764fc0153.zip | |
Adding upstream version 14.5.upstream/14.5upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'src/test/isolation/expected/deadlock-parallel.out')
| -rw-r--r-- | src/test/isolation/expected/deadlock-parallel.out | 68 |
1 files changed, 68 insertions, 0 deletions
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; <waiting ...> +step e2l: SELECT lock_excl(2,x) FROM bigt LIMIT 1; <waiting ...> +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; <waiting ...> +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; <waiting ...> +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; |