Debian Codegraph @

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

raw
1 #
2 # Test the pc.weight wsrep provider option. We set Node #1 to have a high
3 # weight and then suspend it. This will cause Nodes #2 and #3 to transition
4 # to non-primary component.
5 #
6
7 --source include/big_test.inc
8 --source include/galera_cluster.inc
9
10 --connection node_1
11 SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
12 SET GLOBAL wsrep_provider_options = 'pc.weight=3';
13 SELECT VARIABLE_VALUE AS expect_5 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
14
15 # Isolate node_1 from the cluster.
16 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=1';
17
18 --connection node_2
19 # Do not wait for causality as we are no longer in the primary component
20 SET SESSION wsrep_sync_wait=0;
21 SET SESSION wsrep_on=OFF;
22 --let $wait_condition = SELECT VARIABLE_VALUE = 'non-Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'
23 --source include/wait_condition.inc
24 SET SESSION wsrep_on=ON;
25
26 # We can not use SELECT queries here, as only SHOW is allowed to run.
27 # For nodes #2 and #3, we expect a non-primary component of size 2
28 # and cluster weight 0
29 SHOW STATUS LIKE 'wsrep_cluster_size';
30 SHOW STATUS LIKE 'wsrep_cluster_weight';
31 SHOW STATUS LIKE 'wsrep_cluster_status';
32 SHOW STATUS LIKE 'wsrep_connected';
33 SHOW STATUS LIKE 'wsrep_ready';
34 SHOW STATUS LIKE 'wsrep_local_state';
35 SHOW STATUS LIKE 'wsrep_local_state_comment';
36
37 --let $galera_connection_name = node_3
38 --let $galera_server_number = 3
39 --source include/galera_connect.inc
40 --connection node_3
41 SET SESSION wsrep_sync_wait=0;
42 SET SESSION wsrep_on=OFF;
43 --let $wait_condition = SELECT VARIABLE_VALUE = 'non-Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'
44 --source include/wait_condition.inc
45 SET SESSION wsrep_on=ON;
46
47 SHOW STATUS LIKE 'wsrep_cluster_size';
48 SHOW STATUS LIKE 'wsrep_cluster_weight';
49 SHOW STATUS LIKE 'wsrep_cluster_status';
50 SHOW STATUS LIKE 'wsrep_connected';
51 SHOW STATUS LIKE 'wsrep_ready';
52 SHOW STATUS LIKE 'wsrep_local_state';
53 SHOW STATUS LIKE 'wsrep_local_state_comment';
54
55 --connection node_1
56
57 # For Node #1, we expect a primary component of size 1
58 # (NOTE: this is a bit racy as nodes 2 and 3 will try to reconnect ASAP.
59 # to avoid the raice they should be suspended first as well, but that's
60 # not currently possible)
61
62 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
63 --source include/wait_condition.inc
64
65 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
66 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
67 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
68 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
69 SELECT VARIABLE_VALUE AS expect_4 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
70 SELECT VARIABLE_VALUE AS expect_Synced FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
71
72 SET GLOBAL wsrep_provider_options = 'pc.weight=1';
73 SELECT VARIABLE_VALUE AS expect_1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
74
75 # Resume cluster connectivity on node_1
76 --connection node_1
77 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=0';
78
79 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
80 --source include/wait_condition.inc
81 --source include/galera_wait_ready.inc
82
83 --connection node_2
84 --source include/wait_condition.inc
85 --source include/galera_wait_ready.inc
86
87 --connection node_3
88 --source include/wait_condition.inc
89 --source include/galera_wait_ready.inc
90
91 # wait until nodes 2 and 3 have declared ready state (can happen after cluster_size raaise)
92 --connection node_2
93 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready'
94 --source include/wait_condition.inc
95
96 --connection node_3
97 --source include/wait_condition.inc
98
99
100 # On all nodes, we now expect a Primary component of size 3, weight 3, Synced and ready
101 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
102 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
103 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
104 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
105 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
106 SELECT VARIABLE_VALUE AS expect_4 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
107 SELECT VARIABLE_VALUE AS expect_Synced FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
108
109 --connection node_2
110 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
111 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
112 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
113 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
114 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
115 SELECT VARIABLE_VALUE AS expect_4 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
116 SELECT VARIABLE_VALUE AS expect_Synced FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
117
118 --connection node_1
119 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
120 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
121 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
122 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
123 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
124 SELECT VARIABLE_VALUE AS expect_4 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
125 SELECT VARIABLE_VALUE AS expect_Synced FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
126
127 SET GLOBAL wsrep_provider_options = 'pc.weight=1';
128 --let $wait_condition = SELECT @@wsrep_provider_options LIKE '%pc.weight = 1%'
129 --source include/wait_condition.inc
130
131 CALL mtr.add_suppression('WSREP: gcs_caused\\(\\) returned -1');
132
133 --connection node_2
134 CALL mtr.add_suppression('SYNC message from member');
135 CALL mtr.add_suppression('WSREP: user message in state LEAVING');
136 CALL mtr.add_suppression('sending install message failed: (Transport endpoint|Socket) is not connected');
137 CALL mtr.add_suppression('overriding reported weight for ');
138
139 --connection node_3
140 CALL mtr.add_suppression('WSREP: user message in state LEAVING');
141 CALL mtr.add_suppression('sending install message failed: (Transport endpoint|Socket) is not connected');
142 CALL mtr.add_suppression('overriding reported weight for ');