Page MenuHomePhabricator
Create Task
Maniphest T227047

Complete actor table and comment table migration
Open, NormalPublic
Actions

Description

Deploy refactored actor and comment storage, alter revision table to add columns referring to the new tables, and remove temporary relation tables.

Related Objects
Search...

StatusAssignedTask
 OpenNoneT161671 Compacting the revision table
 OpenNoneT227047 Complete actor table and comment table migration
 OpenAnomieT215466 Remove revision_comment_temp and revision_actor_temp
 OpenAnomieT166733 Deploy refactored comment storage
 ResolvedAnomieT166732 Refactor comment storage in the database and abstract access in MediaWiki
 ResolvedNoneT166798 Decide whether back-compat views for upcoming major schema changes will be provided in the Labs replicas
 Resolved• MarosteguiT174569 Schema change for refactored comment storage
 ResolvedBstormT181650 Change views for the new columns of the refactored comment storage
 DeclinedNoneT210935 Blank out remaining rev_comment fields on Wikimedia wikis
 ResolvedAnomieT210937 API query for userprops not working on group0 wikis (maybe because comment migration read-new)
 ResolvedAnomieT212972 Remove reference to text fields replaced by the comment table from WMCS views
 OpenNoneT208690 create revision_commentindex
 OpenAnomieT188327 Deploy refactored actor storage
 Resolved• MarosteguiT188299 Schema change for refactored actor storage
 OpenBstormT195747 Create views for the schema change for refactored actor storage
 OpenAnomieT167246 Refactor "user" & "user_text" fields into "actor" reference table
 ResolvedJdforrester-WMFT188183 Add the "actor" table to the database layout documentation
 OpenCiencia_Al_PoderT188710 Adapt grabbers to support the new actor table
 OpenNoneT205353 Clean up empty ar_user_text and rev_user_text fields
 OpenNoneT229092 Investigate migrateActors script failing due to duplicate empty actor_name
 Resolved• MarosteguiT187089 Fix WMF schemas to not break when comment store goes WRITE_NEW
 ResolvedAnomieT204669 Slow access to Special:Contributions on mediawiki.org (due to enabling actor table WRITE_BOTH mode)
 ResolvedCatropeT204764 DB error in PageTriage: Unknown column 'actor_rev_user.actor_user' in 'on clause'
 ResolvedAnomieT204767 Special:ActiveUsers fails with "Error: 1054 Unknown column 'rc_actor' in 'on clause' (10.192.32.110)"
 ResolvedAnomieT209847 Clean up actor renames on mediawikiwiki
 ResolvedAnomieT210621 Internal api error: CannotCreateActorException
 ResolvedAnomieT215464 Oversighters can no longer see suppressed contributions past a certain date when using the offender parameter
 ResolvedAnomieT215525 log_search rows with ls_field='target_author_actor' and empty ls_value are created during actor migration
 ResolvedAnomieT223406 Remove reference to fields replaced by the actor table from WMCS views
 ResolvedNiharikaT219324 Update tools maintained by Community-Tech to use new actor storage
 ResolvedMaxSemT219328 Update Event Metrics to use new actor storage
 ResolvedMusikAnimalT223667 Update to use new actor storage
 ResolvedBstormT221339 Missing index on revision_userindex.rev_actor
 ResolvedMilimetricT224134 Finish actor migration in refinery sqoop and refinery source
 OpenNoneT225007 Update operator/user manual description of database tables changed for refactored actor storage

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 1 2019, 11:47 PM
CCicalese_WMF triaged this task as Normal priority.Jul 1 2019, 11:55 PM
CCicalese_WMF updated the task description. (Show Details)
jcrespo added a subscriber: jcrespo.Jul 2 2019, 7:56 AM

Hi, I am guessing you will communicate with us (DBAs) on subtasks about the details of how to proceed with this, as this seems quite a complex set of changes, right? We are looking forward to decrease the footprint of revision! :-D

CCicalese_WMF added a comment.Jul 2 2019, 1:24 PM

@jcrespo Yes, of course. This is just a tracking task to link all of the required subtasks. Communication with DBAs will continue on the subtasks.

Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL