Debian Codegraph @

mysql-test/suite/innodb/r/cats-autoinc.result

raw
1 ################################################################
2 # #
3 # Bug #27944920: INNODB: ASSERTION FAILURE: #
4 # LOCK_GET_TYPE_LOW(LOCK) == 32 IN LOCK0PRIV.IC #
5 # #
6 ################################################################
7 SHOW VARIABLES LIKE 'innodb_autoinc_lock_mode';
8 Variable_name Value
9 innodb_autoinc_lock_mode 0
10 CREATE TABLE t1 (
11 id INT PRIMARY KEY AUTO_INCREMENT,
12 val INT
13 ) Engine=InnoDB;
14 CREATE TABLE t2 (
15 id INT PRIMARY KEY
16 ) Engine=InnoDB;
17 INSERT INTO t1 (id, val) VALUES (1,1);
18 INSERT INTO t2 (id) VALUES (1),(2),(3);
19 SET @innodb_lock_wait_timeout_saved = @@global.innodb_lock_wait_timeout;
20 SET @@global.innodb_lock_wait_timeout = 100000;
21 BEGIN;
22 SELECT * FROM t2 WHERE id=2 FOR UPDATE;
23 id
24 2
25 BEGIN;
26 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C4_will_wait';
27 INSERT INTO t1 (val) SELECT id FROM t2;
28 BEGIN;
29 SELECT * FROM t1 WHERE id=1 FOR SHARE;
30 id val
31 1 1
32 SET DEBUG_SYNC = 'now WAIT_FOR C4_will_wait';
33 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C1_will_wait';
34 INSERT INTO t1 (val) VALUES (7);
35 BEGIN;
36 SET DEBUG_SYNC = 'now WAIT_FOR C1_will_wait';
37 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C2_will_wait';
38 SELECT * FROM t1 WHERE id=1 FOR UPDATE;
39 SET DEBUG_SYNC = 'now WAIT_FOR C2_will_wait';
40 ROLLBACK;
41 ROLLBACK;
42 ROLLBACK;
43 id val
44 1 1
45 ROLLBACK;
46 DROP TABLE t2;
47 DROP TABLE t1;
48 SET @@global.innodb_lock_wait_timeout = @innodb_lock_wait_timeout_saved;
49 ########################
50 # #
51 # End of Bug #27944920 #
52 # #
53 ########################
54 CREATE TABLE t1 (
55 id INT PRIMARY KEY AUTO_INCREMENT,
56 val INT
57 ) Engine=InnoDB;
58 CREATE TABLE t2 (
59 id INT PRIMARY KEY
60 ) Engine=InnoDB;
61 CREATE TABLE t3 (
62 id INT PRIMARY KEY,
63 val INT
64 ) Engine=InnoDB;
65 INSERT INTO t1 (id, val) VALUES (1,1);
66 INSERT INTO t2 (id) VALUES (1),(2),(3);
67 INSERT INTO t3 (id, val) VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6);
68 SET @innodb_lock_wait_timeout_saved = @@global.innodb_lock_wait_timeout;
69 SET @@global.innodb_lock_wait_timeout = 100000;
70 BEGIN;
71 SELECT * FROM t2 WHERE id=2 FOR UPDATE;
72 id
73 2
74 BEGIN;
75 SELECT * FROM t2 WHERE id=3 FOR UPDATE;
76 id
77 3
78 BEGIN;
79 UPDATE t3 SET val = 13;
80 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C2_will_wait';
81 INSERT INTO t1 (val) SELECT id FROM t2;
82 SET DEBUG_SYNC = 'now WAIT_FOR C2_will_wait';
83 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C3_will_wait';
84 INSERT INTO t1 (val) VALUES (13);;
85 SET DEBUG_SYNC = 'now WAIT_FOR C3_will_wait';
86 ROLLBACK;
87 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
88 ROLLBACK;
89 ROLLBACK;
90 DROP TABLES t1,t2,t3;
91 SET @@global.innodb_lock_wait_timeout = @innodb_lock_wait_timeout_saved;