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.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
