The extension which managed this table has been decommissioned (see T85984). The table can now be dropped.
Description
Description
Details
Details
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Resolved | LSobanski | T54921 Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) | |||
| Resolved | jcrespo | T115711 Drop `user_daily_contribs` table from all production wikis |
Event Timeline
Comment Actions
Low because it will probably not block anyone. That doesn't mean it will not be done soon, as it is easy.
Comment Actions
According to https://gerrit.wikimedia.org/r/#/c/246689/1/wmf-config/InitialiseSettings.php, this should have been enabled on all production wikis.
About to perform a rename of the table to delete_user_daily_contribs on all wikis to verify that it is indeed not used anymore.
Comment Actions
There are 30 million rows on these tables (on enwiki, fewer on the others). This makes this a slightly more complex issue due to potential impact on the 5.5 masters. We will have to do it slowly, specially for s1 and s3.
I will also create a backup first.
Comment Actions
I have renamed the table on all wikis to delete_user_daily_contribs; I will leave it as is for some time, will delete it afterwards after checking that no code is requiring it.
A backup exists for all tables on iron.
Comment Actions
This table has been dropped from all dblist wikis.
mysql -A -h s1-master.eqiad.wmnet enwiki -e "SHOW TABLES like '%user_daily_contribs%'" [no results]
Comment Actions
@ori, I do not know that you did here, but you did not delete the views:
mysql -BN -A -h labsdb1001.eqiad.wmnet enwiki_p -e "SHOW TABLES like '%user_daily_contribs%'" user_daily_contribs
, or modified the script that creates it:
Reopening and putting it on my backlog.
Comment Actions
Sigh. This has to do with my pathological tendency to confuse labs with beta cluster. I dropped the tables on the beta cluster. Which is not what you were actually asking about, I now realize.
Comment Actions
Change 250378 had a related patch set uploaded (by Jcrespo):
Delete user_daily_contribs from the views in labs
Comment Actions
Finally, I have deleted all tables and view referencing this table and I am ready to close.
One last thing, @ori, I saw the table bing recreated on vewikimedia production. Can you make sure references to that table on code are vanished and it is not recreated? I assume it was a "human race condition", by which it was recreated while it was being deleted and I had an old copy of dblists, but can you check the fact (the table will not be recreated in the future)?
Comment Actions
Change 255443 had a related patch set uploaded (by MaxSem):
UserDailyContribs has been undeployed
Comment Actions
Change 255444 had a related patch set uploaded (by MaxSem):
Don't checkout UserDailyContribs
Comment Actions
@jcrespo, the above patches should take care of remaining vestiges. The reappeared table is safe to drop at any moment meanwhile.
Comment Actions
Thanks, @MaxSem. I think this ticket will serve as a checklist of all things needed for a full table deprecation: production drop, and its script, labs drop, labs views drop, and its script, sanitarium triggers, beta drop.