diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2016-02-12 17:02:59 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2016-02-12 17:02:59 -0500 |
| commit | 3992188c2a8702bcb92140a840b5378b27468921 (patch) | |
| tree | 1ddb2b436967477d66e3ba13a26f9a461764fd7e /src | |
| parent | 34f13cc48432fb0a70bd76116347a758b7a0bc63 (diff) | |
| download | postgresql-3992188c2a8702bcb92140a840b5378b27468921.tar.gz postgresql-3992188c2a8702bcb92140a840b5378b27468921.zip | |
Revert "Still further tweaking of deadlock isolation tests."
This reverts commit d03130d378b5fb071d231a7822784ad87268583a.
That was dependent on an isolationtester.c change that now proves
to be broken; we will need to find another solution.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/isolation/expected/deadlock-hard.out | 9 | ||||
| -rw-r--r-- | src/test/isolation/specs/deadlock-hard.spec | 6 |
2 files changed, 5 insertions, 10 deletions
diff --git a/src/test/isolation/expected/deadlock-hard.out b/src/test/isolation/expected/deadlock-hard.out index 7038972675d..b4ce01962d6 100644 --- a/src/test/isolation/expected/deadlock-hard.out +++ b/src/test/isolation/expected/deadlock-hard.out @@ -15,15 +15,12 @@ step s3a4: LOCK TABLE a4; <waiting ...> step s4a5: LOCK TABLE a5; <waiting ...> step s5a6: LOCK TABLE a6; <waiting ...> step s6a7: LOCK TABLE a7; <waiting ...> -step s7a8: LOCK TABLE a8; SELECT pg_sleep(5); <waiting ...> +step s7a8: LOCK TABLE a8; <waiting ...> step s8a1: LOCK TABLE a1; <waiting ...> step s8a1: <... completed> -ERROR: deadlock detected -step s8c: COMMIT; step s7a8: <... completed> -pg_sleep - - +error in steps s8a1 s7a8: ERROR: deadlock detected +step s8c: COMMIT; step s7c: COMMIT; step s6a7: <... completed> step s6c: COMMIT; diff --git a/src/test/isolation/specs/deadlock-hard.spec b/src/test/isolation/specs/deadlock-hard.spec index 459a7a7ea24..1131ec1a97b 100644 --- a/src/test/isolation/specs/deadlock-hard.spec +++ b/src/test/isolation/specs/deadlock-hard.spec @@ -1,9 +1,7 @@ # This is a straightforward deadlock scenario. Since it involves more than # two processes, the main lock detector will find the problem and rollback # the session that first discovers it. Set deadlock_timeout in each session -# so that it's predictable which session fails. Also, when s8 fails and -# rolls back, it unblocks s7, so that there is a race as to whether s7a8 -# or s8a1 will report first. Add a delay in s7a8 to make that predictable. +# so that it's predictable which session fails. setup { @@ -61,7 +59,7 @@ step "s6c" { COMMIT; } session "s7" setup { BEGIN; SET deadlock_timeout = '100s'; } step "s7a7" { LOCK TABLE a7; } -step "s7a8" { LOCK TABLE a8; SELECT pg_sleep(5); } +step "s7a8" { LOCK TABLE a8; } step "s7c" { COMMIT; } session "s8" |