Debian Codegraph @

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

raw
1 ################################################################################
2 # BUG#28656750 - CHANGE MAXIMUM VALUE OF DELAYED EXPEL TIMEOUT
3 #
4 # This test checks the setting of value of the
5 # group_replication_member_expel_timeout parameter.
6 #
7 # Test:
8 # 0. The test requires one server with GR started.
9 # 1. Set group_replication_member_expel_timeout=<INVALID_VALUE>. Expect error.
10 # 2. Set group_replication_member_expel_timeout=<INVALID_TYPE>. Expect error.
11 # 3. Set group_replication_member_expel_timeout=<INVALID_VALUE>. Expect error.
12 # 4. Set group_replication_member_expel_timeout=<VALID_VALUE>. Assert check the value.
13 # 5. Stop GR.
14 # 6. Set group_replication_member_expel_timeout=<INVALID_VALUE>. Expect error.
15 # 7. Set group_replication_member_expel_timeout=<INVALID_TYPE>. Expect error.
16 # 8. Set group_replication_member_expel_timeout=<INVALID_VALUE>. Expect error.
17 # 9. Set group_replication_member_expel_timeout=<VALID_VALUE>. Assert check the value.
18 #10. Clean up.
19 ################################################################################
20
21 --let $group_replication_group_name= aaaaaaaa-cccc-bbbb-cccc-aaaaaaaaaaaa
22 --source include/have_group_replication_plugin.inc
23 --let $rpl_skip_group_replication_start= 1
24 --source include/group_replication.inc
25
26 --let $rpl_connection_name= server1
27 --source include/rpl_connection.inc
28 --source include/start_and_bootstrap_group_replication.inc
29
30 --error ER_WRONG_VALUE_FOR_VAR
31 SET GLOBAL group_replication_member_expel_timeout= -1;
32
33 --error ER_WRONG_TYPE_FOR_VAR
34 SET GLOBAL group_replication_member_expel_timeout= 0.5;
35
36 --error ER_WRONG_VALUE_FOR_VAR
37 SET GLOBAL group_replication_member_expel_timeout= 3601;
38
39 # This is a valid value for the parameter
40 --eval SET GLOBAL group_replication_member_expel_timeout= 3600
41
42 --let $assert_text= The value of member_expel_timeout should be 3600
43 --let $assert_cond= "[SELECT @@group_replication_member_expel_timeout]" = 3600
44 --source include/assert.inc
45
46 --source include/stop_group_replication.inc
47
48 --error ER_WRONG_VALUE_FOR_VAR
49 SET GLOBAL group_replication_member_expel_timeout= -200;
50
51 --error ER_WRONG_TYPE_FOR_VAR
52 SET GLOBAL group_replication_member_expel_timeout= 5.5;
53
54 --error ER_WRONG_VALUE_FOR_VAR
55 SET GLOBAL group_replication_member_expel_timeout= 10000;
56
57 # This is a valid value for the parameter
58 --eval SET GLOBAL group_replication_member_expel_timeout= 30
59
60 --let $assert_text= The value of member_expel_timeout should be 30
61 --let $assert_cond= "[SELECT @@group_replication_member_expel_timeout]" = 30
62 --source include/assert.inc
63
64 # Reset parameter value to default
65 SET GLOBAL group_replication_member_expel_timeout= default;
66
67 --source include/group_replication_end.inc