Hi PA,
Today my django web app suddenly started producting (1205, 'Lock wait timeout exceeded; try restarting transaction')
errors am unsure of what the cause might be. I haven't changed the codebase in some time and am not sure how to debug this since it seems to be happening on more than one view (i.e when attempting to logout or get a notification count which both typically only take 0.150 seconds or less). I went through the forums and then tried to run the SHOW PROCESSLIST command in the mysql console and this was my result:
| ... | xDev | ... | xDev$MyDb | Query | 0 | starting | SHOW FULL PROCESSLIST |
Do you have any ideas on why this would suddenly start happening?
Thank you for your time!