Debian Codegraph @

mysql-test/suite/group_replication/r/gr_clone_integration_clone_not_installed.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 #########################################################
8 # 1. Start group replication on server1 and add some data
9 [connection server1]
10 include/start_and_bootstrap_group_replication.inc
11 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
12 INSERT INTO t1 VALUES (1);
13 INSERT INTO t1 VALUES (2);
14 include/rpl_sync.inc
15
16 ###############################################################
17 # 2. Configure the threshold on server 2 and start GR
18 # Distributed recovery is used as the clone plugin
19 # is not installed in the joiner
20 [connection server2]
21 SET GLOBAL group_replication_clone_threshold= 1;
22 include/start_group_replication.inc
23 include/assert_grep.inc [Clone plugin is not present]
24
25 #######################################################################
26 # 3. Install the clone plugin in the joiner and start GR
27 # The joiner tries using clone when it is not installed in the donor
28 # Distributed recovery is used as the clone process errors out
29 include/stop_group_replication.inc
30 [connection server1]
31 INSERT INTO t1 VALUES (3);
32 [connection server2]
33 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
34 include/start_group_replication.inc
35 include/assert_grep.inc [Clone plugin is not present in the donor]
36
37 ############################################################
38 # 4. Cleanup
39 SET GLOBAL group_replication_clone_threshold= 9223372036854775807;;
40 DROP TABLE t1;
41 include/rpl_sync.inc
42 UNINSTALL PLUGIN clone;
43 set session sql_log_bin=0;
44 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*");
45 call mtr.add_suppression("There was an issue when configuring the remote cloning process: The clone plugin is not present or active*");
46 call mtr.add_suppression("There was an issue when cloning from another server: Error number: 3862 Error message: Clone Donor Error: 1524 : Plugin 'clone' is not loaded");
47 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:*");
48 call mtr.add_suppression("Due to some issue on the previous step distributed recovery is now executing: Incremental Recovery.");
49 set session sql_log_bin=1;
50 include/group_replication_end.inc