Gotta ask. Is this a problem or just a really bad idea? Part of me can see
why this is barfing. ON the same line you rename a table twice. If it's
threading these requests then one thread might not be finished with the
table formally known as table1 before you try and move it again.
If you absolutely MUST move tables around like this, try 3 different
statements.
Cal
http://www.calevans.com
-----Original Message-----
From: Peter Zaitsev [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 4:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: mysql 3.23.36 problem
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
---------------------------------------------------------------------
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
