Error 1205 (HY000): Lock wait timeout exceeded; try restarting transaction From InnoDB in MySQL Server
(Doc ID 1296631.1)
Last updated on JANUARY 17, 2024
Applies to:
MySQL Server - Version 4.0 and laterInformation in this document applies to any platform.
*** ***
Symptoms
A MySQL client's transaction fails with an error message:
Changes
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.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
Diagnosing the cause |
References |