[05:30:22] 10DBA, 10Collaboration-Team-Triage, 10StructuredDiscussions, 10Patch-For-Review, 10Schema-change: Drop flow_subscription table - https://phabricator.wikimedia.org/T149936#4145123 (10Marostegui) Thanks! I will drop this table on Monday - for the sake of not dropping a table on a Friday :-) [06:21:48] 10DBA, 10Data-Services: Re-institute query killer for the analytics WikiReplica - https://phabricator.wikimedia.org/T183983#4145153 (10Marostegui) pt-kill has been released (https://www.percona.com/doc/percona-toolkit/3.0/release_notes.html#v3-0-8-released-2018-03-13) and it has: ``` Buf Fixes PT-1492: pt-ki... [06:28:24] 10DBA, 10Data-Services: Re-institute query killer for the analytics WikiReplica - https://phabricator.wikimedia.org/T183983#4145160 (10Marostegui) So looks like it is not yet fixed: ``` # 2018-04-20T06:20:09 KILL 8093697 (Execute 0 sec) /* related.suggest_redlinks LIMIT:15 NM */ ``` I am going back to the pre... [06:52:29] 10DBA, 10Data-Services: Re-institute query killer for the analytics WikiReplica - https://phabricator.wikimedia.org/T183983#4145168 (10Marostegui) https://jira.percona.com/browse/PT-1492?focusedCommentId=224100&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-224100 [06:58:36] should I package 8.0? [06:59:21] yessss! [07:31:04] do you want to report the regression of atop to debian? I could do it, but you probably know better the details? [07:37:33] Yeah, I was planning to talk to moritzm about it [08:25:07] moritzm: ack, I'll ping you later [08:25:30] ^ xDDD [08:33:16] 10DBA, 10Cloud-Services, 10User-Urbanecm: Prepare and check storage layer for gorwiki - https://phabricator.wikimedia.org/T189112#4031710 (10MarcoAurelio) @Marostegui Wiki has been created yesterday. Thanks. [08:33:21] ^^ [08:33:55] Saw it yesterday while checking private data for another new wiki created, but I will filter it again to be completely sure [08:33:58] Thanks for the heads up [08:34:41] 10DBA, 10Cloud-Services: Prepare storage layer for euwikisource - https://phabricator.wikimedia.org/T189466#4042582 (10MarcoAurelio) @Marostegui Wiki has been created. Thanks. [08:35:04] 10DBA, 10Cloud-Services, 10User-Urbanecm: Prepare and check storage layer for romdwikimedia - https://phabricator.wikimedia.org/T187774#3985290 (10MarcoAurelio) @Marostegui Wiki has been created. [08:35:12] Yeah, all those were filtered yesterday [08:35:15] But I will double check [08:35:36] 10DBA, 10Cloud-Services, 10User-Urbanecm: Prepare and check storage layer for inhwiki - https://phabricator.wikimedia.org/T184375#3881370 (10MarcoAurelio) @Marostegui Wiki has been created. [08:35:46] I sense a pattern [08:35:46] 10DBA, 10Cloud-Services, 10User-Urbanecm: Prepare and check storage layer for gorwiki - https://phabricator.wikimedia.org/T189112#4145309 (10Marostegui) a:03Marostegui I will make sure it is filtered before sending it to #cloud-services-team [08:35:56] just pinging you as requested :D [08:35:58] 10DBA, 10Cloud-Services: Prepare storage layer for euwikisource - https://phabricator.wikimedia.org/T189466#4145312 (10Marostegui) a:03Marostegui I will make sure it is filtered before sending it to #cloud-services-team [08:36:12] Hauskatze: Yeah, that's great :-) Thank you [08:36:13] 10DBA, 10Cloud-Services, 10User-Urbanecm: Prepare and check storage layer for romdwikimedia - https://phabricator.wikimedia.org/T187774#4145315 (10Marostegui) a:03Marostegui I will make sure it is filtered before sending it to #cloud-services-team [08:36:38] marostegui: so just to know, if I try to query, ie, a non-sanitized wiki now via labs would I be able to see any "innapropriate"? [08:36:52] or is it simply not there yet? [08:36:53] 10DBA, 10Cloud-Services, 10User-Urbanecm: Prepare and check storage layer for inhwiki - https://phabricator.wikimedia.org/T184375#4145318 (10Marostegui) a:03Marostegui I will make sure it is filtered before sending it to #cloud-services-team [08:37:10] Hauskatze: No, because there are no views there :) [08:37:15] ok [08:37:30] so, to sum up: lfnwiki, inhwiki, lfnwiki, euwikisource [08:37:46] lfn was done yesterday, ready for cloud to do it [08:37:54] gorwiki [08:38:05] + hiwikimedia and romdwikimedia [08:38:17] going to double check now: gorwiki euwikisource romdwikimedia inhwiki [08:38:17] 7 new wikis [08:38:39] 4 + lfnwiki [08:38:39] and I'm going to create the wikidata item for inhwiki [08:46:17] 10DBA, 10Cloud-Services, 10Hindi-Sites, 10User-Jayprakash12345: Prepare and check storage layer for hiwikimedia - https://phabricator.wikimedia.org/T188490#4009570 (10MarcoAurelio) @Marostegui Wiki has been created. Thanks. [08:47:08] 10DBA, 10Cloud-Services, 10Hindi-Sites, 10User-Jayprakash12345: Prepare and check storage layer for hiwikimedia - https://phabricator.wikimedia.org/T188490#4145374 (10Marostegui) a:03Marostegui I will make sure it is filtered before sending it to cloud-services-team [08:47:26] * Hauskatze thinks done [08:47:51] fwiw, irc-cookies for all of you, I'm just made 10 years old in Wikimedia [08:48:24] Only 10? ;) [08:48:52] I cannot make the time go faster [08:49:14] maybe that way I could achieve retirement before public pensions dissapear :P [08:49:49] 10?! [08:51:58] Usuario MarcoAurelio en es - Registrado: 20 abr 2008, 11:1 [08:52:07] <3 [08:52:47] Hauskatze: My global account is older than that ;) [08:59:08] marostegui: I have a first try at a mysql package [08:59:30] it won't be pretty, but the basic works, do you think it is ok to upload it? [08:59:52] Yeah, I would say upload it (I would like to try it too :) ) [09:00:04] (some systemd things changed, and I am not 100% sure they are production-ready [09:00:15] changed on the last minute, I mean [09:00:50] also mixing mysql and mariadb on the same server would be a nightmare because different authentication, etc. [09:01:02] yeah indeed [09:01:08] I will try on my vms [09:04:53] uploaded [12:05:52] 10DBA, 10Cloud-Services, 10User-Urbanecm, 10cloud-services-team (Kanban): Prepare and check storage layer for inhwiki - https://phabricator.wikimedia.org/T184375#4145715 (10Marostegui) a:05Marostegui>03None Ready for #cloud-services-team [12:06:04] 10DBA, 10Cloud-Services, 10User-Urbanecm, 10cloud-services-team (Kanban): Prepare and check storage layer for romdwikimedia - https://phabricator.wikimedia.org/T187774#4145720 (10Marostegui) a:05Marostegui>03None Ready for #cloud-services-team [12:06:18] 10DBA, 10Cloud-Services, 10cloud-services-team (Kanban): Prepare storage layer for euwikisource - https://phabricator.wikimedia.org/T189466#4145725 (10Marostegui) a:05Marostegui>03None Ready for #cloud-services-team [12:06:38] 10DBA, 10Cloud-Services, 10User-Urbanecm, 10cloud-services-team (Kanban): Prepare and check storage layer for gorwiki - https://phabricator.wikimedia.org/T189112#4145730 (10Marostegui) a:05Marostegui>03None Ready for #cloud-services-team [12:06:57] 10DBA, 10Cloud-Services, 10cloud-services-team, 10Hindi-Sites, 10User-Jayprakash12345: Prepare and check storage layer for hiwikimedia - https://phabricator.wikimedia.org/T188490#4145735 (10Marostegui) a:05Marostegui>03None Ready for #cloud-services-team [13:21:22] 10DBA, 10Cloud-Services, 10Hindi-Sites, 10User-Jayprakash12345, 10cloud-services-team (Kanban): Prepare and check storage layer for hiwikimedia - https://phabricator.wikimedia.org/T188490#4145832 (10bd808) Ready for the steps described at https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services [13:22:19] 10DBA, 10Cloud-Services, 10User-Urbanecm, 10cloud-services-team (Kanban): Prepare and check storage layer for gorwiki - https://phabricator.wikimedia.org/T189112#4145835 (10bd808) Ready for the steps described at https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services [13:45:51] 10DBA, 10Data-Services, 10Dumps-Generation, 10MediaWiki-Platform-Team, 10Patch-For-Review: Configure Toolforge replica views and dumps for the new MCR tables - https://phabricator.wikimedia.org/T184446#4145880 (10Anomie) The `slots` table should now exist on all wikis.