Page MenuHomePhabricator

Drop unused views for: localisation and localisation_file_hash
Closed, ResolvedPublic

Description

The following tables were removed from production (T119811):

localisation_file_hash
localisation

However the views are still present on labsdb1009 (and I assume 1010 and 1011 too).
They should be cleaned up as they reference an non existing table.
They are present only on a few databases:

localisation_file_hash

root@labsdb1009:/srv/sqldata# find . | grep localisation_file_hash
./commonswiki_p/localisation_file_hash.frm
./dewiki_p/localisation_file_hash.frm
./enwiki_p/localisation_file_hash.frm
./testwiki_p/localisation_file_hash.frm

localisation

root@labsdb1009:/srv/sqldata# find . | grep localisation.frm
./commonswiki_p/localisation.frm
./dewiki_p/localisation.frm
./jawiki_p/localisation.frm
./frwiki_p/localisation.frm
./enwiki_p/localisation.frm
./testwiki_p/localisation.frm

Event Timeline

Marostegui created this task.

Change 424168 had a related patch set uploaded (by BryanDavis; owner: Bryan Davis):
[operations/puppet@production] wiki replicas: Remove localisation and localisation_file_hash views

https://gerrit.wikimedia.org/r/424168

bd808 edited projects, added cloud-services-team (Kanban); removed cloud-services-team.
bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.

Change 424168 merged by Bstorm:
[operations/puppet@production] wiki replicas: Remove localisation and localisation_file_hash views

https://gerrit.wikimedia.org/r/424168

bd808 added subscribers: Bstorm, bd808.

Assigning to @Bstorm so she can run the maintain-views --clean step that is needed while each server is depooled.

Two servers are done. One more to go.