Debian Codegraph @

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

raw
1 ################################################################################
2 # This test proves that post recovery value is 0 for
3 # COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE
4 #
5 # Test:
6 # 0. The test requires two servers: M1 and M2.
7 # 1. Create table t1 and LOCK it on server2.
8 # 2. Create some transactions on server1.
9 # 3. Wait for transactions to appear on applier queue on server2.
10 # 4. UNLOCK tables on server2.
11 # 5. Wait for applier queue on both servers to be 0.
12 # 6. Stop GR on server1 and server2.
13 # 7. Start GR on server1 and server2.
14 # 8. Confirm COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE is 0
15 # when all servers are online.
16 # 9. Cleanup.
17 ################################################################################
18
19 --source include/have_group_replication_plugin.inc
20 --source include/group_replication.inc
21
22 --echo
23 --echo # 1. Create table t1 and LOCK it on server2.
24
25 CREATE TABLE test.t1 (c1 int primary key);
26 --source include/rpl_sync.inc
27
28 --let $rpl_connection_name= server2
29 --source include/rpl_connection.inc
30
31 LOCK TABLE test.t1 READ;
32
33 --echo
34 --echo # 2. Create some transactions on server1.
35
36 --let $rpl_connection_name= server1
37 --source include/rpl_connection.inc
38
39 INSERT INTO test.t1 VALUES (1);
40 INSERT INTO test.t1 VALUES (2);
41
42 --echo
43 --echo # 3. Wait for transactions to appear on applier queue on server2.
44
45 --let $rpl_connection_name= server1
46 --source include/rpl_connection.inc
47
48 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE = 0 FROM performance_schema.replication_group_member_stats WHERE member_id in (SELECT @@server_uuid)
49 --source include/wait_condition_or_abort.inc
50
51 --let $rpl_connection_name= server2
52 --source include/rpl_connection.inc
53
54 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE > 0 FROM performance_schema.replication_group_member_stats WHERE member_id in (SELECT @@server_uuid)
55 --source include/wait_condition_or_abort.inc
56
57 --echo
58 --echo # 4. UNLOCK tables on server2.
59
60 UNLOCK TABLES;
61
62 --echo
63 --echo # 5. Wait for applier queue on both servers to be 0.
64
65 --let $rpl_connection_name= server1
66 --source include/rpl_connection.inc
67
68 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE = 0 FROM performance_schema.replication_group_member_stats WHERE member_id in (SELECT @@server_uuid)
69 --source include/wait_condition_or_abort.inc
70
71 --let $rpl_connection_name= server2
72 --source include/rpl_connection.inc
73
74 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE = 0 FROM performance_schema.replication_group_member_stats WHERE member_id in (SELECT @@server_uuid)
75 --source include/wait_condition_or_abort.inc
76
77 --echo
78 --echo # 6. Stop GR on server1 and server2.
79
80 --let $rpl_connection_name= server1
81 --source include/rpl_connection.inc
82
83 --source include/stop_group_replication.inc
84
85 --let $rpl_connection_name= server2
86 --source include/rpl_connection.inc
87
88 --source include/stop_group_replication.inc
89
90 --echo
91 --echo # 7. Start GR on server1 and server2.
92
93 --let $rpl_connection_name= server1
94 --source include/rpl_connection.inc
95
96 --source include/start_and_bootstrap_group_replication.inc
97
98 --let $rpl_connection_name= server2
99 --source include/rpl_connection.inc
100
101 --source include/start_group_replication.inc
102
103 --echo
104 --echo # 8. Confirm COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE is 0
105 --echo # when all servers are online.
106
107 --let $rpl_connection_name= server1
108 --source include/rpl_connection.inc
109
110 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE = 0 FROM performance_schema.replication_group_member_stats WHERE member_id in (SELECT @@server_uuid)
111 --source include/wait_condition_or_abort.inc
112
113 --let $rpl_connection_name= server2
114 --source include/rpl_connection.inc
115
116 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE = 0 FROM performance_schema.replication_group_member_stats WHERE member_id in (SELECT @@server_uuid)
117 --source include/wait_condition_or_abort.inc
118
119 --echo
120 --echo # 9. Cleanup.
121
122 --let $rpl_connection_name= server1
123 --source include/rpl_connection.inc
124
125 DROP TABLE test.t1;
126
127 --source include/group_replication_end.inc