Yes, it is fully populated as are the _comment_id fields needed for joins.
Brooke Storm
Operations Engineer
Wikimedia Cloud Services
bstorm(a)wikimedia.org <mailto:bstorm@wikimedia.org>
IRC: bstorm_
On Mar 7, 2019, at 11:21 AM, Jesse Plamondon-Willard
<pathoschild(a)gmail.com> wrote:
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(a)wikimedia.org
<mailto: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
bstorm(a)wikimedia.org <mailto:bstorm@wikimedia.org>
IRC: bstorm_
On Mar 7, 2019, at 9:13 AM, Brooke Storm
<bstorm(a)wikimedia.org <mailto:bstorm@wikimedia.org>> wrote:
Since the MCR refactor of the Mediawiki database schema has been progressing
(
https://phabricator.wikimedia.org/T166733
<https://phabricator.wikimedia.org/T166732> 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
<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
bstorm(a)wikimedia.org <mailto:bstorm@wikimedia.org>
IRC: bstorm_
_______________________________________________
Wikimedia Cloud Services announce mailing list
Cloud-announce(a)lists.wikimedia.org <mailto:Cloud-announce@lists.wikimedia.org>
(formerly labs-announce(a)lists.wikimedia.org
<mailto:labs-announce@lists.wikimedia.org>)
https://lists.wikimedia.org/mailman/listinfo/cloud-announce
<https://lists.wikimedia.org/mailman/listinfo/cloud-announce>
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org <mailto:Cloud@lists.wikimedia.org> (formerly
labs-l(a)lists.wikimedia.org <mailto:labs-l@lists.wikimedia.org>)
https://lists.wikimedia.org/mailman/listinfo/cloud
<https://lists.wikimedia.org/mailman/listinfo/cloud>_______________________________________________
Wikimedia Cloud Services mailing list
Cloud(a)lists.wikimedia.org (formerly labs-l(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud