Debian Codegraph @

mysql-test/suite/galera/t/MDEV-6860.test

raw
1 --source include/have_innodb.inc
2
3 --source include/galera_cluster.inc
4
5 --connection node_2
6 --disable_query_log
7 --eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_USER='root', MASTER_SSL_VERIFY_SERVER_CERT=0, MASTER_PORT=$NODE_MYPORT_3, master_use_gtid=slave_pos;
8 --enable_query_log
9 START SLAVE;
10
11 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
12 --connection node_3
13 --let $inserts=1000
14 CREATE TABLE t1 (f1 int, f2 int) ENGINE=InnoDB;
15
16 --let $count=0
17 --disable_query_log
18 while($count < $inserts)
19 {
20 --eval insert into t1 values ($count,1)
21 --inc $count
22 }
23 --enable_query_log
24
25 --connection node_2
26
27 --let $wait_condition = SELECT COUNT(*) = $inserts FROM t1
28 --source include/wait_condition.inc
29
30 --connection node_1
31 --let $wait_condition = SELECT COUNT(*) = $inserts FROM t1
32 --source include/wait_condition.inc
33
34 --connection node_3
35 DROP TABLE t1;
36
37 --connection node_2
38 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test'
39 --source include/wait_condition.inc
40
41 STOP SLAVE;
42 RESET SLAVE ALL;