I did similar insert minutes ago with no problems. Now I try to do the same
insert just with differnet parameters and got such error message.
insert into users(first_name, last_name) values('john', 'smith');
ERROR 1205: Lock wait timeout exceeded; Try restarting transaction
I am using tables INNODB.
After one query, the MySQL does not liberate the LOCK, and when I try to
execute same query it appears the message.
#1205 - Lock wait timeout exceeded; Try restarting transaction
whait urgently one helps. thanks, Bruno
--
MySQL General Mailing List
For list
