Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --connection node_1
5 CREATE TABLE t1 (f1 INTEGER);
6 LOCK TABLE t1 WRITE;
7 --echo value prior to RSU:
8 SHOW STATUS LIKE 'wsrep_desync_count';
9 SHOW VARIABLES LIKE 'wsrep_desync';
10
11 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
12 --connection node_1a
13 SET SESSION wsrep_sync_wait = 0;
14 SET SESSION wsrep_osu_method = RSU;
15 --send ALTER TABLE t1 ADD COLUMN f2 INTEGER;
16
17 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1
18 --connection node_1b
19 SET SESSION wsrep_sync_wait = 0;
20 SET SESSION wsrep_osu_method = RSU;
21 --send ALTER TABLE t1 ADD COLUMN f3 INTEGER;
22
23 --sleep 5
24 --connection node_1
25 --echo value during RSU:
26 SHOW STATUS LIKE 'wsrep_desync_count';
27 SHOW VARIABLES LIKE 'wsrep_desync';
28 UNLOCK TABLES;
29
30 --connection node_1a
31 --reap
32 --connection node_1b
33 --reap
34
35 --connection node_1
36 --echo value after RSU:
37 --sleep 3
38 SHOW STATUS LIKE 'wsrep_desync_count';
39 SHOW VARIABLES LIKE 'wsrep_desync';
40 SET GLOBAL wsrep_desync=0;
41
42 DROP TABLE t1;