Error 1205 (HY000): Lock wait timeout exceeded; try restarting transaction From InnoDB in MySQL Server
Last updated on FEBRUARY 07, 2017
Applies to:MySQL Server - Version 4.0 and later
Information in this document applies to any platform.
***Checked for relevance on28-MAR-2014Y***
***Checked for relevance on 30-JUN-2015Y***
A MySQL client's transaction fails with an error message:
Possible changes that could trigger this error:
- Slow write queries (due to inefficient SQL, data size getting much bigger, or other reasons)
- Decreasing the innodb_lock_wait_timeout variable size.
- Slow queries.
- Slow transactions with many faster queries, so that locks remain held for a long time.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms