Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # This test verifies when a primary election is ongoing and backlog is being
4 # applied, transactions being executed will be aborted if wait_timeout is
5 # reached.
6 #
7 # Test:
8 # 0. This test requires two servers on single primary mode
9 # 1. Bootstrap group on server 1 and create table t1
10 # 2. Join server2 to group
11 # 3. Lock tables to allow create backlog
12 # 4. Execute transaction on primary server
13 # 5. Server2 will certify transaction but won't apply due lock tables
14 # 6. Stop primary server and primary election will occur
15 # 7. Set wait_timeout to 5 seconds
16 # 8. Execute a statement that will be put on hold
17 # 9. Validate statement is on hold
18 # 10. Sleep for 10 seconds to connection on hold exceed wait timeout
19 # 11. Reap with timeout error on pending statement
20 # 12. UNLOCK tables to allow apply backlog
21 # 13. Cleanup
22 #
23 ###############################################################################
24
25 --source include/have_group_replication_plugin.inc
26
27 --let $rpl_skip_group_replication_start= 1
28 --let $rpl_server_count= 2
29 --let $rpl_group_replication_single_primary_mode=1
30 --source include/group_replication.inc
31
32 --echo
33 --echo # 1. Bootstrap group on server 1 and create table t1
34
35 --let $rpl_connection_name= server1
36 --source include/rpl_connection.inc
37
38 --source include/start_and_bootstrap_group_replication.inc
39
40 CREATE TABLE test.t1 (a int primary key);
41
42 --echo
43 --echo # 2. Join server2 to group
44
45 --let $rpl_connection_name= server_2
46 --source include/rpl_connection.inc
47
48 --source include/start_group_replication.inc
49
50 --let $member2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
51
52 --echo
53 --echo # 3. Lock tables to allow create backlog
54
55 LOCK TABLES t1 READ;
56
57 --echo
58 --echo # 4. Execute transaction on primary server
59
60 --let $rpl_connection_name= server1
61 --source include/rpl_connection.inc
62
63 INSERT INTO t1 VALUES (1);
64
65 --echo
66 --echo # 5. Server2 will certify transaction but won't apply due lock tables
67
68 --let $rpl_connection_name= server2
69 --source include/rpl_connection.inc
70
71 --let $wait_condition= SELECT COUNT(*) = 1 FROM performance_schema.replication_group_member_stats WHERE member_id='$member2_uuid' AND count_transactions_checked = 1 AND count_transactions_remote_in_applier_queue = 1
72 --source include/wait_condition.inc
73
74 --echo
75 --echo # 6. Stop primary server and primary election will occur
76
77 --let $rpl_connection_name= server1
78 --source include/rpl_connection.inc
79
80 --source include/stop_group_replication.inc
81
82 --echo
83 --echo # 7. Set wait_timeout to 5 seconds
84
85 --let $rpl_connection_name= server2
86 --source include/rpl_connection.inc
87
88 SET @@SESSION.wait_timeout = 5;
89
90 --echo
91 --echo # 8. Execute a statement that will be put on hold
92
93 SET @@SESSION.group_replication_consistency= BEFORE_ON_PRIMARY_FAILOVER;
94
95 --send SELECT * FROM t1
96
97 --echo
98 --echo # 9. Validate statement is on hold
99
100 --let $rpl_connection_name= server_2
101 --source include/rpl_connection.inc
102
103 --let $wait_condition= SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE='Executing hook on transaction begin.' AND INFO='SELECT * FROM t1'
104 --source include/wait_condition.inc
105
106 --echo
107 --echo # 10. Sleep for 10 seconds to connection on hold exceed wait timeout
108
109 --sleep 10
110
111 --echo
112 --echo # 11. Reap with timeout error on pending statement
113
114 --let $rpl_connection_name= server2
115 --source include/rpl_connection.inc
116
117 --error ER_GR_HOLD_WAIT_TIMEOUT
118 --reap
119
120 --let $rpl_server_number= 2
121 --source include/rpl_reconnect.inc
122
123 --echo
124 --echo # 12. UNLOCK tables to allow apply backlog
125
126 --let $rpl_connection_name= server_2
127 --source include/rpl_connection.inc
128
129 UNLOCK TABLES;
130
131 --echo
132 --echo # 13. Cleanup
133 --let $rpl_connection_name= server2
134 --source include/rpl_connection.inc
135
136 --let $group_replication_member_state= ONLINE
137 --source include/gr_wait_for_member_state.inc
138
139 --let $wait_condition= SELECT @@super_read_only = 0
140 --source include/wait_condition_or_abort.inc
141
142 DROP TABLE t1;
143
144 --source include/stop_group_replication.inc
145
146 --let $rpl_connection_name= server1
147 --source include/rpl_connection.inc
148
149 SET SESSION sql_log_bin= 0;
150 DROP TABLE t1;
151 SET SESSION sql_log_bin= 1;
152
153 --source include/group_replication_end.inc