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(a)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(a)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 -- Amir Sarabadani Software Engineer Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Tel. (030) 219 158 26-0 http://wikimedia.de Stellen Sie sich eine Welt vor, in der jeder Mensch an der Menge allen Wissens frei teilhaben kann. Helfen Sie uns dabei! http://spenden.wikimedia.de/ Wikimedia Deutschland – Gesellschaft zur Förderung Freien Wissens e. V. Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207. _______________________________________________ Wikitech-l mailing list Wikitech-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l