Debian Codegraph @

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

raw
1 CREATE TABLE t (pk int PRIMARY KEY, c varchar(10))
2 STATS_PERSISTENT=0 ENGINE=InnoDB;
3 INSERT INTO t VALUES (10, "0123456789");
4 connection default;
5 BEGIN;
6 SELECT * FROM t WHERE c = 10 FOR UPDATE;
7 pk c
8 connect trx2, localhost,root,,;
9 BEGIN;
10 SET DEBUG_SYNC="lock_wait_start SIGNAL trx2_start_waiting";
11 SET DEBUG_SYNC="lock_wait_end SIGNAL trx2_wait_end WAIT_FOR trx2_cont_upd";
12 SET DEBUG_SYNC="lock_rec_store_on_page_infimum_end SIGNAL trx2_moved_locks WAIT_FOR trx2_cont";
13 UPDATE t SET c = NULL WHERE pk = 10;
14 connect trx3, localhost,root,,;
15 SET DEBUG_SYNC="now WAIT_FOR trx2_start_waiting";
16 SET innodb_lock_wait_timeout=1;
17 BEGIN;
18 SET DEBUG_SYNC="lock_wait_start SIGNAL trx3_start_waiting WAIT_FOR trx3_cont_waiting";
19 SET DEBUG_SYNC="lock_sys_t_cancel_enter SIGNAL trx3_cancel_enter WAIT_FOR trx3_cont_cancel_waiting";
20 UPDATE t SET c = "abcdefghij" WHERE pk = 10;
21 connection default;
22 SET DEBUG_SYNC="now WAIT_FOR trx3_start_waiting";
23 COMMIT;
24 SET DEBUG_SYNC="now WAIT_FOR trx2_wait_end";
25 SET DEBUG_SYNC="now SIGNAL trx3_cont_waiting";
26 SET DEBUG_SYNC="now WAIT_FOR trx3_cancel_enter";
27 SET DEBUG_SYNC="now SIGNAL trx2_cont_upd";
28 SET DEBUG_SYNC="now WAIT_FOR trx2_moved_locks";
29 SET DEBUG_SYNC="now SIGNAL trx3_cont_cancel_waiting";
30 SET DEBUG_SYNC="now SIGNAL trx2_cont";
31 disconnect trx2;
32 disconnect trx3;
33 connection default;
34 SET DEBUG_SYNC="RESET";
35 DROP TABLE t;