Difference between revisions of "T161671: Compacting the revision table"

Latest revision as of 20:07, 23 November 2021

Phabricator Link	T161671
Status	stalled
Priority	Medium (orange)
Points
Phabricator Task Created	2017/03/29 01:05 AM
Wiki Page Created	2019/06/09 01:21 PM
Phabricator Task Last Modified	2021/11/23 06:49 PM
Wiki Page Last Updated	2021/11/23 08:07 PM
Phabricator Task Closed
Authored By	tstarling (Tim Starling)
Assigned To	daniel (Daniel Kinzler)
Projects	Epic MediaWiki-Revision-backend (Revision store) Multi-Content-Revisions (Watching) Patch-For-Review Platform Team Initiatives (Revision Storage Schema Improvements) Platform Team Workboards (Epics) (Paused) Schema-change (Cleanup)
Platform Engineering Initiative Column	Revision Storage Schema Improvements
Platform Team Workboards Column	Epics: Paused
Subtasks	T184615: Once MCR is deployed, drop the rev_text_id, rev_content_model, and rev_content_format fields from the revision table (duplicate) T6715: Allow comments longer than 255 bytes (resolved) T227047: Complete actor table and comment table migration (open) T215445: comment and actor view challenges for Cloud Services (open) T251343: Drop unused columns from revision table in DatabaseUpdater (CommentStore, Actor, MCR) (resolved) T278917: Clean up obsolete ActorMigration usages for non-temp tables (resolved)
Parent Tasks

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

Project	Column	Date
MediaWiki-Platform-Team	⇐ Inbox	20 April 2017
MediaWiki-Platform-Team	⇒ Watching	20 April 2017
Schema-change	⇐ Unsorted	26 April 2017
Schema-change	⇒ Cleanup	26 April 2017
Wikimedia-Rdbms	⇐ Untriaged	7 May 2017
Wikimedia-Rdbms	⇒ Schema changes	7 May 2017
MediaWiki-Platform-Team	⇐ Watching	13 October 2017
MediaWiki-Platform-Team	⇒ MWPT-Q1-Jul-Sep-2017	13 October 2017
MediaWiki-Platform-Team (MWPT-Q1-Jul-Sep-2017)	⇐ Ready	13 October 2017
MediaWiki-Platform-Team (MWPT-Q1-Jul-Sep-2017)	⇒ In Progress	13 October 2017
MediaWiki-Platform-Team	⇐ Inbox	19 October 2017
MediaWiki-Platform-Team	⇒ Epic	19 October 2017
MediaWiki-Platform-Team	⇐ Epic	19 October 2017
MediaWiki-Platform-Team	⇒ Epic	19 October 2017
Multi-Content-Revisions	⇐ Inbox	20 November 2017
Multi-Content-Revisions	⇒ Epic	20 November 2017
MediaWiki-Platform-Team	⇐ Epic	9 January 2018
MediaWiki-Platform-Team	⇒ Epic	9 January 2018
Multi-Content-Revisions	⇐ Epic	7 May 2018
Multi-Content-Revisions	⇒ Watching	7 May 2018
Multi-Content-Revisions	⇐ Watching	8 May 2018
Multi-Content-Revisions	⇒ Epic	8 May 2018
⇓ MediaWiki-Platform-Team		11 July 2018
⇑ Core-Platform-Team-Old		11 July 2018
Core-Platform-Team-Old	⇐ Inbox	11 July 2018
Core-Platform-Team-Old	⇒ Epic	11 July 2018
⇓ Core-Platform-Team-Old		1 October 2018
⇑ Platform Team Legacy		1 October 2018
Platform Team Legacy	⇐ Inbox	1 October 2018
Platform Team Legacy	⇒ Epics	1 October 2018
⇑ Platform Engineering		2 October 2018
⇓ Platform Engineering (Needs Cleaning - Code Health (TEC13))		3 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		3 October 2018
⇑ Platform Engineering (Needs Cleaning - Code Health (TEC13))		3 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 Engineering (Needs Cleaning - Code Health (TEC13))		3 October 2018
⇑ Platform Engineering		3 October 2018
⇓ Platform Engineering		3 October 2018
⇓ Platform Team Legacy		3 October 2018
⇑ Platform Team Legacy (Epic)		3 October 2018
⇑ Platform Engineering (Needs Cleaning - Code Health (TEC13))		3 October 2018
Platform Engineering	⇐ Needs Cleaning - Code Health (TEC13)	3 October 2018
Platform Engineering	⇒ Needs Cleaning - Code Health (TEC13)	3 October 2018
Multi-Content-Revisions	⇐ Epic	4 October 2018
Multi-Content-Revisions	⇒ Watching	4 October 2018
Platform Engineering	⇐ Needs Cleaning - Code Health (TEC13)	8 November 2018
Platform Engineering	⇒ Needs Cleaning - Code Health (TEC13)	8 November 2018
⇓ Platform Team Legacy (Epic)		5 July 2019
⇓ Platform Engineering (Needs Cleaning - Code Health (TEC13))		9 July 2019
⇑ Platform Engineering (Revision Storage Schema Improvements)		9 July 2019
⇓ Wikimedia-Rdbms		18 July 2019
⇑ MediaWiki-Revision-backend		18 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
MediaWiki-Revision-backend	⇐ Untriaged	1 August 2019
MediaWiki-Revision-backend	⇒ Revision store	1 August 2019
⇑ Platform Team Workboards (Initiatives)		18 March 2020
Platform Team Workboards (Initiatives)	⇐ Later	18 March 2020
Platform Team Workboards (Initiatives)	⇒ Paused	18 March 2020
Platform Team Initiatives	⇐ Revision Storage Schema Improvements	19 March 2020
Platform Team Initiatives	⇒ Revision Storage Schema Improvements	19 March 2020
Platform Team Workboards (Initiatives)	⇐ Paused	24 March 2020
Platform Team Workboards (Initiatives)	⇒ Paused	24 March 2020
⇓ Platform Team Workboards (Initiatives)		15 April 2020
⇑ Platform Team Workboards (Epics)		15 April 2020
Platform Team Workboards (Epics)	⇐ Epic Backlog	15 April 2020
Platform Team Workboards (Epics)	⇒ Paused	15 April 2020
⇓ Platform Team Workboards (Epics)		27 April 2020
⇑ Platform Team Workboards (Clinic Duty Team)		27 April 2020
⇓ Platform Team Workboards (Clinic Duty Team)		28 April 2020
⇑ Platform Team Workboards (Epics)		28 April 2020

@@ Line 1: / Line 1: @@
 {{Phabricator Task
 |name=Compacting the revision table
-|status=open
+|status=stalled
 |color=orange
+|points=
+|dateCreated=1490763929
+|dateModified=1637711389
 |author={{Phabricator User
 |type=author
 |username=tstarling
 |realName=Tim Starling
+}}
+|owner={{Phabricator User
+|type=owner
+|username=daniel
+|realName=Daniel Kinzler
 }}
 |projects={{Phabricator Project
-|name=Core Platform Team
+|name=Epic
-|column=Code Health (TEC13)
+|entryDate=1490763929
+}}{{Phabricator Project
+|name=Platform Team Workboards (Epics)
+|column=Paused
+|entryDate=1586967897
 }}{{Phabricator Project
-|name=Core Platform Team Backlog
+|name=MediaWiki-Revision-backend
-|column=Epic
+|column=Revision store
+|entryDate=1564689373
 }}{{Phabricator Project
 |name=Multi-Content-Revisions
 |column=Watching
-}}{{Phabricator Project
+|entryDate=1538665546
-|name=Epic
 }}{{Phabricator Project
 |name=Patch-For-Review
+|entryDate=1490763929
 }}{{Phabricator Project
-|name=MediaWiki-Database
+|name=Platform Team Initiatives
-|column=Schema
+|column=Revision Storage Schema Improvements
+|entryDate=1490763929
 }}{{Phabricator Project
 |name=Schema-change
 |column=Cleanup
+|entryDate=1493220930
+}}
+|subtasks=278917,251343,227047,215445,184615,6715
+|transitions={{Transition
+|date=1588105954
+|type=Removed Project
+|project=Platform Team Workboards (Clinic Duty Team)
+}}{{Transition
+|date=1588105954
+|type=Added Project
+|project=Platform Team Workboards (Epics)
+}}{{Transition
+|date=1588006429
+|type=Removed Project
+|project=Platform Team Workboards (Epics)
+}}{{Transition
+|date=1588006429
+|type=Added Project
+|project=Platform Team Workboards (Clinic Duty Team)
+}}{{Transition
+|date=1586967897
+|type=Entered Column
+|project=Platform Team Workboards (Epics)
+|column=Paused
+}}{{Transition
+|date=1586967897
+|type=Exited Column
+|project=Platform Team Workboards (Epics)
+|column=Epic Backlog
+}}{{Transition
+|date=1586967874
+|type=Removed Project
+|project=Platform Team Workboards (Initiatives)
+}}{{Transition
+|date=1586967874
+|type=Added Project
+|project=Platform Team Workboards (Epics)
+}}{{Transition
+|date=1585072866
+|type=Entered Column
+|project=Platform Team Workboards (Initiatives)
+|column=Paused
+}}{{Transition
+|date=1585072866
+|type=Exited Column
+|project=Platform Team Workboards (Initiatives)
+|column=Paused
+}}{{Transition
+|date=1584624428
+|type=Entered Column
+|project=Platform Team Initiatives
+|column=Revision Storage Schema Improvements
+}}{{Transition
+|date=1584624428
+|type=Exited Column
+|project=Platform Team Initiatives
+|column=Revision Storage Schema Improvements
+}}{{Transition
+|date=1584581845
+|type=Entered Column
+|project=Platform Team Workboards (Initiatives)
+|column=Paused
+}}{{Transition
+|date=1584581845
+|type=Exited Column
+|project=Platform Team Workboards (Initiatives)
+|column=Later
+}}{{Transition
+|date=1584581833
+|type=Added Project
+|project=Platform Team Workboards (Initiatives)
+}}{{Transition
+|date=1564689373
+|type=Entered Column
+|project=MediaWiki-Revision-backend
+|column=Revision store
+}}{{Transition
+|date=1564689373
+|type=Exited Column
+|project=MediaWiki-Revision-backend
+|column=Untriaged
+}}{{Transition
+|date=1564168288
+|type=Removed Project
+|project=Platform Engineering (Revision Storage Schema Improvements)
+}}{{Transition
+|date=1564168288
+|type=Added Project
+|project=Platform Team Initiatives (Revision Storage Schema Improvements)
+}}{{Transition
+|date=1564168288
+|type=Entered Column
+|project=Platform Engineering
+|column=mop
+}}{{Transition
+|date=1564168288
+|type=Exited Column
+|project=Platform Engineering
+|column=Revision Storage Schema Improvements
+}}{{Transition
+|date=1563481978
+|type=Removed Project
+|project=Wikimedia-Rdbms
+}}{{Transition
+|date=1563481978
+|type=Added Project
+|project=MediaWiki-Revision-backend
+}}{{Transition
+|date=1562699095
+|type=Removed Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1562699095
+|type=Added Project
+|project=Platform Engineering (Revision Storage Schema Improvements)
+}}{{Transition
+|date=1562355148
+|type=Removed Project
+|project=Platform Team Legacy (Epic)
+}}{{Transition
+|date=1541719585
+|type=Entered Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1541719585
+|type=Exited Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538665546
+|type=Entered Column
+|project=Multi-Content-Revisions
+|column=Watching
+}}{{Transition
+|date=1538665546
+|type=Exited Column
+|project=Multi-Content-Revisions
+|column=Epic
+}}{{Transition
+|date=1538575940
+|type=Entered Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538575940
+|type=Exited Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538575339
+|type=Removed Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538575339
+|type=Removed Project
+|project=Platform Team Legacy
+}}{{Transition
+|date=1538575339
+|type=Added Project
+|project=Platform Team Legacy (Epic)
+}}{{Transition
+|date=1538575339
+|type=Added Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538574822
+|type=Removed Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538574822
+|type=Added Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538574821
+|type=Removed Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538574821
+|type=Added Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538574821
+|type=Entered Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538574821
+|type=Exited Column
+|project=Platform Engineering
+|column=Inbox
+}}{{Transition
+|date=1538574656
+|type=Removed Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538574656
+|type=Added Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538574656
+|type=Removed Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538574656
+|type=Added Project
+|project=Platform Engineering (Needs Cleaning - Code Health (TEC13))
+}}{{Transition
+|date=1538574656
+|type=Entered Column
+|project=Platform Engineering
+|column=Needs Cleaning - Code Health (TEC13)
+}}{{Transition
+|date=1538574656
+|type=Exited Column
+|project=Platform Engineering
+|column=Inbox
+}}{{Transition
+|date=1538489005
+|type=Added Project
+|project=Platform Engineering
+}}{{Transition
+|date=1538411065
+|type=Entered Column
+|project=Platform Team Legacy
+|column=Epics
+}}{{Transition
+|date=1538411065
+|type=Exited Column
+|project=Platform Team Legacy
+|column=Inbox
+}}{{Transition
+|date=1538411026
+|type=Removed Project
+|project=Core-Platform-Team-Old
+}}{{Transition
+|date=1538411026
+|type=Added Project
+|project=Platform Team Legacy
+}}{{Transition
+|date=1531355971
+|type=Entered Column
+|project=Core-Platform-Team-Old
+|column=Epic
+}}{{Transition
+|date=1531355971
+|type=Exited Column
+|project=Core-Platform-Team-Old
+|column=Inbox
+}}{{Transition
+|date=1531355892
+|type=Removed Project
+|project=MediaWiki-Platform-Team
+}}{{Transition
+|date=1531355892
+|type=Added Project
+|project=Core-Platform-Team-Old
+}}{{Transition
+|date=1525813466
+|type=Entered Column
+|project=Multi-Content-Revisions
+|column=Epic
+}}{{Transition
+|date=1525813466
+|type=Exited Column
+|project=Multi-Content-Revisions
+|column=Watching
+}}{{Transition
+|date=1525689888
+|type=Entered Column
+|project=Multi-Content-Revisions
+|column=Watching
+}}{{Transition
+|date=1525689888
+|type=Exited Column
+|project=Multi-Content-Revisions
+|column=Epic
+}}{{Transition
+|date=1515505435
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=Epic
+}}{{Transition
+|date=1515505435
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Epic
+}}{{Transition
+|date=1511206532
+|type=Entered Column
+|project=Multi-Content-Revisions
+|column=Epic
+}}{{Transition
+|date=1511206532
+|type=Exited Column
+|project=Multi-Content-Revisions
+|column=Inbox
+}}{{Transition
+|date=1508448546
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=Epic
+}}{{Transition
+|date=1508448546
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Epic
+}}{{Transition
+|date=1508436244
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=Epic
+}}{{Transition
+|date=1508436244
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Inbox
+}}{{Transition
+|date=1507918816
+|type=Entered Column
+|project=MediaWiki-Platform-Team (MWPT-Q1-Jul-Sep-2017)
+|column=In Progress
+}}{{Transition
+|date=1507918816
+|type=Exited Column
+|project=MediaWiki-Platform-Team (MWPT-Q1-Jul-Sep-2017)
+|column=Ready
+}}{{Transition
+|date=1507918169
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=MWPT-Q1-Jul-Sep-2017
+}}{{Transition
+|date=1507918169
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Watching
+}}{{Transition
+|date=1494205284
+|type=Entered Column
+|project=Wikimedia-Rdbms
+|column=Schema changes
+}}{{Transition
+|date=1494205284
+|type=Exited Column
+|project=Wikimedia-Rdbms
+|column=Untriaged
+}}{{Transition
+|date=1493220930
+|type=Entered Column
+|project=Schema-change
+|column=Cleanup
+}}{{Transition
+|date=1493220930
+|type=Exited Column
+|project=Schema-change
+|column=Unsorted
+}}{{Transition
+|date=1492665703
+|type=Entered Column
+|project=MediaWiki-Platform-Team
+|column=Watching
+}}{{Transition
+|date=1492665703
+|type=Exited Column
+|project=MediaWiki-Platform-Team
+|column=Inbox
 }}
-|subtasks=167246,184615,6715
 }}