Steps to reproduce:
- Go to https://phabricator.wikimedia.org/config/dbissue/
- See phabricator_file.__dsns DB table listed which should not exist (no clue what that is/was for)
- Its content lists ancient hardware that we likely got rid of in T183469:
MariaDB [phabricator_file]> SELECT * FROM __dsns LIMIT 50; +----+-----------+-----------------------------+ | id | parent_id | dsn | +----+-----------+-----------------------------+ | 1 | NULL | h=db1048.eqiad.wmnet,u=root | | 2 | NULL | h=db2012.codfw.wmnet,u=root | +----+-----------+-----------------------------+ 2 rows in set (0.001 sec)
- See phabricator_search.phabricator_stopwords (50 entries) DB table listed which should not exist
- It duplicates phabricator_search.stopwords (no table prefix) (45 entries) which is actually used by Phorge's Ferret engine
- FYI these surplus tables do _not_ exist on the test instance
Upstream docs about surplus schemata: https://we.phorge.it/book/phorge/article/storage_adjust/#surplus-schemata