Closed Bug 1500561 (bmo-kills-mysql) Opened 6 years ago Closed 6 years ago

BMO kills MySQL with CASE WHEN statements in RequestNags script

Categories

(bugzilla.mozilla.org :: Infrastructure, defect)

Production
defect
Not set
normal

Tracking

()

RESOLVED FIXED

People

(Reporter: dylan, Assigned: ckolos)

References

Details

The request nag script is able to crash MySQL, which has caused many issues. The underlying cause and solution appear to be: "This appears to be caused by INNODB statistics collectors using uncommitted data and has been fixed after MySQL 5.6.35/5.7.17 upgrading to a version in the MySQL 5.6.37-5.6.41 range should resolve this issue."
No longer blocks: bmo-db-went-away
Depends on: 1505050
fwiw, this is still happening. Not nagging, just mentioning :)
This upgrade was done Nov 28th. Since that day, nags has succeeded on every run. I am cautiously optimistic that this has fixed the issue and am closing this.
Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.