mysql - Getting "Lock wait timeout exceeded; try restarting transaction" even though I'm not using a transaction -

i'm running following mysql update statement:

mysql> update customer set account_import_id = 1; error 1205 (hy000): lock wait timeout exceeded; try restarting transaction 

i'm not using transaction, why getting error? tried restarting mysql server , didn't help.

the table has 406,733 rows.

you using transaction; autocommit not disable transactions, makes them automatically commit @ end of statement.

what happening is, other thread holding record lock on record (you're updating every record in table!) long, , thread being timed out.

you can see more details of event issuing

show engine innodb status\g  

after event. ideally on quiet test-machine.