Debian Codegraph @

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

raw
1 ################################################################################
2 # This test validates committing transactions are not rolled back by a UDF
3 # group_replication_set_as_primary even when timeout
4 # `running_transactions_timeout` expires.
5 #
6 # Test:
7 # 0. This test needs 2 server.
8 # 1. Setup group of 2 servers, M1(primary) and M2(secondary).
9 # 2. Execute a transaction on server1 and block it in committing state.
10 # 3. Execute change primary on server2 and block the operation.
11 # 4. Unblock transaction running on sever1 and reap result.
12 # Unblock change primary operation and reap result.
13 # 5. Assert primary and secondary status are correct.
14 # Assert data is present on both members.
15 # 6. Execute a transaction on server2 and block it in committing state.
16 # 7. Execute change primary on server2 and block the operation.
17 # 8. Unblock transaction running on sever2 and reap result.
18 # Unblock change primary operation and reap result.
19 # 9. Assert primary and secondary status are correct.
20 # Assert data is present on both members.
21 # 10. Cleanup.
22 ################################################################################
23
24 --source include/have_debug_sync.inc
25 --source include/have_group_replication_plugin.inc
26 --let $rpl_skip_group_replication_start= 1
27 --let $rpl_group_replication_single_primary_mode=1
28 --source include/group_replication.inc
29
30 --echo
31 --echo # 1. Setup group of 2 servers, M1(primary) and M2(secondary).
32
33 --let $rpl_connection_name= server1
34 --source include/rpl_connection.inc
35
36 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
37
38 CREATE TABLE t1(c1 int primary key);
39
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
47 --source include/start_group_replication.inc
48
49 --echo
50 --echo # 2. Execute a transaction on server1 and block it in committing state.
51
52 --let $rpl_connection_name= server1
53 --source include/rpl_connection.inc
54
55 SET @@GLOBAL.DEBUG= '+d,group_replication_before_commit_hook_wait';
56 --send INSERT INTO t1 values(1)
57
58 --let $rpl_connection_name= server_1
59 --source include/rpl_connection.inc
60
61 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_before_commit_hook_wait_reached";
62
63 --echo
64 --echo # 3. Execute change primary on server2 and block the operation.
65
66 --let $rpl_connection_name= server2
67 --source include/rpl_connection.inc
68
69 SET @@GLOBAL.DEBUG= '+d,group_replication_block_primary_action_validation';
70
71 --replace_result $server2_uuid SERVER2_UUID
72 --send_eval SELECT group_replication_set_as_primary("$server2_uuid", 0);
73
74 --let $rpl_connection_name= server_1
75 --source include/rpl_connection.inc
76
77 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.threads WHERE NAME = "thread/group_rpl/THD_transaction_monitor" AND PROCESSLIST_INFO = "Group replication transaction monitor: Stopped client connections"
78 --source include/wait_condition.inc
79
80 --echo
81 --echo # 4. Unblock transaction running on sever1 and reap result.
82 --echo # Unblock change primary operation and reap result.
83
84 --let $rpl_connection_name= server_1
85 --source include/rpl_connection.inc
86
87 SET DEBUG_SYNC= "now SIGNAL continue_commit";
88 SET @@GLOBAL.DEBUG= '-d,group_replication_before_commit_hook_wait';
89
90 --let $rpl_connection_name= server1
91 --source include/rpl_connection.inc
92 --reap
93
94 --let $rpl_connection_name= server_2
95 --source include/rpl_connection.inc
96 SET DEBUG_SYNC= "now SIGNAL signal.primary_action_continue";
97
98 --let $rpl_connection_name= server2
99 --source include/rpl_connection.inc
100 --replace_result $server2_uuid SERVER2_UUID
101 --reap
102
103 --echo
104 --echo # 5. Assert primary and secondary status are correct.
105 --echo # Assert data is present on both members.
106
107 --let $rpl_connection_name= server2
108 --source include/rpl_connection.inc
109
110 --source include/gr_assert_primary_member.inc
111
112 --let $rpl_connection_name= server1
113 --source include/rpl_connection.inc
114
115 --source include/gr_assert_secondary_member.inc
116
117 --let $assert_text= 'There is a value 1 in table t1'
118 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 1, count, 1] = 1
119 --source include/assert.inc
120
121 --let $diff_tables= server1:test.t1, server2:test.t1
122 --source include/diff_tables.inc
123
124 --echo
125 --echo # 6. Execute a transaction on server2 and block it in committing state.
126
127 --let $rpl_connection_name= server2
128 --source include/rpl_connection.inc
129
130 SET @@GLOBAL.DEBUG= '+d,group_replication_before_commit_hook_wait';
131 --send INSERT INTO t1 values(2)
132
133 --let $rpl_connection_name= server_2
134 --source include/rpl_connection.inc
135
136 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_before_commit_hook_wait_reached";
137
138 --echo
139 --echo # 7. Execute change primary on server2 and block the operation.
140
141 --let $rpl_connection_name= server_2
142 --source include/rpl_connection.inc
143 --replace_result $server1_uuid SERVER1_UUID
144 --send_eval SELECT group_replication_set_as_primary("$server1_uuid", 0);
145
146 --let $rpl_connection_name= server_2_1
147 --source include/rpl_connection.inc
148
149 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.threads WHERE NAME = "thread/group_rpl/THD_transaction_monitor" AND PROCESSLIST_INFO = "Group replication transaction monitor: Stopped client connections"
150 --source include/wait_condition.inc
151
152 --echo
153 --echo # 8. Unblock transaction running on sever2 and reap result.
154 --echo # Unblock change primary operation and reap result.
155
156 --let $rpl_connection_name= server_2_1
157 --source include/rpl_connection.inc
158
159 SET DEBUG_SYNC= "now SIGNAL continue_commit";
160 SET @@GLOBAL.DEBUG= '-d,group_replication_before_commit_hook_wait';
161
162 --let $rpl_connection_name= server2
163 --source include/rpl_connection.inc
164 --reap
165
166 SET DEBUG_SYNC= "now SIGNAL signal.primary_action_continue";
167
168 --let $rpl_connection_name= server_2
169 --source include/rpl_connection.inc
170 --replace_result $server1_uuid SERVER1_UUID
171 --reap
172
173 --echo
174 --echo # 9. Assert primary and secondary status are correct.
175 --echo # Assert data is present on both members.
176
177 --let $rpl_connection_name= server1
178 --source include/rpl_connection.inc
179
180 --source include/gr_assert_primary_member.inc
181
182 --let $rpl_connection_name= server2
183 --source include/rpl_connection.inc
184
185 --source include/gr_assert_secondary_member.inc
186
187 --let $assert_text= 'There is a value 2 in table t1'
188 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 2, count, 1] = 1
189 --source include/assert.inc
190
191 --let $diff_tables= server1:test.t1, server2:test.t1
192 --source include/diff_tables.inc
193
194 --echo
195 --echo # 10. Cleanup.
196
197 --let $rpl_connection_name= server1
198 --source include/rpl_connection.inc
199
200 DROP TABLE t1;
201 --source include/rpl_sync.inc
202
203 --let $rpl_connection_name= server2
204 --source include/rpl_connection.inc
205
206 SET DEBUG_SYNC= 'RESET';
207 SET @@GLOBAL.DEBUG= '-d,group_replication_block_primary_action_validation';
208
209 --source include/group_replication_end.inc