How to debug Lock wait timeout exceeded on MySQL?

In my production error logs I occasionally see:

SQLSTATE[HY000]: General error: 1205
Lock wait timeout exceeded; try
restarting transaction

I know which query is trying to access the database at that moment but is there a way to find out which query had the lock at that precise moment?

11 Answers
11

Leave a Comment