Hi!
----- Original Message -----
From: "Sasha Pachev" <sasha@stripped>
To: <swany@stripped>
Cc: <mysql@stripped>; <heikki@stripped>
Sent: Thursday, May 13, 2004 3:01 AM
Subject: Re: unexpected create table as lock issue
> sp4mv0rt3x-mysql@stripped 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/
