Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_conflict_read_tracking.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 REPLICA;
14 MASTER_SERVER_ID: 1
15 Setup ndb_replication and t1 exceptions table
16 Populate ndb_replication table as necessary
17 replace into mysql.ndb_replication values
18 ("test", "t1", 3, 7, NULL),
19 ("test", "t1", 1, 7, "NDB$EPOCH_TRANS()"),
20 ("test", "t2", 3, 7, NULL),
21 ("test", "t2", 1, 7, "NDB$EPOCH_TRANS()");
22 create table test.t1 (
23 a int primary key,
24 b varchar(2000)) engine=ndb character set latin1;
25 create table test.t2 (
26 a int primary key,
27 b varchar(2000)) engine=ndb character set latin1;
28 Add some data
29 insert into test.t1 values
30 (1, "Initial data 1"),
31 (2, "Initial data 2"),
32 (3, "Initial data 3"),
33 (4, "Initial data 4"),
34 (5, "Initial data 5"),
35 (6, "Initial data 6"),
36 (7, "Initial data 7"),
37 (8, "Initial data 8"),
38 (9, "Initial data 9"),
39 (10, "Initial data 10");
40 insert into test.t2 values
41 (1, "Initial data 1"),
42 (2, "Initial data 2"),
43 (3, "Initial data 3"),
44 (4, "Initial data 4"),
45 (5, "Initial data 5"),
46 (6, "Initial data 6"),
47 (7, "Initial data 7"),
48 (8, "Initial data 8"),
49 (9, "Initial data 9"),
50 (10, "Initial data 10");
51 Sync all changes
52 ---------------------------------------
53 Test 1, read-update conflict without read tracking
54 Stopping secondary replica
55 stop replica;
56 Stopping primary replica
57 stop replica;
58 begin;
59 update test.t1 set b="Primary first change 1" where a=1;
60 update test.t1 set b="Primary first change 2" where a=2;
61 commit;
62 SET ndb_log_exclusive_reads= 0;
63 begin;
64 select * from test.t1 where a = 1 for update;
65 a b
66 1 Initial data 1
67 update test.t2 set b="Secondary first change 3" where a=3;
68 commit;
69 Checking tables before conflict resolution
70 ---------------------------------------
71 **** Primary ****
72 select * from test.t1 order by a;
73 a b
74 1 Primary first change 1
75 2 Primary first change 2
76 3 Initial data 3
77 4 Initial data 4
78 5 Initial data 5
79 6 Initial data 6
80 7 Initial data 7
81 8 Initial data 8
82 9 Initial data 9
83 10 Initial data 10
84 select * from test.t2 order by a;
85 a b
86 1 Initial data 1
87 2 Initial data 2
88 3 Initial data 3
89 4 Initial data 4
90 5 Initial data 5
91 6 Initial data 6
92 7 Initial data 7
93 8 Initial data 8
94 9 Initial data 9
95 10 Initial data 10
96 Starting primary replica
97 start replica;
98 **** Secondary ****
99 select * from test.t1 order by a;
100 a b
101 1 Initial data 1
102 2 Initial data 2
103 3 Initial data 3
104 4 Initial data 4
105 5 Initial data 5
106 6 Initial data 6
107 7 Initial data 7
108 8 Initial data 8
109 9 Initial data 9
110 10 Initial data 10
111 select * from test.t2 order by a;
112 a b
113 1 Initial data 1
114 2 Initial data 2
115 3 Secondary first change 3
116 4 Initial data 4
117 5 Initial data 5
118 6 Initial data 6
119 7 Initial data 7
120 8 Initial data 8
121 9 Initial data 9
122 10 Initial data 10
123 Primary should not have rejected change from Secondary
124 select * from test.t1 order by a;
125 a b
126 1 Primary first change 1
127 2 Primary first change 2
128 3 Initial data 3
129 4 Initial data 4
130 5 Initial data 5
131 6 Initial data 6
132 7 Initial data 7
133 8 Initial data 8
134 9 Initial data 9
135 10 Initial data 10
136 select * from test.t2 order by a;
137 a b
138 1 Initial data 1
139 2 Initial data 2
140 3 Secondary first change 3
141 4 Initial data 4
142 5 Initial data 5
143 6 Initial data 6
144 7 Initial data 7
145 8 Initial data 8
146 9 Initial data 9
147 10 Initial data 10
148 ndb_conflict_fn_epoch_trans
149 0
150 ndb_conflict_fn_epoch2_trans
151 0
152 ndb_conflict_trans_row_conflict_count
153 0
154 ndb_conflict_trans_row_reject_count
155 0
156 ndb_conflict_trans_reject_count
157 0
158 ndb_conflict_trans_detect_iter_count
159 0
160 ndb_conflict_trans_conflict_commit_count
161 0
162 ndb_epoch_delete_delete_count
163 0
164 select NDB$OP_TYPE, b$old, b$new, NDB$CFT_CAUSE from test.t1$EX
165 order by a;
166 NDB$OP_TYPE b$old b$new NDB$CFT_CAUSE
167 select NDB$OP_TYPE, b$old, b$new, NDB$CFT_CAUSE from test.t2$EX
168 order by a;
169 NDB$OP_TYPE b$old b$new NDB$CFT_CAUSE
170 starting secondary replica
171 start replica;
172 Secondary should not have been realigned to Primary
173 **** Primary ****
174 select * from test.t1 order by a;
175 a b
176 1 Primary first change 1
177 2 Primary first change 2
178 3 Initial data 3
179 4 Initial data 4
180 5 Initial data 5
181 6 Initial data 6
182 7 Initial data 7
183 8 Initial data 8
184 9 Initial data 9
185 10 Initial data 10
186 select * from test.t2 order by a;
187 a b
188 1 Initial data 1
189 2 Initial data 2
190 3 Secondary first change 3
191 4 Initial data 4
192 5 Initial data 5
193 6 Initial data 6
194 7 Initial data 7
195 8 Initial data 8
196 9 Initial data 9
197 10 Initial data 10
198 **** Secondary ****
199 select * from test.t1 order by a;
200 a b
201 1 Primary first change 1
202 2 Primary first change 2
203 3 Initial data 3
204 4 Initial data 4
205 5 Initial data 5
206 6 Initial data 6
207 7 Initial data 7
208 8 Initial data 8
209 9 Initial data 9
210 10 Initial data 10
211 select * from test.t2 order by a;
212 a b
213 1 Initial data 1
214 2 Initial data 2
215 3 Secondary first change 3
216 4 Initial data 4
217 5 Initial data 5
218 6 Initial data 6
219 7 Initial data 7
220 8 Initial data 8
221 9 Initial data 9
222 10 Initial data 10
223 update test.t1 set b="Initial data 1" where a=1;
224 update test.t1 set b="Initial data 2" where a=2;
225 update test.t2 set b="Initial data 3" where a=3;
226 Sync all changes
227 ---------------------------------------
228 delete from test.t2$EX;
229 Test 2, read-update conflict with read tracking
230 Stopping secondary replica
231 stop replica;
232 Stopping primary replica
233 stop replica;
234 begin;
235 update test.t1 set b="Primary first change 1" where a=1;
236 update test.t1 set b="Primary first change 2" where a=2;
237 commit;
238 SET ndb_log_exclusive_reads= 1;
239 begin;
240 select * from test.t1 where a = 1 for update;
241 a b
242 1 Initial data 1
243 update test.t2 set b="Secondary first change 3" where a=3;
244 commit;
245 Checking tables before conflict resolution
246 ---------------------------------------
247 **** Primary ****
248 select * from test.t1 order by a;
249 a b
250 1 Primary first change 1
251 2 Primary first change 2
252 3 Initial data 3
253 4 Initial data 4
254 5 Initial data 5
255 6 Initial data 6
256 7 Initial data 7
257 8 Initial data 8
258 9 Initial data 9
259 10 Initial data 10
260 select * from test.t2 order by a;
261 a b
262 1 Initial data 1
263 2 Initial data 2
264 3 Initial data 3
265 4 Initial data 4
266 5 Initial data 5
267 6 Initial data 6
268 7 Initial data 7
269 8 Initial data 8
270 9 Initial data 9
271 10 Initial data 10
272 Starting primary replica
273 start replica;
274 **** Secondary ****
275 select * from test.t1 order by a;
276 a b
277 1 Initial data 1
278 2 Initial data 2
279 3 Initial data 3
280 4 Initial data 4
281 5 Initial data 5
282 6 Initial data 6
283 7 Initial data 7
284 8 Initial data 8
285 9 Initial data 9
286 10 Initial data 10
287 select * from test.t2 order by a;
288 a b
289 1 Initial data 1
290 2 Initial data 2
291 3 Secondary first change 3
292 4 Initial data 4
293 5 Initial data 5
294 6 Initial data 6
295 7 Initial data 7
296 8 Initial data 8
297 9 Initial data 9
298 10 Initial data 10
299 Primary should have rejected change from Secondary, keeping its value
300 select * from test.t1 order by a;
301 a b
302 1 Primary first change 1
303 2 Primary first change 2
304 3 Initial data 3
305 4 Initial data 4
306 5 Initial data 5
307 6 Initial data 6
308 7 Initial data 7
309 8 Initial data 8
310 9 Initial data 9
311 10 Initial data 10
312 select * from test.t2 order by a;
313 a b
314 1 Initial data 1
315 2 Initial data 2
316 3 Initial data 3
317 4 Initial data 4
318 5 Initial data 5
319 6 Initial data 6
320 7 Initial data 7
321 8 Initial data 8
322 9 Initial data 9
323 10 Initial data 10
324 ndb_conflict_fn_epoch_trans
325 1
326 ndb_conflict_fn_epoch2_trans
327 0
328 ndb_conflict_trans_row_conflict_count
329 1
330 ndb_conflict_trans_row_reject_count
331 2
332 ndb_conflict_trans_reject_count
333 1
334 ndb_conflict_trans_detect_iter_count
335 1
336 ndb_conflict_trans_conflict_commit_count
337 1
338 ndb_epoch_delete_delete_count
339 0
340 select NDB$OP_TYPE, b$old, b$new, NDB$CFT_CAUSE from test.t1$EX
341 order by a;
342 NDB$OP_TYPE b$old b$new NDB$CFT_CAUSE
343 READ_ROW Initial data 1 Initial data 1 TRANS_IN_CONFLICT
344 select NDB$OP_TYPE, b$old, b$new, NDB$CFT_CAUSE from test.t2$EX
345 order by a;
346 NDB$OP_TYPE b$old b$new NDB$CFT_CAUSE
347 UPDATE_ROW Initial data 3 Secondary first change 3 TRANS_IN_CONFLICT
348 starting secondary replica
349 start replica;
350 Secondary should have been realigned to Primary
351 **** Primary ****
352 select * from test.t1 order by a;
353 a b
354 1 Primary first change 1
355 2 Primary first change 2
356 3 Initial data 3
357 4 Initial data 4
358 5 Initial data 5
359 6 Initial data 6
360 7 Initial data 7
361 8 Initial data 8
362 9 Initial data 9
363 10 Initial data 10
364 select * from test.t2 order by a;
365 a b
366 1 Initial data 1
367 2 Initial data 2
368 3 Initial data 3
369 4 Initial data 4
370 5 Initial data 5
371 6 Initial data 6
372 7 Initial data 7
373 8 Initial data 8
374 9 Initial data 9
375 10 Initial data 10
376 **** Secondary ****
377 select * from test.t1 order by a;
378 a b
379 1 Primary first change 1
380 2 Primary first change 2
381 3 Initial data 3
382 4 Initial data 4
383 5 Initial data 5
384 6 Initial data 6
385 7 Initial data 7
386 8 Initial data 8
387 9 Initial data 9
388 10 Initial data 10
389 select * from test.t2 order by a;
390 a b
391 1 Initial data 1
392 2 Initial data 2
393 3 Initial data 3
394 4 Initial data 4
395 5 Initial data 5
396 6 Initial data 6
397 7 Initial data 7
398 8 Initial data 8
399 9 Initial data 9
400 10 Initial data 10
401 update test.t1 set b="Initial data 1" where a=1;
402 update test.t1 set b="Initial data 2" where a=2;
403 update test.t2 set b="Initial data 3" where a=3;
404 Sync all changes
405 ---------------------------------------
406 delete from test.t1$EX;
407 delete from test.t2$EX;
408 Test 3, read-read conflict without read tracking
409 Stopping secondary replica
410 stop replica;
411 Stopping primary replica
412 stop replica;
413 SET ndb_log_exclusive_reads= 0;
414 begin;
415 select * from test.t1 where a = 1 for update;
416 a b
417 1 Initial data 1
418 update test.t1 set b="Primary first change 2" where a=2;
419 commit;
420 SET ndb_log_exclusive_reads= 0;
421 begin;
422 select * from test.t1 where a = 1 for update;
423 a b
424 1 Initial data 1
425 update test.t2 set b="Secondary first change 3" where a=3;
426 commit;
427 Checking tables before conflict resolution
428 ---------------------------------------
429 **** Primary ****
430 select * from test.t1 order by a;
431 a b
432 1 Initial data 1
433 2 Primary first change 2
434 3 Initial data 3
435 4 Initial data 4
436 5 Initial data 5
437 6 Initial data 6
438 7 Initial data 7
439 8 Initial data 8
440 9 Initial data 9
441 10 Initial data 10
442 select * from test.t2 order by a;
443 a b
444 1 Initial data 1
445 2 Initial data 2
446 3 Initial data 3
447 4 Initial data 4
448 5 Initial data 5
449 6 Initial data 6
450 7 Initial data 7
451 8 Initial data 8
452 9 Initial data 9
453 10 Initial data 10
454 Starting primary replica
455 start replica;
456 **** Secondary ****
457 select * from test.t1 order by a;
458 a b
459 1 Initial data 1
460 2 Initial data 2
461 3 Initial data 3
462 4 Initial data 4
463 5 Initial data 5
464 6 Initial data 6
465 7 Initial data 7
466 8 Initial data 8
467 9 Initial data 9
468 10 Initial data 10
469 select * from test.t2 order by a;
470 a b
471 1 Initial data 1
472 2 Initial data 2
473 3 Secondary first change 3
474 4 Initial data 4
475 5 Initial data 5
476 6 Initial data 6
477 7 Initial data 7
478 8 Initial data 8
479 9 Initial data 9
480 10 Initial data 10
481 Primary should not have rejected change from Secondary
482 select * from test.t1 order by a;
483 a b
484 1 Initial data 1
485 2 Primary first change 2
486 3 Initial data 3
487 4 Initial data 4
488 5 Initial data 5
489 6 Initial data 6
490 7 Initial data 7
491 8 Initial data 8
492 9 Initial data 9
493 10 Initial data 10
494 select * from test.t2 order by a;
495 a b
496 1 Initial data 1
497 2 Initial data 2
498 3 Secondary first change 3
499 4 Initial data 4
500 5 Initial data 5
501 6 Initial data 6
502 7 Initial data 7
503 8 Initial data 8
504 9 Initial data 9
505 10 Initial data 10
506 ndb_conflict_fn_epoch_trans
507 0
508 ndb_conflict_fn_epoch2_trans
509 0
510 ndb_conflict_trans_row_conflict_count
511 0
512 ndb_conflict_trans_row_reject_count
513 0
514 ndb_conflict_trans_reject_count
515 0
516 ndb_conflict_trans_detect_iter_count
517 0
518 ndb_conflict_trans_conflict_commit_count
519 0
520 ndb_epoch_delete_delete_count
521 0
522 select NDB$OP_TYPE, b$old, b$new, NDB$CFT_CAUSE from test.t1$EX
523 order by a;
524 NDB$OP_TYPE b$old b$new NDB$CFT_CAUSE
525 select NDB$OP_TYPE, b$old, b$new, NDB$CFT_CAUSE from test.t2$EX
526 order by a;
527 NDB$OP_TYPE b$old b$new NDB$CFT_CAUSE
528 starting secondary replica
529 start replica;
530 Secondary should not have been realigned to Primary
531 **** Primary ****
532 select * from test.t1 order by a;
533 a b
534 1 Initial data 1
535 2 Primary first change 2
536 3 Initial data 3
537 4 Initial data 4
538 5 Initial data 5
539 6 Initial data 6
540 7 Initial data 7
541 8 Initial data 8
542 9 Initial data 9
543 10 Initial data 10
544 select * from test.t2 order by a;
545 a b
546 1 Initial data 1
547 2 Initial data 2
548 3 Secondary first change 3
549 4 Initial data 4
550 5 Initial data 5
551 6 Initial data 6
552 7 Initial data 7
553 8 Initial data 8
554 9 Initial data 9
555 10 Initial data 10
556 **** Secondary ****
557 select * from test.t1 order by a;
558 a b
559 1 Initial data 1
560 2 Primary first change 2
561 3 Initial data 3
562 4 Initial data 4
563 5 Initial data 5
564 6 Initial data 6
565 7 Initial data 7
566 8 Initial data 8
567 9 Initial data 9
568 10 Initial data 10
569 select * from test.t2 order by a;
570 a b
571 1 Initial data 1
572 2 Initial data 2
573 3 Secondary first change 3
574 4 Initial data 4
575 5 Initial data 5
576 6 Initial data 6
577 7 Initial data 7
578 8 Initial data 8
579 9 Initial data 9
580 10 Initial data 10
581 update test.t1 set b="Initial data 1" where a=1;
582 update test.t1 set b="Initial data 2" where a=2;
583 update test.t2 set b="Initial data 3" where a=3;
584 Sync all changes
585 ---------------------------------------
586 delete from test.t1$EX;
587 delete from test.t2$EX;
588 Test 4, read-read conflict with read tracking
589 Stopping secondary replica
590 stop replica;
591 Stopping primary replica
592 stop replica;
593 SET ndb_log_exclusive_reads= 1;
594 begin;
595 select * from test.t1 where a = 1 for update;
596 a b
597 1 Initial data 1
598 update test.t1 set b="Primary first change 2" where a=2;
599 commit;
600 SET ndb_log_exclusive_reads= 1;
601 begin;
602 select * from test.t1 where a = 1 for update;
603 a b
604 1 Initial data 1
605 update test.t2 set b="Secondary first change 3" where a=3;
606 commit;
607 Checking tables before conflict resolution
608 ---------------------------------------
609 **** Primary ****
610 select * from test.t1 order by a;
611 a b
612 1 Initial data 1
613 2 Primary first change 2
614 3 Initial data 3
615 4 Initial data 4
616 5 Initial data 5
617 6 Initial data 6
618 7 Initial data 7
619 8 Initial data 8
620 9 Initial data 9
621 10 Initial data 10
622 select * from test.t2 order by a;
623 a b
624 1 Initial data 1
625 2 Initial data 2
626 3 Initial data 3
627 4 Initial data 4
628 5 Initial data 5
629 6 Initial data 6
630 7 Initial data 7
631 8 Initial data 8
632 9 Initial data 9
633 10 Initial data 10
634 Starting primary replica
635 start replica;
636 **** Secondary ****
637 select * from test.t1 order by a;
638 a b
639 1 Initial data 1
640 2 Initial data 2
641 3 Initial data 3
642 4 Initial data 4
643 5 Initial data 5
644 6 Initial data 6
645 7 Initial data 7
646 8 Initial data 8
647 9 Initial data 9
648 10 Initial data 10
649 select * from test.t2 order by a;
650 a b
651 1 Initial data 1
652 2 Initial data 2
653 3 Secondary first change 3
654 4 Initial data 4
655 5 Initial data 5
656 6 Initial data 6
657 7 Initial data 7
658 8 Initial data 8
659 9 Initial data 9
660 10 Initial data 10
661 Primary should have rejected change from Secondary, keeping its value
662 select * from test.t1 order by a;
663 a b
664 1 Initial data 1
665 2 Primary first change 2
666 3 Initial data 3
667 4 Initial data 4
668 5 Initial data 5
669 6 Initial data 6
670 7 Initial data 7
671 8 Initial data 8
672 9 Initial data 9
673 10 Initial data 10
674 select * from test.t2 order by a;
675 a b
676 1 Initial data 1
677 2 Initial data 2
678 3 Initial data 3
679 4 Initial data 4
680 5 Initial data 5
681 6 Initial data 6
682 7 Initial data 7
683 8 Initial data 8
684 9 Initial data 9
685 10 Initial data 10
686 ndb_conflict_fn_epoch_trans
687 1
688 ndb_conflict_fn_epoch2_trans
689 0
690 ndb_conflict_trans_row_conflict_count
691 1
692 ndb_conflict_trans_row_reject_count
693 2
694 ndb_conflict_trans_reject_count
695 1
696 ndb_conflict_trans_detect_iter_count
697 1
698 ndb_conflict_trans_conflict_commit_count
699 1
700 ndb_epoch_delete_delete_count
701 0
702 select NDB$OP_TYPE, b$old, b$new, NDB$CFT_CAUSE from test.t1$EX
703 order by a;
704 NDB$OP_TYPE b$old b$new NDB$CFT_CAUSE
705 READ_ROW Initial data 1 Initial data 1 TRANS_IN_CONFLICT
706 select NDB$OP_TYPE, b$old, b$new, NDB$CFT_CAUSE from test.t2$EX
707 order by a;
708 NDB$OP_TYPE b$old b$new NDB$CFT_CAUSE
709 UPDATE_ROW Initial data 3 Secondary first change 3 TRANS_IN_CONFLICT
710 starting secondary replica
711 start replica;
712 Secondary should have been realigned to Primary
713 **** Primary ****
714 select * from test.t1 order by a;
715 a b
716 1 Initial data 1
717 2 Primary first change 2
718 3 Initial data 3
719 4 Initial data 4
720 5 Initial data 5
721 6 Initial data 6
722 7 Initial data 7
723 8 Initial data 8
724 9 Initial data 9
725 10 Initial data 10
726 select * from test.t2 order by a;
727 a b
728 1 Initial data 1
729 2 Initial data 2
730 3 Initial data 3
731 4 Initial data 4
732 5 Initial data 5
733 6 Initial data 6
734 7 Initial data 7
735 8 Initial data 8
736 9 Initial data 9
737 10 Initial data 10
738 **** Secondary ****
739 select * from test.t1 order by a;
740 a b
741 1 Initial data 1
742 2 Primary first change 2
743 3 Initial data 3
744 4 Initial data 4
745 5 Initial data 5
746 6 Initial data 6
747 7 Initial data 7
748 8 Initial data 8
749 9 Initial data 9
750 10 Initial data 10
751 select * from test.t2 order by a;
752 a b
753 1 Initial data 1
754 2 Initial data 2
755 3 Initial data 3
756 4 Initial data 4
757 5 Initial data 5
758 6 Initial data 6
759 7 Initial data 7
760 8 Initial data 8
761 9 Initial data 9
762 10 Initial data 10
763 update test.t1 set b="Initial data 1" where a=1;
764 update test.t1 set b="Initial data 2" where a=2;
765 update test.t2 set b="Initial data 3" where a=3;
766 Sync all changes
767 ---------------------------------------
768 delete from test.t1$EX;
769 delete from test.t2$EX;
770 Test 5, read-update conflict with read tracking on unique secondary index
771 create table test.t3$EX
772 (NDB$SERVER_ID int unsigned,
773 NDB$MASTER_SERVER_ID int unsigned,
774 NDB$MASTER_EPOCH bigint unsigned,
775 NDB$COUNT int unsigned,
776 a int not null,
777 b$old varchar(2000),
778 b$new varchar(2000),
779 c$old int,
780 c$new int,
781 d$old int,
782 d$new int,
783 NDB$OP_TYPE ENUM('WRITE_ROW','UPDATE_ROW','DELETE_ROW','REFRESH_ROW','READ_ROW') NOT NULL,
784 NDB$CFT_CAUSE ENUM('ROW_DOES_NOT_EXIST','ROW_ALREADY_EXISTS','DATA_IN_CONFLICT','TRANS_IN_CONFLICT') NOT NULL,
785 NDB$ORIG_TRANSID BIGINT UNSIGNED NOT NULL,
786 primary key(NDB$SERVER_ID, NDB$MASTER_SERVER_ID, NDB$MASTER_EPOCH, NDB$COUNT))
787 ENGINE=NDB CHARACTER SET latin1;
788 Populate ndb_replication table as necessary
789 replace into mysql.ndb_replication values
790 ("test", "t3", 3, 7, NULL),
791 ("test", "t3", 1, 7, "NDB$EPOCH_TRANS()");
792 create table test.t3 (
793 a int primary key,
794 b varchar(2000),
795 c int not null unique,
796 d int,
797 key(d)) engine=ndb character set latin1;
798 Add some data
799 insert into test.t3 values
800 (1, "Initial data 1", 1, 1),
801 (2, "Initial data 2", 2, 2),
802 (3, "Initial data 3", 3, 3),
803 (4, "Initial data 4", 4, 4),
804 (5, "Initial data 5", 5, 5),
805 (6, "Initial data 6", 6, 6),
806 (7, "Initial data 7", 7, 7),
807 (8, "Initial data 8", 8, 8),
808 (9, "Initial data 9", 9, 9),
809 (10, "Initial data 10", 10, 10);
810 Show basic read tracking
811 ---------------------------------------
812 Stopping secondary replica
813 stop replica;
814 Stopping primary replica
815 stop replica;
816 begin;
817 update test.t3 set b="Primary first change 1" where a=1;
818 update test.t3 set b="Primary first change 2" where a=2;
819 commit;
820 SET ndb_log_exclusive_reads= 1;
821 begin;
822 select * from test.t3 where c = 1 for update;
823 a b c d
824 1 Initial data 1 1 1
825 update test.t2 set b="Secondary first change 3" where a=3;
826 commit;
827 Checking tables before conflict resolution
828 ---------------------------------------
829 **** Primary ****
830 select * from test.t2 order by a;
831 a b
832 1 Initial data 1
833 2 Initial data 2
834 3 Initial data 3
835 4 Initial data 4
836 5 Initial data 5
837 6 Initial data 6
838 7 Initial data 7
839 8 Initial data 8
840 9 Initial data 9
841 10 Initial data 10
842 select * from test.t3 order by a;
843 a b c d
844 1 Primary first change 1 1 1
845 2 Primary first change 2 2 2
846 3 Initial data 3 3 3
847 4 Initial data 4 4 4
848 5 Initial data 5 5 5
849 6 Initial data 6 6 6
850 7 Initial data 7 7 7
851 8 Initial data 8 8 8
852 9 Initial data 9 9 9
853 10 Initial data 10 10 10
854 Starting primary replica
855 start replica;
856 **** Secondary ****
857 select * from test.t2 order by a;
858 a b
859 1 Initial data 1
860 2 Initial data 2
861 3 Secondary first change 3
862 4 Initial data 4
863 5 Initial data 5
864 6 Initial data 6
865 7 Initial data 7
866 8 Initial data 8
867 9 Initial data 9
868 10 Initial data 10
869 select * from test.t3 order by a;
870 a b c d
871 1 Initial data 1 1 1
872 2 Initial data 2 2 2
873 3 Initial data 3 3 3
874 4 Initial data 4 4 4
875 5 Initial data 5 5 5
876 6 Initial data 6 6 6
877 7 Initial data 7 7 7
878 8 Initial data 8 8 8
879 9 Initial data 9 9 9
880 10 Initial data 10 10 10
881 Primary should have rejected change from Secondary, keeping its value
882 select * from test.t2 order by a;
883 a b
884 1 Initial data 1
885 2 Initial data 2
886 3 Initial data 3
887 4 Initial data 4
888 5 Initial data 5
889 6 Initial data 6
890 7 Initial data 7
891 8 Initial data 8
892 9 Initial data 9
893 10 Initial data 10
894 select * from test.t3 order by a;
895 a b c d
896 1 Primary first change 1 1 1
897 2 Primary first change 2 2 2
898 3 Initial data 3 3 3
899 4 Initial data 4 4 4
900 5 Initial data 5 5 5
901 6 Initial data 6 6 6
902 7 Initial data 7 7 7
903 8 Initial data 8 8 8
904 9 Initial data 9 9 9
905 10 Initial data 10 10 10
906 ndb_conflict_fn_epoch_trans
907 1
908 ndb_conflict_fn_epoch2_trans
909 0
910 ndb_conflict_trans_row_conflict_count
911 1
912 ndb_conflict_trans_row_reject_count
913 2
914 ndb_conflict_trans_reject_count
915 1
916 ndb_conflict_trans_detect_iter_count
917 1
918 ndb_conflict_trans_conflict_commit_count
919 1
920 ndb_epoch_delete_delete_count
921 0
922 select NDB$OP_TYPE, b$old, b$new, c$old, c$new, NDB$CFT_CAUSE from test.t3$EX
923 order by a;
924 NDB$OP_TYPE b$old b$new c$old c$new NDB$CFT_CAUSE
925 READ_ROW Initial data 1 Initial data 1 1 1 TRANS_IN_CONFLICT
926 starting secondary replica
927 start replica;
928 Secondary should have been realigned to Primary
929 **** Primary ****
930 select * from test.t2 order by a;
931 a b
932 1 Initial data 1
933 2 Initial data 2
934 3 Initial data 3
935 4 Initial data 4
936 5 Initial data 5
937 6 Initial data 6
938 7 Initial data 7
939 8 Initial data 8
940 9 Initial data 9
941 10 Initial data 10
942 select * from test.t3 order by a;
943 a b c d
944 1 Primary first change 1 1 1
945 2 Primary first change 2 2 2
946 3 Initial data 3 3 3
947 4 Initial data 4 4 4
948 5 Initial data 5 5 5
949 6 Initial data 6 6 6
950 7 Initial data 7 7 7
951 8 Initial data 8 8 8
952 9 Initial data 9 9 9
953 10 Initial data 10 10 10
954 **** Secondary ****
955 select * from test.t2 order by a;
956 a b
957 1 Initial data 1
958 2 Initial data 2
959 3 Initial data 3
960 4 Initial data 4
961 5 Initial data 5
962 6 Initial data 6
963 7 Initial data 7
964 8 Initial data 8
965 9 Initial data 9
966 10 Initial data 10
967 select * from test.t3 order by a;
968 a b c d
969 1 Primary first change 1 1 1
970 2 Primary first change 2 2 2
971 3 Initial data 3 3 3
972 4 Initial data 4 4 4
973 5 Initial data 5 5 5
974 6 Initial data 6 6 6
975 7 Initial data 7 7 7
976 8 Initial data 8 8 8
977 9 Initial data 9 9 9
978 10 Initial data 10 10 10
979 update test.t2 set b="Initial data 3" where a=3;
980 update test.t3 set b="Initial data 1" where a=1;
981 update test.t3 set b="Initial data 2" where a=2;
982 Sync all changes
983 ---------------------------------------
984 delete from test.t2$EX;
985 delete from test.t3$EX;
986 Test 6, read-update conflict with read tracking on ordered secondary index
987 Show basic read tracking
988 ---------------------------------------
989 Stopping secondary replica
990 stop replica;
991 Stopping primary replica
992 stop replica;
993 begin;
994 update test.t3 set b="Primary first change 1" where a=1;
995 update test.t3 set b="Primary first change 2" where a=2;
996 commit;
997 SET ndb_log_exclusive_reads= 1;
998 begin;
999 select * from test.t3 where d = 1 for update;
1000 a b c d
1001 1 Initial data 1 1 1
1002 update test.t2 set b="Secondary first change 3" where a=3;
1003 commit;
1004 Checking tables before conflict resolution
1005 ---------------------------------------
1006 **** Primary ****
1007 select * from test.t2 order by a;
1008 a b
1009 1 Initial data 1
1010 2 Initial data 2
1011 3 Initial data 3
1012 4 Initial data 4
1013 5 Initial data 5
1014 6 Initial data 6
1015 7 Initial data 7
1016 8 Initial data 8
1017 9 Initial data 9
1018 10 Initial data 10
1019 select * from test.t3 order by a;
1020 a b c d
1021 1 Primary first change 1 1 1
1022 2 Primary first change 2 2 2
1023 3 Initial data 3 3 3
1024 4 Initial data 4 4 4
1025 5 Initial data 5 5 5
1026 6 Initial data 6 6 6
1027 7 Initial data 7 7 7
1028 8 Initial data 8 8 8
1029 9 Initial data 9 9 9
1030 10 Initial data 10 10 10
1031 Starting primary replica
1032 start replica;
1033 **** Secondary ****
1034 select * from test.t2 order by a;
1035 a b
1036 1 Initial data 1
1037 2 Initial data 2
1038 3 Secondary first change 3
1039 4 Initial data 4
1040 5 Initial data 5
1041 6 Initial data 6
1042 7 Initial data 7
1043 8 Initial data 8
1044 9 Initial data 9
1045 10 Initial data 10
1046 select * from test.t3 order by a;
1047 a b c d
1048 1 Initial data 1 1 1
1049 2 Initial data 2 2 2
1050 3 Initial data 3 3 3
1051 4 Initial data 4 4 4
1052 5 Initial data 5 5 5
1053 6 Initial data 6 6 6
1054 7 Initial data 7 7 7
1055 8 Initial data 8 8 8
1056 9 Initial data 9 9 9
1057 10 Initial data 10 10 10
1058 Primary should have rejected change from Secondary, keeping its value
1059 select * from test.t2 order by a;
1060 a b
1061 1 Initial data 1
1062 2 Initial data 2
1063 3 Initial data 3
1064 4 Initial data 4
1065 5 Initial data 5
1066 6 Initial data 6
1067 7 Initial data 7
1068 8 Initial data 8
1069 9 Initial data 9
1070 10 Initial data 10
1071 select * from test.t3 order by a;
1072 a b c d
1073 1 Primary first change 1 1 1
1074 2 Primary first change 2 2 2
1075 3 Initial data 3 3 3
1076 4 Initial data 4 4 4
1077 5 Initial data 5 5 5
1078 6 Initial data 6 6 6
1079 7 Initial data 7 7 7
1080 8 Initial data 8 8 8
1081 9 Initial data 9 9 9
1082 10 Initial data 10 10 10
1083 ndb_conflict_fn_epoch_trans
1084 1
1085 ndb_conflict_fn_epoch2_trans
1086 0
1087 ndb_conflict_trans_row_conflict_count
1088 1
1089 ndb_conflict_trans_row_reject_count
1090 2
1091 ndb_conflict_trans_reject_count
1092 1
1093 ndb_conflict_trans_detect_iter_count
1094 1
1095 ndb_conflict_trans_conflict_commit_count
1096 1
1097 ndb_epoch_delete_delete_count
1098 0
1099 select NDB$OP_TYPE, b$old, b$new, c$old, c$new, NDB$CFT_CAUSE from test.t3$EX
1100 order by a;
1101 NDB$OP_TYPE b$old b$new c$old c$new NDB$CFT_CAUSE
1102 READ_ROW Initial data 1 Initial data 1 1 1 TRANS_IN_CONFLICT
1103 starting secondary replica
1104 start replica;
1105 Secondary should have been realigned to Primary
1106 **** Primary ****
1107 select * from test.t2 order by a;
1108 a b
1109 1 Initial data 1
1110 2 Initial data 2
1111 3 Initial data 3
1112 4 Initial data 4
1113 5 Initial data 5
1114 6 Initial data 6
1115 7 Initial data 7
1116 8 Initial data 8
1117 9 Initial data 9
1118 10 Initial data 10
1119 select * from test.t3 order by a;
1120 a b c d
1121 1 Primary first change 1 1 1
1122 2 Primary first change 2 2 2
1123 3 Initial data 3 3 3
1124 4 Initial data 4 4 4
1125 5 Initial data 5 5 5
1126 6 Initial data 6 6 6
1127 7 Initial data 7 7 7
1128 8 Initial data 8 8 8
1129 9 Initial data 9 9 9
1130 10 Initial data 10 10 10
1131 **** Secondary ****
1132 select * from test.t2 order by a;
1133 a b
1134 1 Initial data 1
1135 2 Initial data 2
1136 3 Initial data 3
1137 4 Initial data 4
1138 5 Initial data 5
1139 6 Initial data 6
1140 7 Initial data 7
1141 8 Initial data 8
1142 9 Initial data 9
1143 10 Initial data 10
1144 select * from test.t3 order by a;
1145 a b c d
1146 1 Primary first change 1 1 1
1147 2 Primary first change 2 2 2
1148 3 Initial data 3 3 3
1149 4 Initial data 4 4 4
1150 5 Initial data 5 5 5
1151 6 Initial data 6 6 6
1152 7 Initial data 7 7 7
1153 8 Initial data 8 8 8
1154 9 Initial data 9 9 9
1155 10 Initial data 10 10 10
1156 update test.t2 set b="Initial data 3" where a=3;
1157 update test.t3 set b="Initial data 1" where a=1;
1158 update test.t3 set b="Initial data 2" where a=2;
1159 Sync all changes
1160 ---------------------------------------
1161 delete from test.t2$EX;
1162 delete from test.t3$EX;
1163 Test 7, read-update conflict with read tracking on table scan
1164 Show basic read tracking
1165 ---------------------------------------
1166 Stopping secondary replica
1167 stop replica;
1168 Stopping primary replica
1169 stop replica;
1170 begin;
1171 update test.t3 set b="Primary first change 1" where a=1;
1172 update test.t3 set b="Primary first change 2" where a=2;
1173 commit;
1174 SET ndb_log_exclusive_reads= 1;
1175 begin;
1176 select * from test.t3 where b like "Initial data 1" for update;
1177 a b c d
1178 1 Initial data 1 1 1
1179 update test.t2 set b="Secondary first change 3" where a=3;
1180 commit;
1181 Checking tables before conflict resolution
1182 ---------------------------------------
1183 **** Primary ****
1184 select * from test.t2 order by a;
1185 a b
1186 1 Initial data 1
1187 2 Initial data 2
1188 3 Initial data 3
1189 4 Initial data 4
1190 5 Initial data 5
1191 6 Initial data 6
1192 7 Initial data 7
1193 8 Initial data 8
1194 9 Initial data 9
1195 10 Initial data 10
1196 select * from test.t3 order by a;
1197 a b c d
1198 1 Primary first change 1 1 1
1199 2 Primary first change 2 2 2
1200 3 Initial data 3 3 3
1201 4 Initial data 4 4 4
1202 5 Initial data 5 5 5
1203 6 Initial data 6 6 6
1204 7 Initial data 7 7 7
1205 8 Initial data 8 8 8
1206 9 Initial data 9 9 9
1207 10 Initial data 10 10 10
1208 Starting primary replica
1209 start replica;
1210 **** Secondary ****
1211 select * from test.t2 order by a;
1212 a b
1213 1 Initial data 1
1214 2 Initial data 2
1215 3 Secondary first change 3
1216 4 Initial data 4
1217 5 Initial data 5
1218 6 Initial data 6
1219 7 Initial data 7
1220 8 Initial data 8
1221 9 Initial data 9
1222 10 Initial data 10
1223 select * from test.t3 order by a;
1224 a b c d
1225 1 Initial data 1 1 1
1226 2 Initial data 2 2 2
1227 3 Initial data 3 3 3
1228 4 Initial data 4 4 4
1229 5 Initial data 5 5 5
1230 6 Initial data 6 6 6
1231 7 Initial data 7 7 7
1232 8 Initial data 8 8 8
1233 9 Initial data 9 9 9
1234 10 Initial data 10 10 10
1235 Primary should have rejected change from Secondary, keeping its value
1236 select * from test.t2 order by a;
1237 a b
1238 1 Initial data 1
1239 2 Initial data 2
1240 3 Initial data 3
1241 4 Initial data 4
1242 5 Initial data 5
1243 6 Initial data 6
1244 7 Initial data 7
1245 8 Initial data 8
1246 9 Initial data 9
1247 10 Initial data 10
1248 select * from test.t3 order by a;
1249 a b c d
1250 1 Primary first change 1 1 1
1251 2 Primary first change 2 2 2
1252 3 Initial data 3 3 3
1253 4 Initial data 4 4 4
1254 5 Initial data 5 5 5
1255 6 Initial data 6 6 6
1256 7 Initial data 7 7 7
1257 8 Initial data 8 8 8
1258 9 Initial data 9 9 9
1259 10 Initial data 10 10 10
1260 ndb_conflict_fn_epoch_trans
1261 1
1262 ndb_conflict_fn_epoch2_trans
1263 0
1264 ndb_conflict_trans_row_conflict_count
1265 1
1266 ndb_conflict_trans_row_reject_count
1267 2
1268 ndb_conflict_trans_reject_count
1269 1
1270 ndb_conflict_trans_detect_iter_count
1271 1
1272 ndb_conflict_trans_conflict_commit_count
1273 1
1274 ndb_epoch_delete_delete_count
1275 0
1276 select NDB$OP_TYPE, b$old, b$new, c$old, c$new, NDB$CFT_CAUSE from test.t3$EX
1277 order by a;
1278 NDB$OP_TYPE b$old b$new c$old c$new NDB$CFT_CAUSE
1279 READ_ROW Initial data 1 Initial data 1 1 1 TRANS_IN_CONFLICT
1280 starting secondary replica
1281 start replica;
1282 Secondary should have been realigned to Primary
1283 **** Primary ****
1284 select * from test.t2 order by a;
1285 a b
1286 1 Initial data 1
1287 2 Initial data 2
1288 3 Initial data 3
1289 4 Initial data 4
1290 5 Initial data 5
1291 6 Initial data 6
1292 7 Initial data 7
1293 8 Initial data 8
1294 9 Initial data 9
1295 10 Initial data 10
1296 select * from test.t3 order by a;
1297 a b c d
1298 1 Primary first change 1 1 1
1299 2 Primary first change 2 2 2
1300 3 Initial data 3 3 3
1301 4 Initial data 4 4 4
1302 5 Initial data 5 5 5
1303 6 Initial data 6 6 6
1304 7 Initial data 7 7 7
1305 8 Initial data 8 8 8
1306 9 Initial data 9 9 9
1307 10 Initial data 10 10 10
1308 **** Secondary ****
1309 select * from test.t2 order by a;
1310 a b
1311 1 Initial data 1
1312 2 Initial data 2
1313 3 Initial data 3
1314 4 Initial data 4
1315 5 Initial data 5
1316 6 Initial data 6
1317 7 Initial data 7
1318 8 Initial data 8
1319 9 Initial data 9
1320 10 Initial data 10
1321 select * from test.t3 order by a;
1322 a b c d
1323 1 Primary first change 1 1 1
1324 2 Primary first change 2 2 2
1325 3 Initial data 3 3 3
1326 4 Initial data 4 4 4
1327 5 Initial data 5 5 5
1328 6 Initial data 6 6 6
1329 7 Initial data 7 7 7
1330 8 Initial data 8 8 8
1331 9 Initial data 9 9 9
1332 10 Initial data 10 10 10
1333 update test.t2 set b="Initial data 3" where a=3;
1334 update test.t3 set b="Initial data 1" where a=1;
1335 update test.t3 set b="Initial data 2" where a=2;
1336 Sync all changes
1337 ---------------------------------------
1338 delete from test.t2$EX;
1339 delete from test.t3$EX;
1340 drop table mysql.ndb_replication;
1341 drop table test.t1, test.t2, test.t3;
1342 drop table test.t1$EX, test.t2$EX, test.t3$EX;
1343 SET ndb_log_exclusive_reads= 0;
1344 flush logs;
1345 stop replica;
1346 reset replica;
1347 include/rpl_end.inc