Re: Can't execute the given command because you have active locked tables or an active transaction
Hi, > I am getting "Can't execute the given command because you have active locked > tables or an active transaction" error when I am trying to truncate table. I > am unable to understand the error as when I am using the mysql query browser > then the same command is working fine but when I am doing it through > NetBeans then I am getting this error. Well that is what is very strange and > I am unable to solve this problem. Try enabling MySQL querie log: log=/var/log/somelog.log and execute the command from netbeans. Look at the log and execute again from query browser. Now, look if there is any difference on the log (perhaps netbeans execute some other queries) ;) -- Lo que haría sería hacerme pasar por sordomudo y así no tendría que hablar. Si querían decirme algo, tendrían que escribirlo en un papelito y enseñármelo. Al final se hartarían y ya no tendría que hablar el resto de mi vida. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Can't execute the given command because you have active locked tables or an active transaction
Hi All,I am getting "Can't execute the given command because you have active locked tables or an active transaction" error when I am trying to truncate table. I am unable to understand the error as when I am using the mysql query browser then the same command is working fine but when I am doing it through NetBeans then I am getting this error. Well that is what is very strange and I am unable to solve this problem.If anyone could just help me with this. Thanks in advance.--Regards, Manasi Save
Can't execute the given command because you have active locked tables or an active transaction
Hi all, i have a problem with a db innoDB 4.0.20 server. The error 'Can't execute the given command because you have active locked tables or an active transaction' happens on the second truncate (the fist table trucante correctly) of a db composed by three tables, without any foreign keys. The db is READ-COMMITTED mode, and no other strange things are around. I woldu like to truncate all the table, then insert new records. I found that a bug was discovered on 4.0.2, but i have 4.0.20... Thanks for any help. Michele -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]