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.