Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/transactional_ddl_locking.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 # Prepare playground for test by creating tables
7 CREATE TABLE t1 (a INT) ;
8 CREATE TABLE t2 (a INT PRIMARY KEY, b INT);
9 CREATE TABLE t3 (a INT);
10 CREATE TABLE t4 (a INT);
11 CREATE TABLE t1part (id INT, year_col INT);
12 CREATE TABLE t2part (id INT, year_col INT)
13 PARTITION BY RANGE (year_col) (
14 PARTITION p0 VALUES LESS THAN (1991),
15 PARTITION p1 VALUES LESS THAN (1995),
16 PARTITION p2 VALUES LESS THAN (2013));
17 CREATE TABLE t3part (id INT, year_col INT)
18 PARTITION BY HASH(year_col)
19 PARTITIONS 4;
20 CREATE TABLE t4part (id INT, year_col INT)
21 PARTITION BY RANGE (year_col) (
22 PARTITION p0 VALUES LESS THAN (1970),
23 PARTITION p1 VALUES LESS THAN (1995),
24 PARTITION p2 VALUES LESS THAN (2013));
25 CREATE TABLE t1prim (a INT, b INT PRIMARY KEY);
26 CREATE TABLE t1opt (id INT , content TEXT, author_id INT,
27 article_title VARCHAR(120), article_hash INT);
28 CREATE TABLE t1bin (c INT);
29 CREATE TABLE t2bin SELECT * FROM t1bin;
30 CREATE TABLE t1myisam (c INT) ENGINE = MYISAM;
31 CREATE TABLE t1innodb (c INT) ENGINE = INNODB;
32 CREATE TABLE t3967_1 (id INT(11) NOT NULL AUTO_INCREMENT,
33 b INT(11) DEFAULT NULL, PRIMARY KEY (id))
34 ENGINE = INNODB;
35 Warnings:
36 Warning 1681 Integer display width is deprecated and will be removed in a future release.
37 Warning 1681 Integer display width is deprecated and will be removed in a future release.
38 CREATE TABLE t3967_2 (id INT(11) NOT NULL AUTO_INCREMENT,
39 b INT(11) DEFAULT NULL, PRIMARY KEY (id))
40 ENGINE = INNODB;
41 Warnings:
42 Warning 1681 Integer display width is deprecated and will be removed in a future release.
43 Warning 1681 Integer display width is deprecated and will be removed in a future release.
44 CREATE TABLE `t1_30138` (id INT) ENGINE = INNODB;
45 COMMIT;
46 --- connection master ---
47 BEGIN;
48 INSERT INTO t1 VALUES (1);
49 --- connection master1 ---
50 SET SESSION lock_wait_timeout = 1;
51 send statement and reap result later ---
52 DROP TABLE t1;;
53 --- connection master2 ---
54 --- connection master1 ---
55 reap result of previous ---
56 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
57 --- connection master ---
58 COMMIT;
59 --- connection slave ---
60 SELECT COUNT(*) FROM t1 ;
61 COUNT(*)
62 1
63 --- connection master ---
64 SELECT COUNT(*) FROM t1 ;
65 COUNT(*)
66 1
67 include/diff_tables.inc [master:t1, slave:t1]
68 --- connection master ---
69 BEGIN;
70 INSERT INTO t1 VALUES (1);
71 --- connection master1 ---
72 SET SESSION lock_wait_timeout = 1;
73 send statement and reap result later ---
74 ALTER TABLE t1 RENAME TO t1new;;
75 --- connection master2 ---
76 --- connection master1 ---
77 reap result of previous---
78 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
79 --- connection master ---
80 COMMIT;
81 --- connection slave ---
82 SELECT COUNT(*) FROM t1 ;
83 COUNT(*)
84 2
85 --- connection master ---
86 SELECT COUNT(*) FROM t1 ;
87 COUNT(*)
88 2
89 include/diff_tables.inc [master:t1, slave:t1]
90 --- connection master ---
91 BEGIN;
92 INSERT INTO t2 VALUES (1,1);
93 --- connection master1 ---
94 SET SESSION lock_wait_timeout = 1;
95 send statement and reap result later ---
96 ALTER TABLE t2 DROP COLUMN a;;
97 --- connection master2 ---
98 --- connection master1 ---
99 reap result of previous---
100 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
101 --- connection master ---
102 COMMIT;
103 --- connection slave ---
104 SELECT COUNT(*) FROM t2 ;
105 COUNT(*)
106 1
107 --- connection master ---
108 SELECT COUNT(*) FROM t2 ;
109 COUNT(*)
110 1
111 include/diff_tables.inc [master:t2, slave:t2]
112 --- connection master ---
113 BEGIN;
114 UPDATE t1 SET a = 2;
115 --- connection master1 ---
116 SET SESSION lock_wait_timeout = 1;
117 send statement and reap result later ---
118 ALTER TABLE t1 ADD COLUMN b INT;;
119 --- connection master2 ---
120 --- connection master1 ---
121 reap result of previous---
122 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
123 --- connection master ---
124 COMMIT;
125 --- connection slave ---
126 SELECT COUNT(*) FROM t1 ;
127 COUNT(*)
128 2
129 --- connection master ---
130 SELECT COUNT(*) FROM t1 ;
131 COUNT(*)
132 2
133 include/diff_tables.inc [master:t1, slave:t1]
134 --- connection master ---
135 BEGIN;
136 INSERT INTO t1 VALUES (1);
137 --- connection master1 ---
138 SET SESSION lock_wait_timeout = 1;
139 send statement and reap result later ---
140 RENAME TABLE t1 to t2new;;
141 --- connection master2 ---
142 --- connection master1 ---
143 reap result of previous---
144 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
145 --- connection master ---
146 COMMIT;
147 --- connection slave ---
148 SELECT COUNT(*) FROM t1 ;
149 COUNT(*)
150 3
151 --- connection master ---
152 SELECT COUNT(*) FROM t1 ;
153 COUNT(*)
154 3
155 include/diff_tables.inc [master:t1, slave:t1]
156 --- connection master ---
157 BEGIN;
158 INSERT INTO t1 VALUES (1);
159 --- connection master1 ---
160 SET SESSION lock_wait_timeout = 1;
161 send statement and reap result later ---
162 ALTER TABLE t1 MODIFY a bigINT COMMENT 'first';;
163 --- connection master2 ---
164 --- connection master1 ---
165 reap result of previous---
166 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
167 COMMIT;
168 SELECT COUNT(*) FROM t1 ;
169 COUNT(*)
170 4
171 SELECT COUNT(*) FROM t1 ;
172 COUNT(*)
173 4
174 include/diff_tables.inc [master:t1, slave:t1]
175 --- connection master ---
176 BEGIN;
177 UPDATE t1 SET a = 1;
178 --- connection master1 --
179 SET SESSION lock_wait_timeout = 1;
180 send statement and reap result later ---
181 ALTER TABLE t1 ADD PRIMARY KEY (a);;
182 --- connection master2 ---
183 --- connection master1 ---
184 reap result of previous---
185 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
186 --- connection master ---
187 COMMIT;
188 --- connection slave ---
189 SELECT COUNT(*) FROM t1 ;
190 COUNT(*)
191 4
192 --- connection master ---
193 SELECT COUNT(*) FROM t1 ;
194 COUNT(*)
195 4
196 include/diff_tables.inc [master:t1, slave:t1]
197 --- connection master ---
198 BEGIN;
199 UPDATE t1 SET a = 1;
200 --- connection master1 ---
201 SET SESSION lock_wait_timeout = 1;
202 send statement and reap result later ---
203 ALTER TABLE t1 ADD FOREIGN KEY (a) REFERENCES t2 (a) ;;
204 --- connection master2 ---
205 --- connection master1 ---
206 reap result of previous---
207 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
208 --- connection master ---
209 COMMIT;
210 --- connection slave ---
211 SELECT COUNT(*) FROM t1 ;
212 COUNT(*)
213 4
214 --- connection master ---
215 SELECT COUNT(*) FROM t1 ;
216 COUNT(*)
217 4
218 include/diff_tables.inc [master:t1, slave:t1]
219 --- connection master ---
220 BEGIN;
221 UPDATE t1 SET a = 1;
222 --- connection master1 ---
223 SET SESSION lock_wait_timeout = 1;
224 send statement and reap result later ---
225 ALTER TABLE t1 ALTER a SET DEFAULT 1;;
226 --- connection master2 ---
227 --- connection master1 ---
228 reap result of previous---
229 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
230 --- connection master ---
231 COMMIT;
232 --- connection slave ---
233 SELECT COUNT(*) FROM t1 ;
234 COUNT(*)
235 4
236 --- connection master ---
237 SELECT COUNT(*) FROM t1 ;
238 COUNT(*)
239 4
240 include/diff_tables.inc [master:t1, slave:t1]
241 --- connection master ---
242 BEGIN;
243 UPDATE t1 SET a = 1;
244 --- connection master1 ---
245 SET SESSION lock_wait_timeout = 1;
246 send statement and reap result later ---
247 ALTER TABLE t1 CHANGE a b smallINT;;
248 --- connection master2 ---
249 --- connection master1 ---
250 reap result of previous---
251 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
252 --- connection master ---
253 COMMIT;
254 --- connection slave ---
255 SELECT COUNT(*) FROM t1 ;
256 COUNT(*)
257 4
258 --- connection master ---
259 SELECT COUNT(*) FROM t1 ;
260 COUNT(*)
261 4
262 include/diff_tables.inc [master:t1, slave:t1]
263 --- connection master ---
264 INSERT INTO t1 VALUES(1);
265 BEGIN;
266 UPDATE t1 SET a = 1;
267 --- connection master1 ---
268 SET SESSION lock_wait_timeout = 1;
269 send statement and reap result later ---
270 ALTER TABLE t1 MODIFY a INTEGER;;
271 --- connection master2 ---
272 --- connection master1 ---
273 reap result of previous---
274 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
275 --- connection master ---
276 COMMIT;
277 --- connection slave ---
278 SELECT COUNT(*) FROM t1 ;
279 COUNT(*)
280 5
281 --- connection master ---
282 SELECT COUNT(*) FROM t1 ;
283 COUNT(*)
284 5
285 include/diff_tables.inc [master:t1, slave:t1]
286 --- connection master ---
287 INSERT INTO t1prim VALUES (1,1);
288 INSERT INTO t1prim VALUES (2,2);
289 COMMIT;
290 BEGIN;
291 UPDATE t1prim SET b = 4 WHERE a = 1;
292 --- connection master1 ---
293 SET SESSION lock_wait_timeout = 1;
294 send statement and reap result later ---
295 ALTER TABLE t1prim DROP PRIMARY KEY;;
296 --- connection master2 ---
297 --- connection master1 ---
298 reap result of previous---
299 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
300 --- connection master ---
301 COMMIT;
302 --- connection slave ---
303 SELECT COUNT(*) FROM t1prim ;
304 COUNT(*)
305 2
306 --- connection master ---
307 SELECT COUNT(*) FROM t1prim ;
308 COUNT(*)
309 2
310 include/diff_tables.inc [master:t1prim, slave:t1prim]
311 --- connection master ---
312 BEGIN;
313 UPDATE t1 SET a = 1;
314 --- connection master1 ---
315 SET SESSION lock_wait_timeout = 1;
316 send statement and reap result later ---
317 ALTER TABLE t1 disable KEYS;;
318 --- connection master2 ---
319 --- connection master1 ---
320 reap result of previous---
321 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
322 --- connection master ---
323 COMMIT;
324 --- connection slave ---
325 SELECT COUNT(*) FROM t1 ;
326 COUNT(*)
327 5
328 --- connection master ---
329 SELECT COUNT(*) FROM t1 ;
330 COUNT(*)
331 5
332 include/diff_tables.inc [master:t1, slave:t1]
333 --- connection master ---
334 INSERT INTO t1part VALUES(1, '1998');
335 INSERT INTO t1part VALUES(2, '2012');
336 BEGIN;
337 INSERT INTO t1part SELECT * FROM t1part;
338 --- connection master1 ---
339 SET SESSION lock_wait_timeout = 1;
340 send statement and reap result later ---
341 ALTER TABLE t1part PARTITION BY HASH(id) PARTITIONS 2 ;;
342 --- connection master2 ---
343 --- connection master1 ---
344 reap result of previous---
345 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
346 --- connection master ---
347 COMMIT;
348 --- connection slave ---
349 SELECT COUNT(*) FROM t1part;
350 COUNT(*)
351 4
352 --- connection master ---
353 SELECT COUNT(*) FROM t1part;
354 COUNT(*)
355 4
356 include/diff_tables.inc [master:t1part, slave:t1part]
357 --- connection master ---
358 INSERT INTO t2part VALUES (1, '1988');
359 BEGIN;
360 INSERT INTO t2part VALUES (2, '1998');
361 --- connection master1 ---
362 SET SESSION lock_wait_timeout = 1;
363 send statement and reap result later ---
364 ALTER TABLE t2part ADD PARTITION (PARTITION p3 VALUES LESS THAN (2015));;
365 --- connection master2 ---
366 --- connection master1 ---
367 reap result of previous---
368 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
369 --- connection master ---
370 COMMIT;
371 --- connection slave ---
372 SELECT COUNT(*) FROM t2part;
373 COUNT(*)
374 2
375 --- connection master ---
376 SELECT COUNT(*) FROM t2part;
377 COUNT(*)
378 2
379 include/diff_tables.inc [master:t2part, slave:t2part]
380 --- connection master ---
381 INSERT INTO t2part VALUES (1, '1912');
382 BEGIN;
383 INSERT INTO t2part VALUES (2, '1978');
384 --- connection master1 ---
385 SET SESSION lock_wait_timeout = 1;
386 send statement and reap result later ---
387 ALTER TABLE t2part Drop PARTITION p1 ;;
388 --- connection master2 ---
389 --- connection master1 ---
390 reap result of previous---
391 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
392 --- connection master ---
393 COMMIT;
394 --- connection slave ---
395 SELECT COUNT(*) FROM t2part;
396 COUNT(*)
397 4
398 --- connection master ---
399 SELECT COUNT(*) FROM t2part;
400 COUNT(*)
401 4
402 include/diff_tables.inc [master:t2part, slave:t2part]
403 --- connection master ---
404 INSERT INTO t3part VALUES (1, '1902');
405 BEGIN;
406 INSERT INTO t3part VALUES (2, '1965');
407 --- connection master1 ---
408 SET SESSION lock_wait_timeout = 1;
409 send statement and reap result later ---
410 ALTER TABLE t3part COALESCE PARTITION 2 ;;
411 --- connection master2 ---
412 --- connection master1 ---
413 reap result of previous---
414 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
415 --- connection master ---
416 COMMIT;
417 --- connection slave ---
418 SELECT COUNT(*) FROM t3part;
419 COUNT(*)
420 2
421 --- connection master ---
422 SELECT COUNT(*) FROM t3part;
423 COUNT(*)
424 2
425 include/diff_tables.inc [master:t3part, slave:t3part]
426 --- connection master ---
427 INSERT INTO t4part VALUES (1, '1932');
428 --- connection master ---
429 BEGIN;
430 INSERT INTO t4part VALUES (2, '1998');
431 --- connection master1 ---
432 SET SESSION lock_wait_timeout = 1;
433 send statement and reap result later ---
434 ALTER TABLE t4part REORGANIZE PARTITION p0,p1 INTO (PARTITION s0 VALUES LESS THAN (1995));;
435 --- connection master2 ---
436 --- connection master1 ---
437 reap result of previous---
438 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
439 --- connection master ---
440 COMMIT;
441 --- connection slave ---
442 SELECT COUNT(*) FROM t4part ;
443 COUNT(*)
444 2
445 --- connection master ---
446 SELECT COUNT(*) FROM t4part ;
447 COUNT(*)
448 2
449 include/diff_tables.inc [master:t4part, slave:t4part]
450 --- connection master ---
451 INSERT INTO t2part VALUES (3, '1892');
452 --- connection master ---
453 BEGIN;
454 INSERT INTO t2part VALUES (4, '2012');
455 --- connection master1 ---
456 SET SESSION lock_wait_timeout = 1;
457 send statement and reap result later ---
458 ALTER TABLE t2part CHECK PARTITION ALL;;
459 --- connection master2 ---
460 --- connection master1 ---
461 reap result of previous---
462 Table Op Msg_type Msg_text
463 test.t2part check status OK
464 --- connection master ---
465 COMMIT;
466 --- connection slave ---
467 SELECT COUNT(*) FROM t2part ;
468 COUNT(*)
469 6
470 --- connection master ---
471 SELECT COUNT(*) FROM t2part ;
472 COUNT(*)
473 6
474 include/diff_tables.inc [master:t2part, slave:t2part]
475 --- connection master ---
476 INSERT INTO t2part VALUES (5, '1975');
477 BEGIN;
478 INSERT INTO t2part VALUES (6, '1980');
479 --- connection master1 ---
480 SET SESSION lock_wait_timeout = 1;
481 send statement and reap result later ---
482 ALTER TABLE t2part CHECK PARTITION ALL;;
483 --- connection master2 ---
484 --- connection master1 ---
485 reap result of previous---
486 Table Op Msg_type Msg_text
487 test.t2part check status OK
488 --- connection master ---
489 COMMIT;
490 --- connection slave ---
491 SELECT COUNT(*) FROM t2part ;
492 COUNT(*)
493 8
494 --- connection master ---
495 SELECT COUNT(*) FROM t2part ;
496 COUNT(*)
497 8
498 include/diff_tables.inc [master:t2part, slave:t2part]
499 --- connection master ---
500 INSERT INTO t2part VALUES (7, '1912');
501 BEGIN;
502 INSERT INTO t2part VALUES (8, '1998');
503 --- connection master1 ---
504 SET SESSION lock_wait_timeout = 1;
505 send statement and reap result later ---
506 ALTER TABLE t2part OPTIMIZE PARTITION ALL;;
507 --- connection master2 ---
508 --- connection master1 ---
509 reap result of previous---
510 Table Op Msg_type Msg_text
511 test.t2part optimize Error Lock wait timeout exceeded; try restarting transaction
512 test.t2part optimize status Operation failed
513 --- connection master ---
514 COMMIT;
515 --- connection slave ---
516 SELECT COUNT(*) FROM t2part ;
517 COUNT(*)
518 10
519 --- connection master ---
520 SELECT COUNT(*) FROM t2part ;
521 COUNT(*)
522 10
523 include/diff_tables.inc [master:t2part, slave:t2part]
524 --- connection master ---
525 INSERT INTO t2part VALUES (9, '2011');
526 BEGIN;
527 INSERT INTO t2part VALUES (10, '1982');
528 --- connection master1 ---
529 SET SESSION lock_wait_timeout = 1;
530 send statement and reap result later ---
531 ALTER TABLE t2part REBUILD PARTITION ALL;;
532 --- connection master2 ---
533 --- connection master1 ---
534 reap result of previous---
535 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
536 --- connection master ---
537 COMMIT;
538 --- connection slave ---
539 SELECT COUNT(*) FROM t2part ;
540 COUNT(*)
541 12
542 --- connection master ---
543 SELECT COUNT(*) FROM t2part ;
544 COUNT(*)
545 12
546 include/diff_tables.inc [master:t2part, slave:t2part]
547 --- connection master ---
548 INSERT INTO t2part VALUES (11, '1912');
549 BEGIN;
550 INSERT INTO t2part VALUES (12, '1999');
551 --- connection master1 ---
552 SET SESSION lock_wait_timeout = 1;
553 send statement and reap result later ---
554 ALTER TABLE t2part REPAIR PARTITION ALL;;
555 --- connection master2 ---
556 --- connection master1 ---
557 reap result of previous---
558 Table Op Msg_type Msg_text
559 test.t2part repair Error Lock wait timeout exceeded; try restarting transaction
560 test.t2part repair status Operation failed
561 --- connection master ---
562 COMMIT;
563 --- connection slave ---
564 SELECT COUNT(*) FROM t2part ;
565 COUNT(*)
566 14
567 --- connection master ---
568 SELECT COUNT(*) FROM t2part ;
569 COUNT(*)
570 14
571 include/diff_tables.inc [master:t2part, slave:t2part]
572 --- connection master ---
573 INSERT INTO t2part VALUES (13, '1923');
574 BEGIN;
575 INSERT INTO t2part VALUES (14, '1981');
576 --- connection master1 ---
577 SET SESSION lock_wait_timeout = 1;
578 send statement and reap result later ---
579 ALTER TABLE t2part REMOVE PARTITIONING ;;
580 --- connection master2 ---
581 --- connection master1 ---
582 reap result of previous---
583 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
584 --- connection master ---
585 COMMIT;
586 --- connection slave ---
587 SELECT COUNT(*) FROM t2part ;
588 COUNT(*)
589 16
590 --- connection master ---
591 SELECT COUNT(*) FROM t2part ;
592 COUNT(*)
593 16
594 include/diff_tables.inc [master:t2part, slave:t2part]
595 --- connection master ---
596 BEGIN;
597 INSERT INTO t1 VALUES (1);
598 --- connection master1 ---
599 SET SESSION lock_wait_timeout = 1;
600 send statement and reap result later ---
601 ALTER TABLE t1 ALGORITHM = COPY;;
602 --- connection master2 ---
603 --- connection master1 ---
604 reap result of previous---
605 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
606 --- connection master ---
607 COMMIT;
608 --- connection slave ---
609 SELECT COUNT(*) FROM t1 ;
610 COUNT(*)
611 6
612 --- connection master ---
613 SELECT COUNT(*) FROM t1 ;
614 COUNT(*)
615 6
616 include/diff_tables.inc [master:t1, slave:t1]
617 --- connection master ---
618 BEGIN;
619 INSERT INTO t1 VALUES (1);
620 --- connection master1 ---
621 SET SESSION lock_wait_timeout = 1;
622 send statement and reap result later ---
623 ALTER TABLE t1 ALGORITHM = INPLACE;;
624 --- connection master2 ---
625 --- connection master1 ---
626 reap result of previous---
627 --- connection master ---
628 COMMIT;
629 --- connection slave ---
630 SELECT COUNT(*) FROM t1 ;
631 COUNT(*)
632 7
633 --- connection master ---
634 SELECT COUNT(*) FROM t1 ;
635 COUNT(*)
636 7
637 include/diff_tables.inc [master:t1, slave:t1]
638 CREATE TABLE t1hand (a INT, KEY a(a));
639 --- connection master ---
640 SET SESSION lock_wait_timeout = 1;
641 BEGIN;
642 SELECT * FROM t1hand;
643 a
644 HANDLER t1hand OPEN;
645 HANDLER t1hand READ a NEXT;
646 a
647 --- connection master1 ---
648 SET SESSION lock_wait_timeout = 1;
649 send statement and reap result later ---
650 DROP TABLE t1hand;;
651 --- connection master2 ---
652 --- connection master1 ---
653 reap result of previous---
654 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
655 --- connection master ---
656 HANDLER t1hand CLOSE;
657 --- connection slave ---
658 SELECT COUNT(*) FROM t1hand ;
659 COUNT(*)
660 0
661 --- connection master ---
662 SELECT COUNT(*) FROM t1hand ;
663 COUNT(*)
664 0
665 include/diff_tables.inc [master:t1hand, slave:t1hand]
666 DROP TABLE t1hand;
667 USE test;
668 --- connection master ---
669 CREATE TABLE t1trig(c INT) ENGINE = INNODB;
670 CREATE TABLE t2trig(c INT) ENGINE = MYISAM;
671 CREATE TRIGGER trig AFTER UPDATE ON t1trig FOR EACH ROW
672 BEGIN
673 INSERT INTO t2trig(c) VALUES (1);
674 END|
675 INSERT INTO t1trig(c) VALUES (1);
676 UPDATE t1trig SET c = 2 WHERE c = 1;
677 --- connection master1 ---
678 INSERT INTO t1trig VALUES (9);
679 --- connection master ---
680 --- connection slave ---
681 SELECT COUNT(*) FROM t1trig;
682 COUNT(*)
683 2
684 --- connection master ---
685 SELECT COUNT(*) FROM t1trig;
686 COUNT(*)
687 2
688 include/diff_tables.inc [master:t1trig, slave:t1trig]
689 USE test;
690 CREATE USER 'user1'@'localhost' ;
691 GRANT ALL ON test.t1 TO user1@localhost;
692 --- connection master ---
693 BEGIN;
694 INSERT INTO t1 VALUES (1);
695 --- connection master1 ---
696 SET SESSION lock_wait_timeout = 1;
697 send statement and reap result later ---
698 REVOKE ALL ON test.t1 FROM user1@localhost;;
699 --- connection master2 ---
700 --- connection master1 ---
701 reap result of previous---
702 --- connection master ---
703 COMMIT;
704 --- connection slave ---
705 SELECT COUNT(*) FROM t1 ;
706 COUNT(*)
707 8
708 --- connection master ---
709 SELECT COUNT(*) FROM t1 ;
710 COUNT(*)
711 8
712 include/diff_tables.inc [master:t1, slave:t1]
713 USE test;
714 --- connection master ---
715 CREATE TABLE tz (s1 INT UNIQUE) ENGINE = INNODB;
716 INSERT INTO tz VALUES (1);
717 --- connection master1 ---
718 INSERT INTO tz VALUES (2);
719 INSERT INTO tz VALUES (3);
720 --- connection master2 ---
721 DROP TABLE tz;
722 --- connection master3 ---
723 send statement and reap result later ---
724 DROP TABLE tz;;
725 --- connection master ---
726 include/diff_tables.inc [master:t1, slave:t1]
727 --- connection master ---
728 BEGIN;
729 INSERT INTO t1 VALUES (1);
730 INSERT INTO t1 VALUES (5);
731 --- connection master1 ---
732 SET SESSION lock_wait_timeout = 1;
733 send statement and reap result later ---
734 ROLLBACK;;
735 --- connection master2 ---
736 --- connection master1 ---
737 reap result of previous---
738 --- connection master ---
739 COMMIT;
740 --- connection slave ---
741 SELECT COUNT(*) FROM t1 ;
742 COUNT(*)
743 10
744 --- connection master ---
745 SELECT COUNT(*) FROM t1 ;
746 COUNT(*)
747 10
748 include/diff_tables.inc [master:t1, slave:t1]
749 --- connection master ---
750 BEGIN;
751 INSERT INTO t1 VALUES (1);
752 INSERT INTO t2 VALUES (2,3);
753 --- connection master1 ---
754 SET SESSION lock_wait_timeout = 1;
755 send statement and reap result later ---
756 DROP TABLE t2;;
757 --- connection master2 ---
758 --- connection master1 ---
759 reap result of previous---
760 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
761 --- connection master ---
762 COMMIT;
763 --- connection slave ---
764 SELECT COUNT(*) FROM t1 ;
765 COUNT(*)
766 11
767 --- connection master ---
768 SELECT COUNT(*) FROM t1 ;
769 COUNT(*)
770 11
771 include/diff_tables.inc [master:t1, slave:t1]
772 --- connection master ---
773 BEGIN;
774 INSERT INTO t1 VALUES (1);
775 INSERT INTO t2 VALUES (3,4);
776 INSERT INTO t3 VALUES (2);
777 INSERT INTO t4 VALUES (1);
778 --- connection master1 ---
779 SET SESSION lock_wait_timeout = 1;
780 send statement and reap result later ---
781 RENAME TABLE t1 to t2, t2 to t3, t3 to t4, t4 to t1;;
782 --- connection master2 ---
783 --- connection master1 ---
784 reap result of previous---
785 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
786 --- connection master ---
787 COMMIT;
788 --- connection slave ---
789 SELECT COUNT(*) FROM t1 ;
790 COUNT(*)
791 12
792 SELECT COUNT(*) FROM t2 ;
793 COUNT(*)
794 3
795 SELECT COUNT(*) FROM t3 ;
796 COUNT(*)
797 1
798 SELECT COUNT(*) FROM t4 ;
799 COUNT(*)
800 1
801 --- connection master ---
802 SELECT COUNT(*) FROM t1 ;
803 COUNT(*)
804 12
805 SELECT COUNT(*) FROM t2 ;
806 COUNT(*)
807 3
808 SELECT COUNT(*) FROM t3 ;
809 COUNT(*)
810 1
811 SELECT COUNT(*) FROM t4 ;
812 COUNT(*)
813 1
814 include/diff_tables.inc [master:t4, slave:t4]
815 --- connection master ---
816 INSERT INTO t3967_1 (b) VALUES (1),(2),(3);
817 BEGIN;
818 INSERT INTO t3967_1(b) VALUES (4);
819 --- connection master1 ---
820 SET SESSION lock_wait_timeout = 1;
821 send statement and reap result later ---
822 RENAME TABLE t3967_1 to t1_backup, t3967_2 to t3967_1;;
823 --- connection master2 ---
824 --- connection master1 ---
825 reap result of previous---
826 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
827 --- connection master ---
828 COMMIT;
829 --- connection slave ---
830 SELECT COUNT(*) FROM t3967_1 ;
831 COUNT(*)
832 4
833 --- connection master ---
834 SELECT COUNT(*) FROM t3967_1 ;
835 COUNT(*)
836 4
837 include/diff_tables.inc [master:t3967_1, slave:t3967_1]
838 INSERT INTO t1_30138 VALUES (1),(2),(3);
839 SET AUTOCOMMIT = 0;
840 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
841 START TRANSACTION WITH CONSISTENT SNAPSHOT;
842 SELECT COUNT(*) FROM t1_30138;
843 COUNT(*)
844 3
845 CREATE TABLE t1_30138_new (id INT) ENGINE = INNODB;
846 INSERT INTO t1_30138_new VALUES (4),(5),(6),(7);
847 INSERT INTO t1_30138 VALUES(8);
848 RENAME TABLE t1_30138 TO t1_30138_old, t1_30138_new TO t1_30138;
849 SELECT COUNT(*) FROM t1_30138;
850 COUNT(*)
851 4
852 SELECT COUNT(*) FROM t1_30138_old;
853 COUNT(*)
854 4
855 --- connection slave ---
856 SELECT COUNT(*) FROM t1_30138 ;
857 COUNT(*)
858 4
859 SELECT COUNT(*) FROM t1_30138_old ;
860 COUNT(*)
861 4
862 --- connection master ---
863 SELECT COUNT(*) FROM t1_30138 ;
864 COUNT(*)
865 4
866 SELECT COUNT(*) FROM t1_30138_old ;
867 COUNT(*)
868 4
869 include/diff_tables.inc [master:t1_30138_old, slave:t1_30138_old]
870 CALL mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT');
871 --- connection master ---
872 INSERT INTO t1innodb (c) VALUES (1);
873 INSERT INTO t1myisam (c) VALUES (1);
874 COMMIT;
875 BEGIN;
876 UPDATE t1myisam, t1innodb SET t1myisam.c = 10, t1innodb.c = NULL;
877 --- connection master1 ---
878 SET SESSION lock_wait_timeout = 1;
879 send statement and reap result later ---
880 DROP TABLE t1myisam;;
881 --- connection master2 ---
882 --- connection master1 ---
883 reap result of previous---
884 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
885 --- connection master ---
886 COMMIT;
887 --- connection slave ---
888 SELECT COUNT(*) FROM t1myisam ;
889 COUNT(*)
890 1
891 SELECT COUNT(*) FROM t1innodb ;
892 COUNT(*)
893 1
894 --- connection master ---
895 SELECT COUNT(*) FROM t1myisam ;
896 COUNT(*)
897 1
898 SELECT COUNT(*) FROM t1innodb ;
899 COUNT(*)
900 1
901 include/diff_tables.inc [master:t1innodb, slave:t1innodb]
902 --- connection master ---
903 BEGIN;
904 INSERT INTO t1 SELECT * FROM t1;
905 --- connection master1 ---
906 SET SESSION lock_wait_timeout = 1;
907 send statement and reap result later ---
908 DROP TABLE t1;;
909 --- connection master2 ---
910 --- connection master1 ---
911 reap result of previous---
912 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
913 --- connection master ---
914 COMMIT;
915 --- connection slave ---
916 SELECT COUNT(*) FROM t1 ;
917 COUNT(*)
918 24
919 --- connection master ---
920 SELECT COUNT(*) FROM t1 ;
921 COUNT(*)
922 24
923 include/diff_tables.inc [master:t1, slave:t1]
924 --- connection master ---
925 CREATE DATABASE db1;
926 USE db1;
927 CREATE TABLE db1.t1 (a INT);
928 BEGIN;
929 CREATE FUNCTION db1.f1() RETURNS INT RETURN 1;
930 INSERT INTO db1.t1 VALUES (f1());
931 --- connection master1 ---
932 SET SESSION lock_wait_timeout = 1;
933 send statement and reap result later ---
934 DROP DATABASE db1;;
935 --- connection master2 ---
936 --- connection master1 ---
937 reap result of previous---
938 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
939 --- connection master ---
940 COMMIT;
941 --- connection slave ---
942 USE db1;
943 SELECT COUNT(*) FROM t1 ;
944 COUNT(*)
945 1
946 --- connection master ---
947 SELECT COUNT(*) FROM t1 ;
948 COUNT(*)
949 1
950 include/diff_tables.inc [master:t1, slave:t1]
951 DROP TABLE db1.t1;
952 DROP FUNCTION db1.f1;
953 USE test;
954 DROP TABLE t1;
955 CREATE TABLE t1 (a INT);
956 CREATE FUNCTION f1() RETURNS INT RETURN 1;
957 BEGIN;
958 INSERT INTO t1 VALUES (f1());
959 --- connection master1 ---
960 SET SESSION lock_wait_timeout = 1;
961 send statement and reap result later ---
962 DROP FUNCTION f1;;
963 --- connection master2 ---
964 --- connection master1 ---
965 reap result of previous---
966 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
967 --- connection master ---
968 COMMIT;
969 --- connection slave ---
970 USE test;
971 SELECT COUNT(*) FROM t1 ;
972 COUNT(*)
973 1
974 --- connection master ---
975 SELECT COUNT(*) FROM t1 ;
976 COUNT(*)
977 1
978 include/diff_tables.inc [master:t1, slave:t1]
979 --- connection master ---
980 CREATE PROCEDURE p1() INSERT INTO t1 SELECT * FROM t3;
981 BEGIN;
982 CALL p1();
983 --- connection master1 ---
984 SET SESSION lock_wait_timeout = 1;
985 send statement and reap result later ---
986 DROP PROCEDURE p1;;
987 --- connection master2 ---
988 --- connection master1 ---
989 reap result of previous---
990 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
991 --- connection master ---
992 COMMIT;
993 --- connection slave ---
994 SELECT COUNT(*) FROM t1 ;
995 COUNT(*)
996 2
997 --- connection master ---
998 SELECT COUNT(*) FROM t1 ;
999 COUNT(*)
1000 2
1001 include/diff_tables.inc [master:t1, slave:t1]
1002 --- connection master ---
1003 CREATE EVENT e1 ON SCHEDULE EVERY 1 SECOND STARTS NOW() DO
1004 BEGIN
1005 DECLARE EXIT HANDLER FOR 1136 BEGIN
1006 INSERT INTO t3 VALUES (1);
1007 END; -- ER_WRONG_VALUE_COUNT_ON_ROW
1008 INSERT INTO t2 SELECT * FROM t1;
1009 END|
1010 --- connection master1 ---
1011 SET SESSION lock_wait_timeout = 1;
1012 send statement and reap result later ---
1013 DROP EVENT e1;;
1014 --- connection master2 ---
1015 --- connection master1 ---
1016 reap result of previous---
1017 --- connection master ---
1018 COMMIT;
1019 --- connection slave ---
1020 SELECT COUNT(*) FROM t2 ;
1021 COUNT(*)
1022 3
1023 --- connection master ---
1024 SELECT COUNT(*) FROM t2 ;
1025 COUNT(*)
1026 3
1027 include/diff_tables.inc [master:t2, slave:t2]
1028 --- connection master ---
1029 CREATE VIEW v1 AS SELECT * FROM t1;
1030 BEGIN;
1031 INSERT INTO v1 VALUES (11);
1032 --- connection master1 ---
1033 SET SESSION lock_wait_timeout = 1;
1034 send statement and reap result later ---
1035 ALTER VIEW v1 AS SELECT * FROM t2;;
1036 --- connection master2 ---
1037 --- connection master1 ---
1038 reap result of previous---
1039 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
1040 --- connection master ---
1041 COMMIT;
1042 --- connection slave ---
1043 SELECT COUNT(*) FROM v1 ;
1044 COUNT(*)
1045 3
1046 --- connection master ---
1047 SELECT COUNT(*) FROM v1;
1048 COUNT(*)
1049 3
1050 include/diff_tables.inc [master:v1, slave:v1]
1051 --- connection master ---
1052 DROP VIEW v1;
1053 CREATE VIEW v1 AS SELECT * FROM t1;
1054 BEGIN;
1055 INSERT INTO v1 VALUES (12);
1056 --- connection master1 ---
1057 SET SESSION lock_wait_timeout = 1;
1058 send statement and reap result later ---
1059 DROP VIEW v1;;
1060 --- connection master2 ---
1061 --- connection master1 ---
1062 reap result of previous---
1063 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
1064 --- connection master ---
1065 COMMIT;
1066 --- connection slave ---
1067 SELECT COUNT(*) FROM v1 ;
1068 COUNT(*)
1069 4
1070 --- connection master ---
1071 SELECT COUNT(*) FROM v1 ;
1072 COUNT(*)
1073 4
1074 include/diff_tables.inc [master:v1, slave:v1]
1075 --- connection master ---
1076 DROP VIEW v1;
1077 CREATE VIEW v1 AS SELECT a, 1 AS col2 FROM t1;
1078 BEGIN;
1079 UPDATE v1 SET a = 0;
1080 --- connection master1 ---
1081 SET SESSION lock_wait_timeout = 1;
1082 send statement and reap result later ---
1083 ALTER VIEW v1 AS SELECT a,1 AS col2 FROM t2;;
1084 --- connection master ---
1085 --- connection master2 ---
1086 reap result of previous---
1087 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
1088 --- connection master ---
1089 COMMIT;
1090 --- connection slave ---
1091 SELECT COUNT(*) FROM v1 ;
1092 COUNT(*)
1093 4
1094 --- connection master ---
1095 SELECT COUNT(*) FROM v1 ;
1096 COUNT(*)
1097 4
1098 include/diff_tables.inc [master:v1, slave:v1]
1099 --- connection master ---
1100 DROP VIEW v1;
1101 CREATE OR REPLACE VIEW v1 AS SELECT * FROM t1;
1102 BEGIN;
1103 INSERT INTO v1 VALUES(13);
1104 --- connection master1 ---
1105 SET SESSION lock_wait_timeout = 1;
1106 send statement and reap result later ---
1107 ALTER VIEW v1 AS SELECT * FROM t2;;
1108 --- connection master2 ---
1109 --- connection master1 ---
1110 reap result of previous---
1111 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
1112 --- connection master ---
1113 COMMIT;
1114 --- connection slave ---
1115 SELECT COUNT(*) FROM v1 ;
1116 COUNT(*)
1117 5
1118 --- connection master ---
1119 SELECT COUNT(*) FROM v1 ;
1120 COUNT(*)
1121 5
1122 include/diff_tables.inc [master:v1, slave:v1]
1123 --- connection master ---
1124 INSERT INTO t1opt VALUES (1,'Mysql locking',20,'Transactional locking',10);
1125 INSERT INTO t1opt SELECT * FROM t1opt;
1126 BEGIN;
1127 OPTIMIZE TABLE t1opt;
1128 --- connection master1 ---
1129 SET SESSION lock_wait_timeout = 1;
1130 send statement and reap result later ---
1131 DROP TABLE t1opt;;
1132 --- connection master2 ---
1133 --- connection master1 ---
1134 reap result of previous---
1135 --- connection master ---
1136 COMMIT;
1137 --- connection slave ---
1138 SELECT COUNT(*) FROM t1 ;
1139 COUNT(*)
1140 5
1141 --- connection master ---
1142 SELECT COUNT(*) FROM t1 ;
1143 COUNT(*)
1144 5
1145 include/diff_tables.inc [master:v1, slave:v1]
1146 --- connection master ---
1147 CREATE TABLE t1opt (id INT , content TEXT, author_id INT,
1148 article_title VARCHAR(120), article_hash INT);
1149 INSERT INTO t1opt VALUES (2,'Mysql locking1',22,'Transactional locking1',11);
1150 INSERT INTO t1opt SELECT * FROM t1opt;
1151 BEGIN;
1152 OPTIMIZE TABLE t1opt;
1153 --- connection master1 ---
1154 SET SESSION lock_wait_timeout = 1;
1155 send statement and reap result later ---
1156 ALTER TABLE t1opt RENAME TO t1opt;;
1157 --- connection master2 ---
1158 --- connection master1 ---
1159 reap result of previous---
1160 --- connection master ---
1161 COMMIT;
1162 --- connection slave ---
1163 SELECT COUNT(*) FROM t1opt ;
1164 COUNT(*)
1165 2
1166 --- connection master ---
1167 SELECT COUNT(*) FROM t1opt ;
1168 COUNT(*)
1169 2
1170 include/diff_tables.inc [master:t1opt, slave:t1opt]
1171 --- connection master ---
1172 BEGIN;
1173 INSERT INTO t1 VALUES (15);
1174 INSERT INTO t3 VALUES (10);
1175 --- connection master1 ---
1176 SET SESSION lock_wait_timeout = 1;
1177 send statement and reap result later ---
1178 DROP TABLE t1,t3;;
1179 --- connection master2 ---
1180 --- connection master1 ---
1181 reap result of previous---
1182 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
1183 --- connection master ---
1184 COMMIT;
1185 --- connection slave ---
1186 SELECT COUNT(*) FROM t1 ;
1187 COUNT(*)
1188 6
1189 SELECT COUNT(*) FROM t3 ;
1190 COUNT(*)
1191 2
1192 --- connection master ---
1193 SELECT COUNT(*) FROM t1 ;
1194 COUNT(*)
1195 6
1196 SELECT COUNT(*) FROM t3 ;
1197 COUNT(*)
1198 2
1199 include/diff_tables.inc [master:t3, slave:t3]
1200 --- connection master ---
1201 BEGIN;
1202 DELETE t3.*, t4.* FROM t3, t4 WHERE t3.a = t4.a AND t3.a = 1;
1203 --- connection master1 ---
1204 SET SESSION lock_wait_timeout = 1;
1205 send statement and reap result later ---
1206 DROP TABLE t3, t4;;
1207 --- connection master2 ---
1208 --- connection master1 ---
1209 reap result of previous---
1210 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
1211 --- connection master ---
1212 COMMIT;
1213 --- connection slave ---
1214 SELECT COUNT(*) FROM t3 ;
1215 COUNT(*)
1216 2
1217 SELECT COUNT(*) FROM t4 ;
1218 COUNT(*)
1219 1
1220 --- connection master ---
1221 SELECT COUNT(*) FROM t3 ;
1222 COUNT(*)
1223 2
1224 SELECT COUNT(*) FROM t4 ;
1225 COUNT(*)
1226 1
1227 include/diff_tables.inc [master:t4, slave:t4]
1228 --- connection master ---
1229 DROP DATABASE db1;
1230 CREATE DATABASE db1;
1231 USE db1;
1232 CREATE TABLE db1.t1(a INT, b INT);
1233 BEGIN;
1234 INSERT INTO db1.t1 VALUES (1, 1);
1235 --- connection master1 ---
1236 SET SESSION lock_wait_timeout = 1;
1237 send statement and reap result later ---
1238 DROP DATABASE db1;;
1239 --- connection master2 ---
1240 --- connection master1 ---
1241 reap result of previous---
1242 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
1243 --- connection master ---
1244 COMMIT;
1245 --- connection slave ---
1246 USE db1;
1247 SELECT COUNT(*) FROM t1;
1248 COUNT(*)
1249 1
1250 --- connection master ---
1251 SELECT COUNT(*) FROM t1;
1252 COUNT(*)
1253 1
1254 include/diff_tables.inc [master:t1, slave:t1]
1255 DROP TABLE db1.t1;
1256 USE test;
1257 --- connection master ---
1258 DROP DATABASE db1;
1259 CREATE DATABASE db1;
1260 USE db1;
1261 CREATE TABLE db1.t1(a INT, b INT);
1262 BEGIN;
1263 INSERT INTO db1.t1 VALUES (1,1);
1264 --- connection master1 ---
1265 SET SESSION lock_wait_timeout = 1;
1266 send statement and reap result later ---
1267 ALTER DATABASE db1 CHARACTER SET big5;;
1268 --- connection master2 ---
1269 --- connection master1 ---
1270 reap result of previous---
1271 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
1272 --- connection master ---
1273 COMMIT;
1274 --- connection slave ---
1275 USE db1;
1276 SELECT COUNT(*) FROM t1;
1277 COUNT(*)
1278 1
1279 --- connection master ---
1280 SELECT COUNT(*) FROM t1;
1281 COUNT(*)
1282 1
1283 include/diff_tables.inc [master:t1, slave:t1]
1284 DROP TABLE db1.t1;
1285 USE test;
1286 --- connection master ---
1287 USE test;
1288 CREATE TABLE tab1(x INT PRIMARY KEY, y INT) ENGINE = INNODB;
1289 INSERT tab1 VALUES (1, 0), (2, 0), (3, 0), (4, 0), (5, 0);
1290 CREATE FUNCTION func(z INT) RETURNS INT
1291 READS SQL DATA
1292 RETURN (SELECT x FROM tab1 WHERE x = z)
1293 |
1294 BEGIN;
1295 SELECT func(1);
1296 func(1)
1297 1
1298 --- connection master1 ---
1299 USE test;
1300 BEGIN;
1301 SELECT func(1);
1302 func(1)
1303 1
1304 UPDATE tab1 SET y = 1 WHERE x = 1;
1305 --- connection master ---
1306 COMMIT;
1307 --- connection master1 ---
1308 COMMIT;
1309 --- connection master ---
1310 --- connection slave ---
1311 USE test;
1312 SELECT COUNT(*) FROM tab1 ;
1313 COUNT(*)
1314 5
1315 --- connection master ---
1316 SELECT COUNT(*) FROM tab1;
1317 COUNT(*)
1318 5
1319 include/diff_tables.inc [master:tab1, slave:tab1]
1320 DROP FUNCTION func;
1321 DROP TABLE tab1;
1322 USE test;
1323 CREATE TABLE t1lock (a INT);
1324 CREATE TABLE t2lock (a INT);
1325 --- connection master ---
1326 LOCK TABLE t1lock WRITE, t2lock WRITE;
1327 DROP TABLE t1lock;
1328 --- connection master1 ---
1329 SET SESSION lock_wait_timeout = 1;
1330 send statement and reap result later ---
1331 ALTER TABLE t2lock RENAME t1lock;;
1332 --- connection master2 ---
1333 --- connection master1 ---
1334 reap result of previous---
1335 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
1336 --- connection master ---
1337 COMMIT;
1338 --- connection slave ---
1339 USE test;
1340 SELECT COUNT(*) FROM t2lock;
1341 COUNT(*)
1342 0
1343 --- connection master ---
1344 SELECT COUNT(*) FROM t2lock;
1345 COUNT(*)
1346 0
1347 include/diff_tables.inc [master:t2lock, slave:t2lock]
1348 --- connection master ---
1349 UNLOCK TABLES;
1350 CREATE TABLE t1lock (a INT);
1351 LOCK TABLE t1lock WRITE;
1352 UNLOCK TABLES;
1353 DROP TABLE t2lock;
1354 --- connection master1 ---
1355 SET SESSION lock_wait_timeout = 1;
1356 send statement and reap result later ---
1357 ALTER TABLE t1lock RENAME t2lock;;
1358 --- connection master2 ---
1359 --- connection master1 ---
1360 reap result of previous---
1361 --- connection master ---
1362 COMMIT;
1363 --- connection slave ---
1364 USE test;
1365 SELECT COUNT(*) FROM t2lock;
1366 COUNT(*)
1367 0
1368 --- connection master ---
1369 SELECT COUNT(*) FROM t2lock;
1370 COUNT(*)
1371 0
1372 include/diff_tables.inc [master:t2lock, slave:t2lock]
1373 DROP TABLE t2lock;
1374 CREATE TABLE t1lock1 (a INT, b INT);
1375 CREATE TABLE t2lock1 (a INT, b INT);
1376 --- connection master ---
1377 LOCK TABLES t1lock1 WRITE;
1378 ANALYZE TABLE t1lock1;
1379 Table Op Msg_type Msg_text
1380 test.t1lock1 analyze status Table is already up to date
1381 UNLOCK TABLES;
1382 --- connection master1 ---
1383 SET SESSION lock_wait_timeout = 1;
1384 LOCK TABLE t2lock1 WRITE;
1385 FLUSH TABLE t2lock1;
1386 UNLOCK TABLES;
1387 --- connection slave ---
1388 USE test;
1389 SELECT COUNT(*) FROM t1lock1;
1390 COUNT(*)
1391 0
1392 --- connection master ---
1393 SELECT COUNT(*) FROM t1lock1;
1394 COUNT(*)
1395 0
1396 include/diff_tables.inc [master:t1lock1, slave:t1lock1]
1397 DROP TABLE t1lock1,t2lock1;
1398 DROP TABLE t1,t2,t3,t4;
1399 DROP TABLE t1part,t2part,t3part,t4part;
1400 DROP TABLE t1prim,t1opt;
1401 DROP TABLE t1trig,t2trig;
1402 DROP TABLE t1bin,t2bin,t1myisam,t1innodb;
1403 DROP TABLE t3967_1,t3967_2,t1_30138,t1_30138_old;
1404 DROP FUNCTION f1;
1405 DROP PROCEDURE p1;
1406 DROP VIEW v1;
1407 DROP USER user1@localhost;
1408 DROP DATABASE db1;
1409 include/rpl_end.inc