Work on this is beginning. 

Brooke Storm
Operations Engineer
Wikimedia Cloud Services
bst...@wikimedia.org <mailto:bst...@wikimedia.org>
IRC: bstorm_

> On May 20, 2019, at 12:38 PM, Brooke Storm <bst...@wikimedia.org> wrote:
> 
> I’d like to announce that after taking considerable user feedback about it, 
> and fixing a performance issue regarding the revision_userindex table at 
> https://phabricator.wikimedia.org/T221339 
> <https://phabricator.wikimedia.org/T221339> that affects migration of tools 
> to the new schema, that we are extending the date to Monday, June 3rd instead 
> to begin dropping the fields in the views.  This should give additional time 
> to fix things up as well as find issues in existing views if any more arise.
> 
> Brooke Storm
> Operations Engineer
> Wikimedia Cloud Services
> bst...@wikimedia.org <mailto:bst...@wikimedia.org>
> IRC: bstorm_
> 
>> On May 17, 2019, at 4:27 PM, Brooke Storm <bst...@wikimedia.org 
>> <mailto:bst...@wikimedia.org>> wrote:
>> 
>> Similar to the earlier removal of text fields from the wiki replicas for 
>> comment storage refactors in Mediawiki, we are going to remove “user text” 
>> columns from the views that are deprecated in the Mediawiki schema to 
>> prepare for when they will actually be removed upstream.  The column drops 
>> are tracked and explained here https://phabricator.wikimedia.org/T223406 
>> <https://phabricator.wikimedia.org/T223406>.  The tables with names such as 
>> <tablename>_compat will not see a difference in structure.  The change is 
>> scheduled for Monday, May 27th.
>> 
>> The fields that are dropping from the views are:
>> revision: rev_user and rev_user_text.
>> archive: ar_user and ar_user_text.
>> ipblocks: ipb_by and ipb_by_text.
>> image: img_user and img_user_text.
>> oldimage: oi_user and oi_user_text.
>> filearchive: fa_user and fa_user_text.
>> recentchanges: rc_user and rc_user_text.
>> logging: log_user and log_user_text.
>> Ideally, tools that connect to the replicas should gather the information 
>> from the appropriate entries in the actor table instead, again, this is 
>> similar to the change for the comment table. The data is already there for 
>> you to start using.  The alternative is to try using the related 
>> <tablename>_compat table, which won’t be changing in a user-visible way at 
>> this time.
>> 
>> 
>> Brooke Storm
>> Operations Engineer
>> Wikimedia Cloud Services
>> bst...@wikimedia.org <mailto:bst...@wikimedia.org>
>> IRC: bstorm_
>> 
> 

_______________________________________________
Wikimedia Cloud Services announce mailing list
cloud-annou...@lists.wikimedia.org (formerly labs-annou...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud-announce
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud

Reply via email to