Removing mysql table lock -


trying run following on mysql server 5.5:

delete `territories` `territories`.`id` = 2012603 

i get:

mysql2::error: lock wait timeout exceeded; try restarting transaction: delete `territories` `territories`.`id` = 2012603 

i see caused lock on table, when try:

show open tables; 

that table (territories) not locked - 0 in_use, 0 name_locked.

i've tried killing various mysql processes, without success. delete query won't run. i've tried rebooting server, restarting mysql, upgrading mysql. without success.

what missing here?


Comments