Is the comment table fully populated, so we can migrate tools immediately?

--
Pathoschild (Jesse)

On Thu, 7 Mar 2019 at 12:54, Brooke Storm <bstorm@wikimedia.org> wrote:
After some discussion, we are moving back the date by a week to 3/19/2019 for people to have a bit more time to update tools and such.
Thanks everyone!

Brooke Storm
Operations Engineer
Wikimedia Cloud Services
IRC: bstorm_

On Mar 7, 2019, at 9:13 AM, Brooke Storm <bstorm@wikimedia.org> wrote:

Since the MCR refactor of the Mediawiki database schema has been progressing (https://phabricator.wikimedia.org/T166733 and many other tickets), one of the last steps is dropping the columns from the wiki replica schema.

The column drops are being tracked and are explained well here https://phabricator.wikimedia.org/T212972, and currently the change is ready to be applied.  It is already applied to two wikis (eswiki and huwiki since there was a column problem that needed fixing).  The tables with names such as <tablename>_compat will retain a similar structure if that is needed for refactoring.

From the ticket, this is a summary of what is changing, organized by table name:
  • archive: Remove ar_comment
  • archive_userindex: Remove ar_comment
  • filearchive:
    • Remove fa_deleted_reason
    • Remove fa_description
  • filearchive_userindex:
    • Remove fa_deleted_reason
    • Remove fa_description
  • image: Remove img_description
  • ipblocks: Remove ipb_reason.
  • ipblocks_ipindex: Remove ipb_reason.
  • logging: Remove log_comment.
  • logging_logindex: Remove log_comment.
  • logging_userindex: Remove log_comment.
  • oldimage: Remove oi_description
  • oldimage_userindex: Remove oi_description
  • recentchanges: Remove rc_comment.
  • recentchanges_userindex: Remove rc_comment.
  • revision: Remove rev_comment.
  • revision_userindex: Remove rev_comment.

The changes to the _compat tables should not affect anything.

We will deploy the change early next week (Tuesday - 3/12/2019).  In most cases, if a table isn’t working for your tool or app anymore because of the change, you can switch to a table named $tablename_compat and it will appear to have the same schema, but it is recommended that comment references use a join to the new comment table on a “comment_id” field instead where possible.

Brooke Storm
Operations Engineer
Wikimedia Cloud Services
IRC: bstorm_


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