Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.6
-
None
-
amd64-windows
Description
|
CURRENT_TEST: innodb.deadlock_wait_thr_race
|
mysqltest: At line 61: query 'reap' failed: ER_LOCK_WAIT_TIMEOUT (1205): Lock wait timeout exceeded; try restarting transaction
|
|
The result from queries just before the failure was:
|
< snip >
|
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
|
SET DEBUG_SYNC = 'lock_trx_handle_wait_enter SIGNAL upd_locked WAIT_FOR upd_cont';
|
SET DEBUG_SYNC = 'trx_t_release_locks_enter SIGNAL sel_cont WAIT_FOR upd_cont_2';
|
BEGIN;
|
UPDATE t SET b = 100;
|
connection default;
|
SET DEBUG_SYNC="now WAIT_FOR upd_locked";
|
SET DEBUG_SYNC="deadlock_report_before_lock_releasing SIGNAL upd_cont WAIT_FOR sel_cont";
|
SET DEBUG_SYNC="lock_wait_before_suspend SIGNAL sel_before_suspend";
|
SELECT * FROM t WHERE a = 10 FOR UPDATE;;
|
connect con_3,localhost,root,,;
|
SET DEBUG_SYNC="now WAIT_FOR sel_before_suspend";
|
Warnings:
|
Warning 1639 debug sync point wait timed out
|
SET DEBUG_SYNC="now SIGNAL upd_cont_2";
|
disconnect con_3;
|
connection con_2;
|
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
|
disconnect con_2;
|
connection default;
|
|
More results from queries before failure can be found in D:\Buildbot\amd64-windows\build\mysql-test\var\12\log\deadlock_wait_thr_race.log
|
Attachments
Issue Links
- causes
-
MDEV-30531 Corrupt index(es) on busy table when using FOREIGN KEY with CASCADE or SET NULL
- Closed
- is caused by
-
MDEV-29622 Wrong assertions in lock_cancel_waiting_and_release() for deadlock resolving caller
- Closed