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