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

Revision as of 08:13, 2 March 2020

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	2019/06/27 06:13 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 25: / Line 25: @@
 |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
 |transitions={{Transition
+|date=1558472659
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1556056838
+|type=Added Project
+|project=1.34.0-wmf.3; 2019-04-30
+}}{{Transition
+|date=1531775567
+|type=Removed Project
+|project=WMF-deploy-2017-06-13_(1.30.0-wmf.5)
+}}{{Transition
+|date=1493841648
+|type=Entered Column
 |project=Availability (MediaWiki-MultiDC)
 |column=Doing
-|transitionDate=1493841648
-|transitionType=Entered Column
 }}{{Transition
+|date=1493841648
+|type=Exited Column
 |project=Availability (MediaWiki-MultiDC)
 |column=Backlog
-|transitionDate=1493841648
-|transitionType=Exited Column
 }}{{Transition
+|date=1493841173
+|type=Entered Column
 |project=Multiple-active-datacenters archived
 |column=Doing
-|transitionDate=1493841173
-|transitionType=Entered Column
 }}{{Transition
+|date=1493841173
+|type=Exited Column
 |project=Multiple-active-datacenters archived
 |column=Backlog
-|transitionDate=1493841173
-|transitionType=Exited Column
 }}{{Transition
+|date=1470978747
+|type=Entered Column
 |project=Wikimedia-Multiple-active-datacenters
 |column=Doing
-|transitionDate=1470978747
-|transitionType=Entered Column
 }}{{Transition
+|date=1470978747
+|type=Exited Column
 |project=Wikimedia-Multiple-active-datacenters
 |column=Backlog
-|transitionDate=1470978747
-|transitionType=Exited Column
 }}{{Transition
+|date=1447549566
+|type=Entered Column
 |project=User-notice
 |column=Archive
-|transitionDate=1447549566
-|transitionType=Entered Column
 }}{{Transition
+|date=1447549566
+|type=Exited Column
 |project=User-notice
 |column=Archive
-|transitionDate=1447549566
-|transitionType=Exited Column
 }}{{Transition
+|date=1443119199
+|type=Entered Column
 |project=Availability
 |column=Blocked
-|transitionDate=1443119199
-|transitionType=Entered Column
 }}{{Transition
+|date=1443119199
+|type=Exited Column
 |project=Availability
 |column=Backlog
-|transitionDate=1443119199
-|transitionType=Exited Column
 }}{{Transition
+|date=1443119197
+|type=Entered Column
 |project=Availability
 |column=Backlog
-|transitionDate=1443119197
-|transitionType=Entered Column
 }}{{Transition
+|date=1443119197
+|type=Exited Column
 |project=Availability
 |column=Backlog
-|transitionDate=1443119197
-|transitionType=Exited Column
 }}{{Transition
+|date=1443009040
+|type=Entered Column
 |project=User-notice
 |column=Archive
-|transitionDate=1443009040
-|transitionType=Entered Column
 }}{{Transition
+|date=1443009040
+|type=Exited Column
 |project=User-notice
 |column=Recently announced in Tech/News
-|transitionDate=1443009040
-|transitionType=Exited Column
 }}{{Transition
+|date=1442505985
+|type=Entered Column
 |project=User-notice
 |column=Recently announced in Tech/News
-|transitionDate=1442505985
-|transitionType=Entered Column
 }}{{Transition
+|date=1442505985
+|type=Exited Column
 |project=User-notice
 |column=In current Tech/News draft
-|transitionDate=1442505985
-|transitionType=Exited Column
 }}{{Transition
+|date=1441871987
+|type=Entered Column
 |project=User-notice
 |column=In current Tech/News draft
-|transitionDate=1441871987
-|transitionType=Entered Column
 }}{{Transition
+|date=1441871987
+|type=Exited Column
 |project=User-notice
 |column=To Triage
-|transitionDate=1441871987
-|transitionType=Exited Column
 }}{{Transition
+|date=1432062559
+|type=Entered Column
 |project=Availability
 |column=Backlog
-|transitionDate=1432062559
-|transitionType=Entered Column
 }}{{Transition
+|date=1432062559
+|type=Exited Column
 |project=Availability
 |column=Doing
-|transitionDate=1432062559
-|transitionType=Exited Column
 }}{{Transition
+|date=1428533836
+|type=Entered Column
 |project=Availability
 |column=Doing
-|transitionDate=1428533836
-|transitionType=Entered Column
 }}{{Transition
+|date=1428533836
+|type=Exited Column
 |project=Availability
 |column=Backlog
-|transitionDate=1428533836
-|transitionType=Exited Column
 }}{{Transition
+|date=1428533828
+|type=Entered Column
 |project=Availability
 |column=Backlog
-|transitionDate=1428533828
-|transitionType=Entered Column
 }}{{Transition
+|date=1428533828
+|type=Exited Column
 |project=Availability
 |column=Backlog
-|transitionDate=1428533828
-|transitionType=Exited Column
 }}{{Transition
+|date=1427342103
+|type=Entered Column
 |project=MediaWiki-Core-Team
 |column=In Dev/Progress
-|transitionDate=1427342103
-|transitionType=Entered Column
 }}{{Transition
+|date=1427342103
+|type=Exited Column
 |project=MediaWiki-Core-Team
 |column=In Dev/Progress
-|transitionDate=1427342103
-|transitionType=Exited Column
 }}{{Transition
+|date=1426048237
+|type=Entered Column
 |project=MediaWiki-Core-Team
 |column=In Dev/Progress
-|transitionDate=1426048237
-|transitionType=Entered Column
 }}{{Transition
+|date=1426048237
+|type=Exited Column
 |project=MediaWiki-Core-Team
 |column=Backlog
-|transitionDate=1426048237
-|transitionType=Exited Column
 }}
 }}