Page MenuHomePhabricator
Create Task
Maniphest T90036

Slow AFComputedVariable users query
Closed, ResolvedPublic
Actions

Description

AFComputedVariable::compute 10.64.32.27 2013 Lost connection to MySQL server during query (10.64.32.27) SELECT DISTINCT rev_user_text FROM revision WHERE rev_page = '36395484' AND (rev_timestamp<'20150219194512') ORDER BY rev_timestamp DESC LIMIT 10

This sucks when the page basically has a few bot authors and many revisions.

Details

SubjectRepoBranchLines +/-
Avoid "recent-contributors" queries that cause timeoutsmediawiki/extensions/AbuseFiltermaster+10 -4
Customize query in gerrit

Related Objects

Event Timeline

aaron created this task.Feb 20 2015, 1:02 AM
aaron raised the priority of this task from to Needs Triage.
aaron updated the task description. (Show Details)
aaron subscribed.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 20 2015, 1:02 AM
gerritbot subscribed.Feb 20 2015, 1:05 AM

Change 191823 had a related patch set uploaded (by Aaron Schulz):
Avoid "recent-contributors" queries that cause timeouts

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

Patch-For-Review

aaron claimed this task.Feb 20 2015, 1:06 AM
aaron added a project: MediaWiki-Core-Team.
aaron set Security to None.
aaron moved this task from Backlog to Needs Review/Feedback on the MediaWiki-Core-Team board.
Aklapper added a project: Patch-For-Review.Feb 20 2015, 12:28 PM
Se4598 added a project: AbuseFilter.Feb 20 2015, 4:24 PM
Se4598 subscribed.
gerritbot added a comment.Feb 20 2015, 10:47 PM

Change 191823 merged by jenkins-bot:
Avoid "recent-contributors" queries that cause timeouts

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

aaron mentioned this in rEABF42120d392111: Avoid "recent-contributors" queries that cause timeouts.Feb 20 2015, 10:48 PM
aaron moved this task from Needs Review/Feedback to Done on the MediaWiki-Core-Team board.Feb 22 2015, 10:25 AM
bd808 closed this task as Resolved.Feb 23 2015, 11:59 PM
bd808 moved this task from Done to Archive on the MediaWiki-Core-Team board.
bd808 subscribed.
Jdforrester-WMF removed a project: Patch-For-Review.Mar 3 2015, 5:27 PM
Diffusion mentioned this in rMEXT19d14d339727: Updated mediawiki/extensions Project: mediawiki/extensions/AbuseFilter….Mar 11 2015, 6:27 AM
• Deskana moved this task from Backlog to Resolved/Invalid/Legacy/Declined on the AbuseFilter board.Apr 23 2015, 4:49 AM
aaron mentioned this in rMREL42120d392111: Avoid "recent-contributors" queries that cause timeouts.Jul 14 2015, 6:11 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits