Page MenuHomePhabricator

"1205 Lock wait timeout exceeded" in AbuseFilter::checkEmergencyDisable
Closed, ResolvedPublic

Description

Author: 7rt1j

Description:
English Wikipedia, MediaWiki 1.23wmf10 (7a69cda)

From ~16:50 to ~17:40 today, many editors at [[Wikipedia:Village pump (technical)#Database error]] were reporting the following error when attempting to save articles:

A database query error has occurred. This may indicate a bug in the software.

Function: AbuseFilter::checkEmergencyDisable
Error: 1205 Lock wait timeout exceeded; try restarting transaction (10.64.32.26)

The problem seems to have started with a bad edit to [[Special:AbuseFilter/554]] that caused it to match the majority of (or possibly even all) edits in the main namespace. The filter became flagged with "Warning: This filter was automatically disabled as a safety measure. It reached the limit of matching more than 5.00% of actions." (I'm not sure exactly when this flag appeared on the filter.)

The filter was not set to block edits, yet it appears the automatic disabling of it caused edits to be blocked anyway (with the above error).


Version: unspecified
Severity: normal
URL: https://en.wikipedia.org/wiki/Wikipedia:Village_pump_(technical)#Database_error

Details

Reference
bz60600

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 2:55 AM
bzimport added a project: AbuseFilter.
bzimport set Reference to bz60600.
bzimport added a subscriber: Unknown Object (MLST).

Change 110253 had a related patch set uploaded by Aaron Schulz:
Defer af_throttled query to post-commit auto-commit mode

https://gerrit.wikimedia.org/r/110253

Change 110253 merged by jenkins-bot:
Defer af_throttled query to post-commit auto-commit mode

https://gerrit.wikimedia.org/r/110253