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/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
