diff options
| -rw-r--r-- | src/test/isolation/expected/timeouts.out | 16 | ||||
| -rw-r--r-- | src/test/isolation/specs/timeouts.spec | 8 |
2 files changed, 12 insertions, 12 deletions
diff --git a/src/test/isolation/expected/timeouts.out b/src/test/isolation/expected/timeouts.out index 0ad792ae09..13822005a4 100644 --- a/src/test/isolation/expected/timeouts.out +++ b/src/test/isolation/expected/timeouts.out @@ -6,7 +6,7 @@ accountid balance checking 600 savings 600 -step sto: SET statement_timeout = 1000; +step sto: SET statement_timeout = 2000; step locktbl: LOCK TABLE accounts; <waiting ...> step locktbl: <... completed> ERROR: canceling statement due to statement timeout @@ -17,7 +17,7 @@ accountid balance checking 600 savings 600 -step lto: SET lock_timeout = 1000; +step lto: SET lock_timeout = 2000; step locktbl: LOCK TABLE accounts; <waiting ...> step locktbl: <... completed> ERROR: canceling statement due to lock timeout @@ -28,7 +28,7 @@ accountid balance checking 600 savings 600 -step lsto: SET lock_timeout = 1000; SET statement_timeout = 2000; +step lsto: SET lock_timeout = 2000; SET statement_timeout = 3000; step locktbl: LOCK TABLE accounts; <waiting ...> step locktbl: <... completed> ERROR: canceling statement due to lock timeout @@ -39,35 +39,35 @@ accountid balance checking 600 savings 600 -step slto: SET lock_timeout = 2000; SET statement_timeout = 1000; +step slto: SET lock_timeout = 3000; SET statement_timeout = 2000; step locktbl: LOCK TABLE accounts; <waiting ...> step locktbl: <... completed> ERROR: canceling statement due to statement timeout starting permutation: wrtbl sto update step wrtbl: UPDATE accounts SET balance = balance + 100; -step sto: SET statement_timeout = 1000; +step sto: SET statement_timeout = 2000; step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...> step update: <... completed> ERROR: canceling statement due to statement timeout starting permutation: wrtbl lto update step wrtbl: UPDATE accounts SET balance = balance + 100; -step lto: SET lock_timeout = 1000; +step lto: SET lock_timeout = 2000; step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...> step update: <... completed> ERROR: canceling statement due to lock timeout starting permutation: wrtbl lsto update step wrtbl: UPDATE accounts SET balance = balance + 100; -step lsto: SET lock_timeout = 1000; SET statement_timeout = 2000; +step lsto: SET lock_timeout = 2000; SET statement_timeout = 3000; step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...> step update: <... completed> ERROR: canceling statement due to lock timeout starting permutation: wrtbl slto update step wrtbl: UPDATE accounts SET balance = balance + 100; -step slto: SET lock_timeout = 2000; SET statement_timeout = 1000; +step slto: SET lock_timeout = 3000; SET statement_timeout = 2000; step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...> step update: <... completed> ERROR: canceling statement due to statement timeout diff --git a/src/test/isolation/specs/timeouts.spec b/src/test/isolation/specs/timeouts.spec index 000b50c9c9..39bcf0cc81 100644 --- a/src/test/isolation/specs/timeouts.spec +++ b/src/test/isolation/specs/timeouts.spec @@ -19,10 +19,10 @@ teardown { ABORT; } session "s2" setup { BEGIN ISOLATION LEVEL READ COMMITTED; } -step "sto" { SET statement_timeout = 1000; } -step "lto" { SET lock_timeout = 1000; } -step "lsto" { SET lock_timeout = 1000; SET statement_timeout = 2000; } -step "slto" { SET lock_timeout = 2000; SET statement_timeout = 1000; } +step "sto" { SET statement_timeout = 2000; } +step "lto" { SET lock_timeout = 2000; } +step "lsto" { SET lock_timeout = 2000; SET statement_timeout = 3000; } +step "slto" { SET lock_timeout = 3000; SET statement_timeout = 2000; } step "locktbl" { LOCK TABLE accounts; } step "update" { DELETE FROM accounts WHERE accountid = 'checking'; } teardown { ABORT; } |