I noticed that several wikis created a couple of months ago (kcgwiki [2022-05], guwwiki [2022-03], shnwikivoyage [2022-03]) do not have wiki replicas fully working (sql <wiki> does not connect to the wiki's replica):
urbanecm@tools-sgebastion-10 ~ $ sql kcgwiki Could not find requested database Make sure to ask for a db in format of <wiki>_p urbanecm@tools-sgebastion-10 ~ $ sql guwwiki Could not find requested database Make sure to ask for a db in format of <wiki>_p urbanecm@tools-sgebastion-10 ~ $ sql shnwikivoyage Could not find requested database Make sure to ask for a db in format of <wiki>_p urbanecm@tools-sgebastion-10 ~ $
However, manually checking s5.analytics.db.svc.wikimedia.cloud shows that the views themselves exist:
urbanecm@tools-sgebastion-10 ~ $ mysql -h s5.analytics.db.svc.wikimedia.cloud [...] MariaDB [(none)]> use kcgwiki_p Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [kcgwiki_p]> select page_id from page limit 1; +---------+ | page_id | +---------+ | 893 | +---------+ 1 row in set (0.005 sec) MariaDB [kcgwiki_p]> use guwwiki_p Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [guwwiki_p]> select page_id from page limit 1; +---------+ | page_id | +---------+ | 21 | +---------+ 1 row in set (0.002 sec) MariaDB [guwwiki_p]> use shnwikivoyage_p Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [shnwikivoyage_p]> select page_id from page limit 1; +---------+ | page_id | +---------+ | 1300 | +---------+ 1 row in set (0.003 sec) MariaDB [shnwikivoyage_p]> Bye urbanecm@tools-sgebastion-10 ~ $
Further investigation shows that the issue is that /usr/bin/sql determines the right host via the <wiki>.{analytics,web}.db.svc.wikimedia.cloud DNS record, which does not exist for the three wikis mentioned above:
urbanecm@tools-sgebastion-10 ~ $ host kcgwiki.analytics.db.svc.wikimedia.cloud Host kcgwiki.analytics.db.svc.wikimedia.cloud not found: 3(NXDOMAIN) urbanecm@tools-sgebastion-10 ~ $ host guwwiki.analytics.db.svc.wikimedia.cloud Host guwwiki.analytics.db.svc.wikimedia.cloud not found: 3(NXDOMAIN) urbanecm@tools-sgebastion-10 ~ $ host shnwikivoyage.analytics.db.svc.wikimedia.cloud Host shnwikivoyage.analytics.db.svc.wikimedia.cloud not found: 3(NXDOMAIN) urbanecm@tools-sgebastion-10 ~ $
In addition to the wiki-replica issue mentioned above, it also looks like the wikis were not added to meta_p.wiki, meaning tools relying on that database will not be not aware of the wiki's existence:
urbanecm@tools-sgebastion-10 ~
$ sql meta
[...]
MariaDB [meta_p]> select * from wiki where dbname in ('kcgwiki', 'guwwiki', 'shnwikivoyage');
Empty set (0.003 sec)
MariaDB [meta_p]> Bye
urbanecm@tools-sgebastion-10 ~
$According to a discussion with @taavi, this seems to be Data-Engineering's responsibility. Tagging as such (feel free to correct me if this is not correct).