Page MenuHomePhabricator

Drop ORES tables from wikis without ORES
Closed, ResolvedPublic

Description

Summary

There are some wikis with the database tables needed for ORES that do not enable the extension. This task focuses on dropping ORES tables on closed wikis (which do not have ORES enabled)

Technical details

  • The following wikis in the closed.dblist have the ores_classification and ores_model table with no database rows:
akwiki
crwiki
klwiki
lrcwiki
nawiki
pihwiki
  • These wikis are not in ores.dblist and so the ORES extension is not enabled on them. Additionally, they are in the closed.dblist so these wikis shouldn't need ORES to be enabled for the wiki

Schema change template

  1. ALTERs to run: DROP TABLE ores_classification; DROP TABLE ores_model;
  2. Where to run those changes: See above for the list
  3. When to run those changes: When DBA has time
  4. If the schema change is backwards compatible: No, but on these wikis the tables are unused so it should cause no problems
  5. If the schema change has been tested already on some of the test/beta wikis: N/A
  6. If the data should be made available on the labs replicas and/or dumps: N/A

Acceptance criteria

  • The database tables are dropped from WMF wikis listed above

Event Timeline

Dreamy_Jazz updated the task description. (Show Details)
Dreamy_Jazz updated the task description. (Show Details)
Ladsgroup triaged this task as Medium priority.Mar 17 2026, 11:16 PM
Ladsgroup moved this task from Triage to Ready on the DBA board.
Marostegui subscribed.

We should rename these tables first before dropping.

They are indeed empty, so I will just go ahead and drop them

[05:31:34] marostegui@cumin1003:~/git/mediawiki-config/dblists$ for i in akwiki crwiki klwiki lrcwiki nawiki pihwiki; do echo $i; sudo db-mysql db1189 $i -e "select count(*) from ores_classification;select count(*) from ores_model;";done
akwiki
+----------+
| count(*) |
+----------+
|        0 |
+----------+
+----------+
| count(*) |
+----------+
|        0 |
+----------+
crwiki
+----------+
| count(*) |
+----------+
|        0 |
+----------+
+----------+
| count(*) |
+----------+
|        0 |
+----------+
klwiki
+----------+
| count(*) |
+----------+
|        0 |
+----------+
+----------+
| count(*) |
+----------+
|        0 |
+----------+
lrcwiki
+----------+
| count(*) |
+----------+
|        0 |
+----------+
+----------+
| count(*) |
+----------+
|        0 |
+----------+
nawiki
+----------+
| count(*) |
+----------+
|        0 |
+----------+
+----------+
| count(*) |
+----------+
|        0 |
+----------+
pihwiki
+----------+
| count(*) |
+----------+
|        0 |
+----------+
+----------+
| count(*) |
+----------+
|        0 |
+----------+

Mentioned in SAL (#wikimedia-operations) [2026-04-01T05:33:07Z] <marostegui> Drop empty ores_classification and ores_model on closed wikis T420093