Debian Codegraph @

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

raw
1 ################################################################################
2 # This test validates transactions monitor does not die when second election
3 # caused by view change happens while previous election is going on.
4 #
5 # Test:
6 # 0. The test requires three servers: M1, M2 and M3.
7 # 1. Start group in single primary mode.
8 # Server1 will be primary and server 2 and server3 secondary.
9 # 2. Create table on server1.
10 # 3. Start transaction on server1.
11 # 4. At server3 start primary change from server1 to server2.
12 # 5. Wait for the THD_transaction_monitor thread to start.
13 # 6. Kill and restart server3.
14 # 7. Wait for server3 to be expelled
15 # 8. Check the monitor thread exited.
16 # Wait for client disconnection on server1.
17 # Client will be disconnected post timeout.
18 # 9. Assert primary changed.
19 # Assert data is not present on M1 and M2.
20 # 10. Cleanup
21 #
22 ################################################################################
23
24
25 # This test does crashes servers, hence we skip it on asan and valgrind.
26 --source include/not_valgrind.inc
27 --source include/big_test.inc
28 --source include/have_group_replication_plugin.inc
29 --let $rpl_skip_group_replication_start= 1
30 --let $rpl_group_replication_single_primary_mode=1
31 --let $rpl_server_count= 3
32 --source include/group_replication.inc
33
34 --echo
35 --echo # 1. Start group in single primary mode.
36 --echo # Server1 will be primary and server 2 and server3 secondary.
37
38 --let $rpl_connection_name= server1
39 --source include/rpl_connection.inc
40 --source include/start_and_bootstrap_group_replication.inc
41
42 --let $rpl_connection_name= server2
43 --source include/rpl_connection.inc
44
45 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
46 --source include/start_group_replication.inc
47
48 --let $rpl_connection_name= server3
49 --source include/rpl_connection.inc
50
51 --source include/start_group_replication.inc
52
53 --echo
54 --echo # 2. Create table on server1.
55
56 --let $rpl_connection_name= server1
57 --source include/rpl_connection.inc
58
59 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
60 --source include/rpl_sync.inc
61
62 --echo
63 --echo # 3. Start transaction on server1.
64
65 --let $rpl_connection_name= server1
66 --source include/rpl_connection.inc
67
68 START TRANSACTION;
69 INSERT INTO t1 VALUES(1);
70
71 --echo
72 --echo # 4. At server3 start primary change from server1 to server2.
73
74 --let $rpl_connection_name= server3
75 --source include/rpl_connection.inc
76
77 --replace_result $server2_uuid MEMBER2_UUID
78 --send_eval SELECT group_replication_set_as_primary("$server2_uuid",30)
79
80 --echo
81 --echo # 5. Wait for the THD_transaction_monitor thread to start.
82
83 --let $rpl_connection_name= server1
84 --source include/rpl_connection.inc
85
86 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.threads WHERE NAME = "thread/group_rpl/THD_transaction_monitor"
87 --source include/wait_condition.inc
88
89 --echo
90 --echo # 6. Kill and restart server3.
91
92 --let $rpl_connection_name= server_3
93 --source include/rpl_connection.inc
94
95 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
96 --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
97
98 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS
99 --let $restart_parameters=restart:--group-replication-group-name=$group_replication_group_name --group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds
100
101 --source include/kill_and_restart_mysqld.inc
102
103 --echo
104 --echo # 7. Wait for server3 to be expelled
105
106 --let $rpl_connection_name= server2
107 --source include/rpl_connection.inc
108
109 --let $group_replication_number_of_members= 2
110 --source include/gr_wait_for_number_of_members.inc
111
112 --echo
113 --echo # 8. Check the monitor thread exited.
114 --echo # Wait for client disconnection on server1.
115 --echo # Client will be disconnected post timeout.
116
117 # NOTE: First client disconnects followed by transaction monitor thread exit.
118 # Timeout mentioned in UDF is 30 seconds.
119 # For slow machines wait for monitor thread has been inceased to 120.
120 # So transaction monitor exit is being checked first.
121 # If wait_until_disconnected can wait for 120 seconds, we can check that first.
122
123 --let $rpl_connection_name= server_1
124 --source include/rpl_connection.inc
125
126 --let $wait_timeout= 120
127 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.threads WHERE NAME LIKE "thread/group_rpl/THD_transaction_monitor%"
128 --source include/wait_condition.inc
129
130 --let $rpl_connection_name= server1
131 --source include/rpl_connection.inc
132
133 --source include/wait_until_disconnected.inc
134 --enable_reconnect
135 --source include/wait_until_connected_again.inc
136 --disable_reconnect
137
138 --echo
139 --echo # 9. Assert primary changed.
140 --echo # Assert data is not present on M1 and M2.
141
142 --let $rpl_connection_name= server1
143 --source include/rpl_connection.inc
144
145 --source include/gr_assert_secondary_member.inc
146
147 --let $rpl_connection_name= server2
148 --source include/rpl_connection.inc
149
150 --source include/gr_assert_primary_member.inc
151
152 --let $assert_text= 'There is no value 1 in table t1'
153 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 1, count, 1] = 0
154 --source include/assert.inc
155
156 --let $diff_tables= server1:test.t1, server2:test.t1
157 --source include/diff_tables.inc
158
159 --echo
160 --echo # 10. Cleanup
161
162 --let $rpl_connection_name= server2
163 --source include/rpl_connection.inc
164 DROP TABLE t1;
165
166 --let $rpl_connection_name= server3
167 --source include/rpl_connection.inc
168
169 --error CR_SERVER_LOST
170 --reap
171
172 --enable_reconnect
173 --source include/wait_until_connected_again.inc
174 --disable_reconnect
175
176 SET @@GLOBAL.read_only= 0;
177 SET @@SESSION.sql_log_bin= 0;
178 DROP TABLE t1;
179 SET @@SESSION.sql_log_bin= 1;
180
181 --source include/group_replication_end.inc