title: Mysql table does not accept any update request
body: <p>I am using <code>Server version: 5.6.27-log MySQL Community Server (GPL)</code> and I have a problem with a table. </p>
  
  <p>I tried to update some fields with a GUI software, but when I came back to the command line, the lines I tried to update where not updated. </p>
  
  <p>I tried to see if the table was locked using <code>SHOW OPEN TABLES</code> as stated in various other questions. But my table does not appear to be locked:</p>
  
  <pre><code>+--------------------+-------------------------------------------------+--------+-------------+
  | Database           | Table                                           | In_use | Name_locked |
  +--------------------+-------------------------------------------------+--------+-------------+
  
  | arcdev             | SCHEDULED_COMMAND                               |      0 |           0 |
  </code></pre>
  
  <p>And as soon as I try to make an update like:</p>
  
  <pre><code>UPDATE SCHEDULED_COMMAND SET field = 1;
  </code></pre>
  
  <p>The server just keeps loading and nothing happen. I tried on other tables and everything worked just fine. </p>
  
  <p>I also tried some <code>DELETE</code> requests and even a <code>DROP TABLE</code> and nothing work so far...</p>
  
  <p>What am I missing? </p>
  
  <p>Thank you for your precious help!</p>
  
  <p>EDIT: Here is the result of the SHOW PROCESSLIST command while a request is hanging:</p>
  
  <pre><code>+--------+----------+---------------------------------------+-----------+---------+------+----------+-------------------------------+
  | Id     | User     | Host                                  | db        | Command | Time | State    | Info                          |
  +--------+----------+---------------------------------------+-----------+---------+------+----------+-------------------------------+
  | 282588 | rdsadmin | localhost:17966                       | mysql     | Sleep   |    2 |          | NULL                          |
  | 534575 | arc      | XXXXXX:49376                          | arcdev    | Sleep   |   17 |          | NULL                          |
  | 534579 | arc      | XXXXXX:49443                          | arcdev    | Query   |    0 | init     | SHOW PROCESSLIST              |
  | 534659 | arc      | XXXXXX:49836                          | arcdev    | Query   |   14 | updating | DELETE FROM SCHEDULED_COMMAND |
  +--------+----------+---------------------------------------+-----------+---------+------+----------+-------------------------------+
  </code></pre>