Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 call mtr.add_suppression("Slave: ER_CONNECTION_KILLED .* is not allowed in --slave-skip-errors");
5 include/assert_grep.inc [Warning about ER_CONNECTION_KILLED should appear in error log]
6 call mtr.add_suppression("Deadlock found when trying to get lock; try restarting transaction");
7 *** Provoke a deadlock on the slave, check that transaction retry succeeds. ***
8 connection master;
9 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
10 CREATE TABLE t2 (a INT) ENGINE=InnoDB;
11 INSERT INTO t1(a) VALUES (1), (2), (3), (4), (5);
12 connection slave;
13 SELECT * FROM t1 ORDER BY a;
14 a b
15 1 NULL
16 2 NULL
17 3 NULL
18 4 NULL
19 5 NULL
20 SET sql_log_bin=0;
21 ALTER TABLE t2 ENGINE=MyISAM;
22 SET sql_log_bin=1;
23 connect con_temp1,127.0.0.1,root,,test,$SERVER_MYPORT_2,;
24 connection con_temp1;
25 BEGIN;
26 UPDATE t1 SET b=2 WHERE a=4;
27 INSERT INTO t2 VALUES (2);
28 DELETE FROM t2 WHERE a=2;
29 connection master;
30 BEGIN;
31 UPDATE t1 SET b=1 WHERE a=2;
32 INSERT INTO t2 VALUES (1);
33 UPDATE t1 SET b=1 WHERE a=4;
34 COMMIT;
35 connection slave;
36 connection con_temp1;
37 UPDATE t1 SET b=2 WHERE a=2;
38 SELECT * FROM t1 WHERE a<10 ORDER BY a;
39 a b
40 1 NULL
41 2 2
42 3 NULL
43 4 2
44 5 NULL
45 ROLLBACK;
46 Warnings:
47 Warning 1196 Some non-transactional changed tables couldn't be rolled back
48 connection slave;
49 SELECT * FROM t1 ORDER BY a;
50 a b
51 1 NULL
52 2 NULL
53 3 NULL
54 4 NULL
55 5 NULL
56 * There will be one row in t2 because the ignored deadlock does not retry.
57 SELECT * FROM t2 ORDER BY a;
58 a
59 1
60 retries
61 0
62 Last_SQL_Errno = '0'
63 Last_SQL_Error = ''
64 connection master;
65 DROP TABLE t1;
66 DROP TABLE t2;
67 include/rpl_end.inc