991 lines
29 KiB
Plaintext
991 lines
29 KiB
Plaintext
#
|
|
# Bug #91959 UBSAN: signed integer overflow in lock_update_trx_age
|
|
#
|
|
CREATE TABLE t1 (
|
|
id INT PRIMARY KEY
|
|
) Engine=InnoDB;
|
|
SET @innodb_lock_wait_timeout_saved = @@global.innodb_lock_wait_timeout;
|
|
SET @@global.innodb_lock_wait_timeout = 100000;
|
|
# establishing connection cats0
|
|
# establishing connection cats1
|
|
# establishing connection cats2
|
|
# establishing connection cats3
|
|
# establishing connection cats4
|
|
# establishing connection cats5
|
|
# establishing connection cats6
|
|
# establishing connection cats7
|
|
# establishing connection cats8
|
|
# establishing connection cats9
|
|
# establishing connection cats10
|
|
# establishing connection cats11
|
|
# establishing connection cats12
|
|
# establishing connection cats13
|
|
# establishing connection cats14
|
|
# establishing connection cats15
|
|
# establishing connection cats16
|
|
# establishing connection cats17
|
|
# establishing connection cats18
|
|
# establishing connection cats19
|
|
# establishing connection cats20
|
|
# establishing connection cats21
|
|
# establishing connection cats22
|
|
# establishing connection cats23
|
|
# establishing connection cats24
|
|
# establishing connection cats25
|
|
# establishing connection cats26
|
|
# establishing connection cats27
|
|
# establishing connection cats28
|
|
# establishing connection cats29
|
|
# establishing connection cats30
|
|
# establishing connection cats31
|
|
# establishing connection cats32
|
|
# wating for cats1
|
|
# wating for cats2
|
|
# wating for cats3
|
|
# wating for cats4
|
|
# wating for cats5
|
|
# wating for cats6
|
|
# wating for cats7
|
|
# wating for cats8
|
|
# wating for cats9
|
|
# wating for cats10
|
|
# wating for cats11
|
|
# wating for cats12
|
|
# wating for cats13
|
|
# wating for cats14
|
|
# wating for cats15
|
|
# wating for cats16
|
|
# wating for cats17
|
|
# wating for cats18
|
|
# wating for cats19
|
|
# wating for cats20
|
|
# wating for cats21
|
|
# wating for cats22
|
|
# wating for cats23
|
|
# wating for cats24
|
|
# wating for cats25
|
|
# wating for cats26
|
|
# wating for cats27
|
|
# wating for cats28
|
|
# wating for cats29
|
|
# wating for cats30
|
|
# wating for cats31
|
|
# wating for cats32
|
|
INSERT INTO t1 (id) VALUES (0);
|
|
INSERT INTO t1 (id) VALUES (1);
|
|
INSERT INTO t1 (id) VALUES (2);
|
|
INSERT INTO t1 (id) VALUES (3);
|
|
INSERT INTO t1 (id) VALUES (4);
|
|
INSERT INTO t1 (id) VALUES (5);
|
|
INSERT INTO t1 (id) VALUES (6);
|
|
INSERT INTO t1 (id) VALUES (7);
|
|
INSERT INTO t1 (id) VALUES (8);
|
|
INSERT INTO t1 (id) VALUES (9);
|
|
INSERT INTO t1 (id) VALUES (10);
|
|
INSERT INTO t1 (id) VALUES (11);
|
|
INSERT INTO t1 (id) VALUES (12);
|
|
INSERT INTO t1 (id) VALUES (13);
|
|
INSERT INTO t1 (id) VALUES (14);
|
|
INSERT INTO t1 (id) VALUES (15);
|
|
INSERT INTO t1 (id) VALUES (16);
|
|
INSERT INTO t1 (id) VALUES (17);
|
|
INSERT INTO t1 (id) VALUES (18);
|
|
INSERT INTO t1 (id) VALUES (19);
|
|
INSERT INTO t1 (id) VALUES (20);
|
|
INSERT INTO t1 (id) VALUES (21);
|
|
INSERT INTO t1 (id) VALUES (22);
|
|
INSERT INTO t1 (id) VALUES (23);
|
|
INSERT INTO t1 (id) VALUES (24);
|
|
INSERT INTO t1 (id) VALUES (25);
|
|
INSERT INTO t1 (id) VALUES (26);
|
|
INSERT INTO t1 (id) VALUES (27);
|
|
INSERT INTO t1 (id) VALUES (28);
|
|
INSERT INTO t1 (id) VALUES (29);
|
|
INSERT INTO t1 (id) VALUES (30);
|
|
INSERT INTO t1 (id) VALUES (31);
|
|
INSERT INTO t1 (id) VALUES (32);
|
|
# establishing connection connection0 on layer 0 and acquire S lock on 0
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 0 FOR SHARE;
|
|
id
|
|
0
|
|
# establishing connection connection1 on layer 0 and acquire S lock on 0
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 0 FOR SHARE;
|
|
id
|
|
0
|
|
# establishing connection connection2 on layer 1 and acquire S lock on 1
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 1 FOR SHARE;
|
|
id
|
|
1
|
|
# establishing connection connection3 on layer 1 and acquire S lock on 1
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 1 FOR SHARE;
|
|
id
|
|
1
|
|
# establishing connection connection4 on layer 2 and acquire S lock on 2
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 2 FOR SHARE;
|
|
id
|
|
2
|
|
# establishing connection connection5 on layer 2 and acquire S lock on 2
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 2 FOR SHARE;
|
|
id
|
|
2
|
|
# establishing connection connection6 on layer 3 and acquire S lock on 3
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 3 FOR SHARE;
|
|
id
|
|
3
|
|
# establishing connection connection7 on layer 3 and acquire S lock on 3
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 3 FOR SHARE;
|
|
id
|
|
3
|
|
# establishing connection connection8 on layer 4 and acquire S lock on 4
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 4 FOR SHARE;
|
|
id
|
|
4
|
|
# establishing connection connection9 on layer 4 and acquire S lock on 4
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 4 FOR SHARE;
|
|
id
|
|
4
|
|
# establishing connection connection10 on layer 5 and acquire S lock on 5
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 5 FOR SHARE;
|
|
id
|
|
5
|
|
# establishing connection connection11 on layer 5 and acquire S lock on 5
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 5 FOR SHARE;
|
|
id
|
|
5
|
|
# establishing connection connection12 on layer 6 and acquire S lock on 6
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 6 FOR SHARE;
|
|
id
|
|
6
|
|
# establishing connection connection13 on layer 6 and acquire S lock on 6
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 6 FOR SHARE;
|
|
id
|
|
6
|
|
# establishing connection connection14 on layer 7 and acquire S lock on 7
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 7 FOR SHARE;
|
|
id
|
|
7
|
|
# establishing connection connection15 on layer 7 and acquire S lock on 7
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 7 FOR SHARE;
|
|
id
|
|
7
|
|
# establishing connection connection16 on layer 8 and acquire S lock on 8
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 8 FOR SHARE;
|
|
id
|
|
8
|
|
# establishing connection connection17 on layer 8 and acquire S lock on 8
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 8 FOR SHARE;
|
|
id
|
|
8
|
|
# establishing connection connection18 on layer 9 and acquire S lock on 9
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 9 FOR SHARE;
|
|
id
|
|
9
|
|
# establishing connection connection19 on layer 9 and acquire S lock on 9
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 9 FOR SHARE;
|
|
id
|
|
9
|
|
# establishing connection connection20 on layer 10 and acquire S lock on 10
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 10 FOR SHARE;
|
|
id
|
|
10
|
|
# establishing connection connection21 on layer 10 and acquire S lock on 10
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 10 FOR SHARE;
|
|
id
|
|
10
|
|
# establishing connection connection22 on layer 11 and acquire S lock on 11
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 11 FOR SHARE;
|
|
id
|
|
11
|
|
# establishing connection connection23 on layer 11 and acquire S lock on 11
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 11 FOR SHARE;
|
|
id
|
|
11
|
|
# establishing connection connection24 on layer 12 and acquire S lock on 12
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 12 FOR SHARE;
|
|
id
|
|
12
|
|
# establishing connection connection25 on layer 12 and acquire S lock on 12
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 12 FOR SHARE;
|
|
id
|
|
12
|
|
# establishing connection connection26 on layer 13 and acquire S lock on 13
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 13 FOR SHARE;
|
|
id
|
|
13
|
|
# establishing connection connection27 on layer 13 and acquire S lock on 13
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 13 FOR SHARE;
|
|
id
|
|
13
|
|
# establishing connection connection28 on layer 14 and acquire S lock on 14
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 14 FOR SHARE;
|
|
id
|
|
14
|
|
# establishing connection connection29 on layer 14 and acquire S lock on 14
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 14 FOR SHARE;
|
|
id
|
|
14
|
|
# establishing connection connection30 on layer 15 and acquire S lock on 15
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 15 FOR SHARE;
|
|
id
|
|
15
|
|
# establishing connection connection31 on layer 15 and acquire S lock on 15
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 15 FOR SHARE;
|
|
id
|
|
15
|
|
# establishing connection connection32 on layer 16 and acquire S lock on 16
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 16 FOR SHARE;
|
|
id
|
|
16
|
|
# establishing connection connection33 on layer 16 and acquire S lock on 16
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 16 FOR SHARE;
|
|
id
|
|
16
|
|
# establishing connection connection34 on layer 17 and acquire S lock on 17
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 17 FOR SHARE;
|
|
id
|
|
17
|
|
# establishing connection connection35 on layer 17 and acquire S lock on 17
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 17 FOR SHARE;
|
|
id
|
|
17
|
|
# establishing connection connection36 on layer 18 and acquire S lock on 18
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 18 FOR SHARE;
|
|
id
|
|
18
|
|
# establishing connection connection37 on layer 18 and acquire S lock on 18
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 18 FOR SHARE;
|
|
id
|
|
18
|
|
# establishing connection connection38 on layer 19 and acquire S lock on 19
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 19 FOR SHARE;
|
|
id
|
|
19
|
|
# establishing connection connection39 on layer 19 and acquire S lock on 19
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 19 FOR SHARE;
|
|
id
|
|
19
|
|
# establishing connection connection40 on layer 20 and acquire S lock on 20
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 20 FOR SHARE;
|
|
id
|
|
20
|
|
# establishing connection connection41 on layer 20 and acquire S lock on 20
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 20 FOR SHARE;
|
|
id
|
|
20
|
|
# establishing connection connection42 on layer 21 and acquire S lock on 21
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 21 FOR SHARE;
|
|
id
|
|
21
|
|
# establishing connection connection43 on layer 21 and acquire S lock on 21
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 21 FOR SHARE;
|
|
id
|
|
21
|
|
# establishing connection connection44 on layer 22 and acquire S lock on 22
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 22 FOR SHARE;
|
|
id
|
|
22
|
|
# establishing connection connection45 on layer 22 and acquire S lock on 22
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 22 FOR SHARE;
|
|
id
|
|
22
|
|
# establishing connection connection46 on layer 23 and acquire S lock on 23
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 23 FOR SHARE;
|
|
id
|
|
23
|
|
# establishing connection connection47 on layer 23 and acquire S lock on 23
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 23 FOR SHARE;
|
|
id
|
|
23
|
|
# establishing connection connection48 on layer 24 and acquire S lock on 24
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 24 FOR SHARE;
|
|
id
|
|
24
|
|
# establishing connection connection49 on layer 24 and acquire S lock on 24
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 24 FOR SHARE;
|
|
id
|
|
24
|
|
# establishing connection connection50 on layer 25 and acquire S lock on 25
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 25 FOR SHARE;
|
|
id
|
|
25
|
|
# establishing connection connection51 on layer 25 and acquire S lock on 25
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 25 FOR SHARE;
|
|
id
|
|
25
|
|
# establishing connection connection52 on layer 26 and acquire S lock on 26
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 26 FOR SHARE;
|
|
id
|
|
26
|
|
# establishing connection connection53 on layer 26 and acquire S lock on 26
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 26 FOR SHARE;
|
|
id
|
|
26
|
|
# establishing connection connection54 on layer 27 and acquire S lock on 27
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 27 FOR SHARE;
|
|
id
|
|
27
|
|
# establishing connection connection55 on layer 27 and acquire S lock on 27
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 27 FOR SHARE;
|
|
id
|
|
27
|
|
# establishing connection connection56 on layer 28 and acquire S lock on 28
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 28 FOR SHARE;
|
|
id
|
|
28
|
|
# establishing connection connection57 on layer 28 and acquire S lock on 28
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 28 FOR SHARE;
|
|
id
|
|
28
|
|
# establishing connection connection58 on layer 29 and acquire S lock on 29
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 29 FOR SHARE;
|
|
id
|
|
29
|
|
# establishing connection connection59 on layer 29 and acquire S lock on 29
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 29 FOR SHARE;
|
|
id
|
|
29
|
|
# establishing connection connection60 on layer 30 and acquire S lock on 30
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 30 FOR SHARE;
|
|
id
|
|
30
|
|
# establishing connection connection61 on layer 30 and acquire S lock on 30
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 30 FOR SHARE;
|
|
id
|
|
30
|
|
# establishing connection connection62 on layer 31 and acquire S lock on 31
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 31 FOR SHARE;
|
|
id
|
|
31
|
|
# establishing connection connection63 on layer 31 and acquire S lock on 31
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 31 FOR SHARE;
|
|
id
|
|
31
|
|
# establishing connection connection64 on layer 32 and acquire S lock on 32
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 32 FOR SHARE;
|
|
id
|
|
32
|
|
# establishing connection connection65 on layer 32 and acquire S lock on 32
|
|
BEGIN;
|
|
SELECT * FROM t1 WHERE id = 32 FOR SHARE;
|
|
id
|
|
32
|
|
# connection_name on layer 0 tries to acquire X lock on 1
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection0';
|
|
SELECT * FROM t1 WHERE id = 1 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection0';
|
|
# connection_name on layer 0 tries to acquire X lock on 1
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection1';
|
|
SELECT * FROM t1 WHERE id = 1 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection1';
|
|
# connection_name on layer 1 tries to acquire X lock on 2
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection2';
|
|
SELECT * FROM t1 WHERE id = 2 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection2';
|
|
# connection_name on layer 1 tries to acquire X lock on 2
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection3';
|
|
SELECT * FROM t1 WHERE id = 2 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection3';
|
|
# connection_name on layer 2 tries to acquire X lock on 3
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection4';
|
|
SELECT * FROM t1 WHERE id = 3 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection4';
|
|
# connection_name on layer 2 tries to acquire X lock on 3
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection5';
|
|
SELECT * FROM t1 WHERE id = 3 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection5';
|
|
# connection_name on layer 3 tries to acquire X lock on 4
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection6';
|
|
SELECT * FROM t1 WHERE id = 4 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection6';
|
|
# connection_name on layer 3 tries to acquire X lock on 4
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection7';
|
|
SELECT * FROM t1 WHERE id = 4 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection7';
|
|
# connection_name on layer 4 tries to acquire X lock on 5
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection8';
|
|
SELECT * FROM t1 WHERE id = 5 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection8';
|
|
# connection_name on layer 4 tries to acquire X lock on 5
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection9';
|
|
SELECT * FROM t1 WHERE id = 5 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection9';
|
|
# connection_name on layer 5 tries to acquire X lock on 6
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection10';
|
|
SELECT * FROM t1 WHERE id = 6 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection10';
|
|
# connection_name on layer 5 tries to acquire X lock on 6
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection11';
|
|
SELECT * FROM t1 WHERE id = 6 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection11';
|
|
# connection_name on layer 6 tries to acquire X lock on 7
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection12';
|
|
SELECT * FROM t1 WHERE id = 7 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection12';
|
|
# connection_name on layer 6 tries to acquire X lock on 7
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection13';
|
|
SELECT * FROM t1 WHERE id = 7 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection13';
|
|
# connection_name on layer 7 tries to acquire X lock on 8
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection14';
|
|
SELECT * FROM t1 WHERE id = 8 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection14';
|
|
# connection_name on layer 7 tries to acquire X lock on 8
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection15';
|
|
SELECT * FROM t1 WHERE id = 8 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection15';
|
|
# connection_name on layer 8 tries to acquire X lock on 9
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection16';
|
|
SELECT * FROM t1 WHERE id = 9 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection16';
|
|
# connection_name on layer 8 tries to acquire X lock on 9
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection17';
|
|
SELECT * FROM t1 WHERE id = 9 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection17';
|
|
# connection_name on layer 9 tries to acquire X lock on 10
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection18';
|
|
SELECT * FROM t1 WHERE id = 10 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection18';
|
|
# connection_name on layer 9 tries to acquire X lock on 10
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection19';
|
|
SELECT * FROM t1 WHERE id = 10 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection19';
|
|
# connection_name on layer 10 tries to acquire X lock on 11
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection20';
|
|
SELECT * FROM t1 WHERE id = 11 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection20';
|
|
# connection_name on layer 10 tries to acquire X lock on 11
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection21';
|
|
SELECT * FROM t1 WHERE id = 11 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection21';
|
|
# connection_name on layer 11 tries to acquire X lock on 12
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection22';
|
|
SELECT * FROM t1 WHERE id = 12 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection22';
|
|
# connection_name on layer 11 tries to acquire X lock on 12
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection23';
|
|
SELECT * FROM t1 WHERE id = 12 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection23';
|
|
# connection_name on layer 12 tries to acquire X lock on 13
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection24';
|
|
SELECT * FROM t1 WHERE id = 13 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection24';
|
|
# connection_name on layer 12 tries to acquire X lock on 13
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection25';
|
|
SELECT * FROM t1 WHERE id = 13 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection25';
|
|
# connection_name on layer 13 tries to acquire X lock on 14
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection26';
|
|
SELECT * FROM t1 WHERE id = 14 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection26';
|
|
# connection_name on layer 13 tries to acquire X lock on 14
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection27';
|
|
SELECT * FROM t1 WHERE id = 14 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection27';
|
|
# connection_name on layer 14 tries to acquire X lock on 15
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection28';
|
|
SELECT * FROM t1 WHERE id = 15 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection28';
|
|
# connection_name on layer 14 tries to acquire X lock on 15
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection29';
|
|
SELECT * FROM t1 WHERE id = 15 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection29';
|
|
# connection_name on layer 15 tries to acquire X lock on 16
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection30';
|
|
SELECT * FROM t1 WHERE id = 16 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection30';
|
|
# connection_name on layer 15 tries to acquire X lock on 16
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection31';
|
|
SELECT * FROM t1 WHERE id = 16 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection31';
|
|
# connection_name on layer 16 tries to acquire X lock on 17
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection32';
|
|
SELECT * FROM t1 WHERE id = 17 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection32';
|
|
# connection_name on layer 16 tries to acquire X lock on 17
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection33';
|
|
SELECT * FROM t1 WHERE id = 17 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection33';
|
|
# connection_name on layer 17 tries to acquire X lock on 18
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection34';
|
|
SELECT * FROM t1 WHERE id = 18 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection34';
|
|
# connection_name on layer 17 tries to acquire X lock on 18
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection35';
|
|
SELECT * FROM t1 WHERE id = 18 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection35';
|
|
# connection_name on layer 18 tries to acquire X lock on 19
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection36';
|
|
SELECT * FROM t1 WHERE id = 19 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection36';
|
|
# connection_name on layer 18 tries to acquire X lock on 19
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection37';
|
|
SELECT * FROM t1 WHERE id = 19 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection37';
|
|
# connection_name on layer 19 tries to acquire X lock on 20
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection38';
|
|
SELECT * FROM t1 WHERE id = 20 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection38';
|
|
# connection_name on layer 19 tries to acquire X lock on 20
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection39';
|
|
SELECT * FROM t1 WHERE id = 20 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection39';
|
|
# connection_name on layer 20 tries to acquire X lock on 21
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection40';
|
|
SELECT * FROM t1 WHERE id = 21 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection40';
|
|
# connection_name on layer 20 tries to acquire X lock on 21
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection41';
|
|
SELECT * FROM t1 WHERE id = 21 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection41';
|
|
# connection_name on layer 21 tries to acquire X lock on 22
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection42';
|
|
SELECT * FROM t1 WHERE id = 22 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection42';
|
|
# connection_name on layer 21 tries to acquire X lock on 22
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection43';
|
|
SELECT * FROM t1 WHERE id = 22 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection43';
|
|
# connection_name on layer 22 tries to acquire X lock on 23
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection44';
|
|
SELECT * FROM t1 WHERE id = 23 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection44';
|
|
# connection_name on layer 22 tries to acquire X lock on 23
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection45';
|
|
SELECT * FROM t1 WHERE id = 23 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection45';
|
|
# connection_name on layer 23 tries to acquire X lock on 24
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection46';
|
|
SELECT * FROM t1 WHERE id = 24 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection46';
|
|
# connection_name on layer 23 tries to acquire X lock on 24
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection47';
|
|
SELECT * FROM t1 WHERE id = 24 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection47';
|
|
# connection_name on layer 24 tries to acquire X lock on 25
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection48';
|
|
SELECT * FROM t1 WHERE id = 25 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection48';
|
|
# connection_name on layer 24 tries to acquire X lock on 25
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection49';
|
|
SELECT * FROM t1 WHERE id = 25 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection49';
|
|
# connection_name on layer 25 tries to acquire X lock on 26
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection50';
|
|
SELECT * FROM t1 WHERE id = 26 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection50';
|
|
# connection_name on layer 25 tries to acquire X lock on 26
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection51';
|
|
SELECT * FROM t1 WHERE id = 26 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection51';
|
|
# connection_name on layer 26 tries to acquire X lock on 27
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection52';
|
|
SELECT * FROM t1 WHERE id = 27 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection52';
|
|
# connection_name on layer 26 tries to acquire X lock on 27
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection53';
|
|
SELECT * FROM t1 WHERE id = 27 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection53';
|
|
# connection_name on layer 27 tries to acquire X lock on 28
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection54';
|
|
SELECT * FROM t1 WHERE id = 28 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection54';
|
|
# connection_name on layer 27 tries to acquire X lock on 28
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection55';
|
|
SELECT * FROM t1 WHERE id = 28 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection55';
|
|
# connection_name on layer 28 tries to acquire X lock on 29
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection56';
|
|
SELECT * FROM t1 WHERE id = 29 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection56';
|
|
# connection_name on layer 28 tries to acquire X lock on 29
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection57';
|
|
SELECT * FROM t1 WHERE id = 29 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection57';
|
|
# connection_name on layer 29 tries to acquire X lock on 30
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection58';
|
|
SELECT * FROM t1 WHERE id = 30 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection58';
|
|
# connection_name on layer 29 tries to acquire X lock on 30
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection59';
|
|
SELECT * FROM t1 WHERE id = 30 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection59';
|
|
# connection_name on layer 30 tries to acquire X lock on 31
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection60';
|
|
SELECT * FROM t1 WHERE id = 31 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection60';
|
|
# connection_name on layer 30 tries to acquire X lock on 31
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection61';
|
|
SELECT * FROM t1 WHERE id = 31 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection61';
|
|
# connection_name on layer 31 tries to acquire X lock on 32
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection62';
|
|
SELECT * FROM t1 WHERE id = 32 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection62';
|
|
# connection_name on layer 31 tries to acquire X lock on 32
|
|
SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL connection63';
|
|
SELECT * FROM t1 WHERE id = 32 FOR UPDATE;ROLLBACK;
|
|
SET DEBUG_SYNC = 'now WAIT_FOR connection63';
|
|
# cleaning up connection connection65
|
|
ROLLBACK;
|
|
# cleaning up connection connection64
|
|
ROLLBACK;
|
|
# cleaning up connection connection63
|
|
id
|
|
32
|
|
ROLLBACK;
|
|
# cleaning up connection connection62
|
|
id
|
|
32
|
|
ROLLBACK;
|
|
# cleaning up connection connection61
|
|
id
|
|
31
|
|
ROLLBACK;
|
|
# cleaning up connection connection60
|
|
id
|
|
31
|
|
ROLLBACK;
|
|
# cleaning up connection connection59
|
|
id
|
|
30
|
|
ROLLBACK;
|
|
# cleaning up connection connection58
|
|
id
|
|
30
|
|
ROLLBACK;
|
|
# cleaning up connection connection57
|
|
id
|
|
29
|
|
ROLLBACK;
|
|
# cleaning up connection connection56
|
|
id
|
|
29
|
|
ROLLBACK;
|
|
# cleaning up connection connection55
|
|
id
|
|
28
|
|
ROLLBACK;
|
|
# cleaning up connection connection54
|
|
id
|
|
28
|
|
ROLLBACK;
|
|
# cleaning up connection connection53
|
|
id
|
|
27
|
|
ROLLBACK;
|
|
# cleaning up connection connection52
|
|
id
|
|
27
|
|
ROLLBACK;
|
|
# cleaning up connection connection51
|
|
id
|
|
26
|
|
ROLLBACK;
|
|
# cleaning up connection connection50
|
|
id
|
|
26
|
|
ROLLBACK;
|
|
# cleaning up connection connection49
|
|
id
|
|
25
|
|
ROLLBACK;
|
|
# cleaning up connection connection48
|
|
id
|
|
25
|
|
ROLLBACK;
|
|
# cleaning up connection connection47
|
|
id
|
|
24
|
|
ROLLBACK;
|
|
# cleaning up connection connection46
|
|
id
|
|
24
|
|
ROLLBACK;
|
|
# cleaning up connection connection45
|
|
id
|
|
23
|
|
ROLLBACK;
|
|
# cleaning up connection connection44
|
|
id
|
|
23
|
|
ROLLBACK;
|
|
# cleaning up connection connection43
|
|
id
|
|
22
|
|
ROLLBACK;
|
|
# cleaning up connection connection42
|
|
id
|
|
22
|
|
ROLLBACK;
|
|
# cleaning up connection connection41
|
|
id
|
|
21
|
|
ROLLBACK;
|
|
# cleaning up connection connection40
|
|
id
|
|
21
|
|
ROLLBACK;
|
|
# cleaning up connection connection39
|
|
id
|
|
20
|
|
ROLLBACK;
|
|
# cleaning up connection connection38
|
|
id
|
|
20
|
|
ROLLBACK;
|
|
# cleaning up connection connection37
|
|
id
|
|
19
|
|
ROLLBACK;
|
|
# cleaning up connection connection36
|
|
id
|
|
19
|
|
ROLLBACK;
|
|
# cleaning up connection connection35
|
|
id
|
|
18
|
|
ROLLBACK;
|
|
# cleaning up connection connection34
|
|
id
|
|
18
|
|
ROLLBACK;
|
|
# cleaning up connection connection33
|
|
id
|
|
17
|
|
ROLLBACK;
|
|
# cleaning up connection connection32
|
|
id
|
|
17
|
|
ROLLBACK;
|
|
# cleaning up connection connection31
|
|
id
|
|
16
|
|
ROLLBACK;
|
|
# cleaning up connection connection30
|
|
id
|
|
16
|
|
ROLLBACK;
|
|
# cleaning up connection connection29
|
|
id
|
|
15
|
|
ROLLBACK;
|
|
# cleaning up connection connection28
|
|
id
|
|
15
|
|
ROLLBACK;
|
|
# cleaning up connection connection27
|
|
id
|
|
14
|
|
ROLLBACK;
|
|
# cleaning up connection connection26
|
|
id
|
|
14
|
|
ROLLBACK;
|
|
# cleaning up connection connection25
|
|
id
|
|
13
|
|
ROLLBACK;
|
|
# cleaning up connection connection24
|
|
id
|
|
13
|
|
ROLLBACK;
|
|
# cleaning up connection connection23
|
|
id
|
|
12
|
|
ROLLBACK;
|
|
# cleaning up connection connection22
|
|
id
|
|
12
|
|
ROLLBACK;
|
|
# cleaning up connection connection21
|
|
id
|
|
11
|
|
ROLLBACK;
|
|
# cleaning up connection connection20
|
|
id
|
|
11
|
|
ROLLBACK;
|
|
# cleaning up connection connection19
|
|
id
|
|
10
|
|
ROLLBACK;
|
|
# cleaning up connection connection18
|
|
id
|
|
10
|
|
ROLLBACK;
|
|
# cleaning up connection connection17
|
|
id
|
|
9
|
|
ROLLBACK;
|
|
# cleaning up connection connection16
|
|
id
|
|
9
|
|
ROLLBACK;
|
|
# cleaning up connection connection15
|
|
id
|
|
8
|
|
ROLLBACK;
|
|
# cleaning up connection connection14
|
|
id
|
|
8
|
|
ROLLBACK;
|
|
# cleaning up connection connection13
|
|
id
|
|
7
|
|
ROLLBACK;
|
|
# cleaning up connection connection12
|
|
id
|
|
7
|
|
ROLLBACK;
|
|
# cleaning up connection connection11
|
|
id
|
|
6
|
|
ROLLBACK;
|
|
# cleaning up connection connection10
|
|
id
|
|
6
|
|
ROLLBACK;
|
|
# cleaning up connection connection9
|
|
id
|
|
5
|
|
ROLLBACK;
|
|
# cleaning up connection connection8
|
|
id
|
|
5
|
|
ROLLBACK;
|
|
# cleaning up connection connection7
|
|
id
|
|
4
|
|
ROLLBACK;
|
|
# cleaning up connection connection6
|
|
id
|
|
4
|
|
ROLLBACK;
|
|
# cleaning up connection connection5
|
|
id
|
|
3
|
|
ROLLBACK;
|
|
# cleaning up connection connection4
|
|
id
|
|
3
|
|
ROLLBACK;
|
|
# cleaning up connection connection3
|
|
id
|
|
2
|
|
ROLLBACK;
|
|
# cleaning up connection connection2
|
|
id
|
|
2
|
|
ROLLBACK;
|
|
# cleaning up connection connection1
|
|
id
|
|
1
|
|
ROLLBACK;
|
|
# cleaning up connection connection0
|
|
id
|
|
1
|
|
ROLLBACK;
|
|
# cleaning up connection cats0
|
|
# cleaning up connection cats1
|
|
# cleaning up connection cats2
|
|
# cleaning up connection cats3
|
|
# cleaning up connection cats4
|
|
# cleaning up connection cats5
|
|
# cleaning up connection cats6
|
|
# cleaning up connection cats7
|
|
# cleaning up connection cats8
|
|
# cleaning up connection cats9
|
|
# cleaning up connection cats10
|
|
# cleaning up connection cats11
|
|
# cleaning up connection cats12
|
|
# cleaning up connection cats13
|
|
# cleaning up connection cats14
|
|
# cleaning up connection cats15
|
|
# cleaning up connection cats16
|
|
# cleaning up connection cats17
|
|
# cleaning up connection cats18
|
|
# cleaning up connection cats19
|
|
# cleaning up connection cats20
|
|
# cleaning up connection cats21
|
|
# cleaning up connection cats22
|
|
# cleaning up connection cats23
|
|
# cleaning up connection cats24
|
|
# cleaning up connection cats25
|
|
# cleaning up connection cats26
|
|
# cleaning up connection cats27
|
|
# cleaning up connection cats28
|
|
# cleaning up connection cats29
|
|
# cleaning up connection cats30
|
|
# cleaning up connection cats31
|
|
# cleaning up connection cats32
|
|
DROP TABLE t1;
|
|
SET @@global.innodb_lock_wait_timeout = @innodb_lock_wait_timeout_saved;
|
|
#
|
|
# End of Bug #91959
|
|
#
|