Forwarding to Analytics and Research in case this is of interest.
Pine ( https://meta.wikimedia.org/wiki/User:Pine )
---------- Forwarded message --------- From: Amir Sarabadani amir.sarabadani@wikimedia.de Date: Thu, Sep 6, 2018 at 9:19 PM Subject: [Wikitech-l] Change tag reading from the new column in the beta cluster To: Wikimedia developers Wikitech-l@lists.wikimedia.org
Hello, As part of normalizing change tag schema [1] I just switched on reading from the new column (ct_tag_id in change_tag table, a foreign key to ctd_id from change_tag_def table) in beta cluster [2] which means new rows will have empty string as their value of ct_tag. [3]
We are not rushing to flip the switch in production but I just wanted to send this email asking people who test in beta cluster to file a phabricator ticket if they see anything unexpected in there that might be related change tags. This table is being read if someone checks history, recent changes, watchlist, user contributions, or whole lot of other special pages plus lots of API queries. I checked anything I could think of but I might have missed something. Any extra pair of eyes would be extremely appreciated.
[1]: https://phabricator.wikimedia.org/T185355 [2]: https://phabricator.wikimedia.org/T196671 [3]: For example: MariaDB [enwiki]> select ct_id, ct_rc_id, ct_rev_id, ct_tag, ct_tag_id from change_tag order by ct_id desc limit 10; +--------+----------+-----------+-----------------------+-----------+ | ct_id | ct_rc_id | ct_rev_id | ct_tag | ct_tag_id | +--------+----------+-----------+-----------------------+-----------+ | 217824 | 633991 | 384018 | | 3 | | 217823 | 633990 | 384017 | | 3 | | 217822 | 633989 | 384016 | | 3 | | 217821 | 633988 | 384015 | | 3 | | 217820 | 633987 | 384014 | | 3 | | 217819 | 633986 | 384013 | mw-undo | 2 | | 217818 | 633985 | 384012 | mw-undo | 2 | | 217817 | 633984 | 384011 | visualeditor-wikitext | 29 | | 217816 | 633983 | 384010 | mobile web edit | 16 | | 217815 | 633983 | 384010 | mobile edit | 15 | +--------+----------+-----------+-----------------------+-----------+ 10 rows in set (0.00 sec)
Thank you! Best