Page MenuHomePhabricator

Drop database table "namespaces" from Wikimedia wikis
Closed, ResolvedPublic

Description

On at least enwiki, there is a "namespaces" database table that appears to be unused and unneeded.

Its schema:

MariaDB [enwiki_p]> describe namespaces;
+-------+---------+------+-----+---------+-------+

FieldTypeNullKeyDefaultExtra

+-------+---------+------+-----+---------+-------+

iint(11)YESNULL
vblobYESNULL

+-------+---------+------+-----+---------+-------+
2 rows in set (0.03 sec)

Its contents:

MariaDB [enwiki_p]> select * from namespaces;
+------+----------------+

iv

+------+----------------+

0
1Talk
2User
3User_talk
4Wikipedia
5Wikipedia_talk
6Image
7Image_talk
8MediaWiki
9MediaWiki_talk
10Template
11Template_talk
12Help
13Help_talk
14Category
15Category_talk

+------+----------------+
16 rows in set (0.03 sec)

This database table should be dropped from all Wikimedia wikis.


Version: wmf-deployment
Severity: enhancement

Details

Reference
bz52929

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:51 AM
bzimport set Reference to bz52929.

No there isn't:

MariaDB [enwiki_p]> explain namespaces;
ERROR 1146 (42S02): Table 'enwiki_p.namespaces' doesn't exist
mysql> explain namespaces;
ERROR 1146 (42S02): Table 'enwiki.namespaces' doesn't exist

Assuming this was resolved.

Do you realize that if your user account doesn't have permissions to read the table it would tell you it doesn't exist?

Yep. Luckily I do have view/select permissions for all tables on these databases.