Debian Codegraph @

mysql-test/suite/group_replication/t/gr_switch_primary_timeout_begin_transactions_rollback.test

raw
1 ################################################################################
2 # This test validates new transactions are rejected immediately if UDF
3 # group_replication_set_as_primary is executed with
4 # `running_transactions_timeout` option.
5 #
6 # Test:
7 # 0. The test requires two servers: M1 and M2.
8 # 1. Setup group of 2 servers, M1(primary) and M2(secondary).
9 # 2. Execute change primary from server2(secondary) and block the operation.
10 # 3. Execute transaction on server1(primary), transactions should fail.
11 # 4. Execute commands which are unaffected with
12 # group_replication_set_as_primary() in execution.
13 # 5. Unblock change primary from server2 and reap the operation.
14 # 6. Assert primary changed.
15 # Assert data is not present on M1 and M2.
16 # 7. Execute change primary from server2(primary) and block the operation.
17 # 8. Execute transaction on server2(primary), transactions should fail.
18 # 9. Execute commands which are not stopped.
19 # 10. Unblock change primary from server2 and reap the operation.
20 # 11. Assert primary changed.
21 # Assert data is not present on M1 and M2.
22 # 12. Cleanup.
23 ################################################################################
24
25 --source include/have_debug_sync.inc
26 --source include/have_group_replication_plugin.inc
27 --let $rpl_skip_group_replication_start= 1
28 --let $rpl_group_replication_single_primary_mode=1
29 --source include/group_replication.inc
30
31 --echo
32 --echo # 1. Setup group of 2 servers, M1(primary) and M2(secondary).
33
34 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
35
36 CREATE TABLE t1(c1 int primary key);
37
38 --source include/start_and_bootstrap_group_replication.inc
39
40 --let $rpl_connection_name= server2
41 --source include/rpl_connection.inc
42
43 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
44
45 --source include/start_group_replication.inc
46
47 --echo
48 --echo # 2. Execute change primary from server2(secondary) and block the operation.
49
50 --let $rpl_connection_name= server2
51 --source include/rpl_connection.inc
52
53 SET @@GLOBAL.DEBUG= '+d,group_replication_block_primary_action_validation';
54
55 --replace_result $server2_uuid SERVER2_UUID
56 --send_eval SELECT group_replication_set_as_primary("$server2_uuid", 1);
57
58 --let $rpl_connection_name= server1
59 --source include/rpl_connection.inc
60
61 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.threads WHERE NAME = "thread/group_rpl/THD_transaction_monitor"
62 --source include/wait_condition.inc
63
64 --echo
65 --echo # 3. Execute transaction on server1(primary), transactions should fail.
66
67 --let $rpl_connection_name= server1
68 --source include/rpl_connection.inc
69
70 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
71 INSERT INTO t1 values(1);
72
73 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
74 CREATE TABLE t2(c1 int primary key);
75
76 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
77 CREATE TABLE t1(c1 int primary key);
78
79 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
80 SELECT c1 FROM t1;
81
82 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
83 DO group_replication_enable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
84
85 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
86 SELECT group_replication_enable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
87
88 --echo
89 --echo # 4. Execute commands which are unaffected with
90 --echo # group_replication_set_as_primary() in execution.
91
92 DO SLEEP(1);
93
94 SELECT SLEEP(1);
95
96 SELECT COUNT(*) from performance_schema.replication_group_members;
97
98 SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE='debug sync point: now';
99
100 SELECT COUNT(*)=1 FROM sys.version;
101
102 --echo
103 --echo # 5. Unblock change primary from server2 and reap the operation.
104
105 --let $rpl_connection_name= server_2
106 --source include/rpl_connection.inc
107 SET DEBUG_SYNC= "now SIGNAL signal.primary_action_continue";
108
109 --let $rpl_connection_name= server2
110 --source include/rpl_connection.inc
111 --replace_result $server2_uuid SERVER2_UUID
112 --reap
113
114 --echo
115 --echo # 6. Assert primary changed.
116 --echo # Assert data is not present on M1 and M2.
117
118 --let $rpl_connection_name= server2
119 --source include/rpl_connection.inc
120
121 --source include/gr_assert_primary_member.inc
122
123 --let $rpl_connection_name= server1
124 --source include/rpl_connection.inc
125
126 --source include/gr_assert_secondary_member.inc
127
128 --let $assert_text= 'There is no value 1 in table t1'
129 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 1, count, 1] = 0
130 --source include/assert.inc
131
132 --let $assert_text= 'Check table t2 does not exist.'
133 --let $assert_cond= "[SELECT COUNT(*) FROM information_schema.tables WHERE TABLE_SCHEMA=\"test\" AND TABLE_NAME=\"t2\"]" = 0
134 --source include/assert.inc
135
136 --let $diff_tables= server1:test.t1, server2:test.t1
137 --source include/diff_tables.inc
138
139 --echo
140 --echo # 7. Execute change primary from server2(primary) and block the operation.
141
142 --let $rpl_connection_name= server2
143 --source include/rpl_connection.inc
144
145 --replace_result $server1_uuid SERVER1_UUID
146 --send_eval SELECT group_replication_set_as_primary("$server1_uuid", 1);
147
148 --let $rpl_connection_name= server_2
149 --source include/rpl_connection.inc
150
151 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.threads WHERE NAME = "thread/group_rpl/THD_transaction_monitor"
152 --source include/wait_condition.inc
153
154 --echo
155 --echo # 8. Execute transaction on server2(primary), transactions should fail.
156
157 --let $rpl_connection_name= server_2
158 --source include/rpl_connection.inc
159
160 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
161 INSERT INTO t1 values(1);
162
163 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
164 CREATE TABLE t2(c1 int primary key);
165
166 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
167 CREATE TABLE t1(c1 int primary key);
168
169 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
170 SELECT c1 FROM t1;
171
172 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
173 DO group_replication_enable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
174
175 --error ER_OPERATION_NOT_ALLOWED_WHILE_PRIMARY_CHANGE_IS_RUNNING
176 SELECT group_replication_enable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
177
178 --echo
179 --echo # 9. Execute commands which are not stopped.
180
181 DO SLEEP(1);
182
183 SELECT SLEEP(1);
184
185 SELECT COUNT(*) from performance_schema.replication_group_members;
186
187 SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE='debug sync point: now';
188
189 SELECT COUNT(*)=1 FROM sys.version;
190
191 --echo
192 --echo # 10. Unblock change primary from server2 and reap the operation.
193
194 SET DEBUG_SYNC= "now SIGNAL signal.primary_action_continue";
195
196 --let $rpl_connection_name= server2
197 --source include/rpl_connection.inc
198 --replace_result $server1_uuid SERVER1_UUID
199 --reap
200
201 --echo
202 --echo # 11. Assert primary changed.
203 --echo # Assert data is not present on M1 and M2.
204
205 --let $rpl_connection_name= server1
206 --source include/rpl_connection.inc
207
208 --source include/gr_assert_primary_member.inc
209
210 --let $rpl_connection_name= server2
211 --source include/rpl_connection.inc
212
213 --source include/gr_assert_secondary_member.inc
214
215 --let $assert_text= 'There is no value 1 in table t1'
216 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 1, count, 1] = 0
217 --source include/assert.inc
218
219 --let $assert_text= 'Check table t2 does not exist.'
220 --let $assert_cond= "[SELECT COUNT(*) FROM information_schema.tables WHERE TABLE_SCHEMA=\"test\" AND TABLE_NAME=\"t2\"]" = 0
221 --source include/assert.inc
222
223 --let $diff_tables= server1:test.t1, server2:test.t1
224 --source include/diff_tables.inc
225
226 --echo
227 --echo # 12. Cleanup.
228
229 --let $rpl_connection_name= server1
230 --source include/rpl_connection.inc
231
232 DROP TABLE t1;
233
234 --let $rpl_connection_name= server2
235 --source include/rpl_connection.inc
236
237 SET DEBUG_SYNC= 'RESET';
238 SET @@GLOBAL.DEBUG= '-d,group_replication_block_primary_action_validation';
239
240 --source include/group_replication_end.inc