Debian Codegraph @

mysql-test/suite/group_replication/t/gr_recovery_completion_mode_live_switch.test

raw
1 ################################################################################
2 # This test evaluates a live switch of the recovery_complete_at option.
3 # The member is recovering and waiting for the execution of cached transactions,
4 # and while doing this, the user can switch to wait for certification only.
5 #
6 # Test:
7 # 0. The test requires two servers.
8 # 1. Start group replication on server1 and create 2 tables (t1,t2)
9 # Replicate the tables to server2.
10 # 2. Insert a row on table t1 on server1.
11 # Lock table t1 and t2 on server2 and start group replication.
12 # Recovery will get stuck as the member can't execute data on t1.
13 # 3. Insert a row on table t2 on server1.
14 # This transaction will be executed after state transfer ends on server2.
15 # 4. Unlock t1 and recovery first phase will unblock.
16 # Recovery is still stuck on server2 waiting for the transaction on t2.
17 # 5. Change the recovery policy to wait for certification only
18 # Recovery should end and the member is online.
19 # 6. Test that all is fine and clean the setup.
20 # 7. Clean up.
21 ################################################################################
22
23 --source include/big_test.inc
24 --source include/have_debug.inc
25 --let $group_replication_group_name= 93150a70-b30b-11e5-a837-0800200c9a66
26 --source include/have_group_replication_plugin.inc
27 --let $rpl_skip_group_replication_start= 1
28 --source include/group_replication.inc
29
30 --echo #
31 --echo # Create t1 and t2 on server 1.
32 --echo # Replicate it to server 2 but stop the group replication again.
33 --echo #
34
35 --let $rpl_connection_name= server1
36 --source include/rpl_connection.inc
37
38 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
39 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
40
41 --source include/start_and_bootstrap_group_replication.inc
42
43 #sync the tables
44 --let $rpl_connection_name= server2
45 --source include/rpl_connection.inc
46
47 --source include/start_group_replication.inc
48 --source include/stop_group_replication.inc
49
50 --echo #
51 --echo # Insert a row on table 1 in server 1.
52 --echo # Lock table t1 and t2 on server 2 and start group replication.
53 --echo # Server 2 recovery is stuck on state transfer as it cannot execute on t1.
54 --echo #
55
56 --let $rpl_connection_name= server1
57 --source include/rpl_connection.inc
58
59 INSERT INTO t1 VALUES (1);
60
61 --let $rpl_connection_name= server_2
62 --source include/rpl_connection.inc
63
64 LOCK TABLE t1 WRITE;
65
66 --let $rpl_connection_name= slave
67 --source include/rpl_connection.inc
68
69 LOCK TABLE t2 WRITE;
70
71 --let $rpl_connection_name= server2
72 --source include/rpl_connection.inc
73
74 SET GLOBAL debug= '+d,group_replication_skip_read_mode';
75
76 --let $group_replication_start_member_state= RECOVERING
77 --source include/start_group_replication.inc
78
79 --echo #
80 --echo # Insert a row on table t2 in server 1.
81 --echo # This row is a cached row to be executed when the state transfer ends.
82 --echo # On server 2, the queue contains a VCLevent and this transaction
83 --echo #
84
85 --let $rpl_connection_name= server1
86 --source include/rpl_connection.inc
87
88 # Wait for the View Change event to reach the binlog.
89 --eval SELECT WAIT_FOR_EXECUTED_GTID_SET('$group_replication_group_name:4')
90 INSERT INTO t2 VALUES (1);
91
92 --let $rpl_connection_name= server2
93 --source include/rpl_connection.inc
94
95 # Wait for the the 2 transaction to be in the queue
96 --let $wait_condition= SELECT count_transactions_in_queue=2 FROM performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid)
97 --source include/wait_condition.inc
98
99 --echo #
100 --echo # Unlock table t1, state transfer will end on server 2.
101 --echo # Everything in the queue is certified
102 --echo # Recovery is still stuck on server 2 waiting for the transaction on t2.
103 --echo #
104
105 --let $rpl_connection_name= server_2
106 --source include/rpl_connection.inc
107
108 UNLOCK TABLES;
109
110 --let $rpl_connection_name= server2
111 --source include/rpl_connection.inc
112
113 # Everything should be certified at this point.
114 --let $wait_condition= SELECT count_transactions_in_queue=0 FROM performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid)
115 --source include/wait_condition.inc
116
117 --let $group_replication_member_state= RECOVERING
118 --source include/gr_wait_for_member_state.inc
119
120 --echo #
121 --echo # Change the recovery policy.
122 --echo # As it only depends on certified transactions, recovery ends.
123 --echo #
124
125 SET @configured_rec_policy= @@GLOBAL.group_replication_recovery_complete_at;
126 SET GLOBAL group_replication_recovery_complete_at= "transactions_certified";
127
128 --let $group_replication_member_state= ONLINE
129 --source include/gr_wait_for_member_state.inc
130
131 --echo #
132 --echo # Test all is fine
133 --echo #
134
135 --let $rpl_connection_name= slave
136 --source include/rpl_connection.inc
137
138 UNLOCK TABLES;
139
140 INSERT INTO t2 VALUES (2);
141
142 --let $rpl_connection_name= server1
143 --source include/rpl_connection.inc
144
145 # The data should be there.
146 --let $wait_condition= SELECT COUNT(*) = 2 FROM t2;
147 --source include/wait_condition.inc
148
149 --echo #
150 --echo # Clean up
151 --echo #
152
153 --let $rpl_connection_name= server2
154 --source include/rpl_connection.inc
155
156 SET GLOBAL debug= '-d,group_replication_skip_read_mode';
157 SET GLOBAL group_replication_recovery_complete_at= @configured_rec_policy;
158
159 DROP TABLE t1;
160 DROP TABLE t2;
161
162 --source include/group_replication_end.inc