My Oracle Support Banner

Error 1205 (HY000): Lock wait timeout exceeded; try restarting transaction From InnoDB in MySQL Server (Doc ID 1296631.1)

Last updated on JULY 11, 2018

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***

Symptoms

A MySQL client's transaction fails with an error message:

 

Changes

Possible changes that could trigger this error:

  1. Slow write queries (due to inefficient SQL, data size getting much bigger, or other reasons)
  2. Decreasing the innodb_lock_wait_timeout variable size.
  3. Slow queries.
  4. 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.