Debian Codegraph @

mysql-test/suite/group_replication/r/gr_clone_integration_ddl_error.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. Install clone plugin on server1.
9 [connection server1]
10 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
11 SET GLOBAL clone_ddl_timeout = 0;
12
13 ############################################################
14 # 2. Bootstrap server1 and add some data
15 include/start_and_bootstrap_group_replication.inc
16 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
17 INSERT INTO t1 VALUES (1);
18 INSERT INTO t1 VALUES (2);
19
20 #######################################################################
21 # 3. Restart server 2 with a monitoring process (mysqld_safe) if needed
22 [connection server2]
23 include/spawn_monitoring_process.inc
24
25 ############################################################
26 # 4. Setup the server so group replication starts on boot
27 # Install the Clone plugin
28 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
29
30 ############################################################
31 # 5. On a empty server2 start group replication
32 # Pause it and execute a DDL query on the donor
33 # The clone process should fail on the joiner
34 SET GLOBAL group_replication_clone_threshold= 1;
35 SET GLOBAL clone_autotune_concurrency = OFF;
36 SET GLOBAL clone_max_concurrency = 1;
37 SET GLOBAL clone_ddl_timeout = 0;
38 SET @@GLOBAL.DEBUG='+d,gr_clone_wait';
39 START GROUP_REPLICATION;
40 SET DEBUG_SYNC = 'now WAIT_FOR gr_clone_paused';
41 SET @@GLOBAL.DEBUG='-d,gr_clone_wait';
42 [connection server_1_1]
43 ALTER TABLE t1 ADD COLUMN col2 int, ALGORITHM=COPY;
44 [connection server1]
45 [connection server2]
46 SET DEBUG_SYNC = 'now SIGNAL gr_clone_continue';
47 include/gr_wait_for_member_state.inc
48 include/assert.inc [Clone should have failed]
49 include/assert_grep.inc [Clone failed and no recovery is possible]
50
51 ############################################################
52 # 6. Restart Group replication
53 # The clone process should now be successful
54 include/stop_group_replication.inc
55 START GROUP_REPLICATION;
56 include/rpl_reconnect.inc
57 include/gr_wait_for_member_state.inc
58 include/diff_tables.inc [server1:test.t1 ,server2:test.t1]
59
60 ############################################################
61 # 7. Cleanup
62 SET GLOBAL group_replication_clone_threshold= CLONE_THRESHOLD_VALUE;
63 RESET PERSIST IF EXISTS group_replication_group_name;
64 RESET PERSIST IF EXISTS group_replication_local_address;
65 RESET PERSIST IF EXISTS group_replication_group_seeds;
66 RESET PERSIST IF EXISTS group_replication_start_on_boot;
67 RESET PERSIST IF EXISTS group_replication_communication_stack;
68 SET GLOBAL group_replication_start_on_boot= START_ON_BOOT_VALUE;
69 [connection server_1_1]
70 DROP TABLE t1;
71 include/rpl_sync.inc
72 [connection server2]
73 include/clean_monitoring_process.inc
74 set session sql_log_bin=0;
75 call mtr.add_suppression("Clone removing all user data for provisioning: Started");
76 call mtr.add_suppression("Clone removing all user data for provisioning: Finished");
77 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.");
78 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:*");
79 call mtr.add_suppression("There was an issue when cloning from another server: Error number: 3862 Error message: Clone Donor Error: 3633 : Concurrent DDL is performed during clone operation. Please try again.");
80 call mtr.add_suppression("Due to a critical cloning error or lack of donors, distributed recovery cannot be executed. The member will now leave the group.");
81 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
82 set session sql_log_bin=1;
83 [connection server1]
84 UNINSTALL PLUGIN clone;
85 [connection server2]
86 UNINSTALL PLUGIN clone;
87 include/group_replication_end.inc