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.