Error code

MySQL 1205 — Lock wait timeout exceeded

One transaction is waiting too long for a lock held by another transaction.

View my favorites

MySQL 1205. — Lock wait timeout.

Field: DatabasePriority: High.

What does this error mean?

One transaction is waiting too long for a lock held by another transaction.

Probable causes

  • incorrect configuration or dependency.
  • service, network or storage unavailable.
  • recent change or component failure.

Verification and resolution

  1. Keep the message complete and the time of the, error.
  2. Identify the exact component that returns the code.
  3. Control dependencies before any global repair.
  4. Apply a targeted correction and then retester.
Precaution:::.:. Avoid generic repair scripts or irreversible removals before having confirmed the cause.

← Return to error codes.

See also::. MySQL 1213..

♡ 0