Closed Bug 661428 Opened 8 years ago Closed 6 years ago

Sporadic contributor forum posts cause MySQL deadlock


( :: Forum, task)

Windows 7
Not set


(Not tracked)



(Reporter: tgavankar, Unassigned)




(Whiteboard: [fromAutomation])

WebQA Automation found that occasional posts to the contributors forum (both new threads and reply posts) cause an OperationalError, with MySQL deadlocking with the error message, "Deadlock found when trying to get lock; try restarting transaction".

Only applies to allizom, as far as we can tell. 

This has been happening (looking at traceback logs) about once a month since January, all on contributors forum posts (new threads and replies). 

However, in the past 3 days it's spiked and happened ~6 times, but we can't seem to find any rhyme or reason.
Summary: Sporadic controbutor forum posts cause MySQL deadlock → Sporadic contributor forum posts cause MySQL deadlock
Whiteboard: [fromAutomation]
I took a look at the commits since 5/28 or so, and there's nothing suspicious. Nothing significant even changed in the forums app or in any other relevant DB-hitting code, AFAICT. Innnnteresting.
Are there any specific threads or posts that can reliably cause this?

Remember that our databases run on a shared DB environment for both master and slave.
Is this still happening? If not, I think we might close this bug since it hasn't been changed in over two years.  Zac, I'm asking you since you look to be the main WebQA automation person at the moment.
Flags: needinfo?(zcampbell)
Thanks Liz I think that's fine.
Closed: 6 years ago
Flags: needinfo?(zcampbell)
Resolution: --- → INVALID
You need to log in before you can comment on or make changes to this bug.