Debian Codegraph @

mysql-test/suite/galera_3nodes/t/galera_vote_rejoin_mysqldump.test

raw
1 #
2 # Test that mysqldump SST is possible after a vote without a cluster restart
3 #
4
5 --source include/galera_cluster.inc
6 --source suite/galera/include/galera_sst_set_mysqldump.inc
7
8 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
9
10 # Save original auto_increment_offset values.
11 --let $node_1=node_1
12 --let $node_2=node_2
13 --let $node_3=node_3
14 --source ../galera/include/auto_increment_offset_save.inc
15
16 --connection node_1
17 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
18
19 # Introduce inconsistency on node #2
20
21 --connection node_2
22 --let $wsrep_cluster_address_node2 = `SELECT @@wsrep_cluster_address`
23 SET SESSION wsrep_on=OFF;
24 ALTER TABLE t1 ADD PRIMARY KEY (f1);
25 SET SESSION wsrep_on=ON;
26
27 # Run DDL that will fail on nodes #1 and #3 but succeed on node #2
28
29 --connection node_1
30 --error ER_CANT_DROP_FIELD_OR_KEY
31 ALTER TABLE t1 LOCK=SHARED, DROP PRIMARY KEY;
32
33 # Nodes #1 and #3 remain in the cluster
34
35 --connection node_1
36 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
37 --source include/wait_condition.inc
38
39 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
40
41 --connection node_3
42 SELECT VARIABLE_VALUE AS expect_2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
43 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
44
45 # Node #2 is kicked out
46
47 --connection node_2
48 SET SESSION wsrep_on=OFF;
49 --let $wait_condition = SELECT VARIABLE_VALUE = 'Disconnected' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
50 --source include/wait_condition.inc
51 SELECT VARIABLE_VALUE AS expect_Disconnected FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
52 SET SESSION wsrep_on=ON;
53
54 # Restore cluster
55
56 --disable_query_log
57 --eval SET GLOBAL wsrep_cluster_address = '$wsrep_cluster_address_node2'
58 --enable_query_log
59 --enable_reconnect
60
61 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
62 --source include/wait_condition.inc
63
64 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
65 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
66
67 # Confirm that the table is now identical throughout
68
69 --connection node_1
70 SHOW CREATE TABLE t1;
71
72 --connection node_2
73 SHOW CREATE TABLE t1;
74
75 --connection node_3
76 SHOW CREATE TABLE t1;
77 DROP TABLE t1;
78 CALL mtr.add_suppression("Slave SQL: Error 'Can't DROP 'PRIMARY'; check that column/key exists'");
79
80 --connection node_1
81 --source suite/galera/include/galera_sst_restore.inc
82
83 --connection node_2
84 # restart node so we don't fail on WSREP_START_POSITION internal check
85 --source include/restart_mysqld.inc
86 --source include/wait_until_connected_again.inc
87 CALL mtr.add_suppression("WSREP: .+ is inconsistent with group");
88
89 --connection node_1
90 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
91 --source include/wait_condition.inc
92
93 # Restore original auto_increment_offset values.
94 --source ../galera/include/auto_increment_offset_restore.inc