Page MenuHomePhabricator
Create Task
Maniphest T341297

CheckUserLog API DB queries for username targets taking over 5 seconds
Closed, ResolvedPublic
Actions

Description

There are several occurences of the CheckUserLog API requests on enwiki taking over 5 seconds and being flagged by the TransactionProfiler.

Example:

Expectation (readQueryTime <= 5) by ApiMain::setRequestExpectations not met (actual: 6.7618520259857) in trx #7d2c5fa196

Details

SubjectRepoBranchLines +/-
CheckUserLog API: Search by for users by target IDmediawiki/extensions/CheckUsermaster+8 -6
Customize query in gerrit

Event Timeline

Dreamy_Jazz created this task.Jul 6 2023, 10:27 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 6 2023, 10:27 PM
Dreamy_Jazz updated the task description. (Show Details)Jul 6 2023, 10:31 PM
gerritbot added a comment.Jul 6 2023, 10:45 PM

Change 936098 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] CheckUserLog API: Search by for users by target ID

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

gerritbot added a project: Patch-For-Review.Jul 6 2023, 10:45 PM
Dreamy_Jazz triaged this task as Medium priority.Jul 6 2023, 10:45 PM
Dreamy_Jazz updated the task description. (Show Details)
Dreamy_Jazz updated the task description. (Show Details)
Dreamy_Jazz renamed this task from CheckUserLog API DB queries taking over 5 seconds to CheckUserLog API DB queries for username targets taking over 5 seconds.Jul 6 2023, 10:49 PM
gerritbot added a comment.Jul 24 2023, 7:18 PM

Change 936098 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] CheckUserLog API: Search by for users by target ID

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

Maintenance_bot removed a project: Patch-For-Review.Jul 24 2023, 7:30 PM
ReleaseTaggerBot added a project: MW-1.41-notes (1.41.0-wmf.19; 2023-07-25).Jul 24 2023, 8:00 PM
Dreamy_Jazz added a comment.Jul 24 2023, 8:32 PM

I intend to wait until wmf.19 is on all wikis before checking logstash to see if this continues to be an issue.

Dreamy_Jazz closed this task as Resolved.Feb 4 2024, 5:45 PM
Dreamy_Jazz claimed this task.
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