Debian Codegraph @

mysql-test/suite/galera/r/MW-258.result

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