Page MenuHomePhabricator

deploymentwiki site still present in sites table
Closed, ResolvedPublic

Description

The deploymentwiki project and database was removed as part of T198673: Remove deployment.wikimedia.beta.wmflabs.org wiki (deploymentwiki) — however, it is still present in the sites table, and is thus returned via getSites()`.

Can this row be safely deleted from the sites table?

wikiadmin@172.16.3.239(metawiki)> select site_id, site_global_key from sites where site_global_key = 'deploymentwiki';
+---------+-----------------+
| site_id | site_global_key |
+---------+-----------------+
|      33 | deploymentwiki  |
+---------+-----------------+
1 row in set (0.001 sec)

Event Timeline

I have deleted the row in beta's metawiki database

root@BETA[metawiki]> select site_id, site_global_key from sites where site_global_key = 'deploymentwiki';
+---------+-----------------+
| site_id | site_global_key |
+---------+-----------------+
|      33 | deploymentwiki  |
+---------+-----------------+
1 row in set (0.004 sec)

root@BETA[metawiki]> START TRANSACTION;
Query OK, 0 rows affected (0.000 sec)

root@BETA[metawiki]> delete from sites where site_id = 33;
Query OK, 1 row affected (0.008 sec)

root@BETA[metawiki]> COMMIT;
Query OK, 0 rows affected (0.009 sec)

root@BETA[metawiki]> select site_id, site_global_key from sites where site_global_key = 'deploymentwiki';
Empty set (0.001 sec)
TheresNoTime claimed this task.