| 1 |
include/group_replication.inc [rpl_server_count=4] |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection server1] |
| 6 |
|
| 7 |
############################################################ |
| 8 |
# 1. Bootstrap group on server1. |
| 9 |
# Start an inbound channel that replicates from server4. |
| 10 |
[connection server1] |
| 11 |
include/start_and_bootstrap_group_replication.inc |
| 12 |
CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=SERVER_4_PORT FOR CHANNEL 'ch1'; |
| 13 |
Warnings: |
| 14 |
Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 15 |
Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 16 |
include/start_slave.inc [FOR CHANNEL 'ch1'] |
| 17 |
|
| 18 |
############################################################ |
| 19 |
# 2. Create table t1 without consuming a GTID to cause a future |
| 20 |
# `group_replication_recovery` channel error. |
| 21 |
# The goal is make the join operation as short as possible, |
| 22 |
# so that we can maximize the number of joins per test. |
| 23 |
# Join server2 to the group. |
| 24 |
[connection server2] |
| 25 |
SET SESSION sql_log_bin=0; |
| 26 |
CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY); |
| 27 |
SET SESSION sql_log_bin=1; |
| 28 |
include/start_group_replication.inc |
| 29 |
|
| 30 |
############################################################ |
| 31 |
# 3. Create table t1 without consuming a GTID to cause a future |
| 32 |
# `group_replication_recovery` channel error. |
| 33 |
# The goal is make the join operation as short as possible, |
| 34 |
# so that we can maximize the number of joins per test. |
| 35 |
# Join server3 to the group. |
| 36 |
[connection server3] |
| 37 |
SET SESSION sql_log_bin=0; |
| 38 |
CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY); |
| 39 |
SET SESSION sql_log_bin=1; |
| 40 |
include/start_group_replication.inc |
| 41 |
|
| 42 |
############################################################ |
| 43 |
# 4. Execute a procedure on server4 that commits transactions |
| 44 |
# "forever" (until we kill the session). |
| 45 |
[connection server4] |
| 46 |
CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY); |
| 47 |
CREATE EVENT ev1 |
| 48 |
ON SCHEDULE |
| 49 |
EVERY 1 SECOND |
| 50 |
DO |
| 51 |
BEGIN |
| 52 |
DECLARE i INTEGER; |
| 53 |
SET i = 0; |
| 54 |
WHILE i < 5000 DO |
| 55 |
INSERT INTO t1() VALUES (); |
| 56 |
SET i = i + 1; |
| 57 |
END WHILE; |
| 58 |
END | |
| 59 |
|
| 60 |
############################################################ |
| 61 |
# 5. Wait for the duplicate table error on server2 and server3. |
| 62 |
[connection server2] |
| 63 |
include/stop_group_replication.inc |
| 64 |
[connection server3] |
| 65 |
include/stop_group_replication.inc |
| 66 |
|
| 67 |
############################################################ |
| 68 |
# 6. Attempt to rejoin server2 and server3 50 times. |
| 69 |
[connection server2] |
| 70 |
START GROUP_REPLICATION; |
| 71 |
Got one of the listed errors |
| 72 |
[connection server3] |
| 73 |
START GROUP_REPLICATION; |
| 74 |
Got one of the listed errors |
| 75 |
[connection server2] |
| 76 |
START GROUP_REPLICATION; |
| 77 |
Got one of the listed errors |
| 78 |
[connection server3] |
| 79 |
START GROUP_REPLICATION; |
| 80 |
Got one of the listed errors |
| 81 |
[connection server2] |
| 82 |
START GROUP_REPLICATION; |
| 83 |
Got one of the listed errors |
| 84 |
[connection server3] |
| 85 |
START GROUP_REPLICATION; |
| 86 |
Got one of the listed errors |
| 87 |
[connection server2] |
| 88 |
START GROUP_REPLICATION; |
| 89 |
Got one of the listed errors |
| 90 |
[connection server3] |
| 91 |
START GROUP_REPLICATION; |
| 92 |
Got one of the listed errors |
| 93 |
[connection server2] |
| 94 |
START GROUP_REPLICATION; |
| 95 |
Got one of the listed errors |
| 96 |
[connection server3] |
| 97 |
START GROUP_REPLICATION; |
| 98 |
Got one of the listed errors |
| 99 |
[connection server2] |
| 100 |
START GROUP_REPLICATION; |
| 101 |
Got one of the listed errors |
| 102 |
[connection server3] |
| 103 |
START GROUP_REPLICATION; |
| 104 |
Got one of the listed errors |
| 105 |
[connection server2] |
| 106 |
START GROUP_REPLICATION; |
| 107 |
Got one of the listed errors |
| 108 |
[connection server3] |
| 109 |
START GROUP_REPLICATION; |
| 110 |
Got one of the listed errors |
| 111 |
[connection server2] |
| 112 |
START GROUP_REPLICATION; |
| 113 |
Got one of the listed errors |
| 114 |
[connection server3] |
| 115 |
START GROUP_REPLICATION; |
| 116 |
Got one of the listed errors |
| 117 |
[connection server2] |
| 118 |
START GROUP_REPLICATION; |
| 119 |
Got one of the listed errors |
| 120 |
[connection server3] |
| 121 |
START GROUP_REPLICATION; |
| 122 |
Got one of the listed errors |
| 123 |
[connection server2] |
| 124 |
START GROUP_REPLICATION; |
| 125 |
Got one of the listed errors |
| 126 |
[connection server3] |
| 127 |
START GROUP_REPLICATION; |
| 128 |
Got one of the listed errors |
| 129 |
[connection server2] |
| 130 |
START GROUP_REPLICATION; |
| 131 |
Got one of the listed errors |
| 132 |
[connection server3] |
| 133 |
START GROUP_REPLICATION; |
| 134 |
Got one of the listed errors |
| 135 |
[connection server2] |
| 136 |
START GROUP_REPLICATION; |
| 137 |
Got one of the listed errors |
| 138 |
[connection server3] |
| 139 |
START GROUP_REPLICATION; |
| 140 |
Got one of the listed errors |
| 141 |
[connection server2] |
| 142 |
START GROUP_REPLICATION; |
| 143 |
Got one of the listed errors |
| 144 |
[connection server3] |
| 145 |
START GROUP_REPLICATION; |
| 146 |
Got one of the listed errors |
| 147 |
[connection server2] |
| 148 |
START GROUP_REPLICATION; |
| 149 |
Got one of the listed errors |
| 150 |
[connection server3] |
| 151 |
START GROUP_REPLICATION; |
| 152 |
Got one of the listed errors |
| 153 |
[connection server2] |
| 154 |
START GROUP_REPLICATION; |
| 155 |
Got one of the listed errors |
| 156 |
[connection server3] |
| 157 |
START GROUP_REPLICATION; |
| 158 |
Got one of the listed errors |
| 159 |
[connection server2] |
| 160 |
START GROUP_REPLICATION; |
| 161 |
Got one of the listed errors |
| 162 |
[connection server3] |
| 163 |
START GROUP_REPLICATION; |
| 164 |
Got one of the listed errors |
| 165 |
[connection server2] |
| 166 |
START GROUP_REPLICATION; |
| 167 |
Got one of the listed errors |
| 168 |
[connection server3] |
| 169 |
START GROUP_REPLICATION; |
| 170 |
Got one of the listed errors |
| 171 |
[connection server2] |
| 172 |
START GROUP_REPLICATION; |
| 173 |
Got one of the listed errors |
| 174 |
[connection server3] |
| 175 |
START GROUP_REPLICATION; |
| 176 |
Got one of the listed errors |
| 177 |
[connection server2] |
| 178 |
START GROUP_REPLICATION; |
| 179 |
Got one of the listed errors |
| 180 |
[connection server3] |
| 181 |
START GROUP_REPLICATION; |
| 182 |
Got one of the listed errors |
| 183 |
[connection server2] |
| 184 |
START GROUP_REPLICATION; |
| 185 |
Got one of the listed errors |
| 186 |
[connection server3] |
| 187 |
START GROUP_REPLICATION; |
| 188 |
Got one of the listed errors |
| 189 |
[connection server2] |
| 190 |
START GROUP_REPLICATION; |
| 191 |
Got one of the listed errors |
| 192 |
[connection server3] |
| 193 |
START GROUP_REPLICATION; |
| 194 |
Got one of the listed errors |
| 195 |
[connection server2] |
| 196 |
START GROUP_REPLICATION; |
| 197 |
Got one of the listed errors |
| 198 |
[connection server3] |
| 199 |
START GROUP_REPLICATION; |
| 200 |
Got one of the listed errors |
| 201 |
[connection server2] |
| 202 |
START GROUP_REPLICATION; |
| 203 |
Got one of the listed errors |
| 204 |
[connection server3] |
| 205 |
START GROUP_REPLICATION; |
| 206 |
Got one of the listed errors |
| 207 |
[connection server2] |
| 208 |
START GROUP_REPLICATION; |
| 209 |
Got one of the listed errors |
| 210 |
[connection server3] |
| 211 |
START GROUP_REPLICATION; |
| 212 |
Got one of the listed errors |
| 213 |
[connection server2] |
| 214 |
START GROUP_REPLICATION; |
| 215 |
Got one of the listed errors |
| 216 |
[connection server3] |
| 217 |
START GROUP_REPLICATION; |
| 218 |
Got one of the listed errors |
| 219 |
[connection server2] |
| 220 |
START GROUP_REPLICATION; |
| 221 |
Got one of the listed errors |
| 222 |
[connection server3] |
| 223 |
START GROUP_REPLICATION; |
| 224 |
Got one of the listed errors |
| 225 |
[connection server2] |
| 226 |
START GROUP_REPLICATION; |
| 227 |
Got one of the listed errors |
| 228 |
[connection server3] |
| 229 |
START GROUP_REPLICATION; |
| 230 |
Got one of the listed errors |
| 231 |
[connection server2] |
| 232 |
START GROUP_REPLICATION; |
| 233 |
Got one of the listed errors |
| 234 |
[connection server3] |
| 235 |
START GROUP_REPLICATION; |
| 236 |
Got one of the listed errors |
| 237 |
[connection server2] |
| 238 |
START GROUP_REPLICATION; |
| 239 |
Got one of the listed errors |
| 240 |
[connection server3] |
| 241 |
START GROUP_REPLICATION; |
| 242 |
Got one of the listed errors |
| 243 |
[connection server2] |
| 244 |
START GROUP_REPLICATION; |
| 245 |
Got one of the listed errors |
| 246 |
[connection server3] |
| 247 |
START GROUP_REPLICATION; |
| 248 |
Got one of the listed errors |
| 249 |
[connection server2] |
| 250 |
START GROUP_REPLICATION; |
| 251 |
Got one of the listed errors |
| 252 |
[connection server3] |
| 253 |
START GROUP_REPLICATION; |
| 254 |
Got one of the listed errors |
| 255 |
[connection server2] |
| 256 |
START GROUP_REPLICATION; |
| 257 |
Got one of the listed errors |
| 258 |
[connection server3] |
| 259 |
START GROUP_REPLICATION; |
| 260 |
Got one of the listed errors |
| 261 |
[connection server2] |
| 262 |
START GROUP_REPLICATION; |
| 263 |
Got one of the listed errors |
| 264 |
[connection server3] |
| 265 |
START GROUP_REPLICATION; |
| 266 |
Got one of the listed errors |
| 267 |
[connection server2] |
| 268 |
START GROUP_REPLICATION; |
| 269 |
Got one of the listed errors |
| 270 |
[connection server3] |
| 271 |
START GROUP_REPLICATION; |
| 272 |
Got one of the listed errors |
| 273 |
[connection server2] |
| 274 |
START GROUP_REPLICATION; |
| 275 |
Got one of the listed errors |
| 276 |
[connection server3] |
| 277 |
START GROUP_REPLICATION; |
| 278 |
Got one of the listed errors |
| 279 |
[connection server2] |
| 280 |
START GROUP_REPLICATION; |
| 281 |
Got one of the listed errors |
| 282 |
[connection server3] |
| 283 |
START GROUP_REPLICATION; |
| 284 |
Got one of the listed errors |
| 285 |
[connection server2] |
| 286 |
START GROUP_REPLICATION; |
| 287 |
Got one of the listed errors |
| 288 |
[connection server3] |
| 289 |
START GROUP_REPLICATION; |
| 290 |
Got one of the listed errors |
| 291 |
[connection server2] |
| 292 |
START GROUP_REPLICATION; |
| 293 |
Got one of the listed errors |
| 294 |
[connection server3] |
| 295 |
START GROUP_REPLICATION; |
| 296 |
Got one of the listed errors |
| 297 |
[connection server2] |
| 298 |
START GROUP_REPLICATION; |
| 299 |
Got one of the listed errors |
| 300 |
[connection server3] |
| 301 |
START GROUP_REPLICATION; |
| 302 |
Got one of the listed errors |
| 303 |
[connection server2] |
| 304 |
START GROUP_REPLICATION; |
| 305 |
Got one of the listed errors |
| 306 |
[connection server3] |
| 307 |
START GROUP_REPLICATION; |
| 308 |
Got one of the listed errors |
| 309 |
[connection server2] |
| 310 |
START GROUP_REPLICATION; |
| 311 |
Got one of the listed errors |
| 312 |
[connection server3] |
| 313 |
START GROUP_REPLICATION; |
| 314 |
Got one of the listed errors |
| 315 |
[connection server2] |
| 316 |
START GROUP_REPLICATION; |
| 317 |
Got one of the listed errors |
| 318 |
[connection server3] |
| 319 |
START GROUP_REPLICATION; |
| 320 |
Got one of the listed errors |
| 321 |
[connection server2] |
| 322 |
START GROUP_REPLICATION; |
| 323 |
Got one of the listed errors |
| 324 |
[connection server3] |
| 325 |
START GROUP_REPLICATION; |
| 326 |
Got one of the listed errors |
| 327 |
[connection server2] |
| 328 |
START GROUP_REPLICATION; |
| 329 |
Got one of the listed errors |
| 330 |
[connection server3] |
| 331 |
START GROUP_REPLICATION; |
| 332 |
Got one of the listed errors |
| 333 |
[connection server2] |
| 334 |
START GROUP_REPLICATION; |
| 335 |
Got one of the listed errors |
| 336 |
[connection server3] |
| 337 |
START GROUP_REPLICATION; |
| 338 |
Got one of the listed errors |
| 339 |
[connection server2] |
| 340 |
START GROUP_REPLICATION; |
| 341 |
Got one of the listed errors |
| 342 |
[connection server3] |
| 343 |
START GROUP_REPLICATION; |
| 344 |
Got one of the listed errors |
| 345 |
[connection server2] |
| 346 |
START GROUP_REPLICATION; |
| 347 |
Got one of the listed errors |
| 348 |
[connection server3] |
| 349 |
START GROUP_REPLICATION; |
| 350 |
Got one of the listed errors |
| 351 |
[connection server2] |
| 352 |
START GROUP_REPLICATION; |
| 353 |
Got one of the listed errors |
| 354 |
[connection server3] |
| 355 |
START GROUP_REPLICATION; |
| 356 |
Got one of the listed errors |
| 357 |
[connection server2] |
| 358 |
START GROUP_REPLICATION; |
| 359 |
Got one of the listed errors |
| 360 |
[connection server3] |
| 361 |
START GROUP_REPLICATION; |
| 362 |
Got one of the listed errors |
| 363 |
[connection server2] |
| 364 |
START GROUP_REPLICATION; |
| 365 |
Got one of the listed errors |
| 366 |
[connection server3] |
| 367 |
START GROUP_REPLICATION; |
| 368 |
Got one of the listed errors |
| 369 |
|
| 370 |
############################################################ |
| 371 |
# 7. There must be 0 applier threads on server1 with the state |
| 372 |
# 'Waiting for Binlog Group Commit ticket'. |
| 373 |
[connection server1] |
| 374 |
|
| 375 |
############################################################ |
| 376 |
# 8. Clean up. |
| 377 |
[connection server3] |
| 378 |
DROP TABLE t1; |
| 379 |
include/suppress_messages.inc |
| 380 |
# Connection 3 suppresses message <Replica SQL for channel 'group_replication_applier': Worker [0-9] failed executing transaction*>. |
| 381 |
# Connection 3 suppresses message <The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.>. |
| 382 |
# Connection 3 suppresses message <Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.>. |
| 383 |
# Connection 3 suppresses message <The server was automatically set into read only mode after an error was detected.>. |
| 384 |
# Connection 3 suppresses message <Skipping leave operation: concurrent attempt to leave the group is on-going.>. |
| 385 |
# Connection 3 suppresses message <Skipping leave operation: member already left the group.>. |
| 386 |
# Connection 3 suppresses message <Unable to confirm whether the server has left the group or not. Check *.*>. |
| 387 |
# Connection 3 suppresses message <The server was automatically set into read only mode after an error was detected.>. |
| 388 |
# Connection 3 suppresses message <There was a previous plugin error while the member joined the group. The member will now exit the group.>. |
| 389 |
# Connection 3 suppresses message <Message received while the plugin is not ready, message discarded.>. |
| 390 |
# Connection 3 suppresses message <Unable to initialize the Group Replication applier module.>. |
| 391 |
# Connection 3 suppresses message <.*Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state*>. |
| 392 |
# Connection 3 suppresses message <.*Coordinator experienced an error or was killed while scheduling an event at.*>. |
| 393 |
[connection server2] |
| 394 |
DROP TABLE t1; |
| 395 |
include/suppress_messages.inc |
| 396 |
# Connection 2 suppresses message <Replica SQL for channel 'group_replication_applier': Worker [0-9] failed executing transaction*>. |
| 397 |
# Connection 2 suppresses message <The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.>. |
| 398 |
# Connection 2 suppresses message <Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.>. |
| 399 |
# Connection 2 suppresses message <The server was automatically set into read only mode after an error was detected.>. |
| 400 |
# Connection 2 suppresses message <Skipping leave operation: concurrent attempt to leave the group is on-going.>. |
| 401 |
# Connection 2 suppresses message <Skipping leave operation: member already left the group.>. |
| 402 |
# Connection 2 suppresses message <Unable to confirm whether the server has left the group or not. Check *.*>. |
| 403 |
# Connection 2 suppresses message <The server was automatically set into read only mode after an error was detected.>. |
| 404 |
# Connection 2 suppresses message <There was a previous plugin error while the member joined the group. The member will now exit the group.>. |
| 405 |
# Connection 2 suppresses message <Message received while the plugin is not ready, message discarded.>. |
| 406 |
# Connection 2 suppresses message <Unable to initialize the Group Replication applier module.>. |
| 407 |
# Connection 2 suppresses message <.*Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state*>. |
| 408 |
# Connection 2 suppresses message <.*Coordinator experienced an error or was killed while scheduling an event at.*>. |
| 409 |
[connection server1] |
| 410 |
include/stop_slave.inc [FOR CHANNEL 'ch1'] |
| 411 |
include/stop_group_replication.inc |
| 412 |
RESET REPLICA ALL FOR CHANNEL 'ch1'; |
| 413 |
DROP EVENT ev1; |
| 414 |
DROP TABLE t1; |
| 415 |
include/suppress_messages.inc |
| 416 |
# Connection 1 suppresses message <The transaction '[a-z0-9-]*:[0-9]*' will commit out of order with respect to its source to follow the group global order.>. |
| 417 |
[connection server4] |
| 418 |
DROP EVENT ev1; |
| 419 |
DROP TABLE t1; |
| 420 |
include/group_replication_end.inc |