Debian Codegraph @

mysql-test/suite/group_replication/r/gr_auto_increment_start_stop_parallel.result

raw
1 include/group_replication.inc [rpl_server_count=4]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 ############################################################
7 # 1. Start group replication on member1
8 ############################################################
9 include/start_and_bootstrap_group_replication.inc
10 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB;
11 ############################################################
12 # 2. Executing the same transaction on all members (almost)
13 # in parallel, while starting and stopping group
14 # replication on members 2,3 and 4, there should be
15 # no error
16 ############################################################
17 INSERT INTO t1 VALUES(NULL);
18 INSERT INTO t1 VALUES(NULL);
19 INSERT INTO t1 VALUES(NULL);
20 INSERT INTO t1 VALUES(NULL);
21 INSERT INTO t1 VALUES(NULL);
22 INSERT INTO t1 VALUES(NULL);
23 INSERT INTO t1 VALUES(NULL);
24 INSERT INTO t1 VALUES(NULL);
25 INSERT INTO t1 VALUES(NULL);
26 INSERT INTO t1 VALUES(NULL);
27 START GROUP_REPLICATION;
28 include/gr_wait_for_member_state.inc
29 include/assert.inc [The value of auto_increment_increment for server1 should be 7]
30 include/assert.inc [The value of auto_increment_offset for server1 should be 1]
31 include/assert.inc [The value of auto_increment_increment for server2 should be 7]
32 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
33 INSERT INTO t1 VALUES(NULL);
34 INSERT INTO t1 VALUES(NULL);
35 INSERT INTO t1 VALUES(NULL);
36 INSERT INTO t1 VALUES(NULL);
37 INSERT INTO t1 VALUES(NULL);
38 INSERT INTO t1 VALUES(NULL);
39 INSERT INTO t1 VALUES(NULL);
40 INSERT INTO t1 VALUES(NULL);
41 INSERT INTO t1 VALUES(NULL);
42 INSERT INTO t1 VALUES(NULL);
43 INSERT INTO t1 VALUES(NULL);
44 INSERT INTO t1 VALUES(NULL);
45 INSERT INTO t1 VALUES(NULL);
46 INSERT INTO t1 VALUES(NULL);
47 INSERT INTO t1 VALUES(NULL);
48 INSERT INTO t1 VALUES(NULL);
49 INSERT INTO t1 VALUES(NULL);
50 INSERT INTO t1 VALUES(NULL);
51 INSERT INTO t1 VALUES(NULL);
52 INSERT INTO t1 VALUES(NULL);
53 START GROUP_REPLICATION;
54 include/gr_wait_for_member_state.inc
55 include/assert.inc [The value of auto_increment_increment for server1 should be 7]
56 include/assert.inc [The value of auto_increment_offset for server1 should be 1]
57 include/assert.inc [The value of auto_increment_increment for server2 should be 7]
58 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
59 include/assert.inc [The value of auto_increment_increment for server3 should be 7]
60 include/assert.inc [The value of auto_increment_offset for server3 should be 3]
61 INSERT INTO t1 VALUES(NULL);
62 INSERT INTO t1 VALUES(NULL);
63 INSERT INTO t1 VALUES(NULL);
64 INSERT INTO t1 VALUES(NULL);
65 INSERT INTO t1 VALUES(NULL);
66 INSERT INTO t1 VALUES(NULL);
67 INSERT INTO t1 VALUES(NULL);
68 INSERT INTO t1 VALUES(NULL);
69 INSERT INTO t1 VALUES(NULL);
70 INSERT INTO t1 VALUES(NULL);
71 INSERT INTO t1 VALUES(NULL);
72 INSERT INTO t1 VALUES(NULL);
73 INSERT INTO t1 VALUES(NULL);
74 INSERT INTO t1 VALUES(NULL);
75 INSERT INTO t1 VALUES(NULL);
76 INSERT INTO t1 VALUES(NULL);
77 INSERT INTO t1 VALUES(NULL);
78 INSERT INTO t1 VALUES(NULL);
79 INSERT INTO t1 VALUES(NULL);
80 INSERT INTO t1 VALUES(NULL);
81 INSERT INTO t1 VALUES(NULL);
82 INSERT INTO t1 VALUES(NULL);
83 INSERT INTO t1 VALUES(NULL);
84 INSERT INTO t1 VALUES(NULL);
85 INSERT INTO t1 VALUES(NULL);
86 INSERT INTO t1 VALUES(NULL);
87 INSERT INTO t1 VALUES(NULL);
88 INSERT INTO t1 VALUES(NULL);
89 INSERT INTO t1 VALUES(NULL);
90 INSERT INTO t1 VALUES(NULL);
91 START GROUP_REPLICATION;
92 include/gr_wait_for_member_state.inc
93 include/assert.inc [The value of auto_increment_increment for server1 should be 7]
94 include/assert.inc [The value of auto_increment_offset for server1 should be 1]
95 include/assert.inc [The value of auto_increment_increment for server2 should be 7]
96 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
97 include/assert.inc [The value of auto_increment_increment for server3 should be 7]
98 include/assert.inc [The value of auto_increment_offset for server3 should be 3]
99 include/assert.inc [The value of auto_increment_increment for server4 should be 7]
100 include/assert.inc [The value of auto_increment_offset for server4 should be 4]
101 INSERT INTO t1 VALUES(NULL);
102 INSERT INTO t1 VALUES(NULL);
103 INSERT INTO t1 VALUES(NULL);
104 INSERT INTO t1 VALUES(NULL);
105 INSERT INTO t1 VALUES(NULL);
106 INSERT INTO t1 VALUES(NULL);
107 INSERT INTO t1 VALUES(NULL);
108 INSERT INTO t1 VALUES(NULL);
109 INSERT INTO t1 VALUES(NULL);
110 INSERT INTO t1 VALUES(NULL);
111 INSERT INTO t1 VALUES(NULL);
112 INSERT INTO t1 VALUES(NULL);
113 INSERT INTO t1 VALUES(NULL);
114 INSERT INTO t1 VALUES(NULL);
115 INSERT INTO t1 VALUES(NULL);
116 INSERT INTO t1 VALUES(NULL);
117 INSERT INTO t1 VALUES(NULL);
118 INSERT INTO t1 VALUES(NULL);
119 INSERT INTO t1 VALUES(NULL);
120 INSERT INTO t1 VALUES(NULL);
121 INSERT INTO t1 VALUES(NULL);
122 INSERT INTO t1 VALUES(NULL);
123 INSERT INTO t1 VALUES(NULL);
124 INSERT INTO t1 VALUES(NULL);
125 INSERT INTO t1 VALUES(NULL);
126 INSERT INTO t1 VALUES(NULL);
127 INSERT INTO t1 VALUES(NULL);
128 INSERT INTO t1 VALUES(NULL);
129 INSERT INTO t1 VALUES(NULL);
130 INSERT INTO t1 VALUES(NULL);
131 INSERT INTO t1 VALUES(NULL);
132 INSERT INTO t1 VALUES(NULL);
133 INSERT INTO t1 VALUES(NULL);
134 INSERT INTO t1 VALUES(NULL);
135 INSERT INTO t1 VALUES(NULL);
136 INSERT INTO t1 VALUES(NULL);
137 STOP GROUP_REPLICATION;
138 INSERT INTO t1 VALUES(NULL);
139 INSERT INTO t1 VALUES(NULL);
140 INSERT INTO t1 VALUES(NULL);
141 include/gr_wait_for_member_state.inc
142 include/assert.inc [The value of auto_increment_increment for server1 should be 7]
143 include/assert.inc [The value of auto_increment_offset for server1 should be 1]
144 include/assert.inc [The value of auto_increment_increment for server2 should be 7]
145 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
146 include/assert.inc [The value of auto_increment_increment for server3 should be 7]
147 include/assert.inc [The value of auto_increment_offset for server3 should be 3]
148 include/assert.inc [The value of auto_increment_increment for server4 should be 1]
149 include/assert.inc [The value of auto_increment_offset for server4 should be 1]
150 include/assert_and_disable_read_only.inc
151 INSERT INTO t1 VALUES(NULL);
152 INSERT INTO t1 VALUES(NULL);
153 INSERT INTO t1 VALUES(NULL);
154 INSERT INTO t1 VALUES(NULL);
155 INSERT INTO t1 VALUES(NULL);
156 INSERT INTO t1 VALUES(NULL);
157 INSERT INTO t1 VALUES(NULL);
158 INSERT INTO t1 VALUES(NULL);
159 INSERT INTO t1 VALUES(NULL);
160 INSERT INTO t1 VALUES(NULL);
161 INSERT INTO t1 VALUES(NULL);
162 INSERT INTO t1 VALUES(NULL);
163 INSERT INTO t1 VALUES(NULL);
164 INSERT INTO t1 VALUES(NULL);
165 INSERT INTO t1 VALUES(NULL);
166 INSERT INTO t1 VALUES(NULL);
167 INSERT INTO t1 VALUES(NULL);
168 INSERT INTO t1 VALUES(NULL);
169 INSERT INTO t1 VALUES(NULL);
170 INSERT INTO t1 VALUES(NULL);
171 INSERT INTO t1 VALUES(NULL);
172 INSERT INTO t1 VALUES(NULL);
173 INSERT INTO t1 VALUES(NULL);
174 INSERT INTO t1 VALUES(NULL);
175 INSERT INTO t1 VALUES(NULL);
176 INSERT INTO t1 VALUES(NULL);
177 INSERT INTO t1 VALUES(NULL);
178 STOP GROUP_REPLICATION;
179 INSERT INTO t1 VALUES(NULL);
180 INSERT INTO t1 VALUES(NULL);
181 include/gr_wait_for_member_state.inc
182 include/assert.inc [The value of auto_increment_increment for server1 should be 7]
183 include/assert.inc [The value of auto_increment_offset for server1 should be 1]
184 include/assert.inc [The value of auto_increment_increment for server2 should be 7]
185 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
186 include/assert.inc [The value of auto_increment_increment for server3 should be 1]
187 include/assert.inc [The value of auto_increment_offset for server3 should be 1]
188 include/assert_and_disable_read_only.inc
189 INSERT INTO t1 VALUES(NULL);
190 INSERT INTO t1 VALUES(NULL);
191 INSERT INTO t1 VALUES(NULL);
192 INSERT INTO t1 VALUES(NULL);
193 INSERT INTO t1 VALUES(NULL);
194 INSERT INTO t1 VALUES(NULL);
195 INSERT INTO t1 VALUES(NULL);
196 INSERT INTO t1 VALUES(NULL);
197 INSERT INTO t1 VALUES(NULL);
198 INSERT INTO t1 VALUES(NULL);
199 INSERT INTO t1 VALUES(NULL);
200 INSERT INTO t1 VALUES(NULL);
201 INSERT INTO t1 VALUES(NULL);
202 INSERT INTO t1 VALUES(NULL);
203 INSERT INTO t1 VALUES(NULL);
204 INSERT INTO t1 VALUES(NULL);
205 INSERT INTO t1 VALUES(NULL);
206 INSERT INTO t1 VALUES(NULL);
207 STOP GROUP_REPLICATION;
208 INSERT INTO t1 VALUES(NULL);
209 include/gr_wait_for_member_state.inc
210 include/assert.inc [The value of auto_increment_increment for server1 should be 7]
211 include/assert.inc [The value of auto_increment_offset for server1 should be 1]
212 include/assert.inc [The value of auto_increment_increment for server2 should be 1]
213 include/assert.inc [The value of auto_increment_offset for server2 should be 1]
214 include/assert_and_disable_read_only.inc
215 ############################################################
216 # 3. Start group replication on all members and wait for sync
217 ############################################################
218 include/start_group_replication.inc
219 include/start_group_replication.inc
220 include/start_group_replication.inc
221 include/rpl_sync.inc
222 ############################################################
223 # 4. Validate members state is equal.
224 ############################################################
225 include/diff_tables.inc [server1:t1, server2:t1, server3:t1, server4:t1]
226 ############################################################
227 # 5. Clean up and reset auto_inc variables value
228 ############################################################
229 DROP TABLE t1;
230 include/group_replication_end.inc