Debian Codegraph @

mysql-test/suite/galera/r/galera_serializable.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (id INT PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
5 SET AUTOCOMMIT=OFF;
6 SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
7 START TRANSACTION;
8 SELECT * FROM t1;
9 id f2
10 connection node_2;
11 INSERT INTO t1 VALUES (1,1);
12 connection node_1;
13 SELECT * FROM t1;
14 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
15 ROLLBACK;
16 DELETE FROM t1;
17 connection node_1;
18 INSERT INTO t1 VALUES (1,1);
19 START TRANSACTION;
20 SELECT * FROM t1;
21 id f2
22 1 1
23 connection node_2;
24 UPDATE t1 SET f2 = 2;
25 connection node_1;
26 UPDATE t1 SET f2 = 3;
27 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
28 ROLLBACK;
29 DELETE FROM t1;
30 connection node_1;
31 START TRANSACTION;
32 connection node_1;
33 INSERT INTO t1 VALUES (1,1);
34 connection node_2;
35 INSERT INTO t1 VALUES (1,2);
36 connection node_1;
37 COMMIT;
38 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
39 DROP TABLE t1;