Debian Codegraph @

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

raw
1 ################################################################################
2 # This test proves that sequence number gap is not generated when certification
3 # garbage collector runs.
4 #
5 # Test:
6 # 0. The test requires two servers: M1 and M2.
7 # 1. Add debug point to reduce certifier broadcast time to 1 second.
8 # Bootstrap M1 and join M2.
9 # 2. Insert 5 rows.
10 # Wait for garbage collector to run for every insert.
11 # 3. Assert sequence numbers and last_committed are correct.
12 # Verify no gaps in sequence number.
13 # 4. Run 5 DDLs.
14 # Wait for garbage collector to run for every statement.
15 # 5. Assert sequence numbers and last_committed are correct.
16 # Verify no gaps in sequence number.
17 # 6. Stop the group.
18 # 7. Add debug point to disable certification info garbage collection.
19 # Bootstrap M1 and join M2.
20 # 8. Insert 10 rows.
21 # 9. Run 5 DDLs.
22 # 10. Cleanup.
23 ################################################################################
24
25 --source include/have_debug.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_group_replication_single_primary_mode=1
30 --source include/group_replication.inc
31
32 --echo #################################################################
33 --echo # 1. Add debug point to reduce certifier broadcast time to 1 second.
34 --echo # Bootstrap M1 and join M2.
35
36 --let $rpl_connection_name= server1
37 --source include/rpl_connection.inc
38
39 SET @@GLOBAL.DEBUG= '+d,group_replication_certifier_broadcast_thread_short_period';
40
41 --source include/start_and_bootstrap_group_replication.inc
42
43 --let $rpl_connection_name= server2
44 --source include/rpl_connection.inc
45
46 SET @@GLOBAL.DEBUG= '+d,group_replication_certifier_broadcast_thread_short_period';
47 SET @@GLOBAL.DEBUG= '+d,group_replication_certifier_garbage_collection_ran';
48
49 --source include/start_group_replication.inc
50
51 --echo #################################################################
52 --echo # 2. Insert 5 rows.
53 --echo # Wait for garbage collector to run for every insert.
54
55 --let $rpl_connection_name= server1
56 --source include/rpl_connection.inc
57
58 CREATE TABLE t1(c1 INT PRIMARY KEY);
59
60 --let $i=1
61 while($i < 6)
62 {
63 --let $rpl_connection_name= server2
64 --source include/rpl_connection.inc
65
66 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_certifier_garbage_collection_finished";
67
68 --let $rpl_connection_name= server1
69 --source include/rpl_connection.inc
70
71 --eval INSERT INTO t1 VALUES ($i)
72 --inc $i
73 }
74 --source include/rpl_sync.inc
75
76 --echo #################################################################
77 --echo # 3. Assert sequence numbers and last_committed are correct.
78 --echo # Verify no gaps in sequence number.
79
80 --let $rpl_connection_name= server2
81 --source include/rpl_connection.inc
82
83 --let $binlog_file= server-relay-log-group_replication_applier.000002
84 --let $logical_timestamps= 0 0;1 2;2 3;3 4;4 5;5 6;6 7
85 --source include/assert_logical_timestamps.inc
86
87 --echo #################################################################
88 --echo # 4. Run 5 DDLs.
89 --echo # Wait for garbage collector to run for every statement.
90
91 --let $rpl_connection_name= server1
92 --source include/rpl_connection.inc
93
94 --let $i=1
95 while($i < 6)
96 {
97 --let $rpl_connection_name= server2
98 --source include/rpl_connection.inc
99
100 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_certifier_garbage_collection_finished";
101
102 --let $rpl_connection_name= server1
103 --source include/rpl_connection.inc
104
105 --eval CREATE TABLE tt$i(c1 INT PRIMARY KEY)
106 --inc $i
107 }
108 --source include/rpl_sync.inc
109
110 --echo #################################################################
111 --echo # 5. Assert sequence numbers and last_committed are correct.
112 --echo # Verify no gaps in sequence number.
113
114 --let $rpl_connection_name= server2
115 --source include/rpl_connection.inc
116
117 --let $binlog_file= server-relay-log-group_replication_applier.000002
118 --let $logical_timestamps= 0 0;1 2;2 3;3 4;4 5;5 6;6 7;7 8;8 9;9 10;10 11;11 12
119 --source include/assert_logical_timestamps.inc
120
121 --echo #################################################################
122 --echo # 6. Stop the group.
123
124 --let $rpl_connection_name= server2
125 --source include/rpl_connection.inc
126
127 --source include/stop_group_replication.inc
128 SET @@GLOBAL.DEBUG= '-d,group_replication_certifier_garbage_collection_ran';
129 SET @@GLOBAL.DEBUG= '-d,group_replication_certifier_broadcast_thread_short_period';
130 SET DEBUG_SYNC= 'RESET';
131
132 --let $rpl_connection_name= server1
133 --source include/rpl_connection.inc
134
135 --source include/stop_group_replication.inc
136 SET @@GLOBAL.DEBUG= '-d,group_replication_certifier_broadcast_thread_short_period';
137
138
139 --echo #################################################################
140 --echo # 7. Add debug point to disable certification info garbage collection.
141 --echo # Bootstrap M1 and join M2.
142
143 --let $rpl_connection_name= server1
144 --source include/rpl_connection.inc
145
146 SET @@GLOBAL.DEBUG= '+d,group_replication_do_not_clear_certification_database';
147 SET @@GLOBAL.DEBUG= '+d,group_replication_certifier_broadcast_thread_big_period';
148 --source include/start_and_bootstrap_group_replication.inc
149
150 --let $rpl_connection_name= server2
151 --source include/rpl_connection.inc
152
153 SET @@GLOBAL.DEBUG= '+d,group_replication_do_not_clear_certification_database';
154 SET @@GLOBAL.DEBUG= '+d,group_replication_certifier_broadcast_thread_big_period';
155 --source include/start_group_replication.inc
156
157 --echo #################################################################
158 --echo # 8. Insert 10 rows.
159
160 --let $rpl_connection_name= server1
161 --source include/rpl_connection.inc
162
163 --let $i=6
164 while($i < 16)
165 {
166 --let $rpl_connection_name= server1
167 --source include/rpl_connection.inc
168
169 --eval INSERT INTO test.t1 VALUES ($i)
170 --inc $i
171 }
172 --source include/rpl_sync.inc
173
174 --let $rpl_connection_name= server2
175 --source include/rpl_connection.inc
176
177 --let $binlog_file= server-relay-log-group_replication_applier.000003
178 --let $logical_timestamps= 0 0;1 2;1 3;1 4;1 5;1 6;1 7;1 8;1 9;1 10;1 11
179 --source include/assert_logical_timestamps.inc
180
181 --echo #################################################################
182 --echo # 9. Run 5 DDLs.
183
184 --let $rpl_connection_name= server1
185 --source include/rpl_connection.inc
186
187 --let $i=1
188 while($i < 6)
189 {
190 --eval DROP TABLE tt$i
191 --inc $i
192 }
193 --source include/rpl_sync.inc
194
195 --let $rpl_connection_name= server2
196 --source include/rpl_connection.inc
197
198 --let $binlog_file= server-relay-log-group_replication_applier.000003
199 --let $logical_timestamps= 0 0;1 2;1 3;1 4;1 5;1 6;1 7;1 8;1 9;1 10;1 11;11 12;12 13;13 14;14 15;15 16
200 --source include/assert_logical_timestamps.inc
201
202 --echo #################################################################
203 --echo # 10. Cleanup.
204
205 --let $rpl_connection_name= server1
206 --source include/rpl_connection.inc
207
208 DROP TABLE t1;
209 --source include/rpl_sync.inc
210
211 --let $rpl_connection_name= server2
212 --source include/rpl_connection.inc
213
214 --source include/stop_group_replication.inc
215 SET @@GLOBAL.DEBUG= '-d,group_replication_do_not_clear_certification_database';
216 SET @@GLOBAL.DEBUG= '-d,group_replication_certifier_broadcast_thread_big_period';
217
218 --let $rpl_connection_name= server1
219 --source include/rpl_connection.inc
220
221 --source include/stop_group_replication.inc
222 SET @@GLOBAL.DEBUG= '-d,group_replication_do_not_clear_certification_database';
223 SET @@GLOBAL.DEBUG= '-d,group_replication_certifier_broadcast_thread_big_period';
224
225 --source include/group_replication_end.inc