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

http://stackoverflow.com/questions/7598373/display-open-transactions-in-mysql — Vicky Thakor, Jul 28 '15 at 07:22

score 21 · Answer 1 · edited Dec 25 '19 at 14:43

21

I solved this problem using SQL query : UNLOCK TABLES;

edited Dec 25 '19 at 14:43

EricLavault

answered Dec 04 '19 at 18:10

Cleber Griff

score 15 · Accepted Answer · edited Dec 25 '19 at 14:44

15

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.

edited Dec 25 '19 at 14:44

EricLavault

answered Jul 28 '15 at 06:58

Madhivanan

2 Answers2