Difference between revisions of "T163495: Mediawiki revision-related queries are failing with high rate for enwiki on codfw"

Latest revision as of 15:21, 16 October 2020

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

@@ Line 3: / Line 3: @@
 |status=resolved
 |color=violet
+|points=
+|dateCreated=1492718159
+|dateModified=1602869959
+|dateClosed=1543346719
 |author={{Phabricator User
 |type=author
@@ Line 9: / Line 13: @@
 }}
 |projects={{Phabricator Project
-|name=Core Platform Team Workboards
+|name=Platform Team Workboards
 |column=Done with CPT
+|entryDate=1492718159
 }}{{Phabricator Project
-|name=Core Platform Team
+|name=MediaWiki-General
-|column=Security, stability, performance and scalability (TEC1)
+|entryDate=1492718159
+}}{{Phabricator Project
+|name=Platform Engineering
+|column=Needs Cleaning - Security, stability, performance, and scalability (TEC1)
+|entryDate=1492718159
 }}{{Phabricator Project
 |name=Patch-For-Review
-}}{{Phabricator Project
+|entryDate=1492718159
-|name=codfw-rollout
-|column=Fallout from Apr/May 2017 switch
 }}{{Phabricator Project
 |name=Wikimedia-Incident
 |column=Active Situation
+|entryDate=1531941690
 }}{{Phabricator Project
-|name=MediaWiki-General-or-Unknown
+|name=codfw-rollout
+|column=Fallout from Apr/May 2017 switch
+|entryDate=1492735982
 }}
 |subtasks=163544,163351,160984,116557
+|transitions={{Transition
+|date=1544741540
+|type=Removed Project
+|project=Platform Team Legacy (Next)
+}}{{Transition
+|date=1544741540
+|type=Added Project
+|project=Platform Team Workboards (Done with CPT)
+}}{{Transition
+|date=1538447127
+|type=Removed Project
+|project=Core Platform Team Goals (Security, stability, performance and scalability (TEC1))
+}}{{Transition
+|date=1538447127
+|type=Added Project
+|project=Platform Engineering (Needs Cleaning - Security, stability, performance, and scalability (TEC1))
+}}{{Transition
+|date=1538438703
+|type=Removed Project
+|project=Core-Platform-Team-Old
+}}{{Transition
+|date=1538438703
+|type=Added Project
+|project=Core Platform Team Goals (Security, stability, performance and scalability (TEC1))
+}}{{Transition
+|date=1538436135
+|type=Added Project
+|project=Platform Team Legacy (Next)
+}}{{Transition
+|date=1531941690
+|type=Entered Column
+|project=Wikimedia-Incident
+|column=Active Situation
+}}{{Transition
+|date=1531941690
+|type=Exited Column
+|project=Wikimedia-Incident
+|column=Active Situation
+}}{{Transition
+|date=1531792652
+|type=Entered Column
+|project=Core-Platform-Team-Old
+|column=CPT TEC1 Backlog
+}}{{Transition
+|date=1531792652
+|type=Exited Column
+|project=Core-Platform-Team-Old
+|column=Inbox
+}}{{Transition
+|date=1531357384
+|type=Removed Project
+|project=MediaWiki-Platform-Team
+}}{{Transition
+|date=1531357384
+|type=Added Project
+|project=Core-Platform-Team-Old
+}}{{Transition
+|date=1531280849
+|type=Added Project
+|project=MediaWiki-Platform-Team
+}}{{Transition
+|date=1492793657
+|type=Entered Column
+|project=Wikimedia-Incident
+|column=Active Situation
+}}{{Transition
+|date=1492793657
+|type=Exited Column
+|project=Wikimedia-Incident
+|column=Active investigation
+}}{{Transition
+|date=1492735982
+|type=Entered Column
+|project=codfw-rollout
+|column=Fallout from Apr/May 2017 switch
+}}{{Transition
+|date=1492735982
+|type=Exited Column
+|project=codfw-rollout
+|column=Backlog
+}}
 }}