& Ldquo; Lock wait timeout exceeded & rdquo; Without processes in processlist

advertisements

I've gotten the next error while trying to perform some bunch deletion with reasonable limit:

query=(DELETE FROM `A` WHERE `id` < 123456 LIMIT 1000)

exception=(1205, 'Lock wait timeout exceeded; try restarting transaction')

And

mysql> SHOW OPEN TABLES like 'A';
+----------+----------------------+--------+-------------+
| Database | Table                | In_use | Name_locked |
+----------+----------------------+--------+-------------+
| D        | A                    |      3 |           0 |
+----------+----------------------+--------+-------------+
1 row in set (0.22 sec)

I see that where is might be a deadlock, but show full processlist outputs only itself. Where to dig into?

InnoDB, MySQL 5.5


This means there is a transaction that should be committed. Check other sessions or other applications which may operate with this table.