Closed Bug 844863 Opened 8 years ago Closed 8 years ago

Frequent deadlocks in TagNewUsers/Extension.pm line 174 when TBPLbot comments on bugs

Categories

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

Production
defect
Not set
normal

Tracking

()

RESOLVED FIXED

People

(Reporter: emorley, Assigned: glob)

References

Details

TBPL uses bzapi to comment on bugs marked as intermittent-failures. Multiple sheriffs may be marking these bugs at once, leading to frequent:
{
Bugzilla error submitting bug comment: DBD::mysql::db do failed: Deadlock found when trying to get lock; try restarting transaction [for Statement "UPDATE profiles SET comment_count=? WHERE userid=?"] at /data/www/bugzilla.mozilla.org/extensions/TagNewUsers/Extension.pm line 174. 
}

(Note until bug 844102 we just dropped these failures on the floor)

Could we exclude TBPLbot from TagNewUsers to avoid this?
Assignee: nobody → glob
added a NEVER_NEW constant with tbplbot@gmail.com as the only member currently.
also took the opportunity to upgrade the license, and remove trailing whitespace.

Committing to: bzr+ssh://bjones%40mozilla.com@bzr.mozilla.org/bmo/4.0/
modified extensions/TagNewUsers/Config.pm
modified extensions/TagNewUsers/Extension.pm
modified extensions/TagNewUsers/template/en/default/hook/bug/comments-comment_banner.html.tmpl
modified extensions/TagNewUsers/template/en/default/hook/bug/comments-user.html.tmpl
modified extensions/TagNewUsers/web/style.css
Committed revision 8508.

Committing to: bzr+ssh://bjones%40mozilla.com@bzr.mozilla.org/bmo/4.2/
modified extensions/TagNewUsers/Config.pm
modified extensions/TagNewUsers/Extension.pm
modified extensions/TagNewUsers/template/en/default/hook/bug/comments-comment_banner.html.tmpl
modified extensions/TagNewUsers/template/en/default/hook/bug/comments-user.html.tmpl
modified extensions/TagNewUsers/web/style.css
Committed revision 8596.
Status: NEW → RESOLVED
Closed: 8 years ago
Resolution: --- → FIXED
\o/ Thank you :-)
Component: Extensions: BMO → Extensions
You need to log in before you can comment on or make changes to this bug.