LMSouq
general-dev Open

Getting "Lock wait timeout exceeded; try restarting transaction" even though I'm not using a transaction

JA
Jason Swett
1 month ago
3 views
Problem Description
I'm running the following MySQL `UPDATE` statement: mysql> update customer set account_import_id = 1; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction I'm not using a transaction, so why would I be getting this error? I even tried restarting my MySQL server and it didn't help. The table has 406,733 rows.

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base