Debian Codegraph @

mysql-test/suite/innodb/r/iodku_debug.result

raw
1 #
2 # Bug#25966845 INSERT ON DUPLICATE KEY GENERATE A DEADLOCK
3 #
4 CREATE TABLE t1(f1 int primary key,
5 f2 int, f3 int, unique key(f2))engine=innodb;
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `f1` int NOT NULL,
10 `f2` int DEFAULT NULL,
11 `f3` int DEFAULT NULL,
12 PRIMARY KEY (`f1`),
13 UNIQUE KEY `f2` (`f2`)
14 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
15 INSERT INTO t1(f1, f2, f3) VALUES(1, 10, 100);
16 # Connection default
17 BEGIN;
18 INSERT INTO t1 VALUES(2, 20, 300) ON DUPLICATE KEY UPDATE f3 = 500;
19 # Connection other:
20 BEGIN;
21 SET DEBUG_SYNC = 'ib_after_row_insert_step SIGNAL default_commit';
22 INSERT INTO t1 VALUES(2, 10, 200) ON DUPLICATE KEY UPDATE f3 = 120;
23 # Connection default
24 SET DEBUG_SYNC = 'now WAIT_FOR default_commit';
25 COMMIT;
26 # Connection other
27 COMMIT;
28 # Verify Results:
29 SELECT * FROM t1;
30 f1 f2 f3
31 1 10 100
32 2 20 120
33 SET DEBUG_SYNC ='RESET';
34 DROP TABLE t1;
35 #
36 # Bug #29195848 ASSERTION "!OTHER_LOCK" IN LOCK_REC_ADD_TO_QUEUE
37 #
38 SET GLOBAL innodb_purge_stop_now = ON;
39 CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY, b INT, UNIQUE KEY(b));
40 INSERT INTO t1 VALUES(2, 300);
41 DELETE FROM t1;
42 INSERT INTO t1 VALUES(3, 300);
43 SELECT * FROM t1;
44 id b
45 3 300
46 SET DEBUG_SYNC='ib_after_row_insert_step SIGNAL after_insert WAIT_FOR
47 rollback';
48 INSERT INTO t1 VALUES(2, 300);;
49 SET DEBUG_SYNC='now WAIT_FOR after_insert';
50 START TRANSACTION;
51 INSERT INTO t1 VALUES(1, 300);
52 ERROR 23000: Duplicate entry '300' for key 't1.b'
53 SET GLOBAL innodb_purge_run_now=ON;
54 SET DEBUG_SYNC='now SIGNAL rollback';
55 ERROR 23000: Duplicate entry '300' for key 't1.b'
56 COMMIT;
57 DROP TABLE t1;
58 SET GLOBAL innodb_purge_stop_now = ON;
59 CREATE TABLE t1 (a INT PRIMARY KEY, b INT, UNIQUE KEY(b));
60 INSERT INTO t1 VALUES(1,10);
61 DELETE FROM t1;
62 INSERT INTO t1 VALUES(2,10);
63 SET DEBUG_SYNC='ib_undo_mod_before_remove_clust SIGNAL during_rollback
64 WAIT_FOR rollback';
65 INSERT INTO t1 VALUES(1, 10) ;;
66 SET DEBUG_SYNC='now WAIT_FOR during_rollback';
67 SELECT * FROM t1 WHERE a = 1 LOCK IN SHARE MODE;
68 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
69 SET GLOBAL innodb_purge_run_now=ON;
70 SET DEBUG_SYNC='now SIGNAL rollback';
71 ERROR 23000: Duplicate entry '10' for key 't1.b'
72 SELECT * FROM t1;
73 a b
74 2 10
75 DROP TABLE t1;
76 #
77 # Bug #29718243 MYQL SERVER CRASHING
78 #
79 CREATE TEMPORARY TABLE tmpTest(tmpField INT , UNIQUE KEY uq_tmpField (tmpField));
80 CREATE TEMPORARY TABLE tmpTest1(tmpField INT , UNIQUE KEY uq_tmpField (tmpField));
81 CREATE FUNCTION ZZtest() RETURNS int(11)
82 BEGIN
83 DECLARE l_total INTEGER;
84 SET l_total = 0;
85 INSERT INTO tmpTest SET tmpField = 40;
86 INSERT IGNORE INTO tmpTest SET tmpField = 40;
87 INSERT IGNORE INTO tmpTest1 SET tmpField = 40;
88 DROP TEMPORARY TABLE IF EXISTS tmpTest;
89 DROP TEMPORARY TABLE IF EXISTS tmpTest1;
90 RETURN l_total;
91 END|
92 Warnings:
93 Warning 1681 Integer display width is deprecated and will be removed in a future release.
94 SELECT ZZtest() AS test;
95 test
96 0
97 DROP FUNCTION ZZtest;