Debian Codegraph @

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

raw
1 ################################################################################
2 # This test validates UDF group_replication_set_as_primary does not drop
3 # connection of single-statement read-only explicit transactions.
4 # The client connections running write transactions are gracefully killed.
5 #
6 # Test:
7 # 0. The test requires two servers: M1 and M2.
8 # 1. Start group in single primary mode.
9 # Server1 will be primary and server2 secondary.
10 # 2. Start a read-only transaction on server1.
11 # It should succeed with primary change initiated from server2(secondary).
12 # 3. Assert primary changed.
13 # 4. Start a read-only transaction on server2.
14 # It should succeed with primary change initiated from server2(primary).
15 # 5. Assert primary changed.
16 # 6. Start a write transaction on server1.
17 # Client connection will be dropped.
18 # Primary change initiated from server2(secondary).
19 # 7. Assert primary changed.
20 # 8. Start a write transaction on server2.
21 # Client connection will be dropped.
22 # Primary change initiated from server2(primary).
23 # 9. Assert primary changed.
24 # 10. Cleanup.
25 ################################################################################
26 --source include/have_debug_sync.inc
27 --source include/have_group_replication_plugin.inc
28 --let $rpl_skip_group_replication_start= 1
29 --let $rpl_group_replication_single_primary_mode=1
30 --source include/group_replication.inc
31
32 --echo
33 --echo # 1. Start group in single primary mode.
34 --echo # Server1 will be primary and server2 secondary.
35
36 --let $rpl_connection_name= server1
37 --source include/rpl_connection.inc
38
39 CREATE TABLE test.t1(c1 int primary key);
40 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
41 --source include/start_and_bootstrap_group_replication.inc
42
43 --let $rpl_connection_name= server2
44 --source include/rpl_connection.inc
45
46 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
47 --source include/start_group_replication.inc
48
49 --echo
50 --echo # 2. Start a read-only transaction on server1.
51 --echo # It should succeed with primary change initiated from server2(secondary).
52
53 --let $conn_of_new_primary= server2
54 --let $command_to_execute= SELECT * FROM test.t1;
55 --let $conn_for_command= server1
56 --let $conn_for_debug_sync= server_1
57 --let $conn_for_primary= server2
58 --let $connection_is_killed=
59 --source ../include/gr_parallel_command_primary_change.inc
60
61 --echo
62 --echo # 3. Assert primary changed.
63
64 --let $rpl_connection_name= server2
65 --source include/rpl_connection.inc
66
67 --source include/gr_assert_primary_member.inc
68
69 --let $rpl_connection_name= server1
70 --source include/rpl_connection.inc
71
72 --source include/gr_assert_secondary_member.inc
73
74 --echo
75 --echo # 4. Start a read-only transaction on server2.
76 --echo # It should succeed with primary change initiated from server2(primary).
77
78 --let $conn_of_new_primary= server1
79 --let $command_to_execute= SELECT * FROM test.t1;
80 --let $conn_for_command= server2
81 --let $conn_for_debug_sync= server_2
82 --let $conn_for_primary= server_2_1
83 --let $connection_is_killed=
84 --source ../include/gr_parallel_command_primary_change.inc
85
86 --echo
87 --echo # 5. Assert primary changed.
88
89 --let $rpl_connection_name= server1
90 --source include/rpl_connection.inc
91
92 --source include/gr_assert_primary_member.inc
93
94 --let $rpl_connection_name= server2
95 --source include/rpl_connection.inc
96
97 --source include/gr_assert_secondary_member.inc
98
99 --echo
100 --echo # 6. Start a write transaction on server1.
101 --echo # Client connection will be dropped.
102 --echo # Primary change initiated from server2(secondary).
103
104 --let $conn_of_new_primary= server2
105 --let $command_to_execute= INSERT INTO test.t1 values (1);
106 --let $conn_for_command= server1
107 --let $conn_for_debug_sync= server_1
108 --let $conn_for_primary= server2
109 --let $connection_is_killed=1
110 --source ../include/gr_parallel_command_primary_change.inc
111
112 --echo
113 --echo # 7. Assert primary changed.
114
115 --let $rpl_connection_name= server2
116 --source include/rpl_connection.inc
117
118 --source include/gr_assert_primary_member.inc
119
120 --let $rpl_connection_name= server1
121 --source include/rpl_connection.inc
122
123 --source include/gr_assert_secondary_member.inc
124
125 --let $assert_text= 'There is no value 1 in table t1'
126 --let $assert_cond= [SELECT COUNT(*) AS count FROM test.t1 WHERE t1.c1 = 1, count, 1] = 0
127 --source include/assert.inc
128
129 --let $diff_tables= server1:test.t1, server2:test.t1
130 --source include/diff_tables.inc
131
132 --echo
133 --echo # 8. Start a write transaction on server2.
134 --echo # Client connection will be dropped.
135 --echo # Primary change initiated from server2(primary).
136
137 --let $conn_of_new_primary= server1
138 --let $command_to_execute= INSERT INTO test.t1 values (2);
139 --let $conn_for_command= server2
140 --let $conn_for_debug_sync= server_2
141 --let $conn_for_primary= server_2_1
142 --let $connection_is_killed=1
143 --source ../include/gr_parallel_command_primary_change.inc
144
145 --echo
146 --echo # 9. Assert primary changed.
147
148 --let $rpl_connection_name= server1
149 --source include/rpl_connection.inc
150
151 --source include/gr_assert_primary_member.inc
152
153 --let $rpl_connection_name= server2
154 --source include/rpl_connection.inc
155
156 --source include/gr_assert_secondary_member.inc
157
158 --let $assert_text= 'There is no value 2 in table t1'
159 --let $assert_cond= [SELECT COUNT(*) AS count FROM test.t1 WHERE t1.c1 = 2, count, 1] = 0
160 --source include/assert.inc
161
162 --let $diff_tables= server1:test.t1, server2:test.t1
163 --source include/diff_tables.inc
164
165 --echo
166 --echo # 10. Cleanup.
167
168 --let $rpl_connection_name= server1
169 --source include/rpl_connection.inc
170
171 DROP TABLE test.t1;
172
173 --source include/group_replication_end.inc