Debian Codegraph @

mysql-test/suite/group_replication/r/gr_force_peer_addresses_option.result

raw
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