Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_conflict_epoch_extended_exceptions_table.result

raw
1 include/master-slave.inc
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 master]
6 Setup circular replication
7 RESET MASTER;
8 SLAVE_SERVER_ID: 3
9 CHANGE REPLICATION SOURCE TO SOURCE_HOST="127.0.0.1",SOURCE_PORT=SLAVE_PORT,SOURCE_USER="root";
10 Warnings:
11 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
12 Note 1760 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.
13 START SLAVE;
14 Warnings:
15 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
16 MASTER_SERVER_ID: 1
17 Setup ndb_replication and exceptions tables
18 Populate ndb_replication table as necessary
19 replace into mysql.ndb_replication values
20 ("test", "t1", 3, 7, NULL),
21 ("test", "t1", 1, 7, "NDB$EPOCH()"),
22 ("test", "t2", 3, 7, NULL),
23 ("test", "t2", 1, 7, "NDB$EPOCH_TRANS()");
24 create table test.t1$EX
25 (SERVER_ID int unsigned,
26 NDB$MASTER_SERVER_ID int unsigned,
27 NDB$MASTER_EPOCH bigint unsigned,
28 NDB$COUNT int unsigned,
29 a int not null,
30 NDB$OP_TYPE ENUM('WRITE_ROW','UPDATE_ROW', 'DELETE_ROW') NOT NULL,
31 NDB$CFT_CAUSE ENUM('ROW_DOES_NOT_EXIST','ROW_ALREADY_EXISTS','DATA_IN_CONFLICT','TRANS_IN_CONFLICT') NOT NULL,
32 primary key(SERVER_ID, NDB$MASTER_SERVER_ID, NDB$MASTER_EPOCH, NDB$COUNT))
33 ENGINE=NDB;
34 create table test.t1 (
35 a int not null,
36 b int not null,
37 c varchar(2000),
38 primary key (a,b)) engine=ndb;
39 MySQLD error output for server 1.1 matching pattern %Exceptions table %
40 relevant
41 [warning] replica: exceptions table t1$ex has wrong definition (column 1):
42 drop table test.t1$EX, test.t1;
43 create table test.t1$EX
44 (NDB$SERVER_ID int unsigned,
45 NDB$MASTER_SERVER_ID int unsigned,
46 NDB$MASTER_EPOCH bigint unsigned,
47 NDB$COUNT int unsigned,
48 a$old int,
49 a$new int,
50 NDB$OP_TYPE ENUM('WRITE_ROW','UPDATE_ROW', 'DELETE_ROW') NOT NULL,
51 NDB$CFT_CAUSE ENUM('ROW_DOES_NOT_EXIST','ROW_ALREADY_EXISTS','DATA_IN_CONFLICT','TRANS_IN_CONFLICT') NOT NULL,
52 primary key(NDB$SERVER_ID, NDB$MASTER_SERVER_ID, NDB$MASTER_EPOCH, NDB$COUNT))
53 ENGINE=NDB;
54 create table test.t1 (
55 a int not null,
56 b int not null,
57 c varchar(2000),
58 primary key (a,b)) engine=ndb;
59 MySQLD error output for server 1.1 matching pattern %Exceptions table %
60 relevant
61 [warning] replica: exceptions table t1$ex has wrong definition (column 5): old or new values of primary key columns cannot be referenced since primary keys cannot be updated, column a$new in table t1$ex
62 drop table test.t1$EX, test.t1;
63 create table test.t1$EX
64 (NDB$SERVER_ID int unsigned,
65 NDB$MASTER_SERVER_ID int unsigned,
66 NDB$MASTER_EPOCH bigint unsigned,
67 NDB$COUNT int unsigned,
68 c$old varchar(2000) not null,
69 c$new varchar(2000) not null,
70 NDB$OP_TYPE ENUM('WRITE_ROW','UPDATE_ROW', 'DELETE_ROW') NOT NULL,
71 NDB$CFT_CAUSE ENUM('ROW_DOES_NOT_EXIST','ROW_ALREADY_EXISTS','DATA_IN_CONFLICT','TRANS_IN_CONFLICT') NOT NULL,
72 primary key(NDB$SERVER_ID, NDB$MASTER_SERVER_ID, NDB$MASTER_EPOCH, NDB$COUNT))
73 ENGINE=NDB CHARACTER SET latin1;
74 create table test.t1 (
75 a int not null,
76 b int not null,
77 c varchar(2000),
78 primary key (a,b)) engine=ndb CHARACTER SET latin1;
79 MySQLD error output for server 1.1 matching pattern %Exceptions table %
80 relevant
81 [warning] replica: exceptions table t1$ex has wrong definition (column 5): old or new column reference c$new in table t1$ex is not nullable and doesn't have a default value
82 drop table test.t1$EX, test.t1;
83 create table test.t1$EX
84 (NDB$SERVER_ID int unsigned,
85 NDB$MASTER_SERVER_ID int unsigned,
86 NDB$MASTER_EPOCH bigint unsigned,
87 NDB$COUNT int unsigned,
88 a int not null,
89 NDB$OP_TYPE ENUM('WRITE_ROW','UPDATE_ROW', 'DELETE_ROW') NOT NULL,
90 NDB$CFT_CAUSE ENUM('ROW_DOES_NOT_EXIST','ROW_ALREADY_EXISTS','DATA_IN_CONFLICT','TRANS_IN_CONFLICT') NOT NULL,
91 primary key(NDB$SERVER_ID, NDB$MASTER_SERVER_ID, NDB$MASTER_EPOCH, NDB$COUNT))
92 ENGINE=NDB;
93 create table test.t1 (
94 a int not null,
95 b int not null,
96 c varchar(2000),
97 primary key (a,b)) engine=ndb;
98 create table test.t2$ex
99 (ndb$server_id int unsigned,
100 ndb$master_server_id int unsigned,
101 ndb$master_epoch bigint unsigned,
102 ndb$count int unsigned,
103 d varchar(2000),
104 c int not null default 99,
105 b int not null,
106 a int not null,
107 d$old varchar(2000),
108 d$new varchar(2000),
109 ndb$op_type enum('write_row','update_row', 'delete_row') not null,
110 ndb$cft_cause enum('row_does_not_exist','row_already_exists','data_in_conflict','trans_in_conflict') not null,
111 ndb$orig_transid bigint unsigned not null,
112 e int,
113 primary key(ndb$server_id, ndb$master_server_id, ndb$master_epoch, ndb$count))
114 engine=ndb CHARACTER SET latin1;
115 create table test.t2 (
116 x int default 21,
117 a int not null,
118 b int not null,
119 c int,
120 d varchar(2000),
121 e int,
122 primary key(a,b)) engine=ndb CHARACTER SET latin1;
123 Add some data
124 stop slave;
125 Warnings:
126 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
127 Slave contents
128 select * from t1 order by a;
129 a b c
130 1 2 Initial data 1
131 2 3 Initial data 2
132 3 4 Initial data 3
133 4 5 Initial data 4
134 5 6 Initial data 5
135 6 7 Initial data 6
136 7 8 Initial data 7
137 8 9 Initial data 8
138 9 10 Initial data 9
139 10 11 Initial data 10
140 select * from test.t2 order by a;
141 x a b c d e
142 21 1 2 3 Initial data 1 17
143 21 2 3 4 Initial data 2 17
144 21 3 4 5 Initial data 3 17
145 21 4 5 6 Initial data 4 17
146 21 5 6 7 Initial data 5 17
147 21 6 7 8 Initial data 6 17
148 21 7 8 9 Initial data 7 17
149 21 8 9 10 Initial data 8 17
150 21 9 10 11 Initial data 9 17
151 21 10 11 12 Initial data 10 17
152 Master contents
153 select * from test.t1 order by a;
154 a b c
155 1 2 Master updated data 1
156 2 3 Master updated data 2
157 3 4 Master updated data 3
158 4 5 Master updated data 4
159 5 6 Master updated data 5
160 6 7 Master updated data 6
161 7 8 Master updated data 7
162 8 9 Master updated data 8
163 9 10 Master updated data 9
164 10 11 Master updated data 10
165 select * from test.t2 order by a;
166 x a b c d e
167 21 1 2 3 Master updated data 1 17
168 21 2 3 4 Master updated data 2 17
169 21 3 4 5 Master updated data 3 17
170 21 4 5 6 Master updated data 4 17
171 21 5 6 7 Master updated data 5 17
172 21 6 7 8 Master updated data 6 17
173 21 7 8 9 Master updated data 7 17
174 21 8 9 10 Master updated data 8 17
175 21 9 10 11 Master updated data 9 17
176 21 10 11 12 Master updated data 10 17
177 Slave contents
178 select * from test.t1 order by a;
179 a b c
180 1 2 Slave updated data 1
181 2 3 Slave updated data 2
182 3 4 Slave updated data 3
183 4 5 Slave updated data 4
184 5 6 Slave updated data 5
185 6 7 Slave updated data 6
186 7 8 Slave updated data 7
187 8 9 Slave updated data 8
188 9 10 Slave updated data 9
189 10 11 Slave updated data 10
190 select * from test.t2 order by a;
191 x a b c d e
192 21 1 2 3 Slave updated data 1 17
193 21 2 3 4 Slave updated data 2 17
194 21 3 4 5 Slave updated data 3 17
195 21 4 5 6 Slave updated data 4 17
196 21 5 6 7 Slave updated data 5 17
197 21 6 7 8 Slave updated data 6 17
198 21 7 8 9 Slave updated data 7 17
199 21 8 9 10 Slave updated data 8 17
200 21 9 10 11 Slave updated data 9 17
201 21 10 11 12 Slave updated data 10 17
202 Primary should have rejected change from Secondary, keeping its value
203 select * from t1 order by a;
204 a b c
205 1 2 Master updated data 1
206 2 3 Master updated data 2
207 3 4 Master updated data 3
208 4 5 Master updated data 4
209 5 6 Master updated data 5
210 6 7 Master updated data 6
211 7 8 Master updated data 7
212 8 9 Master updated data 8
213 9 10 Master updated data 9
214 10 11 Master updated data 10
215 select * from t2 order by a;
216 x a b c d e
217 21 1 2 3 Master updated data 1 17
218 21 2 3 4 Master updated data 2 17
219 21 3 4 5 Master updated data 3 17
220 21 4 5 6 Master updated data 4 17
221 21 5 6 7 Master updated data 5 17
222 21 6 7 8 Master updated data 6 17
223 21 7 8 9 Master updated data 7 17
224 21 8 9 10 Master updated data 8 17
225 21 9 10 11 Master updated data 9 17
226 21 10 11 12 Master updated data 10 17
227 start slave;
228 Warnings:
229 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
230 Secondary should have been realigned to Primary
231 Slave contents
232 select * from t1 order by a;
233 a b c
234 1 2 Master updated data 1
235 2 3 Master updated data 2
236 3 4 Master updated data 3
237 4 5 Master updated data 4
238 5 6 Master updated data 5
239 6 7 Master updated data 6
240 7 8 Master updated data 7
241 8 9 Master updated data 8
242 9 10 Master updated data 9
243 10 11 Master updated data 10
244 select * from t2 order by a;
245 x a b c d e
246 21 1 2 3 Master updated data 1 17
247 21 2 3 4 Master updated data 2 17
248 21 3 4 5 Master updated data 3 17
249 21 4 5 6 Master updated data 4 17
250 21 5 6 7 Master updated data 5 17
251 21 6 7 8 Master updated data 6 17
252 21 7 8 9 Master updated data 7 17
253 21 8 9 10 Master updated data 8 17
254 21 9 10 11 Master updated data 9 17
255 21 10 11 12 Master updated data 10 17
256 Show rollback of whole secondary transaction
257 --------------------------------------------
258 flush logs;
259 Slave contents
260 select * from t1 order by a;
261 a b c
262 1 2 Master updated data 1
263 2 3 Master updated data 2
264 3 4 Master updated data 3
265 4 5 Master updated data 4
266 5 6 Master updated data 5
267 6 7 Master updated data 6
268 7 8 Master updated data 7
269 8 9 Master updated data 8
270 9 10 Master updated data 9
271 10 11 Master updated data 10
272 select * from t2 order by a;
273 x a b c d e
274 21 1 2 3 Master updated data 1 17
275 21 2 3 4 Master updated data 2 17
276 21 3 4 5 Master updated data 3 17
277 21 4 5 6 Master updated data 4 17
278 21 5 6 7 Master updated data 5 17
279 21 6 7 8 Master updated data 6 17
280 21 7 8 9 Master updated data 7 17
281 21 8 9 10 Master updated data 8 17
282 21 9 10 11 Master updated data 9 17
283 21 10 11 12 Master updated data 10 17
284 select count(*) from t1$EX;
285 count(*)
286 10
287 select NDB$OP_TYPE,NDB$CFT_CAUSE from t1$EX
288 order by a;
289 NDB$OP_TYPE NDB$CFT_CAUSE
290 UPDATE_ROW DATA_IN_CONFLICT
291 UPDATE_ROW DATA_IN_CONFLICT
292 UPDATE_ROW DATA_IN_CONFLICT
293 UPDATE_ROW DATA_IN_CONFLICT
294 UPDATE_ROW DATA_IN_CONFLICT
295 UPDATE_ROW DATA_IN_CONFLICT
296 UPDATE_ROW DATA_IN_CONFLICT
297 UPDATE_ROW DATA_IN_CONFLICT
298 UPDATE_ROW DATA_IN_CONFLICT
299 UPDATE_ROW DATA_IN_CONFLICT
300 select count(*) from t2$ex;
301 count(*)
302 10
303 select a, b, c, d, d$old, d$new, e, ndb$count > 0,ndb$op_type,ndb$cft_cause, ndb$orig_transid > 0 from t2$ex order by a;
304 a b c d d$old d$new e ndb$count > 0 ndb$op_type ndb$cft_cause ndb$orig_transid > 0
305 1 2 3 Slave updated data 1 Initial data 1 Slave updated data 1 17 1 update_row trans_in_conflict 1
306 2 3 4 Slave updated data 2 Initial data 2 Slave updated data 2 17 1 update_row trans_in_conflict 1
307 3 4 5 Slave updated data 3 Initial data 3 Slave updated data 3 17 1 update_row trans_in_conflict 1
308 4 5 6 Slave updated data 4 Initial data 4 Slave updated data 4 17 1 update_row trans_in_conflict 1
309 5 6 7 Slave updated data 5 Initial data 5 Slave updated data 5 17 1 update_row trans_in_conflict 1
310 6 7 8 Slave updated data 6 Initial data 6 Slave updated data 6 17 1 update_row trans_in_conflict 1
311 7 8 9 Slave updated data 7 Initial data 7 Slave updated data 7 17 1 update_row trans_in_conflict 1
312 8 9 10 Slave updated data 8 Initial data 8 Slave updated data 8 17 1 update_row trans_in_conflict 1
313 9 10 11 Slave updated data 9 Initial data 9 Slave updated data 9 17 1 update_row trans_in_conflict 1
314 10 11 12 Slave updated data 10 Initial data 10 Slave updated data 10 17 1 update_row trans_in_conflict 1
315 SET NAMES utf8;
316 Warnings:
317 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
318 replace into mysql.ndb_replication values
319 ("test", "アアア", 3, 7, NULL),
320 ("test", "アアア", 1, 7, "NDB$EPOCH_TRANS()");
321 create table test.`アアア$ex`
322 (ndb$server_id int unsigned,
323 ndb$master_server_id int unsigned,
324 ndb$master_epoch bigint unsigned,
325 ndb$count int unsigned,
326 `キキキ` varchar(2000) charset utf8,
327 `カカカ` int not null,
328 ndb$op_type enum('write_row','update_row', 'delete_row') not null,
329 ndb$cft_cause enum('row_does_not_exist','row_already_exists','data_in_conflict','trans_in_conflict') not null,
330 ndb$orig_transid bigint unsigned not null,
331 primary key(ndb$server_id, ndb$master_server_id, ndb$master_epoch, ndb$count))
332 engine=ndb;
333 Warnings:
334 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
335 create table test.`アアア` (
336 `カカカ` int primary key,
337 `キキキ` varchar(2000) charset utf8) engine=ndb;
338 Warnings:
339 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
340 SET NAMES latin1;
341 MySQLD error output for server 1.1 matching pattern %suspicious % column op_type %
342 relevant
343 SET NAMES utf8;
344 Warnings:
345 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
346 drop table test.`アアア`,test.`アアア$ex`;
347 SET NAMES utf8;
348 Warnings:
349 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
350 replace into mysql.ndb_replication values
351 ("test", "アアア", 3, 7, NULL),
352 ("test", "アアア", 1, 7, "NDB$EPOCH_TRANS()");
353 create table test.`アアア$ex`
354 (ndb$server_id int unsigned,
355 ndb$master_server_id int unsigned,
356 ndb$master_epoch bigint unsigned,
357 ndb$count int unsigned,
358 `キキキ$old` varchar(2000) charset utf8,
359 `キキキ$new` varchar(2000) charset utf8,
360 `カカカ` int not null,
361 ndb$op_type enum('write_row','update_row', 'delete_row') not null,
362 ndb$cft_cause enum('row_does_not_exist','row_already_exists','data_in_conflict','trans_in_conflict') not null,
363 ndb$orig_transid bigint unsigned not null,
364 primary key(ndb$server_id, ndb$master_server_id, ndb$master_epoch, ndb$count))
365 engine=ndb;
366 Warnings:
367 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
368 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
369 create table test.`アアア` (
370 `カカカ` int primary key,
371 `キキキ` varchar(2000) charset utf8) engine=ndb;
372 Warnings:
373 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
374 SET NAMES latin1;
375 MySQLD error output for server 1.1 matching pattern %suspicious % column op_type %
376 relevant
377 flush logs;
378 drop table test.t1$EX, test.t1, test.t2$ex, test.t2;
379 SET NAMES utf8;
380 Warnings:
381 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
382 drop table test.`アアア`, test.`アアア$ex`;
383 SET NAMES latin1;
384 flush logs;
385 drop table mysql.ndb_replication;
386 stop slave;
387 Warnings:
388 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
389 reset slave;
390 Warnings:
391 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
392 include/rpl_end.inc