Debian Codegraph @

mysql-test/suite/group_replication/r/gr_member_actions_reset.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
7 ############################################################
8 # 1. Disable `mysql_disable_super_read_only_if_primary` action.
9 [connection server1]
10 include/start_and_bootstrap_group_replication.inc
11 SELECT group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
12 group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION")
13 OK
14 include/assert.inc [The action mysql_disable_super_read_only_if_primary must be disabled]
15 include/assert.inc [The version of replication_group_member_actions must be 2]
16
17 ############################################################
18 # 2. Try to reset member actions on a running member, it will
19 # not be allowed.
20 SELECT group_replication_reset_member_actions();
21 ERROR HY000: The function 'group_replication_reset_member_actions' failed. Member must be OFFLINE to reset its member actions configuration.
22 include/assert.inc [The action mysql_disable_super_read_only_if_primary must be disabled]
23 include/assert.inc [The version of replication_group_member_actions must be 2]
24
25 ############################################################
26 # 3. Leave the group and reset member actions.
27 # Validate Group Replication members actions default values.
28 include/stop_group_replication.inc
29 SELECT group_replication_reset_member_actions();
30 group_replication_reset_member_actions()
31 OK
32 include/assert.inc [There must be two member actions]
33 include/assert.inc [mysql_disable_super_read_only_if_primary action default value]
34 include/assert.inc [mysql_start_failover_channels_if_primary action default value]
35 include/assert.inc [There must be one GR configuration version]
36 include/assert.inc [The version of replication_group_member_actions must be 1]
37 include/assert_grep.inc [Member actions configuration was reset.]
38
39 ############################################################
40 # 4. Try to reset member actions on a server with super_read_only=1,
41 # it will not be allowed.
42 SET GLOBAL super_read_only= 1;
43 SELECT group_replication_reset_member_actions();
44 ERROR HY000: Can't initialize function 'group_replication_reset_member_actions'; Server must have super_read_only=0.
45 SET GLOBAL read_only= 0;
46
47 ############################################################
48 # 5. Try to reset member actions passing invalid parameters.
49 SELECT group_replication_reset_member_actions(1);
50 ERROR HY000: Can't initialize function 'group_replication_reset_member_actions'; UDF takes 0 arguments.
51 SELECT group_replication_reset_member_actions("foo");
52 ERROR HY000: Can't initialize function 'group_replication_reset_member_actions'; UDF takes 0 arguments.
53
54 ############################################################
55 # 6. Clean up.
56 include/group_replication_end.inc