#innodb_lock_wait_timeout

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

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

Error Transaction is aborted and we need to restart the transaction. Some other transaction is blocking the transaction. ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Solution We have two solutions for this 1. Increase the database parameter value “innodb_lock_wait_timeout”. 2. Check the…