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]
