1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
# ==== Purpose ====
#
# Clear variables that were persisted with SET PERSIST[_ONLY]
# For now it only resets single primary variables
# - group_replication_single_primary_mode
# - group_replication_enforce_update_everywhere_checks
#
# ==== Usage ====
#
# --source include/gr_clear_persistent_variables.inc
#
--let $include_filename= gr_clear_persistent_variables.inc
--source include/begin_include_file.inc
# Save current connection.
--let $_old_connection= $CURRENT_CONNECTION
# Clean persisted primary mode options on all servers to avoid contamination
# to other testcases.
--let $_rpl_server_max= 10
--let $_rpl_server= 1
while ($_rpl_server <= $_rpl_server_max)
{
--let $_rpl_server_port= \$SERVER_MYPORT_$_rpl_server
if (!$_rpl_server_port)
{
# Break loop.
--let $_rpl_server= $_rpl_server_max
}
if ($_rpl_server_port)
{
--let $rpl_connection_name= server_aux_$_rpl_server
--let $rpl_server_number= $_rpl_server
--source include/rpl_connect.inc
--let $rpl_connection_name= server_aux_$_rpl_server
--source include/rpl_connection.inc
--disable_query_log
# variables might not be there for some connections
--disable_warnings
RESET PERSIST IF EXISTS group_replication_single_primary_mode;
RESET PERSIST IF EXISTS group_replication_enforce_update_everywhere_checks;
--enable_warnings
--enable_query_log
--connection default
--disconnect server_aux_$_rpl_server
}
--inc $_rpl_server
}
# Revert to old connection.
--connection $_old_connection
--let $include_filename= gr_clear_persistent_variables.inc
--source include/end_include_file.inc
|
