Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=3]
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 [connection server3]
8 [connection server1]
9 ###############################################################################
10 # 2. Check that it is *not* possible to modify the communication_protocol value via an ONLINE member when some other member is in RECOVERING state.
11 [connection server2]
12 include/stop_group_replication.inc
13 [connection server2]
14 SET @@GLOBAL.DEBUG='+d,recovery_thread_wait_before_finish';
15 include/start_group_replication.inc
16 [connection server1]
17 SELECT group_replication_set_communication_protocol("5.7.14");
18 ERROR HY000: Can't initialize function 'group_replication_set_communication_protocol'; A member is joining the group, wait for it to be ONLINE.
19 ###############################################################################
20 # 3. Check that it is *not* possible to modify the communication_protocol value via a RECOVERING member.
21 [connection server2]
22 SELECT group_replication_set_communication_protocol("5.7.14");
23 ERROR HY000: Can't initialize function 'group_replication_set_communication_protocol'; A member is joining the group, wait for it to be ONLINE.
24 ###############################################################################
25 # 4. Check that it is possible to query the communication_protocol value via an ONLINE member when some other members are in RECOVERING state.
26 [connection server1]
27 SELECT group_replication_get_communication_protocol();
28 group_replication_get_communication_protocol()
29 GR_COMMUNICATION_PROTOCOL_VERSION
30 ###############################################################################
31 # 5. Check that it is *not* possible to query the communication_protocol value via a RECOVERING member.
32 [connection server2]
33 SELECT group_replication_get_communication_protocol();
34 ERROR HY000: Can't initialize function 'group_replication_get_communication_protocol'; Member must be ONLINE and in the majority partition.
35 [connection server2]
36 SET DEBUG_SYNC= "now WAIT_FOR signal.recovery_thread_wait_before_finish_reached";
37 SET @@GLOBAL.DEBUG='-d,recovery_thread_wait_before_finish';
38 SET DEBUG_SYNC= "now SIGNAL signal.recovery_end";
39 Wait until server2 becomes ONLINE
40 include/gr_wait_for_member_state.inc
41 SET DEBUG_SYNC= 'RESET';
42 ###############################################################################
43 # 6. Check that it is *not* possible to modify the communication_protocol value via an ONLINE member when some member is in UNREACHABLE state.
44 # Kill and restart
45 [connection server_1]
46 include/gr_wait_for_member_state.inc
47 SELECT group_replication_set_communication_protocol("5.7.14");
48 ERROR HY000: Can't initialize function 'group_replication_set_communication_protocol'; All members in the group must be reachable.
49 ###############################################################################
50 # 7. Check that it is possible to query the communication_protocol value via an ONLINE member when a minority of members are UNREACHABLE.
51 SELECT group_replication_get_communication_protocol();
52 group_replication_get_communication_protocol()
53 GR_COMMUNICATION_PROTOCOL_VERSION
54 ###############################################################################
55 # 8. Check that it is *not* possible to query the communication_protocol value via an ONLINE member when a majority of members are UNREACHABLE.
56 [connection server3]
57 # Kill and restart
58 [connection server_1]
59 include/gr_wait_for_member_state.inc
60 SELECT group_replication_get_communication_protocol();
61 ERROR HY000: Can't initialize function 'group_replication_get_communication_protocol'; Member must be ONLINE and in the majority partition.
62 ###############################################################################
63 # 9. Cleanup
64 [connection server1]
65 include/rpl_reconnect.inc
66 [connection server_2]
67 SET @@global.group_replication_group_seeds="GROUP_SEEDS_SERVER2";
68 SET @@global.group_replication_local_address="LOCAL_ADDRESS_SERVER2";
69 SET @@global.group_replication_group_name="GROUP_REPLICATION_GROUP_NAME";
70 include/start_group_replication.inc
71 include/rpl_reconnect.inc
72 [connection server_3]
73 SET @@global.group_replication_group_seeds="GROUP_SEEDS_SERVER3";
74 SET @@global.group_replication_local_address="LOCAL_ADDRESS_SERVER3";
75 SET @@global.group_replication_group_name="GROUP_REPLICATION_GROUP_NAME";
76 include/start_group_replication.inc
77 [connection server1]
78 include/rpl_gr_wait_for_number_of_members.inc
79 include/group_replication_end.inc