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