Debian Codegraph @

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

raw
1 ################################################################################
2 # Validate that COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE is reset to 0
3 # when applier is free.
4 #
5 # Steps:
6 # 0. The test requires three servers.
7 # 1. Start 2 servers.
8 # Only setup recovery_user with GRANT REPLICATION SLAVE on server2
9 # for force server3 to recover from it.
10 # 2. Block applier on server 2 to force the delayed
11 # View_change_log_event log to binary log.
12 # 3. Start Group Replication on server3.
13 # It will recover from server2 and will stay on
14 # RECOVERING state waiting for View_change_log_event log.
15 # 4. Execute 2 transactions on server1 and 2 while server3
16 # is on RECOVERING.
17 # 5. INSERT(1) will only be applied after member is ONLINE.
18 # INSERT(2) will only be applied after member is ONLINE.
19 # 6. Resume applier on server2.
20 # Server3 state will change to ONLINE.
21 # 7. Assert COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE is 0 on all servers.
22 # 8. Clean up.
23 ################################################################################
24
25 --source include/big_test.inc
26 --source include/have_debug_sync.inc
27 --source include/have_group_replication_plugin.inc
28 --let $rpl_skip_group_replication_start= 1
29 --let $rpl_server_count= 3
30 --source include/group_replication.inc
31
32 --let $recovery_user= recovery_user
33 --let $recovery_password= recovery_password
34
35 --echo
36 --echo # 1. Start 2 servers.
37 --echo # Only setup recovery_user with GRANT REPLICATION SLAVE on server2
38 --echo # for force server3 to recover from it.
39
40 --let $rpl_connection_name= server1
41 --source include/rpl_connection.inc
42
43 SET SESSION sql_log_bin= 0;
44 --eval CREATE USER "$recovery_user" IDENTIFIED BY "$recovery_password"
45 --eval GRANT GROUP_REPLICATION_STREAM ON *.* TO "$recovery_user"
46 FLUSH PRIVILEGES;
47 SET SESSION sql_log_bin= 1;
48
49 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
50 INSERT INTO t1 VALUES (0);
51
52 --source include/start_and_bootstrap_group_replication.inc
53
54 --let $rpl_connection_name= server2
55 --source include/rpl_connection.inc
56
57 SET SESSION sql_log_bin= 0;
58 --eval CREATE USER "$recovery_user" IDENTIFIED BY "$recovery_password"
59 --eval GRANT REPLICATION SLAVE ON *.* TO "$recovery_user"
60 --eval GRANT GROUP_REPLICATION_STREAM ON *.* TO "$recovery_user"
61 FLUSH PRIVILEGES;
62 SET SESSION sql_log_bin= 1;
63
64 --source include/start_group_replication.inc
65
66 --echo
67 --echo # 2. Block applier on server 2 to force the delayed
68 --echo # View_change_log_event log to binary log.
69
70 --let $rpl_connection_name= server2
71 --source include/rpl_connection.inc
72
73 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
74
75 --echo
76 --echo # 3. Start Group Replication on server3.
77 --echo # It will recover from server2 and will stay on
78 --echo # RECOVERING state waiting for View_change_log_event log.
79
80 --let $rpl_connection_name= server3
81 --source include/rpl_connection.inc
82
83 SET SESSION sql_log_bin= 0;
84 --eval CREATE USER "$recovery_user" IDENTIFIED BY "$recovery_password"
85 --eval GRANT GROUP_REPLICATION_STREAM ON *.* TO "$recovery_user"
86 FLUSH PRIVILEGES;
87 SET SESSION sql_log_bin= 1;
88
89 SET SESSION sql_log_bin= 0;
90 call mtr.add_suppression("There was an error when connecting to the donor server.*");
91 call mtr.add_suppression("For details please check performance_schema.replication_connection_status table and error log messages of Replica I/O for channel group_replication_recovery.");
92 call mtr.add_suppression("Replica I/O for channel 'group_replication_recovery': Source command COM_REGISTER_REPLICA failed*");
93 call mtr.add_suppression("Replica I/O thread couldn't register on source*");
94 SET SESSION sql_log_bin= 1;
95
96 --disable_warnings
97 --eval CHANGE REPLICATION SOURCE TO SOURCE_USER= '$recovery_user', SOURCE_PASSWORD= '$recovery_password' FOR CHANNEL 'group_replication_recovery'
98 --enable_warnings
99
100 --let $group_replication_start_member_state= RECOVERING
101 --source include/start_group_replication.inc
102
103 --echo
104 --echo # 4. Execute 2 transactions on server1 and 2 while server3
105 --echo # is on RECOVERING.
106
107 --let $rpl_connection_name= server1
108 --source include/rpl_connection.inc
109 INSERT INTO t1 VALUES (1);
110
111 --let $rpl_connection_name= server_2
112 --source include/rpl_connection.inc
113 --send INSERT INTO t1 VALUES (2)
114
115 --echo
116 --echo # 5. INSERT(1) will only be applied after member is ONLINE.
117 --echo # INSERT(2) will only be applied after member is ONLINE.
118
119 --let $rpl_connection_name= server3
120 --source include/rpl_connection.inc
121
122 --let $wait_condition= SELECT COUNT(*)=1 FROM information_schema.tables WHERE TABLE_SCHEMA="test" AND TABLE_NAME="t1"
123 --source include/wait_condition.inc
124
125 --let $assert_text= value of 1 is not received.
126 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1 = 1, count, 1] = 0
127 --source include/assert.inc
128
129 --let $assert_text= value of 2 is not received.
130 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1 = 2, count, 1] = 0
131 --source include/assert.inc
132
133 --echo
134 --echo # 6. Resume applier on server2.
135 --echo # Server3 state will change to ONLINE.
136
137 --let $rpl_connection_name= server2
138 --source include/rpl_connection.inc
139
140 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
141 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
142 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
143
144 --let $rpl_connection_name= server_2
145 --source include/rpl_connection.inc
146 --reap
147
148 --let $rpl_connection_name= server3
149 --source include/rpl_connection.inc
150
151 --let $group_replication_member_state= ONLINE
152 --source include/gr_wait_for_member_state.inc
153
154 --source include/rpl_sync.inc
155
156 --echo
157 --echo # 7. Assert COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE is 0 on all servers.
158
159 --let $rpl_connection_name= server1
160 --source include/rpl_connection.inc
161
162 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE = 0 FROM performance_schema.replication_group_member_stats WHERE member_id in (SELECT @@server_uuid)
163 --source include/wait_condition.inc
164
165 --let $rpl_connection_name= server2
166 --source include/rpl_connection.inc
167 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE = 0 FROM performance_schema.replication_group_member_stats WHERE member_id in (SELECT @@server_uuid)
168 --source include/wait_condition.inc
169
170 --let $rpl_connection_name= server3
171 --source include/rpl_connection.inc
172 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE = 0 FROM performance_schema.replication_group_member_stats WHERE member_id in (SELECT @@server_uuid)
173 --source include/wait_condition.inc
174
175 --let $diff_tables= server1:test.t1, server2:test.t1, server3:test.t1
176 --source include/diff_tables.inc
177
178 --let $rpl_connection_name= server1
179 --source include/rpl_connection.inc
180 --let $keep_gtid_events= 1
181 --source include/show_binlog_events.inc
182
183 --let $rpl_connection_name= server2
184 --source include/rpl_connection.inc
185 --let $keep_gtid_events= 1
186 --source include/show_binlog_events.inc
187
188 --let $rpl_connection_name= server3
189 --source include/rpl_connection.inc
190 --let $keep_gtid_events= 1
191 --source include/show_binlog_events.inc
192
193 --echo
194 --echo # 8. Clean up.
195
196 --let $rpl_connection_name= server1
197 --source include/rpl_connection.inc
198
199 SET SESSION sql_log_bin= 0;
200 --eval DROP USER "$recovery_user"
201 SET SESSION sql_log_bin= 1;
202
203 --let $rpl_connection_name= server2
204 --source include/rpl_connection.inc
205
206 SET DEBUG_SYNC= 'RESET';
207 DROP TABLE t1;
208
209 SET SESSION sql_log_bin= 0;
210 --eval DROP USER "$recovery_user"
211 SET SESSION sql_log_bin= 1;
212
213 --let $rpl_connection_name= server3
214 --source include/rpl_connection.inc
215
216 SET SESSION sql_log_bin= 0;
217 --eval DROP USER "$recovery_user"
218 SET SESSION sql_log_bin= 1;
219
220 --source include/group_replication_end.inc