Debian Codegraph @

mysql-test/suite/galera/t/galera_parallel_simple.test

raw
1 #
2 # Test that SHOW PROCESSLIST reports that two slave threads have been involved in applying
3 # two independent transactions
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 --let $wsrep_slave_threads_orig = `SELECT @@wsrep_slave_threads`
10
11 CREATE TABLE t1 (id INT) ENGINE=InnoDB;
12 CREATE TABLE t2 (id INT) ENGINE=InnoDB;
13
14 --connection node_2
15
16 # Wait until above DDL's are replicated
17 --let $wait_condition = SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
18 --source include/wait_condition.inc
19
20 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
21
22 SET GLOBAL wsrep_slave_threads = 2;
23
24 LOCK TABLE t1 WRITE;
25
26 --connection node_1
27 INSERT INTO t1 VALUES (1);
28 INSERT INTO t2 VALUES (1);
29
30 INSERT INTO t1 VALUES (1);
31 INSERT INTO t2 VALUES (1);
32
33 INSERT INTO t1 VALUES (1);
34 INSERT INTO t2 VALUES (1);
35
36 INSERT INTO t1 VALUES (1);
37 INSERT INTO t2 VALUES (1);
38
39 INSERT INTO t1 VALUES (1);
40 INSERT INTO t2 VALUES (1);
41
42 INSERT INTO t1 select * from t1;
43 INSERT INTO t2 select * from t2;
44
45 INSERT INTO t1 select * from t1;
46 INSERT INTO t2 select * from t2;
47
48 --connection node_2
49 SET SESSION wsrep_sync_wait = 0;
50
51 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
52 --source include/wait_condition.inc
53
54 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE '%committing%' OR STATE LIKE 'Commit' OR STATE LIKE 'Waiting for certification');
55 --source include/wait_condition.inc
56
57 UNLOCK TABLES;
58
59 SET SESSION wsrep_sync_wait = 15;
60
61 SELECT COUNT(*) as expect_20 FROM t1;
62 SELECT COUNT(*) as expect_20 FROM t2;
63
64 --disable_query_log
65 --eval SET GLOBAL wsrep_slave_threads = $wsrep_slave_threads_orig;
66 --enable_query_log
67
68 DROP TABLE t1;
69 DROP TABLE t2;