Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_parallel_apply.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_2;
4 SET GLOBAL wsrep_slave_threads = 5;
5 connection node_1;
6 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=InnoDB;
7 SET SESSION wsrep_trx_fragment_size = 1;
8 SET AUTOCOMMIT=OFF;
9 START TRANSACTION;
10 INSERT INTO t1 (f2) VALUES (1);
11 INSERT INTO t1 (f2) VALUES (1);
12 INSERT INTO t1 (f2) VALUES (1);
13 INSERT INTO t1 (f2) VALUES (1);
14 INSERT INTO t1 (f2) VALUES (1);;
15 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
16 SET SESSION wsrep_trx_fragment_size = 1;
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 INSERT INTO t1 (f2) VALUES (2);
20 INSERT INTO t1 (f2) VALUES (2);
21 INSERT INTO t1 (f2) VALUES (2);
22 INSERT INTO t1 (f2) VALUES (2);
23 INSERT INTO t1 (f2) VALUES (2);;
24 connection node_2;
25 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
26 connection node_1;
27 COMMIT;
28 connection node_1a;
29 ROLLBACK;
30 connection node_2;
31 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
32 SELECT COUNT(*) = 5 FROM t1;
33 COUNT(*) = 5
34 1
35 connection node_1;
36 DROP TABLE t1;
37 connection node_2;