Debian Codegraph @

mysql-test/suite/galera_3nodes/r/galera_pc_weight.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
5 VARIABLE_VALUE = 3
6 1
7 SET GLOBAL wsrep_provider_options = 'pc.weight=3';
8 SELECT VARIABLE_VALUE AS expect_5 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
9 expect_5
10 5
11 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=1';
12 connection node_2;
13 SET SESSION wsrep_sync_wait=0;
14 SET SESSION wsrep_on=OFF;
15 SET SESSION wsrep_on=ON;
16 SHOW STATUS LIKE 'wsrep_cluster_size';
17 Variable_name Value
18 wsrep_cluster_size 2
19 SHOW STATUS LIKE 'wsrep_cluster_weight';
20 Variable_name Value
21 wsrep_cluster_weight 0
22 SHOW STATUS LIKE 'wsrep_cluster_status';
23 Variable_name Value
24 wsrep_cluster_status non-Primary
25 SHOW STATUS LIKE 'wsrep_connected';
26 Variable_name Value
27 wsrep_connected ON
28 SHOW STATUS LIKE 'wsrep_ready';
29 Variable_name Value
30 wsrep_ready OFF
31 SHOW STATUS LIKE 'wsrep_local_state';
32 Variable_name Value
33 wsrep_local_state 0
34 SHOW STATUS LIKE 'wsrep_local_state_comment';
35 Variable_name Value
36 wsrep_local_state_comment Initialized
37 connection node_3;
38 SET SESSION wsrep_sync_wait=0;
39 SET SESSION wsrep_on=OFF;
40 SET SESSION wsrep_on=ON;
41 SHOW STATUS LIKE 'wsrep_cluster_size';
42 Variable_name Value
43 wsrep_cluster_size 2
44 SHOW STATUS LIKE 'wsrep_cluster_weight';
45 Variable_name Value
46 wsrep_cluster_weight 0
47 SHOW STATUS LIKE 'wsrep_cluster_status';
48 Variable_name Value
49 wsrep_cluster_status non-Primary
50 SHOW STATUS LIKE 'wsrep_connected';
51 Variable_name Value
52 wsrep_connected ON
53 SHOW STATUS LIKE 'wsrep_ready';
54 Variable_name Value
55 wsrep_ready OFF
56 SHOW STATUS LIKE 'wsrep_local_state';
57 Variable_name Value
58 wsrep_local_state 0
59 SHOW STATUS LIKE 'wsrep_local_state_comment';
60 Variable_name Value
61 wsrep_local_state_comment Initialized
62 connection node_1;
63 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
64 expect_3
65 3
66 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
67 expect_Primary
68 Primary
69 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
70 expect_ON
71 ON
72 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
73 expect_ON
74 ON
75 SELECT VARIABLE_VALUE AS expect_4 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
76 expect_4
77 4
78 SELECT VARIABLE_VALUE AS expect_Synced FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
79 expect_Synced
80 Synced
81 SET GLOBAL wsrep_provider_options = 'pc.weight=1';
82 SELECT VARIABLE_VALUE AS expect_1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
83 expect_1
84 1
85 connection node_1;
86 SET GLOBAL wsrep_provider_options = 'gmcast.isolate=0';
87 connection node_2;
88 connection node_3;
89 connection node_2;
90 connection node_3;
91 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
92 expect_3
93 3
94 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
95 expect_3
96 3
97 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
98 expect_Primary
99 Primary
100 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
101 expect_ON
102 ON
103 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
104 expect_ON
105 ON
106 SELECT VARIABLE_VALUE AS expect_4 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
107 expect_4
108 4
109 SELECT VARIABLE_VALUE AS expect_Synced FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
110 expect_Synced
111 Synced
112 connection node_2;
113 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
114 expect_3
115 3
116 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
117 expect_3
118 3
119 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
120 expect_Primary
121 Primary
122 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
123 expect_ON
124 ON
125 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
126 expect_ON
127 ON
128 SELECT VARIABLE_VALUE AS expect_4 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
129 expect_4
130 4
131 SELECT VARIABLE_VALUE AS expect_Synced FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
132 expect_Synced
133 Synced
134 connection node_1;
135 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
136 expect_3
137 3
138 SELECT VARIABLE_VALUE AS expect_3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_weight';
139 expect_3
140 3
141 SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
142 expect_Primary
143 Primary
144 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_connected';
145 expect_ON
146 ON
147 SELECT VARIABLE_VALUE AS expect_ON FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
148 expect_ON
149 ON
150 SELECT VARIABLE_VALUE AS expect_4 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state';
151 expect_4
152 4
153 SELECT VARIABLE_VALUE AS expect_Synced FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
154 expect_Synced
155 Synced
156 SET GLOBAL wsrep_provider_options = 'pc.weight=1';
157 CALL mtr.add_suppression('WSREP: gcs_caused\\(\\) returned -1');
158 connection node_2;
159 CALL mtr.add_suppression('SYNC message from member');
160 CALL mtr.add_suppression('WSREP: user message in state LEAVING');
161 CALL mtr.add_suppression('sending install message failed: (Transport endpoint|Socket) is not connected');
162 CALL mtr.add_suppression('overriding reported weight for ');
163 connection node_3;
164 CALL mtr.add_suppression('WSREP: user message in state LEAVING');
165 CALL mtr.add_suppression('sending install message failed: (Transport endpoint|Socket) is not connected');
166 CALL mtr.add_suppression('overriding reported weight for ');