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: > > 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 = 69; > > ERROR 1205: Lock wait timeout exceeded; Try > > restarting transaction > > > > > > There aren't any other transactions running in the > > database, so I do not understand why there is any lock > > wait.. > > 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. please run SHOW INNODB STATUS to determine what lock it is waiting for and if there really are no other active transactions. Maybe you have forgotten a transaction open? > -- > Sasha Pachev > Create online surveys at http://www.surveyz.com/ Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
