1Parsed test spec with 2 sessions 2 3starting permutation: s1u1 s1u2 s1c s2u1 s2u2 s2c 4step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 5step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 6step s1c: COMMIT; 7step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 8step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 9step s2c: COMMIT; 10 11starting permutation: s1u1 s1u2 s2u1 s1c s2u2 s2c 12step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 13step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 14step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; <waiting ...> 15step s1c: COMMIT; 16step s2u1: <... completed> 17ERROR: could not serialize access due to concurrent update 18step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 19ERROR: current transaction is aborted, commands ignored until end of transaction block 20step s2c: COMMIT; 21 22starting permutation: s1u1 s2u1 s1u2 s2u2 s2c s1c 23step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 24step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 25step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; <waiting ...> 26step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 27step s2c: COMMIT; 28step s1u2: <... completed> 29ERROR: could not serialize access due to concurrent update 30step s1c: COMMIT; 31 32starting permutation: s1u1 s2u1 s2u2 s1u2 s2c s1c 33step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 34step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 35step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 36step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; <waiting ...> 37step s2c: COMMIT; 38step s1u2: <... completed> 39ERROR: could not serialize access due to concurrent update 40step s1c: COMMIT; 41 42starting permutation: s1u1 s2u1 s2u2 s2c s1u2 s1c 43step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 44step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 45step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 46step s2c: COMMIT; 47step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 48ERROR: could not serialize access due to read/write dependencies among transactions 49step s1c: COMMIT; 50 51starting permutation: s2u1 s1u1 s1u2 s2u2 s2c s1c 52step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 53step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 54step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; <waiting ...> 55step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 56step s2c: COMMIT; 57step s1u2: <... completed> 58ERROR: could not serialize access due to concurrent update 59step s1c: COMMIT; 60 61starting permutation: s2u1 s1u1 s2u2 s1u2 s2c s1c 62step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 63step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 64step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 65step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; <waiting ...> 66step s2c: COMMIT; 67step s1u2: <... completed> 68ERROR: could not serialize access due to concurrent update 69step s1c: COMMIT; 70 71starting permutation: s2u1 s1u1 s2u2 s2c s1u2 s1c 72step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 73step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 74step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 75step s2c: COMMIT; 76step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 77ERROR: could not serialize access due to read/write dependencies among transactions 78step s1c: COMMIT; 79 80starting permutation: s2u1 s2u2 s1u1 s1u2 s2c s1c 81step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 82step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 83step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 84step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; <waiting ...> 85step s2c: COMMIT; 86step s1u2: <... completed> 87ERROR: could not serialize access due to concurrent update 88step s1c: COMMIT; 89 90starting permutation: s2u1 s2u2 s1u1 s2c s1u2 s1c 91step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 92step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 93step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 94step s2c: COMMIT; 95step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 96ERROR: could not serialize access due to read/write dependencies among transactions 97step s1c: COMMIT; 98 99starting permutation: s2u1 s2u2 s2c s1u1 s1u2 s1c 100step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; 101step s2u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 102step s2c: COMMIT; 103step s1u1: UPDATE A SET Col1 = 1 WHERE AID = 1; 104step s1u2: UPDATE B SET Col2 = 1 WHERE BID = 2; 105step s1c: COMMIT; 106