MySql can't update a specific record

Asked Jun 04 '14 at 18:24

Active Jun 04 '14 at 18:48

Viewed 171 times

i am trying to update a single record in my DB. i am getting

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

but when i try to update records with some other column , the update is return immediately.

also i cant delete this record

can you help me with this please .

asked Jun 04 '14 at 18:24

shay te

A wonderful way to debug this transaction can be found here at SO: http://stackoverflow.com/questions/6000336/how-to-debug-lock-wait-timeout-exceeded – Bjoern Jun 04 '14 at 18:27
There may be an open transaction which still not committed. – Rahul Jun 04 '14 at 18:27
can i force close transactions that running more then X seconds ? – shay te Jun 04 '14 at 18:30

0 Answers0