title: "Lock wait timeout exceeded" without no process in processlist
body: <p>I've gotten the next error while trying to perform some bunch deletion with reasonable limit:</p>
  
  <pre><code>query=(DELETE FROM `A` WHERE `id` &lt; 123456 LIMIT 1000)
  
  exception=(1205, 'Lock wait timeout exceeded; try restarting transaction')
  </code></pre>
  
  <p>And</p>
  
  <pre><code>mysql&gt; SHOW OPEN TABLES like 'A';
  +----------+----------------------+--------+-------------+
  | Database | Table                | In_use | Name_locked |
  +----------+----------------------+--------+-------------+
  | D        | A                    |      3 |           0 |
  +----------+----------------------+--------+-------------+
  1 row in set (0.22 sec)
  </code></pre>
  
  <p>I see that where is might be a deadlock, but <code>show full processlist</code> outputs only itself. Where to dig into?</p>
  
  <p><em>InnoDB, MySQL 5.5</em></p>