1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
CREATE TABLE t1 (a int, b int, PRIMARY KEY (a,b)) ENGINE=InnoDB; INSERT INTO t1 (a,b) VALUES (1070109,99); CREATE TABLE t2 (b int, a int, PRIMARY KEY (b)) ENGINE=InnoDB; INSERT INTO t2 (b,a) VALUES (7,1070109); SELECT * FROM t1; a b 1070109 99 BEGIN; SELECT b FROM t2 WHERE b=7 FOR UPDATE; b 7 BEGIN; DELETE FROM t1 WHERE a=(SELECT a FROM t2 WHERE b=7); ERROR HY000: Lock wait timeout exceeded; try restarting transaction ROLLBACK; DROP TABLE t2, t1; |