Debian Codegraph @

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

raw
1 ###############################################################################
2 # Validate Group Replication members actions default values.
3 #
4 # Test:
5 # 0. This test requires one server
6 # 1. Validate Group Replication members actions default values.
7 # 2. Clean up.
8 ###############################################################################
9 --source include/have_group_replication_plugin.inc
10 --let $rpl_skip_group_replication_start= 1
11 --source include/group_replication.inc
12
13
14 --echo
15 --echo ############################################################
16 --echo # 1. Validate Group Replication members actions default values.
17 --let $assert_text= There must be two member actions
18 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_member_actions] = 2
19 --source include/assert.inc
20
21 --let $assert_text= mysql_disable_super_read_only_if_primary action default value
22 --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
23 --source include/assert.inc
24
25 --let $assert_text= mysql_start_failover_channels_if_primary action default value
26 --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
27 --source include/assert.inc
28
29 --let $assert_text= There must be one GR configuration version
30 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_configuration_version] = 1
31 --source include/assert.inc
32
33 --let $assert_text= The version of replication_group_member_actions must be 1
34 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_group_member_actions\', version, 1] = 1
35 --source include/assert.inc
36
37
38 --echo
39 --echo ############################################################
40 --echo # 2. Clean up.
41 --source include/group_replication_end.inc