Re: unexpected create table as lock issue

2004-05-17 Thread Heikki Tuuri
Justin, - Alkuperäinen viesti - Lähettäjä: "Justin Swanhart" <[EMAIL PROTECTED]> Vastaanottaja: "Sasha Pachev" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Lähetetty: Friday, May 14, 2004 9:22 PM Aihe: Re: unexpecte

Re: unexpected create table as lock issue

2004-05-14 Thread sp4mv0rt3x-mysql
--- Sasha Pachev <[EMAIL PROTECTED]> wrote: > Very possibly a bug. INNODB deadlocks itself during > the operation, then detects > the deadlock and aborts the transaction. If this is > indeed a bug, I am sure > Heikki would like to fix it ASAP. There actually was a "create index" that was being

Re: unexpected create table as lock issue

2004-05-12 Thread Heikki Tuuri
Hi! - Original Message - From: "Sasha Pachev" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 3:01 AM Subject: Re: unexpected create table as lock issue > [EMAIL PROTECTED] wrote:

Re: unexpected create table as lock issue

2004-05-12 Thread Sasha Pachev
[EMAIL PROTECTED] wrote: I have a table called web_master which has as a primary key column called web_id. When I try to create another table as a select, I get the following error message [note, that group_id is indexed]: mysql> create table sort_test as select * from web_master where group_id = 6