Debian Codegraph @

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

raw
1 ################################################################################
2 # This test verifies that parallel execution of STOP GROUP_REPLICATION and
3 # Group Replication options change are handled properly by the server.
4 #
5 # Test:
6 # 0. The test requires one server: M1
7 # 1. Bootstrap a group on server1.
8 # Setup a debug point that will block a future
9 # STOP GROUP_REPLICATION command
10 # after the plugin_running_lock is acquired.
11 # 2. Asynchronously execute STOP GROUP_REPLICATION command.
12 # 3. Try to change Group Replication options that cannot be
13 # change while a STOP GROUP_REPLICATION is ongoing, they
14 # must fail.
15 # 4. Change Group Replication options that can be
16 # change while a STOP GROUP_REPLICATION is ongoing.
17 # 5. Validate that we did test all Group Replication options.
18 # 6. Resume the STOP GROUP_REPLICATION command.
19 # 7. Clean up.
20 ################################################################################
21 --source include/have_debug.inc
22 --source include/have_debug_sync.inc
23 --source include/have_group_replication_plugin.inc
24 --let $rpl_skip_group_replication_start= 1
25 --source include/group_replication.inc
26
27
28 --echo ############################################################
29 --echo # 1. Bootstrap a group on server1.
30 --echo # Setup a debug point that will block a future
31 --echo # STOP GROUP_REPLICATION command
32 --echo # after the plugin_running_lock is acquired.
33 --let $rpl_connection_name= server1
34 --source include/rpl_connection.inc
35 --source include/start_and_bootstrap_group_replication.inc
36 SET @@GLOBAL.DEBUG='+d,gr_plugin_gr_stop_after_holding_plugin_running_lock';
37
38
39 --echo ############################################################
40 --echo # 2. Asynchronously execute STOP GROUP_REPLICATION command.
41 --let $rpl_connection_name= server_1
42 --source include/rpl_connection.inc
43 --send STOP GROUP_REPLICATION
44
45 --let $rpl_connection_name= server1
46 --source include/rpl_connection.inc
47 SET DEBUG_SYNC= "now WAIT_FOR signal.reached_plugin_gr_stop_after_holding_plugin_running_lock";
48 SET @@GLOBAL.DEBUG='-d,gr_plugin_gr_stop_after_holding_plugin_running_lock';
49
50
51 --echo ############################################################
52 --echo # 3. Try to change Group Replication options that cannot be
53 --echo # change while a STOP GROUP_REPLICATION is ongoing, they
54 --echo # must fail.
55 --let $rpl_connection_name= server1
56 --source include/rpl_connection.inc
57 # When adding new options, if it can be set while STOP GROUP_REPLICATION is
58 # ongoing please add it below with `AND VARIABLE_NAME != 'xxx'`
59 SET SESSION sql_log_bin = 0;
60 CREATE TABLE gr_options_that_cannot_be_change (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(64) UNIQUE KEY);
61 INSERT INTO gr_options_that_cannot_be_change (name)
62 SELECT VARIABLE_NAME FROM performance_schema.global_variables
63 WHERE VARIABLE_NAME LIKE 'group_replication_%'
64 AND VARIABLE_NAME != 'group_replication_allow_local_lower_version_join'
65 AND VARIABLE_NAME != 'group_replication_bootstrap_group'
66 AND VARIABLE_NAME != 'group_replication_communication_stack'
67 AND VARIABLE_NAME != 'group_replication_consistency'
68 AND VARIABLE_NAME != 'group_replication_exit_state_action'
69 AND VARIABLE_NAME NOT LIKE 'group_replication_flow_control_%'
70 AND VARIABLE_NAME != 'group_replication_group_seeds'
71 AND VARIABLE_NAME != 'group_replication_local_address'
72 AND VARIABLE_NAME != 'group_replication_poll_spin_loops'
73 AND VARIABLE_NAME != 'group_replication_ssl_mode'
74 AND VARIABLE_NAME != 'group_replication_start_on_boot'
75 AND VARIABLE_NAME != 'group_replication_tls_source'
76 AND VARIABLE_NAME != 'group_replication_transaction_size_limit'
77 ORDER BY VARIABLE_NAME;
78 SET SESSION sql_log_bin = 1;
79 --let $gr_options_that_cannot_be_change_count= `SELECT COUNT(*) FROM gr_options_that_cannot_be_change;`
80
81 --let $option_id= 1
82 while ( $option_id <= $gr_options_that_cannot_be_change_count )
83 {
84 --let $option_name= `SELECT name FROM gr_options_that_cannot_be_change WHERE id=$option_id`
85 --eval SET @value= @@GLOBAL.$option_name
86 --error ER_UNABLE_TO_SET_OPTION
87 --eval SET @@GLOBAL.$option_name= @value
88 --inc $option_id
89 }
90
91
92 --echo ############################################################
93 --echo # 4. Change Group Replication options that can be
94 --echo # change while a STOP GROUP_REPLICATION is ongoing.
95 --let $rpl_connection_name= server1
96 --source include/rpl_connection.inc
97 SET SESSION sql_log_bin = 0;
98 CREATE TABLE gr_options_that_can_be_change (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(64) UNIQUE KEY);
99 INSERT INTO gr_options_that_can_be_change (name)
100 SELECT gb.VARIABLE_NAME FROM performance_schema.global_variables gb
101 WHERE gb.VARIABLE_NAME LIKE 'group_replication_%'
102 AND gb.VARIABLE_NAME NOT IN (SELECT name FROM gr_options_that_cannot_be_change)
103 ORDER BY gb.VARIABLE_NAME;
104 SET SESSION sql_log_bin = 1;
105 --let $gr_options_that_can_be_change_count= `SELECT COUNT(*) FROM gr_options_that_can_be_change;`
106
107 --let $option_id= 1
108 while ( $option_id <= $gr_options_that_can_be_change_count )
109 {
110 --let $option_name= `SELECT name FROM gr_options_that_can_be_change WHERE id=$option_id`
111 --eval SET @value= @@GLOBAL.$option_name
112 --eval SET @@GLOBAL.$option_name= @value
113 --inc $option_id
114 }
115
116
117 --echo ############################################################
118 --echo # 5. Validate that we did test all Group Replication options.
119 --let $rpl_connection_name= server1
120 --source include/rpl_connection.inc
121 --let $gr_options= `SELECT COUNT(*) FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'group_replication_%'`
122
123 --let $assert_text= Validate that we did test all Group Replication options
124 --let $assert_cond= $gr_options = ($gr_options_that_cannot_be_change_count + $gr_options_that_can_be_change_count)
125 --source include/assert.inc
126
127
128 --echo ############################################################
129 --echo # 6. Resume the STOP GROUP_REPLICATION command.
130 --let $rpl_connection_name= server1
131 --source include/rpl_connection.inc
132 SET DEBUG_SYNC= "now SIGNAL signal.resume_plugin_gr_stop_after_holding_plugin_running_lock";
133
134 --let $rpl_connection_name= server_1
135 --source include/rpl_connection.inc
136 --reap
137
138 --let $group_replication_member_state= OFFLINE
139 --source include/gr_wait_for_member_state.inc
140
141
142 --echo ############################################################
143 --echo # 7. Clean up.
144 --let $rpl_connection_name= server1
145 --source include/rpl_connection.inc
146 SET DEBUG_SYNC= 'RESET';
147 SET @@GLOBAL.read_only= 0;
148
149 SET SESSION sql_log_bin = 0;
150 DROP TABLE gr_options_that_cannot_be_change;
151 DROP TABLE gr_options_that_can_be_change;
152 SET SESSION sql_log_bin = 1;
153
154 --source include/group_replication_end.inc