Can"t execute the given command because you have active locked

Can"t execute the given command because you have active locked

am 30.12.2009 10:22:25 von Manasi Save

--=_5b4vdc1zxdz4
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit


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

--=_5b4vdc1zxdz4
Content-Type: multipart/related;
boundary="=_5e3xvqoxkfeo";
start="5e4jux3krw8w@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_5e3xvqoxkfeo
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 5e4jux3krw8w@mail.artificialmachines.com

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



--=_5e3xvqoxkfeo--

--=_5b4vdc1zxdz4--

Re: Can"t execute the given command because you have active locked

am 30.12.2009 22:31:23 von Miguel Angel Nieto

Hi,

> I am getting "Can't execute the given command because you have active loc=
ked
> 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 brow=
ser
> 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=3D/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) ;)

--=20
Lo que har=EDa ser=EDa hacerme pasar por sordomudo y as=ED no tendr=EDa que
hablar. Si quer=EDan decirme algo, tendr=EDan que escribirlo en un
papelito y enseñármelo. Al final se hartar=EDan y ya no tendr=EDa 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=3Dgcdmg-mysql-2@m.gmane.o rg