Debian Codegraph @

mysql-test/suite/rpl/r/rpl_deadlock_innodb.result

raw
1 include/master-slave.inc
2 [connection master]
3 *** Prepare tables and data ***
4 connection master;
5 CREATE TABLE t1 (a INT NOT NULL, KEY(a)) ENGINE=innodb;
6 CREATE TABLE t2 (a INT) ENGINE=innodb;
7 CREATE TABLE t3 (a INT NOT NULL, KEY(a)) ENGINE=innodb;
8 connection slave;
9 SHOW CREATE TABLE t1;
10 Table Create Table
11 t1 CREATE TABLE `t1` (
12 `a` int(11) NOT NULL,
13 KEY `a` (`a`)
14 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
15 SHOW CREATE TABLE t2;
16 Table Create Table
17 t2 CREATE TABLE `t2` (
18 `a` int(11) DEFAULT NULL
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
20 SHOW CREATE TABLE t3;
21 Table Create Table
22 t3 CREATE TABLE `t3` (
23 `a` int(11) NOT NULL,
24 KEY `a` (`a`)
25 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
26 SHOW VARIABLES LIKE 'slave_transaction_retries';
27 Variable_name Value
28 slave_transaction_retries 2
29 include/stop_slave.inc
30 connection master;
31 BEGIN;
32 INSERT INTO t1 VALUES (1);
33 INSERT INTO t2 VALUES (2), (2), (2), (2), (2), (2), (2), (2), (2), (2);
34 INSERT INTO t3 VALUES (3);
35 COMMIT;
36
37 *** Test deadlock ***
38 connection slave;
39 BEGIN;
40 SELECT * FROM t1 FOR UPDATE;
41 a
42 connection slave1;
43 START SLAVE;
44 connection slave;
45 SELECT COUNT(*) FROM t2;
46 COUNT(*)
47 0
48 COMMIT;
49
50 # Test that the performance schema coulumn shows > 0 values.
51
52 include/assert.inc [current number of retries should be more than the value saved before deadlock.]
53 include/check_slave_is_running.inc
54 SELECT * FROM t1;
55 a
56 1
57 SELECT * FROM t3;
58 a
59 3
60 include/check_slave_is_running.inc
61
62 *** Test lock wait timeout ***
63 connection slave;
64 include/stop_slave.inc
65 DELETE FROM t2;
66 CHANGE MASTER TO MASTER_LOG_POS=<master_pos_begin>, MASTER_USE_GTID=NO;
67 BEGIN;
68 SELECT * FROM t1 FOR UPDATE;
69 a
70 1
71 connection slave1;
72 START SLAVE;
73 include/wait_for_slave_sql_error.inc [errno=1205]
74 connection slave;
75 SELECT COUNT(*) FROM t2;
76 COUNT(*)
77 0
78 COMMIT;
79 include/start_slave.inc
80 SELECT * FROM t1;
81 a
82 1
83 1
84 SELECT * FROM t3;
85 a
86 3
87 3
88 include/check_slave_is_running.inc
89
90 *** Test lock wait timeout and purged relay logs ***
91 connection slave;
92 SET @my_max_relay_log_size= @@global.max_relay_log_size;
93 SET global max_relay_log_size=0;
94 Warnings:
95 Warning 1292 Truncated incorrect max_relay_log_size value: '0'
96 include/stop_slave.inc
97 DELETE FROM t2;
98 CHANGE MASTER TO MASTER_LOG_POS=<master_pos_begin>, MASTER_USE_GTID=NO;
99 BEGIN;
100 SELECT * FROM t1 FOR UPDATE;
101 a
102 1
103 1
104 connection slave1;
105 START SLAVE;
106 include/wait_for_slave_sql_error.inc [errno=1205]
107 connection slave;
108 SELECT COUNT(*) FROM t2;
109 COUNT(*)
110 0
111 COMMIT;
112 include/start_slave.inc
113 SELECT * FROM t1;
114 a
115 1
116 1
117 1
118 SELECT * FROM t3;
119 a
120 3
121 3
122 3
123 include/check_slave_is_running.inc
124
125 *** Clean up ***
126 connection master;
127 DROP TABLE t1,t2,t3;
128 connection slave;
129 SET global max_relay_log_size= @my_max_relay_log_size;
130 End of 5.1 tests
131 include/rpl_end.inc