Monday, October 10, 2011

Lock, Lock - Who is there? ...

I have been trying to rename a table on a mysql DB and kept getting:


Error Code: 1192
Can't execute the given command because you have active locked tables or an active transaction

I used
SHOW FULL PROCESSLIST

and was able to reduce it to only 2 lines (one of which is the one trying to run the rename).

then I used kill with the id of the other connection and now I have only my own connection.
but still

Error Code: 1192
Can't execute the given command because you have active locked tables or an active transaction

show open tables returns an empty results set.

Finally I gave up.
restarted the mysql service and the rename worked just fine.

 
Clicky Web Analytics