Debian Codegraph @

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

raw
1 ################################################################################
2 # COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE is set to some garbage value when
3 # group_replication_recovery_complete_at= "transactions_certified"
4 #
5 # Transactions received during recovery, when
6 # group_replication_recovery_complete_at was set to "transactions_certified",
7 # made counter go negative.
8 #
9 # Scenario:
10 # 1. This test requires 2 servers.
11 # 2. Prepare server1, creating some transactions for recovery.
12 # 2A. Create table t1 on server1.
13 # 2B. Bootstrap server1.
14 # 2C. Insert some records on server1 so recovery runs.
15 # 3. Prepare server2, block server2 on recovery.
16 # 3A. Create table t1 on server2.
17 # 3B. Set recovery_complete_at=transactions_certified.
18 # 3C. Lock table t1, so recovery does not finishes.
19 # (this gives time to create transactions on server1)
20 # 3D. Start group replication on server2.
21 # 4. Create some transactions on server1 while server2 is in recovery.
22 # This transactions will be applied by server2 when out of recovery.
23 # 5. Unlock all server2 tables and let recovery finish.
24 # 6. Transactions received during recovery, when
25 # group_replication_recovery_complete_at was set to
26 # "transactions_certified", do not make counter go negative.
27 # 7. Cleanup.
28 ################################################################################
29
30 --source include/have_group_replication_plugin.inc
31 --let $rpl_skip_group_replication_start= 1
32 --source include/group_replication.inc
33
34 --echo
35 --echo # 2. Prepare server1, creating some transactions for recovery.
36 --echo
37
38 --let $rpl_connection_name= server1
39 --source include/rpl_connection.inc
40
41 # 2A. Create table t1 on server1.
42 SET SESSION sql_log_bin=0;
43 CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
44 SET SESSION sql_log_bin=1;
45
46 # 2B. Bootstrap server1.
47 --source include/start_and_bootstrap_group_replication.inc
48
49 # 2C. Insert some records on server1 so recovery runs.
50 INSERT INTO test.t1 VALUES (1);
51
52 --echo
53 --echo 3. Prepare server2, block server2 on recovery.
54 --echo
55
56 --let $rpl_connection_name= server2
57 --source include/rpl_connection.inc
58 --let $server2_uuid= `SELECT @@server_uuid`
59 SET @debug_group_replication_recovery_complete_at= @@GLOBAL.group_replication_recovery_complete_at;
60
61 # 3A. Create table t1 on server2.
62 SET SESSION sql_log_bin=0;
63 CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
64 SET SESSION sql_log_bin=1;
65
66 # 3B. Set recovery_complete_at=transactions_certified.
67 SET @@global.group_replication_recovery_complete_at= "transactions_certified";
68
69 # 3C. Lock table t1, so recovery does not finishes.
70 # (this gives time to create transactions on server1)
71 LOCK TABLE test.t1 READ;
72
73 --let $rpl_connection_name= server_2
74 --source include/rpl_connection.inc
75
76 # 3D. Start group replication on server2.
77 --let $group_replication_start_member_state= RECOVERING
78 --source include/start_group_replication.inc
79
80 --echo
81 --echo # 4. Create some transactions on server1 while server2 is in recovery.
82 --echo # This transactions will be applied by server2 when out of recovery.
83 --echo
84 --let $rpl_connection_name= server1
85 --source include/rpl_connection.inc
86
87 insert into test.t1 values(100);
88 insert into test.t1 values(102);
89
90 --echo
91 --echo # 5. Unlock all server2 tables and let recovery finish.
92 --echo
93 --let $rpl_connection_name= server2
94 --source include/rpl_connection.inc
95
96 unlock tables;
97
98 --let $wait_condition=SELECT COUNT(*)=2 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE";
99 --source include/wait_condition.inc
100
101 --echo
102 --echo # 6. Transactions received during recovery, when
103 --echo # group_replication_recovery_complete_at was set to
104 --echo # "transactions_certified", do not make counter go negative.
105 --echo
106
107 --let $rpl_connection_name= server1
108 --source include/rpl_connection.inc
109 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE >= 0 FROM performance_schema.replication_group_member_stats WHERE member_id='$server2_uuid';
110 --source include/wait_condition.inc
111
112 --let $rpl_connection_name= server2
113 --source include/rpl_connection.inc
114 --let $wait_condition= SELECT COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE >= 0 FROM performance_schema.replication_group_member_stats WHERE member_id='$server2_uuid';
115 --source include/wait_condition.inc
116
117 --echo
118 --echo # 7. Cleanup.
119 --echo
120
121 --let $rpl_connection_name= server2
122 --source include/rpl_connection.inc
123 SET @@GLOBAL.group_replication_recovery_complete_at= @debug_group_replication_recovery_complete_at;
124
125 --let $rpl_connection_name= server1
126 --source include/rpl_connection.inc
127 DROP TABLE test.t1;
128 --source include/group_replication_end.inc