Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-wheezy-x86/builds/4832/steps/mtr/logs/stdio
innodb.deadlock_detect 'innodb' w4 [ fail ]
|
Test ended at 2017-07-04 08:46:49
|
|
CURRENT_TEST: innodb.deadlock_detect
|
mysqltest: At line 44: query 'reap' succeeded - should have failed with errno 1205...
|
|
The result from queries just before the failure was:
|
< snip >
|
id INT,
|
PRIMARY KEY(id)
|
) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES(1), (2), (3);
|
BEGIN;
|
SELECT * FROM t1 WHERE id = 1 FOR UPDATE;
|
id
|
1
|
connect con1,localhost,root,,;
|
BEGIN;
|
SELECT * FROM t1 WHERE id = 2 FOR UPDATE;
|
id
|
2
|
SELECT * FROM t1 WHERE id = 1 FOR UPDATE;
|
connection default;
|
SELECT * FROM t1 WHERE id = 2 FOR UPDATE;
|
connection con1;
|
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
|
ROLLBACK;
|
connection default;
|
|
More results from queries before failure can be found in /run/shm/var/4/log/deadlock_detect.log
|