HI! I hope someone can help me with the following problem.
i have a table A type innoDB THREAD 1 makes following query's: SET AUTOCOMMIT=0; SELECT * from table A where field1='value1' FOR UPDATE; and now comes a new THREAD 2 while THREAD 1 is still holding the row lock on Table A THREAD 2 makes this query's: SET AUTOCOMMIT=0; CREATE TEMPORAY TABLE temp_A SELECT * from TABLE A; ERROR 1205: Lock wait timeout exceeded; Try restarting transaction Please Help me, what can i do ? a simple SELECT works fine, SHOW CREATE TABLE A; also bye, thomas --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
