Debian Codegraph @

mysql-test/suite/galera/t/MW-252.test

raw
1 #
2 # MW-252 - Check that FTWRL causes the node to become desynced
3 # and not subject to flow control
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 --connection node_1
10 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
11
12 FLUSH TABLES WITH READ LOCK;
13
14 # Node #1 is now desynced
15 --let $wait_condition = SELECT VARIABLE_VALUE = 'Donor/Desynced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment'
16 --source include/wait_condition.inc
17
18 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
19
20 # Node #2 can issue updates without flow control kicking in
21 --connection node_2
22
23 --let $count = 100
24 --disable_query_log
25 while ($count)
26 {
27 INSERT INTO t1 VALUES (1);
28 --dec $count
29 }
30 --enable_query_log
31
32 # Restore cluster
33 --connection node_1
34 UNLOCK TABLES;
35
36 --let $wait_condition = SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment'
37 --source include/wait_condition.inc
38
39 --let $wait_condition = SELECT COUNT(*) = 100 FROM t1
40 --source include/wait_condition.inc
41
42 DROP TABLE t1;