In order for the new separated-by-age anonymized user_properties view to work, the user.user_touched column needs to be populated.
(It is forcibly set to NULL in the user views already, so populating the underlying column will not diclose)
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | bd808 | T60788 Toolserver migration to Tools (tracking) | |||
| Resolved | bd808 | T60791 Missing Toolserver features in Tools (tracking) | |||
| Resolved | He7d3r | T61480 Gadget usage statistics for Portuguese Wikipedia | |||
| Resolved | coren | T60196 Tool Labs: Provide anonymized view of the user_properties table | |||
| Resolved | jcrespo | T92841 Database replicas: replicate user.user_touched |
Event Timeline
Comment Actions
(This was assigned directly to Sean and likely fell between the cracks because of it)
Comment Actions
Do you want me to fill in that column to sanitarium from production (and take out any nullifying process, if any there)?
Comment Actions
This requires some planning: drop and update the triggers, which has to be done while replication is stopped to avoid leaks. I've started to do so at: https://gerrit.wikimedia.org/r/253930
And reimport in a consistent way the columns- something that could be done with blocking dumps on a slave that can suffer some lag (or depooling one and syncing its binlog position)
Comment Actions
The filters have been dropped (changed to allow that field). Now I have to backfill that column.
Comment Actions
The importing is taking place now. It will take a while, as we have 5GB of user data per server.
Comment Actions
enwiki has been backfilled, it took 5.81GB of transference and 1:28:42 (time).
Will backfill the rest of the wikis later.