Debian Codegraph @

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

raw
1 ################################################################################
2 # This test verifies that if the number of members in a group is below
3 # than the value set for AUTO_INCREMENT_INCREMENT variable on every member,
4 # then there won't be any duplication of auto_increment value.
5 # And, there won't be any errors and rollback due to this.
6 #
7 # Test:
8 # 0. The test requires four servers: M1, M2, M3 and M4.
9 # 1. Start group replication on M1.
10 # 2. Executing the same transaction on all members (almost) in parallel, while
11 # starting and stopping GR on M2, M3 and M4. There should be no error.
12 # 3. Start group replication on all members and wait for sync.
13 # 4. Validate members state is equal.
14 # 5. Clean up.
15 ################################################################################
16 --source include/big_test.inc
17 --source include/not_windows.inc
18 --source include/have_group_replication_plugin.inc
19 --let $rpl_skip_group_replication_start= 1
20 --let $rpl_server_count= 4
21 --source include/group_replication.inc
22
23 --echo ############################################################
24 --echo # 1. Start group replication on member1
25 --echo ############################################################
26 --connection server1
27 --let $rpl_reconnect_server_number= 1
28 --source include/start_and_bootstrap_group_replication.inc
29 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
30
31
32 --echo ############################################################
33 --echo # 2. Executing the same transaction on all members (almost)
34 --echo # in parallel, while starting and stopping group
35 --echo # replication on members 2,3 and 4, there should be
36 --echo # no error
37 --echo ############################################################
38
39 --let $max_transactions= 60
40 --let $mid_transactions= 30
41
42 --let $transactions= 1
43 --let $rpl_num_server= 1
44 while ($transactions <= $max_transactions)
45 {
46 ## start or stop group_replication after every 10 transactions
47 --let $trans_mod_10= `SELECT $transactions % 10`
48 --let $i= 1
49
50 ## insert or start group_replication before it reaches mid
51 if ($transactions <= $mid_transactions)
52 {
53 while ($i <= $rpl_num_server)
54 {
55 --connection server$i
56 --send_eval INSERT INTO t1 VALUES(NULL)
57 --inc $i
58 }
59
60 if (!$trans_mod_10)
61 {
62 --inc $rpl_num_server
63 --connection server$rpl_num_server
64 --disable_query_log
65 --eval SET GLOBAL group_replication_group_name= "$group_replication_group_name"
66 --enable_query_log
67 --send START GROUP_REPLICATION
68 --let $group_replication_member_state= ONLINE
69 }
70 }
71
72 ## insert or stop group_replication after it reaches mid
73 --let $rpl_stop_num_server= 0
74 --let $rpl_stop_server_flag= 0
75 if ($transactions > $mid_transactions)
76 {
77 --let $rpl_stop_num_server= $rpl_num_server
78 if (!$trans_mod_10)
79 {
80 --connection server$rpl_num_server
81 --send STOP GROUP_REPLICATION
82 --let $group_replication_member_state= OFFLINE
83 --let $rpl_stop_server_flag = 1
84 --dec $rpl_stop_num_server
85 }
86
87 # insert on members where group_replication is running
88 while ($i <= $rpl_stop_num_server)
89 {
90 --connection server$i
91 --send_eval INSERT INTO t1 VALUES(NULL)
92 --inc $i
93 }
94 }
95
96 --let $i= 1
97 while ($i <= $rpl_num_server)
98 {
99 --connection server$i
100 # verify that there should not be any error
101 --error 0
102 --reap
103 --inc $i
104 }
105
106 if (!$trans_mod_10)
107 {
108 ## verify member state
109 --source include/gr_wait_for_member_state.inc
110
111 --let $i= 1
112 while ($i <= $rpl_num_server)
113 {
114 --disconnect server$i
115 --let $_group_server_port= \$SERVER_MYPORT_$i
116 --connect (server$i, 127.0.0.1,root,,test,$_group_server_port,)
117 --connection server$i
118
119 ## verify auto-inc variables
120 ## stop group_replication resets auto_increment_increment and
121 ## auto_increment_offset to its default value i.e. 1. So if
122 ## stop group_replication was executed verify auto_increment_increment
123 ## and auto_increment_offset is equal to 1, otherwise for start
124 ## group_replication auto_increment_increment should equal to 7
125 ## and auto_increment_offset should be equal to server_id.
126 --let $is_rpl_stop_server= `SELECT $rpl_stop_server_flag && ($rpl_stop_num_server + 1 = $i)`
127 if ($is_rpl_stop_server)
128 {
129 --let $assert_text= The value of auto_increment_increment for server$i should be 1
130 --let $assert_cond= [SELECT @@GLOBAL.auto_increment_increment] = 1
131 --source include/assert.inc
132
133 --let $assert_text= The value of auto_increment_offset for server$i should be 1
134 --let $assert_cond= [SELECT @@GLOBAL.auto_increment_offset] = 1
135 --source include/assert.inc
136
137 --source include/assert_and_disable_read_only.inc
138 }
139
140 if (!$is_rpl_stop_server)
141 {
142 --let $assert_text= The value of auto_increment_increment for server$i should be 7
143 --let $assert_cond= [SELECT @@GLOBAL.auto_increment_increment] = 7
144 --source include/assert.inc
145
146 --let $assert_text= The value of auto_increment_offset for server$i should be $i
147 --let $assert_cond= [SELECT @@GLOBAL.auto_increment_offset] = $i
148 --source include/assert.inc
149
150 }
151 --inc $i
152 }
153 }
154
155 if ($rpl_stop_server_flag == 1)
156 {
157 --dec $rpl_num_server
158 --let $rpl_stop_server_flag= 0
159 --connection server$rpl_num_server
160 }
161
162 --inc $transactions
163 }
164
165 --echo ############################################################
166 --echo # 3. Start group replication on all members and wait for sync
167 --echo ############################################################
168 --let $i= 2
169 while ($i <= $rpl_server_count)
170 {
171 --connection server$i
172 --source include/start_group_replication.inc
173 --inc $i
174 }
175
176 # sync all members
177 --source include/rpl_sync.inc
178
179 --echo ############################################################
180 --echo # 4. Validate members state is equal.
181 --echo ############################################################
182 --let $diff_tables= server1:t1, server2:t1, server3:t1, server4:t1
183 --source include/diff_tables.inc
184
185 --echo ############################################################
186 --echo # 5. Clean up and reset auto_inc variables value
187 --echo ############################################################
188 DROP TABLE t1;
189 --source include/group_replication_end.inc