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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
###############################################################################
# This test evaluates that a server can be shutdown when clone is in progress
# in the context of group replication.
#
# 0. This test requires 2 servers.
# 1. Install clone plugin on server1.
# 2. Bootstrap server1 and add some data
# 3. Make a backup of server 2 to restore it at the end
# 4. Install the clone plugin on server2
# 5. On a empty server2 start group replication
# Block clone progress
# 6. Shutdown the server while the clone is happening
# 7. Restart server2 using the backup folder
# 8. Cleanup
#
--source include/have_debug_sync.inc
--source include/not_windows.inc
--source include/have_clone_plugin.inc
--source include/have_group_replication_plugin.inc
--let $rpl_skip_group_replication_start= 1
--source include/group_replication.inc
# Validate plugins
--let plugins = CLONE_PLUGIN,GROUP_REPLICATION
--source include/check_plugin_dir.inc
--echo
--echo ############################################################
--echo # 1. Install clone plugin on server1.
--let $rpl_connection_name= server1
--source include/rpl_connection.inc
--let $server1_port= `SELECT @@GLOBAL.PORT`
--replace_result $CLONE_PLUGIN CLONE_PLUGIN
--eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
--echo
--echo ############################################################
--echo # 2. Bootstrap server1 and add some data
--source include/start_and_bootstrap_group_replication.inc
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
--echo ############################################################
--echo # 3. Make a backup of server 2 to restore it at the end
--let $rpl_connection_name= server2
--source include/rpl_connection.inc
--let $BACKUP_DATADIR = $MYSQL_TMP_DIR/data_new
--let $MYSQLD_2_DATADIR= `SELECT @@datadir`
--force-cpdir $MYSQLD_2_DATADIR $BACKUP_DATADIR
--echo
--echo ############################################################
--echo # 4. Install the clone plugin on server2
--replace_result $CLONE_PLUGIN CLONE_PLUGIN
--eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
--echo
--echo ############################################################
--echo # 5. On a empty server2 start group replication
--echo # Block clone progress
--let $_group_replication_threshold_save= `SELECT @@GLOBAL.group_replication_clone_threshold`
SET GLOBAL group_replication_clone_threshold= 1;
SET GLOBAL clone_autotune_concurrency = OFF;
SET GLOBAL clone_max_concurrency = 1;
SET @@GLOBAL.DEBUG='+d,gr_clone_wait';
--replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
--eval SET GLOBAL group_replication_group_name= "$group_replication_group_name"
START GROUP_REPLICATION;
SET DEBUG_SYNC = 'now WAIT_FOR gr_clone_paused';
--echo
--echo ############################################################
--echo # 6. Shutdown the server while the clone is happening
--let $_expect_file_name= $MYSQLTEST_VARDIR/tmp/mysqld.2.expect
--exec echo "wait" > $_expect_file_name
--exec $MYSQLADMIN -uroot --password="" -S $SLAVE_MYSOCK shutdown 2>&1
--source include/wait_until_disconnected.inc
--echo
--echo ############################################################
--echo # 7. Restart server2 using the backup folder
--force-rmdir $MYSQLD_2_DATADIR
--force-cpdir $BACKUP_DATADIR $MYSQLD_2_DATADIR
--force-rmdir $BACKUP_DATADIR
--source include/start_mysqld.inc
--let $rpl_server_number= 2
--source include/rpl_reconnect.inc
--echo
--echo ############################################################
--echo # 8. Cleanup
--let $rpl_connection_name= server1
--source include/rpl_connection.inc
DROP TABLE t1;
--let $rpl_connection_name= server2
--source include/rpl_connection.inc
set session sql_log_bin=0;
call mtr.add_suppression("Clone removing all user data for provisioning: Started");
call mtr.add_suppression("Clone removing all user data for provisioning: Finished");
call mtr.add_suppression("This member will start distributed recovery using clone. It is due to the number of missing transactions being higher than the configured threshold of 1.");
call mtr.add_suppression("Internal query: CLONE INSTANCE FROM \'root\'@\'127.0.0.1\':[0-9]+ IDENTIFIED BY \'\\*\\*\\*\\*\\*\' REQUIRE NO SSL; result in error. Error number:*");
call mtr.add_suppression("There was an issue when cloning from another server: Error number: 1317 Error message: Query execution was interrupted'");
call mtr.add_suppression("Plugin group_replication reported: 'Error, maximum number of retries exceeded when waiting for the internal server session state to be operating'");
call mtr.add_suppression("Failed to establish an internal server connection to execute plugin operations");
call mtr.add_suppression("Info table is not ready to be used. *");
call mtr.add_suppression("Error while starting the group replication applier thread");
set session sql_log_bin=1;
--let $rpl_connection_name= server1
--source include/rpl_connection.inc
UNINSTALL PLUGIN clone;
--source include/group_replication_end.inc
|
