| 1 |
include/group_replication.inc |
| 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 |
[connection server2] |
| 7 |
SET SESSION sql_log_bin= 0; |
| 8 |
call mtr.add_suppression("Member is not ONLINE, it is not possible to force a new group membership."); |
| 9 |
call mtr.add_suppression("group_replication_force_members must be empty on group start. Current value: '127.0.0.1:10000'"); |
| 10 |
call mtr.add_suppression("Unable to start Group Replication on boot"); |
| 11 |
call mtr.add_suppression("force_members can only be updated when Group Replication is running*"); |
| 12 |
call mtr.add_suppression("The member lost contact with a majority of the members in the group. Until the network is restored.*"); |
| 13 |
call mtr.add_suppression("\\[GCS\\] Peer address .* is not valid."); |
| 14 |
call mtr.add_suppression("\\[GCS\\] The peers list contains invalid addresses.Please provide a list with only valid addresses."); |
| 15 |
call mtr.add_suppression("Error setting group_replication_force_members value .* on group communication interfaces"); |
| 16 |
call mtr.add_suppression("The member resumed contact with a majority of the members in the group.*"); |
| 17 |
call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped.*"); |
| 18 |
call mtr.add_suppression(".*Only alive members in the current configuration should be present in a forced configuration list.*"); |
| 19 |
call mtr.add_suppression("\\[GCS\\] Error reconfiguring group."); |
| 20 |
SET SESSION sql_log_bin= 1; |
| 21 |
[connection server1] |
| 22 |
SET SESSION sql_log_bin= 0; |
| 23 |
call mtr.add_suppression("Member is OFFLINE, it is not possible to force a new group membership"); |
| 24 |
call mtr.add_suppression("force_members can only be updated when Group Replication is running*"); |
| 25 |
SET SESSION sql_log_bin= 1; |
| 26 |
|
| 27 |
############################################################ |
| 28 |
# 1. Set empty string value to |
| 29 |
# group_replication_force_members on a OFFLINE |
| 30 |
# member. |
| 31 |
SET GLOBAL group_replication_force_members= ""; |
| 32 |
include/assert.inc [group_replication_force_members is empty] |
| 33 |
|
| 34 |
############################################################ |
| 35 |
# 2. Set group_replication_force_members on a OFFLINE |
| 36 |
# member. |
| 37 |
SET GLOBAL group_replication_force_members= "127.0.0.1:10000"; |
| 38 |
ERROR HY000: The 'SET GLOBAL group_replication_force_members=127.0.0.1:10000' command encountered a failure. Member is not ONLINE, it is not possible to force a new group membership. |
| 39 |
include/assert.inc [group_replication_force_members is empty] |
| 40 |
|
| 41 |
############################################################ |
| 42 |
# 3. Set empty string value to |
| 43 |
# group_replication_force_members on a ONLINE |
| 44 |
# member. |
| 45 |
include/start_and_bootstrap_group_replication.inc |
| 46 |
SET GLOBAL group_replication_force_members= ""; |
| 47 |
include/assert.inc [group_replication_force_members is empty] |
| 48 |
|
| 49 |
############################################################ |
| 50 |
# 4. Set valid IP string value to |
| 51 |
# group_replication_force_members on a ONLINE member and |
| 52 |
# majority of group members are reachable |
| 53 |
SET GLOBAL group_replication_force_members= "127.0.0.1:10001"; |
| 54 |
ERROR HY000: The 'SET GLOBAL group_replication_force_members=127.0.0.1:10001' command encountered a failure. The group_replication_force_members can only be updated when Group Replication is running and majority of the members are unreachable. |
| 55 |
include/assert.inc [group_replication_force_members is empty] |
| 56 |
|
| 57 |
############################################################ |
| 58 |
# 5. Set empty string value to |
| 59 |
# group_replication_force_members on a RECOVERING |
| 60 |
# member. |
| 61 |
[connection server2] |
| 62 |
SET @@GLOBAL.DEBUG='+d,recovery_thread_wait_before_finish'; |
| 63 |
include/start_group_replication.inc |
| 64 |
SET GLOBAL group_replication_force_members= ""; |
| 65 |
include/assert.inc [group_replication_force_members is empty] |
| 66 |
|
| 67 |
############################################################ |
| 68 |
# 6. Set group_replication_force_members on a RECOVERING |
| 69 |
# member. |
| 70 |
include/gr_wait_for_member_state.inc |
| 71 |
SET GLOBAL group_replication_force_members= "127.0.0.1:10000"; |
| 72 |
ERROR HY000: The 'SET GLOBAL group_replication_force_members=127.0.0.1:10000' command encountered a failure. The group_replication_force_members can only be updated when Group Replication is running and majority of the members are unreachable. |
| 73 |
SET DEBUG_SYNC= "now WAIT_FOR signal.recovery_thread_wait_before_finish_reached"; |
| 74 |
SET @@GLOBAL.DEBUG='-d,recovery_thread_wait_before_finish'; |
| 75 |
SET DEBUG_SYNC= "now SIGNAL signal.recovery_end"; |
| 76 |
[connection server2] |
| 77 |
include/gr_wait_for_member_state.inc |
| 78 |
SET DEBUG_SYNC= 'RESET'; |
| 79 |
|
| 80 |
############################################################ |
| 81 |
# 7. Restart member with group_replication_force_members |
| 82 |
# set. Group Replication start will error out. |
| 83 |
# 2 members. |
| 84 |
[connection server2] |
| 85 |
# restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_start_on_boot=1 --group-replication-group-name=GROUP_REPLICATION_GROUP_NAME --group_replication_force_members=127.0.0.1:10000 |
| 86 |
include/rpl_reconnect.inc |
| 87 |
include/assert.inc [Member 2 is OFFLINE] |
| 88 |
|
| 89 |
############################################################ |
| 90 |
# 8. Start Group Replication while |
| 91 |
# group_replication_force_members is set. Start |
| 92 |
# will error out. |
| 93 |
include/assert.inc [group_replication_force_members must be 127.0.0.1:10000] |
| 94 |
START GROUP_REPLICATION; |
| 95 |
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log. |
| 96 |
include/assert.inc [Member 2 is OFFLINE] |
| 97 |
|
| 98 |
############################################################ |
| 99 |
# 9. Clear group_replication_force_members and start |
| 100 |
# Group Replication. Group will have the 2 members. |
| 101 |
SET GLOBAL group_replication_force_members= ""; |
| 102 |
include/assert.inc [group_replication_force_members is empty] |
| 103 |
include/start_group_replication.inc |
| 104 |
[connection server1] |
| 105 |
include/rpl_gr_wait_for_number_of_members.inc |
| 106 |
include/assert.inc [Server 1 must be present on group members] |
| 107 |
include/assert.inc [Server 2 must be present on group members] |
| 108 |
[connection server2] |
| 109 |
include/rpl_gr_wait_for_number_of_members.inc |
| 110 |
include/assert.inc [Server 1 must be present on group members] |
| 111 |
include/assert.inc [Server 2 must be present on group members] |
| 112 |
include/assert.inc [group_replication_force_members must be empty] |
| 113 |
|
| 114 |
############################################################ |
| 115 |
# 10. Kill and restart a member to group loose majority. |
| 116 |
[connection server1] |
| 117 |
# Kill and restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS1 --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_group_name=GROUP_REPLICATION_GROUP_NAME |
| 118 |
include/rpl_reconnect.inc |
| 119 |
[connection server2] |
| 120 |
include/gr_wait_for_member_state.inc |
| 121 |
|
| 122 |
############################################################ |
| 123 |
# 11. Set invalid IP string value to |
| 124 |
# group_replication_force_members on a ONLINE member and |
| 125 |
# majority of group members are unreachable. |
| 126 |
SET GLOBAL group_replication_force_members= "256.256.256.777:1234"; |
| 127 |
ERROR HY000: The 'SET GLOBAL group_replication_force_members=256.256.256.777:1234' command encountered a failure. Error setting group_replication_force_members value '256.256.256.777:1234'. Please check error log for additional details. |
| 128 |
include/assert.inc [group_replication_force_members is empty] |
| 129 |
|
| 130 |
############################################################ |
| 131 |
# 12. Set IP of an UNREACHABLE member to |
| 132 |
# group_replication_force_members on a ONLINE member . |
| 133 |
SET GLOBAL group_replication_force_members= "GROUP_REPLICATION_LOCAL_ADDRESS1";; |
| 134 |
ERROR HY000: The 'SET GLOBAL group_replication_force_members=GROUP_REPLICATION_LOCAL_ADDRESS1' command encountered a failure. Error setting group_replication_force_members value 'GROUP_REPLICATION_LOCAL_ADDRESS1'. Please check error log for additional details. |
| 135 |
include/assert.inc [group_replication_force_members is empty] |
| 136 |
|
| 137 |
############################################################ |
| 138 |
# 13. Set valid IP string value to |
| 139 |
# group_replication_force_members on a ONLINE member and |
| 140 |
# majority of group members are unreachable |
| 141 |
SET GLOBAL group_replication_force_members= "GROUP_REPLICATION_LOCAL_ADDRESS1"; |
| 142 |
include/assert.inc [group_replication_force_members has member2 local address] |
| 143 |
|
| 144 |
############################################################ |
| 145 |
# 14. Clean up. |
| 146 |
[connection server1] |
| 147 |
include/start_group_replication.inc |
| 148 |
include/group_replication_end.inc |