Debian Codegraph @

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

raw
1 ###############################################################################
2 #
3 # Any member exit or failure under a majority shall not affect
4 # the process of changing to multi master mode.
5 #
6 # Test:
7 # 0. This test require 3 servers
8 # 1. Server1 start, bootstrap the group and create table test.t1
9 # 2. Start server2 and server3
10 # 3. Begin a transaction on server1
11 # 4. Execute action to switch to multi primary
12 # 5. Assert that action is waiting for a member
13 # 6. Restart a member, won't impact the success of action
14 # 7. COMMIT pending transaction to action switch to multi primary be
15 # executed
16 # 8. Confirm that exists two members as primary in the group
17 # 9. Cleanup
18 #
19 ###############################################################################
20
21 --source include/have_group_replication_plugin.inc
22 --source include/not_valgrind.inc
23 --let $rpl_server_count= 3
24 --let $rpl_skip_group_replication_start= 1
25 --let $rpl_group_replication_single_primary_mode=1
26 --source include/group_replication.inc
27
28 --echo
29 --echo # 1. Server1 start, bootstrap the group and create table test.t1
30
31 --source include/start_and_bootstrap_group_replication.inc
32
33 CREATE TABLE test.t1 (a INT PRIMARY KEY);
34
35 --echo
36 --echo # 2. Start server2 and server3
37
38 --let $rpl_connection_name= server2
39 --source include/rpl_connection.inc
40
41 --source include/start_group_replication.inc
42
43 --let $rpl_connection_name= server3
44 --source include/rpl_connection.inc
45
46 --source include/start_group_replication.inc
47
48 --echo
49 --echo # 3. Begin a transaction on server1
50
51 --let $rpl_connection_name= server1
52 --source include/rpl_connection.inc
53
54 BEGIN;
55 INSERT INTO t1 VALUES(1);
56
57 --echo
58 --echo # 4. Execute action to switch to multi primary
59
60 --let $rpl_connection_name= server_1_1
61 --source include/rpl_connection.inc
62
63 --send SELECT group_replication_switch_to_multi_primary_mode()
64
65 --echo
66 --echo # 5. Assert that action is waiting for a member
67
68 --let $rpl_connection_name= server2
69 --source include/rpl_connection.inc
70
71 --let $wait_condition=SELECT COUNT(*)=1 FROM performance_schema.events_stages_current WHERE event_name LIKE "%waiting on another member step%"
72 --source include/wait_condition.inc
73
74 --let $stage_name= `SELECT event_name FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl%" AND event_name NOT LIKE "%stage/group_rpl/Group Replication%";`
75 --let $assert_text= stage/group_rpl/Multi-primary Switch: waiting on another member step completion
76 --let $assert_cond= "$stage_name" = "stage/group_rpl/Multi-primary Switch: waiting on another member step completion"
77 --source include/assert.inc
78
79 --echo
80 --echo # 6. Restart a member, won't impact the success of action
81
82 --let $rpl_connection_name= server3
83 --source include/rpl_connection.inc
84
85 --let $group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
86 --let $group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
87 --let $restart_parameters=restart:--group_replication_local_address=$group_replication_local_address --group_replication_group_seeds=$group_replication_group_seeds --group_replication_group_name=$group_replication_group_name
88 --replace_result $group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
89 --source include/kill_and_restart_mysqld.inc
90
91 --let $rpl_server_number= 3
92 --source include/rpl_reconnect.inc
93
94 --echo
95 --echo # 7. COMMIT pending transaction to action switch to multi primary be
96 --echo # executed
97
98 --let $rpl_connection_name= server1
99 --source include/rpl_connection.inc
100
101 COMMIT;
102
103 --let $rpl_connection_name= server_1_1
104 --source include/rpl_connection.inc
105
106 --reap
107
108 --echo
109 --echo # 8. Confirm that exists two members as primary in the group
110
111 --source include/gr_assert_multi_primary_mode.inc
112
113 --let $rpl_connection_name= server_2
114 --source include/rpl_connection.inc
115
116 --source include/gr_assert_multi_primary_mode.inc
117
118 --echo
119 --echo # 9. Cleanup
120
121 DROP TABLE t1;
122
123 --let $rpl_connection_name= server_3
124 --source include/rpl_connection.inc
125 DROP TABLE t1;
126
127 --let $rpl_connection_name= server_2
128 --source include/rpl_connection.inc
129
130 --let $rpl_group_replication_reset_persistent_vars=1
131 --source include/group_replication_end.inc