Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=3]
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 the clone plugin and bootstrap group
9 # replication on server1.
10 [connection server1]
11 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
12 include/start_and_bootstrap_group_replication.inc
13 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
14 INSERT INTO t1 VALUES (0);
15
16 ############################################################
17 # 2. Start group replication on server3.
18 [connection server3]
19 include/start_group_replication.inc
20
21 ########################################################################
22 # 3. Restart server 2 with a monitoring process (mysqld_safe) if needed
23 [connection server2]
24 include/spawn_monitoring_process.inc
25 ############################################################
26 # 4. Install the clone plugin on server 2
27 # Setup the server so group replication starts on boot
28 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
29
30 ############################################################
31 # 5. Start group replication on server 2
32 # Set a debug point so it blocks during clone.
33 SET GLOBAL group_replication_clone_threshold= 1;
34 SET GLOBAL clone_autotune_concurrency = OFF;
35 SET GLOBAL clone_max_concurrency = 1;
36 SET @@GLOBAL.DEBUG='+d,gr_clone_wait';
37 START GROUP_REPLICATION;
38 SET DEBUG_SYNC = 'now WAIT_FOR gr_clone_paused';
39
40 ############################################################
41 # 6. Assert COUNT_TRANSACTIONS_ROWS_VALIDATING and
42 # TRANSACTIONS_COMMITTED_ALL_MEMBERS values on all servers.
43 [connection server3]
44 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
45 [connection server1]
46 include/assert.inc ['Count_transactions_rows_validating must be equal to 10 on server1']
47 include/assert.inc ['Transactions_committed_all_members must be equal to aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4 on server1']
48 [connection server2]
49 include/assert.inc ['Count_transactions_rows_validating must be equal to 0 on server2']
50 include/assert.inc ['Transactions_committed_all_members must be equal to "" on server2']
51 [connection server3]
52 include/assert.inc ['Count_transactions_rows_validating must be equal to 10 on server3']
53 include/assert.inc ['Transactions_committed_all_members must be equal to aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-4 on server3']
54 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
55 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
56 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
57
58 ############################################################
59 # 7. Assert COUNT_TRANSACTIONS_ROWS_VALIDATING and
60 # TRANSACTIONS_COMMITTED_ALL_MEMBERS values on all servers
61 # after a garbage collection round.
62 [connection server1]
63 'Count_transactions_rows_validating must be equal to 1 on server1'
64 'Transactions_committed_all_members must be equal to aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-15 on server1'
65 [connection server2]
66 include/assert.inc ['Count_transactions_rows_validating must be equal to 0 on server2']
67 include/assert.inc ['Transactions_committed_all_members must be equal to "" on server2']
68 [connection server3]
69 'Count_transactions_rows_validating must be equal to 1 on server3'
70 'Transactions_committed_all_members must be equal to aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-15 on server3'
71
72 ############################################################
73 # 8. Resume clone.
74 # Check process finished and server2 is online
75 [connection server2]
76 SET DEBUG_SYNC = 'now SIGNAL gr_clone_continue';
77 SET @@GLOBAL.DEBUG = '-d,gr_clone_wait';
78 include/rpl_reconnect.inc
79 include/gr_wait_for_member_state.inc
80 include/assert.inc [Clone must be completed]
81
82 ############################################################
83 # 9. Assert COUNT_TRANSACTIONS_ROWS_VALIDATING and
84 # TRANSACTIONS_COMMITTED_ALL_MEMBERS values on all servers
85 # once all members are ONLNE.
86 [connection server1]
87 'Count_transactions_rows_validating must be equal to 0 on server1'
88 'Transactions_committed_all_members must be equal to aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-16 on server1'
89 [connection server2]
90 'Count_transactions_rows_validating must be equal to 0 on server2'
91 'Transactions_committed_all_members must be equal to aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-16 on server2'
92 [connection server3]
93 'Count_transactions_rows_validating must be equal to 0 on server3'
94 'Transactions_committed_all_members must be equal to aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-16 on server3'
95
96 ############################################################
97 # 10. Cleanup
98 [connection server1]
99 DROP TABLE t1;
100 include/rpl_sync.inc
101 include/stop_group_replication.inc
102 UNINSTALL PLUGIN clone;
103 [connection server3]
104 SET DEBUG_SYNC = 'RESET';
105 include/stop_group_replication.inc
106 [connection server2]
107 SET DEBUG_SYNC = 'RESET';
108 include/stop_group_replication.inc
109 UNINSTALL PLUGIN clone;
110 SET GLOBAL group_replication_clone_threshold= GROUP_REPLICATION_CLONE_THRESHOLD;
111 RESET PERSIST group_replication_group_name;
112 RESET PERSIST group_replication_local_address;
113 RESET PERSIST group_replication_group_seeds;
114 RESET PERSIST group_replication_start_on_boot;
115 RESET PERSIST group_replication_communication_stack;
116 SET GLOBAL group_replication_start_on_boot= GROUP_REPLICATION_START_ON_BOOT;
117 SET SESSION sql_log_bin=0;
118 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.");
119 call mtr.add_suppression("Clone removing all user data for provisioning: Started");
120 call mtr.add_suppression("Clone removing all user data for provisioning: Finished");
121 call mtr.add_suppression("Internal query: CLONE INSTANCE FROM 'root'@'127.0.0.1':.* Error number: 3862");
122 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.");
123 SET SESSION sql_log_bin=1;
124 include/clean_monitoring_process.inc
125 include/group_replication_end.inc