T92357: Fix problematic database master queries performed on HTTP GET/HEAD

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