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

Question

I am trying to truncate my table on mysql workbench

truncate pbx_api.confbridges;

but it says

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

Solution 1

It means that the table is exclusively locked and is under transaction. You cannot truncate until it is rollbacked or committed.

For example to unlock tables, see @Cleber Griff's answer.

Solution 2

I solved this problem using SQL query : UNLOCK TABLES;

Comments

[Vicky Thakor]

stackoverflow.com/questions/7598373/…