T163495: Mediawiki revision-related queries are failing with high rate for enwiki on codfw

Phabricator Link	T163495
Status	resolved
Priority	Needs Triage (violet)
Points
Phabricator Task Created	2017/04/20 03:55 PM
Wiki Page Created	2019/06/09 01:18 PM
Phabricator Task Last Modified	2020/10/16 01:39 PM
Wiki Page Last Updated	2020/10/16 04:21 PM
Phabricator Task Closed	2018/11/27 02:25 PM
Authored By	jcrespo (Jaime Crespo)
Assigned To
Projects	MediaWiki-General Patch-For-Review Platform Engineering (Needs Cleaning - Security, stability, performance, and scalability (TEC1)) Platform Team Workboards (Done with CPT) Wikimedia-Incident (Active Situation) codfw-rollout (Fallout from Apr/May 2017 switch)
Platform Engineering Initiative Column
Platform Team Workboards Column	Done with CPT
Subtasks	T163544: Wikibase\TermSqlIndex::getMatchingTerms , Wikibase\TermSqlIndex::fetchTerms have bad performance after codfw failover (resolved) T163351: codfw API slaves overloaded during the 2017-04-19 codfw switch (resolved) T160984: Reduce max execution time of interactive queries or a better detection and killing of bad query patterns (resolved) T116557: AFComputedVariable::compute query timeouts (resolved)
Parent Tasks

Column Transitions: (Added project: ⇑, Removed project: ⇓,Entered column: ⇒, Exited column: ⇐)

Project	Column	Date
codfw-rollout	⇐ Backlog	20 April 2017
codfw-rollout	⇒ Fallout from Apr/May 2017 switch	20 April 2017
Wikimedia-Incident	⇐ Active investigation	21 April 2017
Wikimedia-Incident	⇒ Active Situation	21 April 2017
⇑ MediaWiki-Platform-Team		10 July 2018
⇓ MediaWiki-Platform-Team		11 July 2018
⇑ Core-Platform-Team-Old		11 July 2018
Core-Platform-Team-Old	⇐ Inbox	16 July 2018
Core-Platform-Team-Old	⇒ CPT TEC1 Backlog	16 July 2018
Wikimedia-Incident	⇐ Active Situation	18 July 2018
Wikimedia-Incident	⇒ Active Situation	18 July 2018
⇑ Platform Team Legacy (Next)		1 October 2018
⇓ Core-Platform-Team-Old		1 October 2018
⇑ Core Platform Team Goals (Security, stability, performance and scalability (TEC1))		1 October 2018
⇓ Core Platform Team Goals (Security, stability, performance and scalability (TEC1))		1 October 2018
⇑ Platform Engineering (Needs Cleaning - Security, stability, performance, and scalability (TEC1))		1 October 2018
⇓ Platform Team Legacy (Next)		13 December 2018
⇑ Platform Team Workboards (Done with CPT)		13 December 2018