Difference between revisions of "T188327: Deploy refactored actor storage"

Latest revision as of 13:45, 27 April 2021

Phabricator Link	T188327
Status	resolved
Priority	High (red)
Points
Phabricator Task Created	2018/02/26 05:31 PM
Wiki Page Created	2019/06/09 01:18 PM
Phabricator Task Last Modified	2021/04/27 12:51 PM
Wiki Page Last Updated	2021/04/27 02:45 PM
Phabricator Task Closed	2019/09/17 01:40 PM
Authored By	Anomie
Assigned To	Anomie
Projects	Epic MW-1.32-notes (Backlog) MW-1.33-notes MW-1.34-notes (1.34.0-wmf.21; 2019-09-03) Platform Team Initiatives (Revision Storage Schema Improvements) Platform Team Workboards (Clinic Duty Team) (Done)
Platform Engineering Initiative Column	Revision Storage Schema Improvements
Platform Team Workboards Column	Clinic Duty Team: Done
Subtasks	T209847: Clean up actor renames on mediawikiwiki (resolved) T223406: Remove reference to fields replaced by the actor table from WMCS views (resolved) T204767: Special:ActiveUsers fails with "Error: 1054 Unknown column 'rc_actor' in 'on clause' (10.192.32.110)" (resolved) T204764: DB error in PageTriage: Unknown column 'actor_rev_user.actor_user' in 'on clause' (resolved) T204669: Slow access to Special:Contributions on mediawiki.org (due to enabling actor table WRITE_BOTH mode) (resolved) T187089: Fix WMF schemas to not break when comment store goes WRITE_NEW (resolved) T215525: log_search rows with ls_field='target_author_actor' and empty ls_value are created during actor migration (resolved) T210621: Internal api error: CannotCreateActorException (resolved) T188299: Schema change for refactored actor storage (resolved) T215464: Oversighters can no longer see suppressed contributions past a certain date when using the offender parameter (resolved)
Parent Tasks	T227047: Complete actor table and comment table migration

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

Project	Column	Date
⇑ Epic		26 February 2018
⇑ MediaWiki-Platform-Team		26 February 2018
⇓ MediaWiki-Platform-Team		26 February 2018
MediaWiki-Platform-Team	⇐ Inbox	26 February 2018
MediaWiki-Platform-Team	⇒ MWPT-Q3-Jan-Mar-2018	26 February 2018
⇑ MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)		26 February 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇐ Ready	26 February 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇒ In Progress	26 February 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇐ In Progress	2 April 2018
MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)	⇒ Blocked	2 April 2018
⇓ MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)		4 April 2018
⇑ MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)		4 April 2018
MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)	⇐ Ready	4 April 2018
MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)	⇒ Blocked	4 April 2018
⇓ MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)		11 July 2018
⇑ Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)		11 July 2018
Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)	⇐ Backlog	11 July 2018
Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)	⇒ Blocked	11 July 2018
⇑ Patch-For-Review		17 September 2018
⇓ Patch-For-Review		17 September 2018
⇑ Patch-For-Review		18 September 2018
⇓ Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)		1 October 2018
⇑ Platform Team Legacy (Designing)		1 October 2018
Platform Team Legacy (Designing)	⇐ Inbox	1 October 2018
Platform Team Legacy (Designing)	⇒ Blocked Externally	1 October 2018
⇑ Platform Engineering		2 October 2018
⇓ Platform Engineering		3 October 2018
Platform Engineering	⇐ Inbox	3 October 2018
Platform Engineering	⇒ Needs Cleaning - Code Health (TEC13)	3 October 2018
⇑ Platform Engineering (Needs Cleaning - Code Health (TEC13))		3 October 2018
⇓ Platform Team Legacy (Designing)		14 October 2018
⇑ Platform Team Workboards (Blocked Externally)		14 October 2018
⇓ Patch-For-Review		13 December 2018
⇑ Patch-For-Review		17 December 2018
⇑ MW-1.33-notes (1.33.0-wmf.13; 2019-01-15)		10 January 2019
⇓ MW-1.33-notes (1.33.0-wmf.13; 2019-01-15)		10 January 2019
⇑ MW-1.33-notes (1.33.0-wmf.12; 2019-01-08)		10 January 2019
⇑ MW-1.32-notes		10 January 2019
⇓ Platform Team Workboards (Blocked Externally)		5 March 2019
Platform Team Workboards	⇐ Blocked Externally	5 March 2019
Platform Team Workboards	⇒ Doing	5 March 2019
⇑ Platform Team Workboards (Doing)		5 March 2019
Platform Team Workboards	⇐ Doing	14 March 2019
Platform Team Workboards	⇒ Doing	14 March 2019
⇓ MW-1.33-notes (1.33.0-wmf.12; 2019-01-08)		5 April 2019
⇑ MW-1.33-notes (1.33.0-wmf.25; 2019-04-09)		5 April 2019
⇑ MW-1.34-notes (1.34.0-wmf.1; 2019-04-16)		9 April 2019
⇓ MW-1.34-notes (1.34.0-wmf.1; 2019-04-16)		1 May 2019
⇑ MW-1.34-notes (1.34.0-wmf.4; 2019-05-07)		1 May 2019
⇓ MW-1.33-notes (1.33.0-wmf.25; 2019-04-09)		1 May 2019
⇑ MW-1.33-notes		1 May 2019
⇓ Patch-For-Review		13 May 2019
⇑ Patch-For-Review		15 May 2019
⇓ Patch-For-Review		15 May 2019
⇑ Patch-For-Review		20 May 2019
⇓ Patch-For-Review		20 May 2019
⇑ Patch-For-Review		29 May 2019
⇓ Patch-For-Review		29 May 2019
⇑ Patch-For-Review		3 June 2019
⇓ Patch-For-Review		3 June 2019
⇓ Platform Team Workboards (Doing)		5 July 2019
Platform Team Workboards	⇐ Doing	5 July 2019
Platform Team Workboards	⇒ Team 1	5 July 2019
⇑ Platform Team Workboards (Team 1)		5 July 2019
Platform Team Workboards (Team 1)	⇐ Backlog	5 July 2019
Platform Team Workboards (Team 1)	⇒ Doing	5 July 2019
⇓ Platform Engineering (Needs Cleaning - Code Health (TEC13))		9 July 2019
⇑ Platform Engineering (Revision Storage Schema Improvements)		9 July 2019
⇓ Platform Team Workboards (Team 1)		16 July 2019
⇑ Platform Team Workboards (Clinic Duty Team)		16 July 2019
Platform Team Workboards (Clinic Duty Team)	⇐ Inbox	17 July 2019
Platform Team Workboards (Clinic Duty Team)	⇒ Ready (WIP:5)	17 July 2019
Platform Team Workboards (Clinic Duty Team)	⇐ Ready (WIP:5)	17 July 2019
Platform Team Workboards (Clinic Duty Team)	⇒ Later	17 July 2019
Platform Team Workboards (Clinic Duty Team)	⇐ Later	22 July 2019
Platform Team Workboards (Clinic Duty Team)	⇒ Ready (WIP:5)	22 July 2019
Platform Team Workboards (Clinic Duty Team)	⇐ Ready (WIP:5)	24 July 2019
Platform Team Workboards (Clinic Duty Team)	⇒ Doing(WIP:5)	24 July 2019
⇑ Patch-For-Review		25 July 2019
Platform Team Workboards (Clinic Duty Team)	⇐ Doing(WIP:5)	25 July 2019
Platform Team Workboards (Clinic Duty Team)	⇒ Waiting for Review	25 July 2019
⇓ Platform Engineering (Revision Storage Schema Improvements)		26 July 2019
Platform Engineering	⇐ Revision Storage Schema Improvements	26 July 2019
Platform Engineering	⇒ mop	26 July 2019
⇑ Platform Team Initiatives (Revision Storage Schema Improvements)		26 July 2019
⇓ MW-1.34-notes (1.34.0-wmf.4; 2019-05-07)		29 July 2019
⇑ MW-1.34-notes (1.34.0-wmf.16; 2019-07-30)		29 July 2019
⇓ MW-1.34-notes (1.34.0-wmf.16; 2019-07-30)		28 August 2019
⇑ MW-1.34-notes (1.34.0-wmf.21; 2019-09-03)		28 August 2019
⇓ Patch-For-Review		9 September 2019
Platform Team Workboards (Clinic Duty Team)	⇐ Waiting for Review	11 September 2019
Platform Team Workboards (Clinic Duty Team)	⇒ Waiting for deployment	11 September 2019
Platform Team Workboards (Clinic Duty Team)	⇐ Waiting for deployment	17 September 2019
Platform Team Workboards (Clinic Duty Team)	⇒ Done	17 September 2019

@@ Line 1: / Line 1: @@
 {{Phabricator Task
 |name=Deploy refactored actor storage
-|status=open
+|status=resolved
-|color=violet
+|color=red
+|points=
 |dateCreated=1519684314
-|dateModified=1562699235
+|dateModified=1619542289
+|dateClosed=1568742005
 |author={{Phabricator User
 |type=author
 |username=Anomie
-|realName=Brad Jorsch
+|realName=
 }}
 |owner={{Phabricator User
 |type=owner
 |username=Anomie
-|realName=Brad Jorsch
+|realName=
 }}
 |projects={{Phabricator Project
-|name=Core Platform Team
+|name=MW-1.34-notes
-|column=Revision Storage Schema Improvements
+|column=1.34.0-wmf.21; 2019-09-03
+|entryDate=1519684314
 }}{{Phabricator Project
-|name=Core Platform Team Workboards (Team 1)
+|name=Platform Team Workboards (Clinic Duty Team)
-|column=Doing
+|column=Done
+|entryDate=1568742148
 }}{{Phabricator Project
-|name=MW-1.33-notes
+|name=Epic
-}}{{Phabricator Project
+|entryDate=1519684314
-|name=MW-1.34-notes
-|column=1.34.0-wmf.4; 2019-05-07
 }}{{Phabricator Project
 |name=MW-1.32-notes
 |column=Backlog
+|entryDate=1519684314
 }}{{Phabricator Project
-|name=Epic
+|name=MW-1.33-notes
+|entryDate=1519684314
+}}{{Phabricator Project
+|name=Platform Team Initiatives
+|column=Revision Storage Schema Improvements
+|entryDate=1519684314
+}}
+|subtasks=223406,209847,204767,204764,204669,187089,215525,210621,188299,215464
+|transitions={{Transition
+|date=1568742148
+|type=Entered Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Done
+}}{{Transition
+|date=1568742148
+|type=Exited Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Waiting for deployment
+}}{{Transition
+|date=1568236492
+|type=Entered Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Waiting for deployment
+}}{{Transition
+|date=1568236492
+|type=Exited Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Waiting for Review
+}}{{Transition
+|date=1568049541
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1566968440
+|type=Removed Project
+|project=MW-1.34-notes (1.34.0-wmf.16; 2019-07-30)
+}}{{Transition
+|date=1566968440
+|type=Added Project
+|project=MW-1.34-notes (1.34.0-wmf.21; 2019-09-03)
+}}{{Transition
+|date=1564376431
+|type=Removed Project
+|project=MW-1.34-notes (1.34.0-wmf.4; 2019-05-07)
+}}{{Transition
+|date=1564376431
+|type=Added Project
+|project=MW-1.34-notes (1.34.0-wmf.16; 2019-07-30)
+}}{{Transition
+|date=1564168283
+|type=Removed Project
+|project=Platform Engineering (Revision Storage Schema Improvements)
+}}{{Transition
+|date=1564168283
+|type=Added Project
+|project=Platform Team Initiatives (Revision Storage Schema Improvements)
+}}{{Transition
+|date=1564168283
+|type=Entered Column
+|project=Platform Engineering
+|column=mop
+}}{{Transition
+|date=1564168283
+|type=Exited Column
+|project=Platform Engineering
+|column=Revision Storage Schema Improvements
+}}{{Transition
+|date=1564077466
+|type=Entered Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Waiting for Review
+}}{{Transition
+|date=1564077466
+|type=Exited Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Doing(WIP:5)
+}}{{Transition
+|date=1564076287
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1563988843
+|type=Entered Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Doing(WIP:5)
+}}{{Transition
+|date=1563988843
+|type=Exited Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Ready (WIP:5)
+}}{{Transition
+|date=1563837183
+|type=Entered Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Ready (WIP:5)
+}}{{Transition
+|date=1563837183
+|type=Exited Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Later
+}}{{Transition
+|date=1563394259
+|type=Entered Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Later
+}}{{Transition
+|date=1563394259
+|type=Exited Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Ready (WIP:5)
+}}{{Transition
+|date=1563393823
+|type=Entered Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Ready (WIP:5)
+}}{{Transition
+|date=1563393823
+|type=Exited Column
+|project=Platform Team Workboards (Clinic Duty Team)
+|column=Inbox
+}}{{Transition
+|date=1563322474
+|type=Removed Project
+|project=Platform Team Workboards (Team 1)
+}}{{Transition
+|date=1563322474
+|type=Added Project
+|project=Platform Team Workboards (Clinic Duty Team)
+}}{{Transition
+|date=1562699235
+|type=Removed Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1562699235
+|type=Added Project
+|project=Platform Engineering (Revision Storage Schema Improvements)
+}}{{Transition
+|date=1562351742
+|type=Entered Column
+|project=Platform Team Workboards (Team 1)
+|column=Doing
+}}{{Transition
+|date=1562351742
+|type=Exited Column
+|project=Platform Team Workboards (Team 1)
+|column=Backlog
+}}{{Transition
+|date=1562351738
+|type=Removed Project
+|project=Platform Team Workboards (Doing)
+}}{{Transition
+|date=1562351738
+|type=Added Project
+|project=Platform Team Workboards (Team 1)
+}}{{Transition
+|date=1562351738
+|type=Entered Column
+|project=Platform Team Workboards
+|column=Team 1
+}}{{Transition
+|date=1562351738
+|type=Exited Column
+|project=Platform Team Workboards
+|column=Doing
+}}{{Transition
+|date=1559566551
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1559566413
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1559142621
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1559142135
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1558365957
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1558365018
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1557926500
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1557926293
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1557767968
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1556737232
+|type=Removed Project
+|project=MW-1.33-notes (1.33.0-wmf.25; 2019-04-09)
+}}{{Transition
+|date=1556737232
+|type=Added Project
+|project=MW-1.33-notes
+}}{{Transition
+|date=1556712025
+|type=Removed Project
+|project=MW-1.34-notes (1.34.0-wmf.1; 2019-04-16)
+}}{{Transition
+|date=1556712025
+|type=Added Project
+|project=MW-1.34-notes (1.34.0-wmf.4; 2019-05-07)
+}}{{Transition
+|date=1554843688
+|type=Added Project
+|project=MW-1.34-notes (1.34.0-wmf.1; 2019-04-16)
+}}{{Transition
+|date=1554494463
+|type=Removed Project
+|project=MW-1.33-notes (1.33.0-wmf.12; 2019-01-08)
+}}{{Transition
+|date=1554494463
+|type=Added Project
+|project=MW-1.33-notes (1.33.0-wmf.25; 2019-04-09)
+}}{{Transition
+|date=1552575860
+|type=Entered Column
+|project=Platform Team Workboards
+|column=Doing
+}}{{Transition
+|date=1552575860
+|type=Exited Column
+|project=Platform Team Workboards
+|column=Doing
+}}{{Transition
+|date=1551800409
+|type=Removed Project
+|project=Platform Team Workboards (Blocked Externally)
+}}{{Transition
+|date=1551800409
+|type=Added Project
+|project=Platform Team Workboards (Doing)
+}}{{Transition
+|date=1551800409
+|type=Entered Column
+|project=Platform Team Workboards
+|column=Doing
+}}{{Transition
+|date=1551800409
+|type=Exited Column
+|project=Platform Team Workboards
+|column=Blocked Externally
+}}{{Transition
+|date=1547157643
+|type=Added Project
+|project=MW-1.32-notes
+}}{{Transition
+|date=1547146831
+|type=Removed Project
+|project=MW-1.33-notes (1.33.0-wmf.13; 2019-01-15)
+}}{{Transition
+|date=1547146831
+|type=Added Project
+|project=MW-1.33-notes (1.33.0-wmf.12; 2019-01-08)
+}}{{Transition
+|date=1547136026
+|type=Added Project
+|project=MW-1.33-notes (1.33.0-wmf.13; 2019-01-15)
+}}{{Transition
+|date=1545068229
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1544715666
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1539532161
+|type=Removed Project
+|project=Platform Team Legacy (Designing)
+}}{{Transition
+|date=1539532161
+|type=Added Project
+|project=Platform Team Workboards (Blocked Externally)
+}}{{Transition
+|date=1538576571
+|type=Removed Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538576571
+|type=Added Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538576571
+|type=Entered Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538576571
+|type=Exited Column
+|project=Platform Engineering
+|column=Inbox
+}}{{Transition
+|date=1538490276
+|type=Added Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538400332
+|type=Entered Column
+|project=Platform Team Legacy (Designing)
+|column=Blocked Externally
+}}{{Transition
+|date=1538400332
+|type=Exited Column
+|project=Platform Team Legacy (Designing)
+|column=Inbox
+}}{{Transition
+|date=1538400276
+|type=Removed Project
+|project=Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)
+}}{{Transition
+|date=1538400276
+|type=Added Project
+|project=Platform Team Legacy (Designing)
+}}{{Transition
+|date=1537303831
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1537201303
+|type=Removed Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1537196958
+|type=Added Project
+|project=Patch-For-Review
+}}{{Transition
+|date=1531344704
+|type=Entered Column
+|project=Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)
+|column=Blocked
+}}{{Transition
+|date=1531344704
+|type=Exited Column
+|project=Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)
+|column=Backlog
+}}{{Transition
+|date=1531344653
+|type=Removed Project
+|project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
+}}{{Transition
+|date=1531344653
+|type=Added Project
+|project=Core-Platform-Team-Old (CPT-Q1-Jul-Sep-2018)
+}}{{Transition
+|date=1522868437
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
+|column=Blocked
+}}{{Transition
+|date=1522868437
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
+|column=Ready
+}}{{Transition
+|date=1522868408
+|type=Removed Project
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+}}{{Transition
+|date=1522868408
+|type=Added Project
+|project=MediaWiki-Platform-Team (MWPT-Q4-Apr-Jun-2018)
+}}{{Transition
+|date=1522719594
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=Blocked
+}}{{Transition
+|date=1522719594
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=In Progress
+}}{{Transition
+|date=1519684551
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=In Progress
+}}{{Transition
+|date=1519684551
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+|column=Ready
+}}{{Transition
+|date=1519684533
+|type=Removed Project
+|project=MediaWiki-Platform-Team
+}}{{Transition
+|date=1519684533
+|type=Added Project
+|project=MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018)
+}}{{Transition
+|date=1519684533
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=MWPT-Q3-Jan-Mar-2018
+}}{{Transition
+|date=1519684533
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Inbox
+}}{{Transition
+|date=1519684314
+|type=Added Project
+|project=Epic
+}}{{Transition
+|date=1519684314
+|type=Added Project
+|project=MediaWiki-Platform-Team
 }}
-|subtasks=225007,223406,209847,204767,204764,167246,204669,187089,215525,210621,188299,215464
 }}