Debian Codegraph @

mysql-test/suite/group_replication/t/gr_member_actions_reset.test

raw
1 ###############################################################################
2 # Validate that Group Replication members actions can be reset.
3 # The UDF `group_replication_reset_member_actions` can only be performed on a
4 # OFFLINE member.
5 #
6 # Test:
7 # 0. This test requires one server
8 # 1. Disable `mysql_disable_super_read_only_if_primary` action.
9 # 2. Try to reset member actions on a running member, it will
10 # not be allowed.
11 # 3. Leave the group and reset member actions.
12 # Validate Group Replication members actions default values.
13 # 4. Try to reset member actions on a server with super_read_only=1,
14 # it will not be allowed.
15 # 5. Try to reset member actions passing invalid parameters.
16 # 6. Clean up.
17 ###############################################################################
18 --source include/have_group_replication_plugin.inc
19 --let $rpl_skip_group_replication_start= 1
20 --let $rpl_group_replication_single_primary_mode=1
21 --source include/group_replication.inc
22
23 --echo
24 --echo ############################################################
25 --echo # 1. Disable `mysql_disable_super_read_only_if_primary` action.
26 --let $rpl_connection_name= server1
27 --source include/rpl_connection.inc
28 --source include/start_and_bootstrap_group_replication.inc
29
30 SELECT group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", "AFTER_PRIMARY_ELECTION");
31
32 --let $assert_text= The action mysql_disable_super_read_only_if_primary must be disabled
33 --let $assert_cond= [SELECT enabled FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_disable_super_read_only_if_primary\' AND event=\'AFTER_PRIMARY_ELECTION\', enabled, 1] = 0
34 --source include/assert.inc
35
36 --let $assert_text= The version of replication_group_member_actions must be 2
37 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_group_member_actions\', version, 1] = 2
38 --source include/assert.inc
39
40
41 --echo
42 --echo ############################################################
43 --echo # 2. Try to reset member actions on a running member, it will
44 --echo # not be allowed.
45 --error ER_GRP_RPL_UDF_ERROR
46 SELECT group_replication_reset_member_actions();
47
48 --let $assert_text= The action mysql_disable_super_read_only_if_primary must be disabled
49 --let $assert_cond= [SELECT enabled FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_disable_super_read_only_if_primary\' AND event=\'AFTER_PRIMARY_ELECTION\', enabled, 1] = 0
50 --source include/assert.inc
51
52 --let $assert_text= The version of replication_group_member_actions must be 2
53 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_group_member_actions\', version, 1] = 2
54 --source include/assert.inc
55
56
57 --echo
58 --echo ############################################################
59 --echo # 3. Leave the group and reset member actions.
60 --echo # Validate Group Replication members actions default values.
61 --source include/stop_group_replication.inc
62
63 SELECT group_replication_reset_member_actions();
64
65 --let $assert_text= There must be two member actions
66 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_member_actions] = 2
67 --source include/assert.inc
68
69 --let $assert_text= mysql_disable_super_read_only_if_primary action default value
70 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_disable_super_read_only_if_primary\' AND enabled=1 AND type=\'INTERNAL\' AND event=\'AFTER_PRIMARY_ELECTION\' AND priority=1 AND error_handling=\'IGNORE\'] = 1
71 --source include/assert.inc
72
73 --let $assert_text= mysql_start_failover_channels_if_primary action default value
74 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_start_failover_channels_if_primary\' AND enabled=1 AND type=\'INTERNAL\' AND event=\'AFTER_PRIMARY_ELECTION\' AND priority=10 AND error_handling=\'CRITICAL\'] = 1
75 --source include/assert.inc
76
77 --let $assert_text= There must be one GR configuration version
78 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_configuration_version] = 1
79 --source include/assert.inc
80
81 --let $assert_text= The version of replication_group_member_actions must be 1
82 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_group_member_actions\', version, 1] = 1
83 --source include/assert.inc
84
85 --let $assert_only_after = CURRENT_TEST: group_replication.gr_member_actions_reset
86 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
87 --let $assert_select= Member actions configuration was reset.
88 --let $assert_count= 1
89 --let $assert_text= Member actions configuration was reset.
90 --source include/assert_grep.inc
91
92
93 --echo
94 --echo ############################################################
95 --echo # 4. Try to reset member actions on a server with super_read_only=1,
96 --echo # it will not be allowed.
97
98 SET GLOBAL super_read_only= 1;
99 --error ER_CANT_INITIALIZE_UDF
100 SELECT group_replication_reset_member_actions();
101 SET GLOBAL read_only= 0;
102
103
104 --echo
105 --echo ############################################################
106 --echo # 5. Try to reset member actions passing invalid parameters.
107
108 --error ER_CANT_INITIALIZE_UDF
109 SELECT group_replication_reset_member_actions(1);
110
111 --error ER_CANT_INITIALIZE_UDF
112 SELECT group_replication_reset_member_actions("foo");
113
114
115 --echo
116 --echo ############################################################
117 --echo # 6. Clean up.
118 --source include/group_replication_end.inc