Debian Codegraph @

mysql-test/suite/group_replication/r/gr_communication_configuration.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 server1]
7 SET SESSION sql_log_bin= 0;
8 call mtr.add_suppression("Unable to initialize the group communication engine");
9 call mtr.add_suppression("Error on group communication engine initialization");
10 call mtr.add_suppression("Error on group communication engine start");
11 call mtr.add_suppression("Invalid hostname or IP address \\(.*\\) assigned to the parameter local_node!");
12 call mtr.add_suppression("\\[GCS\\] Unable to join the group: peers not configured.");
13 call mtr.add_suppression("\\[GCS\\] Timeout while waiting for the group communication engine to exit!");
14 call mtr.add_suppression("\\[GCS\\] The member has failed to gracefully leave the group.");
15 call mtr.add_suppression("\\[GCS\\] None of the provided peer address is valid.");
16 call mtr.add_suppression("\\[GCS\\] read failed");
17 call mtr.add_suppression("\\[GCS\\] Invalid hostname or IP address.*");
18 call mtr.add_suppression("\\[GCS\\] The group_name, peer_nodes, local_node,");
19 SET SESSION sql_log_bin= 1;
20 [connection server2]
21 SET SESSION sql_log_bin= 0;
22 call mtr.add_suppression("Unable to initialize the group communication engine");
23 call mtr.add_suppression("Error on group communication engine initialization");
24 call mtr.add_suppression("Peer address .* is not valid.");
25 call mtr.add_suppression("\\[GCS\\] The group_name, peer_nodes, local_node or bootstrap_group parameters were not specified.");
26 call mtr.add_suppression("\\[GCS\\] Timeout while waiting for the group communication engine to exit!");
27 call mtr.add_suppression("\\[GCS\\] The member has failed to gracefully leave the group.");
28 call mtr.add_suppression("\\[GCS\\] None of the provided peer address is valid.");
29 call mtr.add_suppression("\\[GCS\\] read failed");
30 call mtr.add_suppression("\\[GCS\\] The group_name, peer_nodes, local_node,");
31 SET SESSION sql_log_bin= 1;
32 [connection server1]
33 [connection server2]
34 [connection server1]
35 SET @local_address= @@GLOBAL.group_replication_local_address;
36 SET @group_seeds= @@GLOBAL.group_replication_group_seeds;
37 [connection server2]
38 SET @local_address= @@GLOBAL.group_replication_local_address;
39 SET @group_seeds= @@GLOBAL.group_replication_group_seeds;
40 SET PERSIST group_replication_ip_allowlist= "GROUP_LOCAL_IP_ALLOWLIST";
41 [connection server1]
42 SET PERSIST group_replication_ip_allowlist= "GROUP_LOCAL_IP_ALLOWLIST";
43 [connection server2]
44 #######################################################
45 # 1. Try setting bootstrap_group variable with invalid
46 # values. It must fail.
47 SET GLOBAL group_replication_bootstrap_group= NULL;
48 ERROR 42000: Variable 'group_replication_bootstrap_group' can't be set to the value of 'NULL'
49 SET GLOBAL group_replication_bootstrap_group= "a";
50 ERROR 42000: Variable 'group_replication_bootstrap_group' can't be set to the value of 'a'
51 SET GLOBAL group_replication_bootstrap_group= 1.2;
52 ERROR 42000: Incorrect argument type to variable 'group_replication_bootstrap_group'
53 #######################################################
54 # 2. Try start Group Replication without configure any
55 # communication engine parameter, start must fail.
56 [connection server1]
57 START GROUP_REPLICATION;
58 ERROR HY000: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
59 #######################################################
60 # 3. Try start Group Replication with only bootstrap
61 # parameter enabled, start must fail.
62 SET GLOBAL group_replication_bootstrap_group= 1;
63 SET GLOBAL group_replication_local_address= "";
64 SET GLOBAL group_replication_group_seeds= "";
65 START GROUP_REPLICATION;
66 ERROR HY000: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
67 #######################################################
68 # 4. Try start Group Replication with invalid
69 # local_address parameter set, start must fail.
70 SET GLOBAL group_replication_bootstrap_group= 0;
71 SET GLOBAL group_replication_local_address= "ola";
72 SET GLOBAL group_replication_group_seeds= "";
73 START GROUP_REPLICATION;
74 ERROR HY000: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
75 #######################################################
76 # 5. Try start Group Replication with only local_address
77 # parameter set, start must fail.
78 SET GLOBAL group_replication_bootstrap_group= 0;
79 SET GLOBAL group_replication_local_address= @local_address;
80 SET GLOBAL group_replication_group_seeds= "";
81 START GROUP_REPLICATION;
82 ERROR HY000: The START GROUP_REPLICATION command failed as there was an error when joining the communication group.
83 #######################################################
84 # 6. Try start Group Replication with bootstrap
85 # parameter enable and group_seeds, start must
86 # fail.
87 SET GLOBAL group_replication_bootstrap_group= 1;
88 SET GLOBAL group_replication_local_address= "";
89 SET GLOBAL group_replication_group_seeds= @group_seeds;
90 START GROUP_REPLICATION;
91 ERROR HY000: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
92 #######################################################
93 # 7. Try start Group Replication with bootstrap
94 # parameter enable and local_address, start must
95 # succeed.
96 SET GLOBAL group_replication_bootstrap_group= 1;
97 SET GLOBAL group_replication_local_address= @local_address;
98 SET GLOBAL group_replication_group_seeds= "";
99 CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_PASSWORD='' FOR CHANNEL 'group_replication_recovery';
100 #######################################################
101 # 8. Try start Group Replication on server2 with invalid
102 # invalid group_seeds, start must fail.
103 [connection server2]
104 SET GLOBAL group_replication_bootstrap_group= 0;
105 SET GLOBAL group_replication_local_address= @local_address;
106 SET GLOBAL group_replication_group_seeds= "ola";
107 START GROUP_REPLICATION;
108 ERROR HY000: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
109 #######################################################
110 # 9. Try start Group Replication on server2 with
111 # invalid group_seeds, start must fail.
112 SET GLOBAL group_replication_bootstrap_group= 0;
113 SET GLOBAL group_replication_local_address= @local_address;
114 START GROUP_REPLICATION;
115 ERROR HY000: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
116 #######################################################
117 # 10. Try start Group Replication on server2 with
118 # local_address and group_seeds set to NULL, start
119 # must fail.
120 SET GLOBAL group_replication_bootstrap_group= 0;
121 SET GLOBAL group_replication_local_address= NULL;
122 SET GLOBAL group_replication_group_seeds= NULL;
123 START GROUP_REPLICATION;
124 ERROR HY000: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
125 #######################################################
126 # 11. Try start Group Replication on server2 with valid
127 # local_address and some invalid group_seeds, start must
128 # succeed.
129 SET GLOBAL group_replication_bootstrap_group= 0;
130 SET GLOBAL group_replication_local_address= @local_address;
131 CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_PASSWORD='' FOR CHANNEL 'group_replication_recovery';
132 #######################################################
133 # 12. We must have a group with two members.
134 [connection server1]
135 [connection server2]
136 #######################################################
137 # 13. Cleanup.
138 SET GLOBAL group_replication_group_seeds= @group_seeds;