Debian Codegraph @

mysql-test/suite/group_replication/r/gr_member_actions_join_lower_version_group.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("This member joined a group on which all members do not support member actions, as such it did reset its member configuration to the default one.");
9 call mtr.add_suppression("This member joined a group on which all members do not support replication failover channels integration on Group Replication, as such it did reset its replication failover channels configuration to the default one.");
10 SET SESSION sql_log_bin = 1;
11
12 ############################################################
13 # 1. Bootstrap a group and increase the member actions
14 # configuration version.
15 # Simulate a member version lower than 8.0.25 which does
16 # not support member actions, thence does not include its
17 # configuration on the exchangeable data.
18 [connection server1]
19 include/start_and_bootstrap_group_replication.inc
20 SELECT group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
21 group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION")
22 OK
23 SELECT group_replication_enable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
24 group_replication_enable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION")
25 OK
26 include/assert.inc [The version of replication_group_member_actions must be 3]
27 SET @@GLOBAL.DEBUG='+d,group_replication_skip_add_member_actions_to_exchangeable_data';
28
29 ############################################################
30 # 2. This member will not receive the members configuration
31 # thence will reset its configuration to the default one.
32 [connection server2]
33 SELECT group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
34 group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION")
35 OK
36 include/assert.inc [The action mysql_disable_super_read_only_if_primary must be disabled]
37 include/assert.inc [The version of replication_group_member_actions must be 2]
38 include/start_group_replication.inc
39 include/assert.inc [There must be two member actions]
40 include/assert.inc [mysql_disable_super_read_only_if_primary action default value]
41 include/assert.inc [mysql_start_failover_channels_if_primary action default value]
42 include/assert.inc [There must be one GR configuration version]
43 include/assert.inc [The version of replication_group_member_actions must be 1]
44 include/assert_grep.inc [This member joined a group on which all members do not support member actions, as such it did reset its member configuration to the default one.]
45
46 ############################################################
47 # 3. Clean up.
48 [connection server1]
49 SET @@GLOBAL.DEBUG='-d,group_replication_skip_add_member_actions_to_exchangeable_data';
50 include/group_replication_end.inc