Hello mysql,
Resently I've found a problem when I was trying to upgrade from
3.23.32 to 3.23.36, well I had a same problem then tried to upgrade
to 3.23.33 so decided to wait a bit, but now i think I should check
more about this.
The problem is the followings: Sometimes then I rename a table I get
the following strange error, therefore sometimes I do not. I do not
use transactions and do not lock anything at this point but it
sometimes happens:
mysql> create table test1 ( id int );
Query OK, 0 rows affected (0.00 sec)
mysql> create table test2 ( id int );
Query OK, 0 rows affected (0.00 sec)
mysql> rename tables test1 to test3, test2 to test1, test3 to test2;
ERROR 1192: Can't execute the given command because you have active locked
tables or an active transaction
The same problem may appear even then using just first part of rename
statement.
I tried many different things like trying to flush tables before
trying to rename them, trying to start and commit a transaction before
or lock and unlock tables nothing helps but after restarting mysql I
get ride of this problem.
Also I found what after this problem appears there is no way to get a
ride from it without restarting mysql.
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php