MySQL ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Change innodb_lock_wait_timeout

Property	Value
Command-Line Format	--innodb-lock-wait-timeout=#
System Variable	innodb_lock_wait_timeout
Scope	Global, Session
Dynamic	Yes
Type	Integer
Default Value	50
Minimum Value	1
Maximum Value	1073741824

The length of time in seconds an InnoDB transaction waits for a row lock before giving up. The default value is 50 seconds.

A transaction that tries to access a row that is locked by another InnoDB transaction waits at most this many seconds for write access to the row before issuing the following error:

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction