Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_parallel_apply.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test SR with parallel apply
6 #
7
8 --connection node_2
9 --let $wsrep_slave_threads_orig = `SELECT @@wsrep_slave_threads`
10 SET GLOBAL wsrep_slave_threads = 5;
11
12 --connection node_1
13 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=InnoDB;
14 SET SESSION wsrep_trx_fragment_size = 1;
15 SET AUTOCOMMIT=OFF;
16 START TRANSACTION;
17 INSERT INTO t1 (f2) VALUES (1);
18 INSERT INTO t1 (f2) VALUES (1);
19 INSERT INTO t1 (f2) VALUES (1);
20 INSERT INTO t1 (f2) VALUES (1);
21 --send INSERT INTO t1 (f2) VALUES (1);
22
23 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
24 SET SESSION wsrep_trx_fragment_size = 1;
25 SET AUTOCOMMIT=OFF;
26 START TRANSACTION;
27 INSERT INTO t1 (f2) VALUES (2);
28 INSERT INTO t1 (f2) VALUES (2);
29 INSERT INTO t1 (f2) VALUES (2);
30 INSERT INTO t1 (f2) VALUES (2);
31 --send INSERT INTO t1 (f2) VALUES (2);
32
33 --connection node_2
34 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
35 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1 WHERE f2 = 1;
36 --source include/wait_condition.inc
37
38 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1 WHERE f2 = 2;
39 --source include/wait_condition.inc
40
41 --connection node_1
42 --reap
43 COMMIT;
44
45 --connection node_1a
46 --reap
47 ROLLBACK;
48
49 --connection node_2
50 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
51 SELECT COUNT(*) = 5 FROM t1;
52
53 --connection node_1
54 DROP TABLE t1;
55
56 --connection node_2
57 --disable_query_log
58 --eval SET GLOBAL wsrep_slave_threads = $wsrep_slave_threads_orig;
59 --enable_query_log