[ERROR]Lock wait timeout exceeded; try restarting transaction

1205, 'Lock wait timeout exceeded; try restarting transaction'

 

mysql> show processlist;

+--------+------+--------------------+-------+---------+------+--------------+-+

| Id     | User | Host               | db    | Command | Time | State        | |

+--------+------+--------------------+-------+---------+------+--------------+-+

| 306835 | root | localhost          | dmsDB | Query   | 3651 | updating     | |

| 309090 | root | localhost          | dmsDB | Sleep   | 1018 |              | |

| 309199 | root | 192.168.1.231:2452 | dmsDB | Query   |   53 | Sending data | |

| 309288 | root | localhost          | NULL  | Query   |    0 | NULL         | |

+--------+------+--------------------+-------+---------+------+--------------+-+

4 rows in set (0.00 sec)

 

kill 306835

kill 309199

 

mysql> show processlist;

+--------+------+-----------+-------+---------+------+-------+-----------------+

| Id     | User | Host      | db    | Command | Time | State | Info            |

+--------+------+-----------+-------+---------+------+-------+-----------------+

| 306835 | root | localhost | dmsDB | Killed  | 4942 | end   | DELETE FROM t_do|

| 309090 | root | localhost | dmsDB | Sleep   | 2309 |       | NULL            |

| 309288 | root | localhost | NULL  | Query   |    0 | NULL  | show processlist|

+--------+------+-----------+-------+---------+------+-------+-----------------+

 

unlock tables;

출처 : http://blog.naver.com/w123654/10035121619