1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
############################################################
# 1. Create a group with 5 members.
include/group_replication.inc [rpl_server_count=5]
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
[connection server1]
[connection server4]
############################################################
# 2. Crash member 5.
[connection server5]
############################################################
# 3. Restart member 4.
# Member 4 will receive the view on which member 5 is
# expelled during server shutdown, this was triggering
# assert failures on SQL service
# Srv_session::deinit_thread().
[connection server4]
# restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=0 --group_replication_start_on_boot=1
include/rpl_reconnect.inc
############################################################
# 4. Validate that member is back ONLINE and group has 4
# members.
include/gr_wait_for_member_state.inc
SET SESSION sql_log_bin= 0;
call mtr.add_suppression("Plugin group_replication reported: 'Error, maximum number of retries exceeded when waiting for the internal server session state to be operating'");
call mtr.add_suppression("Plugin group_replication reported: 'Failed to establish an internal server connection to execute plugin operations'");
call mtr.add_suppression("Plugin group_replication reported: 'Error when extracting information for group change. Operations and checks made to group joiners may be incomplete.'");
call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped.*");
call mtr.add_suppression("Plugin group_replication reported: 'The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.'");
call mtr.add_suppression("Plugin group_replication reported: 'Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.'");
call mtr.add_suppression("Plugin group_replication reported: 'The server was automatically set into read only mode after an error was detected.'");
call mtr.add_suppression("Plugin group_replication reported: 'Skipping leave operation: concurrent attempt to leave the group is on-going.'");
call mtr.add_suppression("Error writing relay log configuration.");
call mtr.add_suppression("Plugin group_replication reported: 'Failed to stop the group replication applier thread.");
SET SESSION sql_log_bin= 1;
############################################################
# 5. Wait for client reconnection to server 5.
[connection server_5]
include/rpl_reconnect.inc
############################################################
# 6. Clean up.
include/group_replication_end.inc
|
