Hi!
> "Tim" == Tim Bunce <[EMAIL PROTECTED]> writes:
Tim> On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote:
>>
mysql> rename tables test1 to test3, test2 to test1, test3 to test2;
Peter> ERROR 1192: Can't execute the given command because you have active locked
Peter> table
On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote:
>
> mysql> rename tables test1 to test3, test2 to test1, test3 to test2;
> Peter> ERROR 1192: Can't execute the given command because you have active locked
> Peter> tables or an active transaction
>
> I bet this happens when you
Hi!
> "Cal" == Cal Evans <[EMAIL PROTECTED]> writes:
Cal> Gotta ask. Is this a problem or just a really bad idea? Part of me can see
Cal> why this is barfing. ON the same line you rename a table twice. If it's
Cal> threading these requests then one thread might not be finished with the
Ca
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> Resently I've found a problem when I was trying to upgrade from
Peter> 3.23.32 to 3.23.36, well I had a same problem then tried to upgrade
Peter> to 3.23.33 so decided to wait a bit, but now i think
f 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
