Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # If the action thread is killed but the configuration process
4 # still has major tasks to complete the member shall finish UDF.
5 #
6 # Test:
7 # 0. Group start in Single Primary mode with 3 servers
8 # 1. Begin a transaction on server 1 but do not commit it
9 # 2. Do a change to multi primary mode
10 # Get the connection ID
11 # See that it is stuck waiting for current transactions
12 # 3. Kill the query
13 # 4. Commit transaction and member will finish the UDF
14 # 5. Unlock the table, check the action completed in the other members
15 # 6. Cleanup
16 #
17 ###############################################################################
18
19 --source include/big_test.inc
20 --source include/have_group_replication_plugin.inc
21 --let $rpl_server_count= 3
22 --let $rpl_skip_group_replication_start= 1
23 --let $rpl_group_replication_single_primary_mode=1
24 --source include/group_replication.inc
25
26 --echo
27 --echo # 0. Group start in Single Primary mode with 3 servers
28
29 set session sql_log_bin=0;
30 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
31 call mtr.add_suppression("A configuration change was killed in this member. The member will now leave the group as its configuration may have diverged.");
32 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
33 call mtr.add_suppression("The function 'group_replication_switch_to_multi_primary_mode' failed. This operation was locally killed and for that reason terminated.*");
34 set session sql_log_bin=1;
35
36 --source include/start_and_bootstrap_group_replication.inc
37
38 --let $rpl_connection_name= server2
39 --source include/rpl_connection.inc
40
41 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
42
43 --source include/start_group_replication.inc
44
45 --let $rpl_connection_name= server3
46 --source include/rpl_connection.inc
47
48 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
49
50 --source include/start_group_replication.inc
51
52 --echo
53 --echo # 1. Begin a transaction on server 1 but do not commit it
54
55 --let $rpl_connection_name= server_1_1
56 --source include/rpl_connection.inc
57
58 CREATE TABLE test.t1 (a INT PRIMARY KEY);
59 --source include/rpl_sync.inc
60
61 BEGIN;
62 INSERT INTO t1 VALUES (1);
63
64 --echo
65 --echo # 2. Do a change to multi primary mode
66 --echo # Get the connection ID
67 --echo # See that it is stuck waiting for current transactions
68
69 --let $rpl_connection_name= server1
70 --source include/rpl_connection.inc
71
72 --let $conn_id=`SELECT CONNECTION_ID()`
73
74 --replace_result $server2_uuid MEMBER2_UUID
75 --send SELECT group_replication_switch_to_multi_primary_mode()
76
77 --let $rpl_connection_name= server_1
78 --source include/rpl_connection.inc
79
80 --let $wait_condition=SELECT COUNT(*)=1 FROM performance_schema.events_stages_current WHERE event_name LIKE "%Multi-primary Switch: waiting for pending transactions to finish%"
81 --source include/wait_condition.inc
82
83 --let $rpl_connection_name= server3
84 --source include/rpl_connection.inc
85
86 --let $wait_condition=SELECT COUNT(*)=1 FROM performance_schema.events_stages_current WHERE event_name LIKE "%Multi-primary Switch: waiting on another member step completion%"
87 --source include/wait_condition.inc
88
89 --echo
90 --echo # 3. Kill the query
91
92 --let $rpl_connection_name= server_1
93 --source include/rpl_connection.inc
94
95 --replace_result $conn_id CONNECTION_ID
96 --eval KILL QUERY $conn_id
97
98 --echo
99 --echo # 4. Commit transaction and member will finish the UDF
100
101 --let $rpl_connection_name= server_1_1
102 --source include/rpl_connection.inc
103
104 COMMIT;
105 --source include/rpl_sync.inc
106
107 --let $rpl_connection_name= server1
108 --source include/rpl_connection.inc
109
110 --reap
111
112 --echo
113 --echo # 5. Unlock the table, check the action completed in the other members
114
115 --let $rpl_connection_name= server_2
116 --source include/rpl_connection.inc
117
118 --let $wait_condition=SELECT COUNT(*)=0 FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl%" AND event_name NOT LIKE "%stage/group_rpl/Group Replication%"
119 --source include/wait_condition.inc
120
121 --source include/gr_assert_multi_primary_mode.inc
122
123 --let $rpl_connection_name= server3
124 --source include/rpl_connection.inc
125
126 --let $wait_condition=SELECT COUNT(*)=0 FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl%" AND event_name NOT LIKE "%stage/group_rpl/Group Replication%"
127 --source include/wait_condition.inc
128
129 --source include/gr_assert_multi_primary_mode.inc
130
131 --let $rpl_connection_name= server1
132 --source include/rpl_connection.inc
133
134 --let $wait_condition=SELECT COUNT(*)=0 FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl%" AND event_name NOT LIKE "%stage/group_rpl/Group Replication%"
135 --source include/wait_condition.inc
136
137 --source include/gr_assert_multi_primary_mode.inc
138
139 --echo
140 --echo # 6. Cleanup
141
142 --let $rpl_connection_name= server2
143 --source include/rpl_connection.inc
144
145 DROP TABLE t1;
146
147 --let $rpl_group_replication_single_primary_mode=0
148 --let $rpl_group_replication_reset_persistent_vars=1
149 --source include/group_replication_end.inc