Page MenuHomePhabricator

Cleanup empty and bogus databases/tables from external storage
Open, LowPublic

Description

The other 3 are:
wikidata -> I guess mistake
10wikipedia -> I guess temporary test or something?
tenwikipedia -> I guess temporary test or something?

I know it's out of the scope for this ticket, and probably should have another filed.. But is there anything in those on any host? Can we drop them?

es1:
wikidata doesn't exist
1 row on blobs_cluster22
0 rows on blobs_cluster23

es2:
0 rows on the 3 databases

es3:
wikidata has 1 row
10wikipedia empty
tenwikipedia empty

Event Timeline

Reedy renamed this task from Cleanup empty databases/tables from external storage to Cleanup empty and bogus databases/tables from external storage.EditedFeb 20 2020, 12:16 PM

As they are not proper wiki database names, and probably one row means it is the main page...

wikidata is actually wikidatawiki
tenwikipedia/10wikipedia is actually tenwiki

Reedy triaged this task as Lowest priority.Feb 20 2020, 12:33 PM

So, for reference... The 2 rows referenced in the task are just variants of the mainpage. In tenwikipedia case, it has a load of IW links, the wikidata one doesn't

Doesn't seem to be any reason to keep any of them around

So, for reference... The 2 rows referenced in the task are just variants of the mainpage. In tenwikipedia case, it has a load of IW links, the wikidata one doesn't

Doesn't seem to be any reason to keep any of them around

Should we truncate the tables first to make sure nothing is really there or drop the 3 database entirely?
wikidata
tenwikipedia
10wikipedia

You can truncate them, but I'm almost certain they're not used/accessed (we can verify that the correct databases for those wikis have the main page entries too), and are just an artefact of mis-creating wikis; in the case of 'wikidata', probably my fault

LSobanski raised the priority of this task from Lowest to Low.Apr 26 2021, 10:09 AM