Difference between revisions of "T92357: Fix database master queries from HTTP GET/HEAD before active-active multi-dc"

Latest revision as of 16:14, 18 October 2021

Phabricator Link	T92357
Status	open
Priority	Medium (orange)
Points
Phabricator Task Created	2015/03/10 11:29 PM
Wiki Page Created	2019/06/09 01:23 PM
Phabricator Task Last Modified	2021/03/02 04:33 PM
Wiki Page Last Updated	2021/10/18 05:14 PM
Phabricator Task Closed
Authored By	aaron (Aaron Schulz)
Assigned To	aaron (Aaron Schulz)
Projects	MediaWiki-General Performance-Team (Backlog: Maintenance) Sustainability (MediaWiki-MultiDC) (Later)
Platform Engineering Initiative Column
Platform Team Workboards Column
Subtasks	T216287: BannerMessageGroup::registerGroupHook of CentralNotice must not query master on GET request (page views) (open) T154795: CheckUser opens DB master connection when email is sent (resolved) T154719: PageTriage opens master connection on GET for ArticleMetadata cache misses (resolved) T154556: Babel autocreates category and system user on GET (resolved) T154554: AbuseFilter "Examine past edits" feature opens master conn on GET in certain cases involving Scribunto (resolved) T135170: Require POST in ?action=purge (resolved) T129973: Dig through logs from 15 Mar 2016 read-only test and file bugs (resolved) T103429: Investigation: Parser save hook handler does master writes in GETs (resolved) T95753: Translate extensions uses the master a lot on page views (resolved) T188801: Migrate wl_notificationtimestamp updates to the job queue (resolved) T179760: File metadata gets refreshed when accessing the file description page (resolved) T154596: SpecialModifyEntity master queries on page views (duplicate) T154555: Special:SetSiteLink, other SpecialModifyEntity subclasses open master connection on GET (resolved) T136224: OATHAuth doing DB master queries on HTTP GET (resolved) T134842: SpecialCentralAutoLogin calls User::saveSettings() on HTTP GET presend (open) T134841: MessageGroupStats::queueUpdates trigger on page views (resolved) T134608: CentralAuth uses master on POST requests for API/specialpages that return false for doesWrites() (resolved) T133422: DB master queries for entities on parse (duplicate) T122708: ShortUrl must not write to master db on page views (DBPerformance warning) (open) T119689: Enable $wgCentralAuthUseSlaves to avoid master queries (resolved) T110399: WikiPageEntityMetaDataLookup querying DB master on HTTP GET (duplicate) T95232: High frequency of master queries on GET requests due to Flow (duplicate) T95156: Wikidata needlessly queries master DB to populate deprecated wbUserIsBlocked JS variable (duplicate) T94030: Avoid opening master db connection on special pages (e.g. Special:NewItem) when not needed (resolved) T151903: Special:Search performs DB writes on GET request (resolved)
Parent Tasks	T88445: MediaWiki active/active datacenter investigation and work (tracking)

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

Project	Column	Date
MediaWiki-Core-Team	⇐ Backlog	11 March 2015
MediaWiki-Core-Team	⇒ In Dev/Progress	11 March 2015
MediaWiki-Core-Team	⇐ In Dev/Progress	25 March 2015
MediaWiki-Core-Team	⇒ In Dev/Progress	25 March 2015
Sustainability	⇐ Tag	8 April 2015
Sustainability	⇒ Tag	8 April 2015
Sustainability	⇐ Tag	8 April 2015
Sustainability	⇒ Doing	8 April 2015
Sustainability	⇐ Doing	19 May 2015
Sustainability	⇒ Tag	19 May 2015
User-notice	⇐ To Triage	10 September 2015
User-notice	⇒ In current Tech/News draft	10 September 2015
User-notice	⇐ In current Tech/News draft	17 September 2015
User-notice	⇒ Recently announced in Tech/News	17 September 2015
User-notice	⇐ Recently announced in Tech/News	23 September 2015
User-notice	⇒ Already announced/Archive	23 September 2015
Sustainability	⇐ Tag	24 September 2015
Sustainability	⇒ Tag	24 September 2015
Sustainability	⇐ Tag	24 September 2015
Sustainability	⇒ Blocked	24 September 2015
User-notice	⇐ Already announced/Archive	14 November 2015
User-notice	⇒ Already announced/Archive	14 November 2015
Wikimedia-Multiple-active-datacenters	⇐ Backlog	12 August 2016
Wikimedia-Multiple-active-datacenters	⇒ Doing	12 August 2016
Multiple-active-datacenters archived	⇐ Backlog	3 May 2017
Multiple-active-datacenters archived	⇒ Doing	3 May 2017
Sustainability (MediaWiki-MultiDC)	⇐ Later	3 May 2017
Sustainability (MediaWiki-MultiDC)	⇒ Current: Performance Team	3 May 2017
⇓ MW-1.30-release-notes (WMF-deploy-2017-06-13_(1.30.0-wmf.5))		16 July 2018
⇑ MW-1.34-notes (1.34.0-wmf.3; 2019-04-30)		23 April 2019
⇓ Patch-For-Review		21 May 2019
⇓ MW-1.34-notes (1.34.0-wmf.3; 2019-04-30)		2 July 2020
⇑ Performance-Team		2 July 2020
Performance-Team	⇐ Inbox	6 July 2020
Performance-Team	⇒ Doing (old)	6 July 2020
Performance-Team	⇐ Doing (old)	20 July 2020
Performance-Team	⇒ Next: Goal / Oct-Dec '21	20 July 2020
Sustainability (MediaWiki-MultiDC)	⇐ Current: Performance Team	22 December 2020
Sustainability (MediaWiki-MultiDC)	⇒ Later	22 December 2020
Performance-Team	⇐ Next: Goal / Oct-Dec '21	1 March 2021
Performance-Team	⇒ Next: Goal / Oct-Dec '21	1 March 2021
Performance-Team	⇐ Next: Goal / Oct-Dec '21	2 March 2021
Performance-Team	⇒ Backlog: Maintenance	2 March 2021

@@ Line 1: / Line 1: @@
 {{Phabricator Task
-|name=Fix problematic database master queries performed on HTTP GET/HEAD
+|name=Fix database master queries from HTTP GET/HEAD before active-active multi-dc
 |status=open
 |color=orange
 |points=
 |dateCreated=1426044550
-|dateModified=1561673586
+|dateModified=1614720796
 |author={{Phabricator User
 |type=author
+|username=aaron
+|realName=Aaron Schulz
+}}
+|owner={{Phabricator User
+|type=owner
 |username=aaron
 |realName=Aaron Schulz
 }}
 |projects={{Phabricator Project
-|name=MW-1.34-notes
-|column=1.34.0-wmf.3; 2019-04-30
-|entryDate=1426044550
-}}{{Phabricator Project
 |name=MediaWiki-General
 |entryDate=1426044550
 }}{{Phabricator Project
 |name=Sustainability (MediaWiki-MultiDC)
-|column=Doing
+|column=Later
-|entryDate=1493841648
+|entryDate=1608676886
+}}{{Phabricator Project
+|name=Performance-Team
+|column=Backlog: Maintenance
+|entryDate=1614720796
 }}
-|subtasks=216287,154795,154719,154556,154554,154552,135170,129973,103429,95753,88044,188801,179760,154596,154555,136224,134842,134841,134608,133422,122708,119689,110399,95232,95156,94030,151903
+|subtasks=154795,154719,154556,154554,135170,216287,129973,103429,95753,188801,179760,154596,154555,136224,134842,134841,134608,133422,122708,119689,110399,95232,95156,94030,151903
 |transitions={{Transition
+|date=1614720796
+|type=Entered Column
+|project=Performance-Team
+|column=Backlog: Maintenance
+}}{{Transition
+|date=1614720796
+|type=Exited Column
+|project=Performance-Team
+|column=Next: Goal / Oct-Dec '21
+}}{{Transition
+|date=1614630665
+|type=Entered Column
+|project=Performance-Team
+|column=Next: Goal / Oct-Dec '21
+}}{{Transition
+|date=1614630665
+|type=Exited Column
+|project=Performance-Team
+|column=Next: Goal / Oct-Dec '21
+}}{{Transition
+|date=1608676886
+|type=Entered Column
+|project=Sustainability (MediaWiki-MultiDC)
+|column=Later
+}}{{Transition
+|date=1608676886
+|type=Exited Column
+|project=Sustainability (MediaWiki-MultiDC)
+|column=Current: Performance Team
+}}{{Transition
+|date=1595276544
+|type=Entered Column
+|project=Performance-Team
+|column=Next: Goal / Oct-Dec '21
+}}{{Transition
+|date=1595276544
+|type=Exited Column
+|project=Performance-Team
+|column=Doing (old)
+}}{{Transition
+|date=1594066854
+|type=Entered Column
+|project=Performance-Team
+|column=Doing (old)
+}}{{Transition
+|date=1594066854
+|type=Exited Column
+|project=Performance-Team
+|column=Inbox
+}}{{Transition
+|date=1593701744
+|type=Added Project
+|project=Performance-Team
+}}{{Transition
+|date=1593701677
+|type=Removed Project
+|project=MW-1.34-notes (1.34.0-wmf.3; 2019-04-30)
+}}{{Transition
 |date=1558472659
 |type=Removed Project
@@ Line 40: / Line 103: @@
 |type=Entered Column
 |project=Sustainability (MediaWiki-MultiDC)
-|column=Doing
+|column=Current: Performance Team
 }}{{Transition
 |date=1493841648
 |type=Exited Column
 |project=Sustainability (MediaWiki-MultiDC)
-|column=Backlog
+|column=Later
 }}{{Transition
 |date=1493841173
@@ Line 70: / Line 133: @@
 |type=Entered Column
 |project=User-notice
-|column=Archive
+|column=Already announced/Archive
 }}{{Transition
 |date=1447549566
 |type=Exited Column
 |project=User-notice
-|column=Archive
+|column=Already announced/Archive
 }}{{Transition
 |date=1443119199
@@ Line 85: / Line 148: @@
 |type=Exited Column
 |project=Sustainability
-|column=Backlog
+|column=Tag
 }}{{Transition
 |date=1443119197
 |type=Entered Column
 |project=Sustainability
-|column=Backlog
+|column=Tag
 }}{{Transition
 |date=1443119197
 |type=Exited Column
 |project=Sustainability
-|column=Backlog
+|column=Tag
 }}{{Transition
 |date=1443009040
 |type=Entered Column
 |project=User-notice
-|column=Archive
+|column=Already announced/Archive
 }}{{Transition
 |date=1443009040
@@ Line 130: / Line 193: @@
 |type=Entered Column
 |project=Sustainability
-|column=Backlog
+|column=Tag
 }}{{Transition
 |date=1432062559
@@ Line 145: / Line 208: @@
 |type=Exited Column
 |project=Sustainability
-|column=Backlog
+|column=Tag
 }}{{Transition
 |date=1428533828
 |type=Entered Column
 |project=Sustainability
-|column=Backlog
+|column=Tag
 }}{{Transition
 |date=1428533828
 |type=Exited Column
 |project=Sustainability
-|column=Backlog
+|column=Tag
 }}{{Transition
 |date=1427342103