Debian Codegraph @

mysql-test/suite/galera_sr/r/mysql-wsrep-features#96.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
5 CREATE TABLE t2 (f2 VARCHAR(32));
6 SET SESSION wsrep_trx_fragment_size=1;
7 SET AUTOCOMMIT=OFF;
8 START TRANSACTION;
9 INSERT INTO t1 VALUES (1);
10 INSERT INTO t1 VALUES (2),(1);
11 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
12 INSERT INTO t2 VALUES ('abc');
13 connection node_2;
14 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15 SELECT COUNT(*) = 0 FROM t1;
16 COUNT(*) = 0
17 1
18 SELECT COUNT(*) = 1 FROM t2;
19 COUNT(*) = 1
20 1
21 connection node_1;
22 ROLLBACK;
23 connection node_2;
24 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
25 SELECT COUNT(*) = 0 FROM t1;
26 COUNT(*) = 0
27 1
28 SELECT COUNT(*) = 0 FROM t2;
29 COUNT(*) = 0
30 1
31 connection node_1;
32 DROP TABLE t1;
33 DROP TABLE t2;