No info on why "sites" table was created only on specific WMF wikis circa May 2013, yet it is in the core schema since v1.21.
https://gerrit.wikimedia.org/r/#/c/23528/
On dbstore1002:
select schema_name from information_schema.schemata left join (select table_schema from information_schema.tables where table_name = 'sites') t on schema_name = table_schema where table_schema is null and schema_name like '%wik%';
reedy@tin:~$ sql enwiki -h dbstore1002 ERROR 1045 (28000): Access denied for user 'wikiadmin'@'10.64.0.196' (using password: YES)
Do we actually have a list of these? IIRC anything running wikidata should explicitly have this table. Any new wikis will have it too, but it's possible we never bothered creating it everywhere else
Is that a question to Springle or to the unknown audience out there? How to proceed here?
I don't think this is a real problem anymore... can be fixed for vewikimedia, but also doesn't really matter if it's not done. Leaving it to @Springle whether this task should be closed.
mysql:root@dbstore1002 [(none)]> select schema_name from information_schema.schemata left join (select table_schema from information_schema.tables where table_name = 'sites') t on schema_name = table_schema where table_schema is null and schema_name like '%wik%'; +-------------+ | schema_name | +-------------+ | vewikimedia | +-------------+ 1 row in set (5.47 sec)
Might be better pinging @jcrespo. TBH, if it's only 1 wiki missing it, I think we should just make it, and close this task out
select schema_name from information_schema.schemata left join (select table_schema from information_schema.tables where table_name = 'site_identifiers') t on schema_name = table_schema where table_schema is null and schema_name like '%wik%'; Empty set (4.45 sec)