Debian Codegraph @

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

raw
1 #################################################################
2 # #
3 # Bug # 27898384: InnoDB: Assertion failure: lock0lock.cc:4226: #
4 # !(lock2->trx == trx && lock_get_mode(lock2) == lock_mode) #
5 # #
6 #################################################################
7 ##############
8 # SCENARIO 1 #
9 ##############
10 CREATE TABLE t1 (
11 id INT PRIMARY KEY,
12 val INT
13 ) Engine=InnoDB;
14 INSERT INTO t1 (id, val) VALUES (100,100),(200,200);
15 BEGIN;
16 DELETE FROM t1 WHERE id=123;
17 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
18 BEGIN;
19 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con1_will_wait';
20 INSERT INTO t1 (id, val) VALUES (123,123);;
21 SET DEBUG_SYNC = 'now WAIT_FOR con1_will_wait';
22 ROLLBACK;
23 SELECT * FROM t1 WHERE 100<=id AND id<=200 AND val=100 FOR UPDATE;
24 id val
25 100 100
26 ROLLBACK;
27 DROP TABLE t1;
28 SET DEBUG_SYNC = 'RESET';
29 ##############
30 # SCENARIO 2 #
31 ##############
32 CREATE TABLE t1 (
33 `a` int(11) NOT NULL auto_increment,
34 `b` int(11) default NULL,
35 `c` int default 7,
36 PRIMARY KEY (`a`),
37 UNIQUE KEY `b` (`b`)
38 ) ENGINE=innodb;
39 Warnings:
40 Warning 1681 Integer display width is deprecated and will be removed in a future release.
41 Warning 1681 Integer display width is deprecated and will be removed in a future release.
42 INSERT INTO t1 (a,b,c) VALUES (1,1,1), (2,2,2), (3,3,3), (4,4,4);
43 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
44 BEGIN;
45 UPDATE t1 SET b=2 WHERE a=1;
46 ERROR 23000: Duplicate entry '2' for key 't1.b'
47 SELECT a FROM t1 WHERE 2<=b AND b<=3 AND c=1 FOR SHARE;
48 a
49 BEGIN;
50 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con2_will_wait';
51 DELETE FROM t1 WHERE b=2;
52 SET DEBUG_SYNC = 'now WAIT_FOR con2_will_wait';
53 COMMIT;
54 COMMIT;
55 DROP TABLE t1;
56 SET DEBUG_SYNC = 'RESET';
57 ########################
58 # #
59 # End of Bug #27898384 #
60 # #
61 ########################
62 # Bug #31046834 ASSERTION FAILURE: TRX0TRX.CC:2663:TRX_ALLOWED_TWO_LATCHES THREAD 14024410520550
63 # Bug #31047326 ASSERTION FAILURE: TRX0TRX.CC:2663:TRX_ALLOWED_2_LATCHES THREAD 139840853837568
64 CREATE TABLE t1 (
65 id INT PRIMARY KEY,
66 val INT
67 ) Engine=InnoDB;
68 INSERT INTO t1 (id, val) VALUES (1,1);
69 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
70 BEGIN;
71 SET DEBUG_SYNC = 'after_lock_clust_rec_read_check_and_lock SIGNAL con1_created_lock WAIT_FOR con2_will_wait';
72 SELECT * FROM t1 WHERE val=13 FOR UPDATE;
73 SET DEBUG_SYNC = 'now WAIT_FOR con1_created_lock';
74 BEGIN;
75 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con2_will_wait';
76 SELECT * FROM t1 WHERE id=1 FOR UPDATE;
77 id val
78 COMMIT;
79 id val
80 1 1
81 COMMIT;
82 DROP TABLE t1;
83 SET DEBUG_SYNC = 'RESET';