Debian Codegraph @

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

raw
1 SET SESSION sql_log_bin=0;
2 call mtr.add_suppression("Unable to start Group Replication on boot");
3 call mtr.add_suppression("Invalid input value for group_replication_view_change_uuid ''. Please, provide a valid UUID.");
4 call mtr.add_suppression("group_replication_group_name '.*', which is the same as group_replication_view_change_uuid. Please change group_replication_view_change_uuid to AUTOMATIC");
5 call mtr.add_suppression("group_replication_view_change_uuid is incompatible with group. group_replication_view_change_uuid.*matches server_uuid.*.");
6 SET SESSION sql_log_bin=1;
7 ####################################################################
8 # 1. We can't start a Group Replication if
9 # group_replication_view_change_uuid is configured with a invalid
10 # uuid
11 SET PERSIST_ONLY group_replication_view_change_uuid = "";
12 # restart:--group-replication-start-on-boot=1 --group-replication-group-name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1
13 include/assert_grep.inc [group_replication_view_change_uuid '' not a valid uuid]
14 START GROUP_REPLICATION;
15 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
16 SET GLOBAL group_replication_view_change_uuid = "";
17 ERROR 42000: The group_replication_view_change_uuid is not a valid UUID
18 include/assert_grep.inc [group_replication_view_change_uuid '' not a valid uuid]
19 ####################################################################
20 # 2. We can't start a Group Replication if
21 # group_replication_view_change_uuid is configured with same uuid
22 # as group_replication_group_name
23 SET PERSIST_ONLY group_replication_view_change_uuid = "GROUP_NAME";
24 # restart:--group-replication-start-on-boot=1 --group-replication-group-name=GROUP_REPLICATION_GROUP_NAME --group_replication_view_change_uuid=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1
25 include/assert_grep.inc [group_replication_group_name shall be different from group_replication_view_change_uuid]
26 START GROUP_REPLICATION;
27 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
28 SET GLOBAL group_replication_view_change_uuid = "GROUP_NAME";
29 ERROR HY000: Variable 'group_replication_view_change_uuid' cannot be set to the value of 'GROUP_NAME'. If you want to use the UUID of 'group_replication_group_name' for the UUID of View_change_log_events, please set 'group_replication_view_change_uuid' to AUTOMATIC.
30 include/assert_grep.inc [group_replication_group_name shall be different from group_replication_view_change_uuid]
31 ####################################################################
32 # 3. We can't start a Group Replication if
33 # group_replication_view_change_uuid is configured with same uuid
34 # as server 1
35 SET PERSIST_ONLY group_replication_view_change_uuid = "MEMBER_1_UUID";
36 # restart:--group-replication-start-on-boot=1 --group-replication-group-name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_bootstrap_group=1
37 include/assert_grep.inc [group_replication_view_change_uuid shall be diferent from server uuid]
38 START GROUP_REPLICATION;
39 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
40 include/assert_grep.inc [group_replication_view_change_uuid shall be diferent from server uuid]
41 ####################################################################
42 # 4. We can't set group_replication_group_name to same uuid
43 # configured on group_replication_view_change_uuid
44 SET GLOBAL group_replication_view_change_uuid = "9f46e042-98a0-439d-a8fb-7130670ca49b";
45 Warnings:
46 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
47 SET GLOBAL group_replication_group_name = "9f46e042-98a0-439d-a8fb-7130670ca49b";
48 ERROR HY000: Variable 'group_replication_group_name' cannot be set to the value of '9f46e042-98a0-439d-a8fb-7130670ca49b'. The value is the same as group_replication_view_change_uuid. Please change group_replication_view_change_uuid to AUTOMATIC
49 ####################################################################
50 # 5. Cleanup
51 RESET PERSIST;
52 SET GLOBAL group_replication_view_change_uuid = VIEW_CHANGE_UUID;
53 Warnings:
54 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
55 Warnings:
56 Warning 3615 Variable group_replication_ip_allowlist does not exist in persisted config file