New public wiki
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Reedy | T196357 Create Wikivoyage Bengali | |||
| Resolved | • Bstorm | T196358 Prepare and check storage layer for bn.wikivoyage |
Event Timeline
Comment Actions
We are troubleshooting a views creation issues (https://phabricator.wikimedia.org/T193187) but for this one, we have done it manually running:
set session sql_log_bin=0;GRANT SELECT, SHOW VIEW ON `bnwikivoyage\_p`.* TO 'labsdbuser'; create database bnwikivoyage_p;
And ran the maintainviews scripts
Comment Actions
@Marostegui Are you sure it is working?
urbanecm@tools-bastion-02 ~ $ sql --cluster=analytics bnwikivoyage Could not find requested database Make sure to ask for a db in format of <wiki>_p urbanecm@tools-bastion-02 ~ $ sql --cluster=web bnwikivoyage Could not find requested database Make sure to ask for a db in format of <wiki>_p urbanecm@tools-bastion-02 ~ [8/8] $ host bnwikivoyage.analytics.db.svc.eqiad.wmflabs Host bnwikivoyage.analytics.db.svc.eqiad.wmflabs not found: 3(NXDOMAIN) urbanecm@tools-bastion-02 ~ $ host bnwikivoyage.web.db.svc.eqiad.wmflabs Host bnwikivoyage.web.db.svc.eqiad.wmflabs not found: 3(NXDOMAIN) urbanecm@tools-bastion-02 ~ $ sql cswiki Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 7178500 Server version: 10.1.33-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [cswiki_p]> select @@hostname; +------------+ | @@hostname | +------------+ | labsdb1010 | +------------+ 1 row in set (0.00 sec) MariaDB [cswiki_p]> use bnwikivoyage_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 [bnwikivoyage_p]> Bye urbanecm@tools-bastion-02 ~ $ sql cswiki Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 6693997 Server version: 10.1.33-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [cswiki_p]> select @@hostname; +------------+ | @@hostname | +------------+ | labsdb1011 | +------------+ 1 row in set (0.00 sec) MariaDB [cswiki_p]> use bnwikivoyage_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 [bnwikivoyage_p]> Bye urbanecm@tools-bastion-02 ~ $
I can connect to the database, but not using the shortcut sql. Also, I found the domain names do not exist
urbanecm@tools-bastion-02 ~ $ host cswiki.web.db.svc.eqiad.wmflabs cswiki.web.db.svc.eqiad.wmflabs is an alias for s2.web.db.svc.eqiad.wmflabs. s2.web.db.svc.eqiad.wmflabs has address 10.64.37.15 urbanecm@tools-bastion-02 ~ $ host cswiki.analytics.db.svc.eqiad.wmflabs cswiki.analytics.db.svc.eqiad.wmflabs is an alias for s2.analytics.db.svc.eqiad.wmflabs. s2.analytics.db.svc.eqiad.wmflabs has address 10.64.37.14 urbanecm@tools-bastion-02 ~ $ host bnwikivoyage.web.db.svc.eqiad.wmflabs Host bnwikivoyage.web.db.svc.eqiad.wmflabs not found: 3(NXDOMAIN) urbanecm@tools-bastion-02 ~ $ host bnwikivoyage.analytics.db.svc.eqiad.wmflabs Host bnwikivoyage.analytics.db.svc.eqiad.wmflabs not found: 3(NXDOMAIN) urbanecm@tools-bastion-02 ~ $
Comment Actions
Sorry, I have one more step. Let me run that. There's an additional script I haven't yet run.
Comment Actions
There, the last script triggers a few more actions, relating to DNS. Give it a few minutes and try again.
Comment Actions
@Bstorm as reported by @Urbanecm , this still doesn't work after a few hours.
marostegui@tools-bastion-03:~$ sql -v --cluster analytics bnwikivoyage_p Could not find requested database marostegui@tools-bastion-03:~$ sql -v --cluster web bnwikivoyage_p Could not find requested database
However it is there if you switch to it
marostegui@tools-bastion-03:~$ sql -v --cluster analytics enwiki_p Resolved enwiki_p to enwiki.analytics.db.svc.eqiad.wmflabs Connecting to enwiki.analytics.db.svc.eqiad.wmflabs Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 7232365 Server version: 10.1.33-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [enwiki_p]> use bnwikivoyage_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 [bnwikivoyage_p]>
Comment Actions
Doh! Yes, there is yet another script (for DNS) that doesn't automatically run. It's running now (and specifically creating the aliases).
Comment Actions
Working, thanks.
urbanecm@tools-bastion-02 ~ $ sql --cluster=analytics bnwikivoyage Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8263420 Server version: 10.1.33-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [bnwikivoyage_p]> Bye urbanecm@tools-bastion-02 ~ $ sql --cluster=web bnwikivoyage Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 13224974 Server version: 10.1.33-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [bnwikivoyage_p]> Bye urbanecm@tools-bastion-02 ~ $