Please note that a new gr.wikimedia.org wiki has been requested. The wiki is going to be public but edition will be restricted (what we call a fishbowl). Thanks.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Urbanecm | T245911 Create a wiki for Wikimedia Community User Group Greece | |||
| Resolved | • JHedden | T245912 Prepare and check storage layer for gr.wikimedia.org |
Event Timeline
Comment Actions
@Urbanecm I saw you created the database, next time please ping us on this sort of ticket "Prepare and check storage layer" so we can go ahead and sanitize the database. We got some alerts about unsanitized data for this database. There is no data leak or anything as there are no views assigned to the tables, but still...
I am going to go ahead and sanitize them now.
Comment Actions
cloud-services-team this is ready for the views creation on labsdb1009, 1010, 1011 and 1012.
I have run this: set session sql_log_bin=0; create database grwikimedia_p; GRANT SELECT, SHOW VIEW ON grwikimedia\_p`.* TO 'labsdbuser';` so the maintainviews script should run fine.
Thank you
Comment Actions
Mentioned in SAL (#wikimedia-cloud) [2020-04-15T18:44:36Z] <jeh> create indexes and views for grwikimedia T245912
Comment Actions
Updates on labsdb10{09,10,11,12}
$ sudo /usr/local/sbin/maintain-replica-indexes --database grwikimedia --debug $ sudo /usr/local/sbin/maintain-views --databases grwikimedia --debug $ sudo /usr/local/sbin/maintain-meta_p --databases grwikimedia
Updates on cloudcontrol1003
$ /usr/local/sbin/wmcs-wikireplica-dns --aliases WARNING:mwopenstackclients.DnsManager:Creating grwikimedia.analytics.db.svc.eqiad.wmflabs. WARNING:mwopenstackclients.DnsManager:Creating grwikimedia.web.db.svc.eqiad.wmflabs.
Testing from Toolforge
MariaDB [grwikimedia_p]> select * from page limit 1\G
*************************** 1. row ***************************
page_id: 1
page_namespace: 0
page_title: Αρχική_σελίδα
page_restrictions:
page_is_redirect: 0
page_is_new: 1
page_random: 0.502073964967
page_touched: 20200406124029
page_links_updated: 20200406124029
page_latest: 1
page_len: 1356
page_content_model: wikitext
page_lang: NULL
1 row in set (0.01 sec)