https://bugzilla.wikimedia.org/show_bug.cgi?id=52979
Web browser: ---
Bug ID: 52979
Summary: ApiQueryAllUsers-related queries causing lag on
Wikidata
Product: MediaWiki
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: API
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: b...@mzmcbride.com
CC: bjor...@wikimedia.org, bryan.tongm...@gmail.com,
roan.katt...@gmail.com, s...@reedyboy.net
Classification: Unclassified
Mobile Platform: ---
We just had an issue where hung queries from the Web API were causing massive
lag on one of the Wikidata servers. Example query snippet:
---
SELECT /* ApiQueryAllUsers::execute */ ipb_deleted,COUNT(*) AS
recentedits,user_name
---
Lag as reported by
<https://www.wikidata.org/w/api.php?action=query&meta=siteinfo&siprop=dbrepllag&sishowalldb=>
was high:
---
<?xml version="1.0"?>
<api>
<query>
<dbrepllag>
<db host="db1058" lag="0" />
<db host="db1005" lag="0" />
<db host="db1026" lag="26432" />
<db host="db1021" lag="0" />
</dbrepllag>
</query>
</api>
---
Server log entry about killing the queries:
<https://wikitech.wikimedia.org/w/index.php?title=Server_Admin_Log&diff=80744&oldid=80742&diffonly=1>.
As soon as the queries were killed, lag decreased.
ApiQueryAllUsers needs investigation.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
