[00:06:27] Analytics-Tech-community-metrics, Developer-Relations, Community-Tech-Sprint: Investigation: Can we find a new search API for CorenSearchBot and Copyvio Detector tool? - https://phabricator.wikimedia.org/T125459#2262211 (kaldari) The meeting with Microsoft was a mixed bag. They basically said that th... [00:10:24] Analytics-Tech-community-metrics, Developer-Relations, Community-Tech-Sprint: Investigation: Can we find a new search API for CorenSearchBot and Copyvio Detector tool? - https://phabricator.wikimedia.org/T125459#2262214 (Earwig) Re point #2, can we argue that CSB is user-initiated on the principle th... [02:21:32] Analytics-Tech-community-metrics, Developer-Relations, Community-Tech-Sprint: Investigation: Can we find a new search API for CorenSearchBot and Copyvio Detector tool? - https://phabricator.wikimedia.org/T125459#2262353 (kaldari) @Tnegrin: Yes, we are still considering Google. If nothing pans out wit... [05:25:54] Analytics-Tech-community-metrics, Developer-Relations, Community-Tech-Sprint: Investigation: Can we find a new search API for CorenSearchBot and Copyvio Detector tool? - https://phabricator.wikimedia.org/T125459#2262499 (Josve05a) >>! In T125459#2262353, @kaldari wrote: > @Tnegrin: Yes, we are still... [07:32:48] Analytics-General-or-Unknown: gu.wikiquote.org URL Do Not work - https://phabricator.wikimedia.org/T134343#2262627 (YmKavishwar) [07:33:53] Analytics-General-or-Unknown: gu.wikiquote.org URL Do Not work - https://phabricator.wikimedia.org/T134343#2262640 (YmKavishwar) p:Triage>High [08:26:07] o/ [08:26:15] Hi elukey :) [08:26:24] review morning again for me [08:26:30] I was about to say the same [08:26:36] * joal is trying hard to write correct english :) [08:26:41] I have been writing for an hour and still need to write stuff [08:26:44] ahhahahaah [08:27:31] Today I've read what I wrote yesterday and I thought "did a 5 years old child hacked my laptop tonight?" [08:27:43] huhuhu :) [08:29:28] stats.wikimedia.org, datasets.w.o, etc.. are all working with HTTP/2 [08:30:08] nginx has been updated yesterday, really really great [09:38:28] (CR) Joal: "Weeeeeird ! To me the separator still shows up as a space !" [analytics/refinery] - https://gerrit.wikimedia.org/r/286672 (https://phabricator.wikimedia.org/T134279) (owner: Nuria) [11:25:36] Analytics-Kanban, DC-Ops, EventBus, MediaWiki-Cache, and 5 others: setup kafka2001 & kafka2002 - https://phabricator.wikimedia.org/T121558#2263404 (elukey) LVS configuration set up on lvs200[36]: curl http://eventbus.svc.codfw.wmnet:8085/v1/topics Pending verification, but the work should be do... [11:54:00] * elukey lunch + afk for a bit [11:56:34] Analytics-Tech-community-metrics, Developer-Relations (Apr-Jun-2016): Create basic/high-level Kibana (dashboard) documentation - https://phabricator.wikimedia.org/T132323#2263484 (Qgil) [11:56:39] Analytics-Tech-community-metrics, Developer-Relations (Apr-Jun-2016): Identify Wikimedia's most important/used info panels in korma.wmflabs.org - https://phabricator.wikimedia.org/T132421#2263482 (Qgil) [11:56:59] Analytics-Tech-community-metrics, Developer-Relations (Apr-Jun-2016): Mismatch between numbers for code merges per organization - https://phabricator.wikimedia.org/T129910#2263494 (Qgil) [11:57:05] Analytics-Tech-community-metrics, Developer-Relations (Apr-Jun-2016): Play with Bitergia's Kabana UI (which might potential replace our current UI on korma.wmflabs.org) - https://phabricator.wikimedia.org/T127078#2263498 (Qgil) [11:57:24] Analytics-Tech-community-metrics, Differential, Developer-Relations (Apr-Jun-2016): Make MetricsGrimoire/korma support gathering Code Review statistics from Phabricator's Differential - https://phabricator.wikimedia.org/T118753#2263506 (Qgil) [13:01:39] Analytics-Kanban, DC-Ops, EventBus, MediaWiki-Cache, and 5 others: setup kafka2001 & kafka2002 - https://phabricator.wikimedia.org/T121558#2263744 (elukey) [13:03:12] Analytics-Kanban, Operations, Patch-For-Review: Upgrade stat1001 to Debian Jessie - https://phabricator.wikimedia.org/T76348#2263748 (elukey) [13:03:29] Analytics-Kanban, Operations, Patch-For-Review: Upgrade stat1001 to Debian Jessie - https://phabricator.wikimedia.org/T76348#798408 (elukey) [15:17:56] elukey, ottomata, yt? [15:18:24] jaa hi [15:18:34] hi ottomata :] [15:19:11] can you help me troubleshoot why vital-signs.wmflabs.org and browser-reports.wmflabs.org are 502ing? [15:19:32] surre [15:19:36] oh ottomata... it seems not any more... [15:19:42] haha [15:19:44] ok... [15:19:45] you are welcome! [15:19:48] hehe [15:20:06] ottomata: you didn't even to `hmmm` to make it work again ! [15:20:16] * joal is impressed [15:20:25] haha [15:20:31] my power grows... [15:21:00] xDDDD [15:21:24] I think it's the sole mention of his name that does the thing [15:30:11] mforns: When Chuck Norris invented computers, ottomata had already sent him two emails [15:30:20] xDDDDD [15:33:48] nuria_: https://phabricator.wikimedia.org/T96848 [15:34:12] joal: hahahahah [15:47:17] elukey: some respect for ema: https://github.com/wikimedia/operations-puppet/blob/production/modules/tlsproxy/files/utils/h2_spdy_stats.stp [15:47:22] bow [15:48:00] nuria_: I know, ema++ :) [15:48:12] elukey: indeed. [15:49:10] Analytics-EventLogging, Analytics-Kanban, scap, Patch-For-Review, Scap3 (Scap3-Adoption-Phase1): Use scap3 to deploy eventlogging/eventlogging - https://phabricator.wikimedia.org/T118772#2264457 (Ottomata) Yes, it is mostly performance team for the deployment to hafnium. See T131977 [15:49:55] Analytics-EventLogging, Analytics-Kanban, scap, Patch-For-Review, Scap3 (Scap3-Adoption-Phase1): Use scap3 to deploy eventlogging/eventlogging - https://phabricator.wikimedia.org/T118772#2264461 (Ottomata) Actually T110903 is more descriptive. [15:52:00] ottomata: do you have a minute? [15:52:22] yup [15:52:26] what's up? [15:53:03] I sent https://gerrit.wikimedia.org/r/#/c/286845/ and tested in the puppet compiler, should be good, but before proceeding I'd need a basic step: where can I find the analytics1003 root db pass? [15:53:13] I need to create hue's schema :) [15:53:19] didn't find it in the private repo [15:55:49] elukey: , no root pass [15:55:54] you just need to be root user [15:56:01] sudo mysql [15:56:03] will do it [15:56:45] * elukey is confused but will try [15:57:08] joal: ottomata scares me sometimes [15:57:14] :P [15:57:26] ahahhahaha it wooork [15:57:28] huhu [15:57:37] now DROP TABLE [15:57:39] err no [16:00:33] a-team: standddupppp [16:01:16] mforns, joal , elukey , madhuvishy : standuppppp [16:01:22] nuria_, going [16:01:27] nuria_: in meeting, sent email [16:01:52] Analytics-Kanban, Patch-For-Review: Fix Dashiki's metrics-by-project breakdown - https://phabricator.wikimedia.org/T133944#2264529 (Nuria) [16:01:58] mforns: get up stand up, stand up for your rights [16:02:01] :P [16:02:10] xDDD [16:03:38] Analytics-Kanban, Patch-For-Review: Client values inbound in X-analytics header (pageview and preview) are reflected in outbound X-Analytics on varnish - https://phabricator.wikimedia.org/T133204#2264537 (Nuria) [16:06:00] i cannot get into batcave [16:15:18] Analytics-Kanban, DNS, Operations, Traffic: Create analytics.wikimedia.org - https://phabricator.wikimedia.org/T132407#2264602 (Ottomata) [16:15:31] Analytics-Kanban, DNS, Operations, Traffic: Create analytics.wikimedia.org - https://phabricator.wikimedia.org/T132407#2197243 (Ottomata) a:Ottomata [16:30:34] nuria_, do you want to look at the dashiki bug? [16:30:44] mforns: yes, let's go back to batcave [16:30:51] ok [16:38:57] wikimedia/mediawiki-extensions-EventLogging#553 (REL1_27 - 67dedc9 : Translation updater bot): The build failed. [16:38:57] Change view : https://github.com/wikimedia/mediawiki-extensions-EventLogging/compare/REL1_27 [16:38:57] Build details : https://travis-ci.org/wikimedia/mediawiki-extensions-EventLogging/builds/127843551 [16:40:12] elukey: mobrovac fyi i'm running a throughput test in codfw [16:43:13] ottomata: I am going to stop hue, dump the db && copy the sqlite as prep steps for the migration [16:43:42] !log stopping hue on analytics1027 to dump its databse [16:44:11] ok cool [17:00:03] ottomata: just saw your comments on the hue code review, I thought about adding everything to hiera too. Just amended it, puppet compiler looks good https://puppet-compiler.wmflabs.org/2666/analytics1027.eqiad.wmnet/ [17:02:46] anything against me merging? [17:03:15] nope! +1 this will break hue until it is done though, ja? [17:03:36] yeppa [17:04:01] but I am going to migrate the db now [17:06:09] (PS2) Mforns: Fix issues in metrics-by-project breakdown patterns [analytics/dashiki] - https://gerrit.wikimedia.org/r/286755 (https://phabricator.wikimedia.org/T133944) (owner: Nuria) [17:08:35] ok [17:09:36] ah snap [17:16:30] !log migrating the hue database [17:20:28] (PS3) Mforns: Fix issues in metrics-by-project breakdown patterns [analytics/dashiki] - https://gerrit.wikimedia.org/r/286755 (https://phabricator.wikimedia.org/T133944) (owner: Nuria) [17:22:59] (PS4) Mforns: Fix issues in metrics-by-project breakdown patterns [analytics/dashiki] - https://gerrit.wikimedia.org/r/286755 (https://phabricator.wikimedia.org/T133944) (owner: Nuria) [17:25:23] nuria_, it's ready for review: https://gerrit.wikimedia.org/r/#/c/286755 [17:25:36] mforns: on meeting will talk in abit [17:25:43] sure [17:28:56] ottomata: migration completed! [17:29:05] do you mind to double check that everything is working fine? [17:31:19] elukey: i think it looks good! [17:31:19] nice! [17:31:29] \o/ [17:31:55] I had to follow the procedure for InnoDB though [17:32:06] because there were some foreign keys to clear [17:32:09] and then restore [17:32:11] a bit weird [17:33:08] hm [17:33:33] Analytics-Cluster, Analytics-Kanban, Patch-For-Review: Use MySQL as Hue data backend store - https://phabricator.wikimedia.org/T127990#2264972 (elukey) Executed the migration steps, everything worked nicely and hue looks good now. [17:35:05] ottomata: I suspect that the database engine should have been set to "mariadb" [17:35:08] not mysql [17:36:15] mmmm no the docs says mysql [17:36:18] http://www.cloudera.com/documentation/enterprise/5-5-x/topics/cdh_ig_hue_database.html#concept_id1_wkj_zj__cdh_ig_hue_database_mariadb [17:36:45] anyhooowww [17:37:00] I am going to log-off and then double check later that everything is fine [17:37:03] byeee a-team! [17:39:28] ook laters! [17:39:39] bye elukey ! [17:40:40] a-team fyi, ellery just noticed that spark jobs aren't being accepted by yarn [17:40:44] trying to troubleshoot [17:40:53] have we noticed any problems with prod spark jobs? [17:41:04] ottomata: oh at all? i thought just temp resource allocation issue [17:41:13] i mean, maybe it is [17:41:20] but ellery has noticed since yesterday [17:41:27] hmmm [17:41:27] hm, will try in higher level queue [17:52:20] yeah madhuvishy it never gets accepted [17:52:34] ottomata: hmmm [17:52:37] weird [17:53:08] yeah not good, i assume oozie submitted jobs are going to fail too :/ [17:53:15] trying to figure out why [17:53:20] i find errors in logs, but nothing really useful [17:53:28] checking prod jobs [17:54:44] ottomata: https://hue.wikimedia.org/oozie/list_oozie_coordinator/0000116-160420145651441-oozie-oozi-C/ [17:55:04] everything upto an hour ago seems to have run [17:55:42] not sure about the current job though [17:55:50] hm [17:56:52] ottomata: http://localhost:8088/proxy/application_1458129362008_163704/ [17:57:00] if you're proxying already [17:57:02] it's running [17:57:23] HMM madhuvishy! [17:57:29] --deploy-mode cluster works [17:57:36] ottomata: oh interesting [17:57:42] but not local? [17:58:07] not client, yeah [17:58:12] hmmm [17:58:20] double checking [17:58:35] ewulczyn_____: oh you are here [17:58:39] so many underscores! [17:59:26] ok, so prod jobs won't die [17:59:28] hm [18:00:36] yeah prod jobs look fine [18:04:42] I tried --deploy-mode cluster and the job still did not get going [18:05:07] ewulczyn_____: you are doing spark-submit? [18:05:12] can you paste full command to launch job? [18:05:13] yes [18:05:39] spark-submit \ [18:05:39] --driver-memory 5g \ [18:05:39] --master yarn \ [18:05:39] --deploy-mode cluster \ [18:05:39] --num-executors 4 \ [18:05:39] --executor-memory 5g \ [18:05:39] --executor-cores 4 \ [18:05:40] --priority [18:05:40] hash_trace_ips.py \ [18:05:41] --name test [18:07:09] ewulczyn_____: hmmm woah 5g driver memory? [18:10:21] hmm, i'm trying with ewulczyn_____'s stuff, haven't tried a python example [18:10:27] cluster seems also to not work for python [18:11:10] event without 5g driver [18:11:18] i'm runing a simpler python spark job with spark-submit [18:11:20] not working :( [18:12:48] (PS8) Amire80: Add sorted errors [analytics/limn-language-data] - https://gerrit.wikimedia.org/r/282228 [18:13:53] (CR) Amire80: Add sorted errors (1 comment) [analytics/limn-language-data] - https://gerrit.wikimedia.org/r/282228 (owner: Amire80) [18:15:22] bahhhh [18:15:25] OH [18:15:28] ewulczyn_____: i take it back [18:15:33] i got it to run in cluster mode [18:15:37] my script was just funky [18:15:53] hm [18:16:02] so, it isn't a python problem [18:16:03] hm [18:16:15] ottomata: may be it cant get 5g driver memory [18:16:44] maybe, but it doesn't work in client mode either [18:16:46] which it should [18:16:48] right [18:17:48] when i couldn't get it to run before in cluster mode, my python script had a syntax error in it [18:17:57] which did not show up in cluster mode [18:18:01] but when I ran in client it showed me [18:18:56] madhuvishy: i got my cluster mode script to run with 5g driver memory, trying the same settings ellery had [18:18:57] ... [18:19:32] note it should be --queue priority not --priority [18:19:37] aye [18:19:40] i'm running in default queue right now [18:19:57] ja ellery i can make both python and scala run in cluster mode [18:20:04] you sure yours doesn't ever run in cluster mode? [18:20:26] that's not your full command, is it your script takes args [18:20:33] can you paste full command with absolute paths in a gist or something? [18:20:38] or pastebin? [18:22:21] the job oscillates between state:ACCEPTED and state: RUNNING [18:22:36] oscillates? [18:22:42] weird [18:23:08] you were saying that if there is abug in my code and I run in cluster mode, I would not see the stacktrace? [18:23:22] ewulczyn_____: ewulczyn_____ not sure, i just noticed that when there was one in mine [18:23:31] can you run it in local mode on a small dataset? [18:24:03] also, ewulczyn_____ please paste or email me a full command I can run with your script (with absolute paths so I can find it :) ) i want to try it [18:25:21] spark-submit \ [18:25:21] --driver-memory 1g \ [18:25:21] --master yarn \ [18:25:21] --deploy-mode cluster \ [18:25:21] --num-executors 4 \ [18:25:21] --executor-memory 5g \ [18:25:21] --executor-cores 4 \ [18:25:22] --queue priority \ [18:25:22] --name test \ [18:25:23] --key dummy_key [18:25:40] I'll email it [18:26:50] sent [18:28:19] ewulczyn_____: hmmm i've seen the oscillation if it runs out of memory and keeps rescheduling the job [18:28:31] ottomata: ^ [18:30:24] hm [18:30:41] yeah this does look like a different problem. at least, a diffferent exit ode [18:30:42] hm [18:33:07] yeah if it get sto running and then back to accepted it means that something is failing during the job execution , pretty sure [18:33:17] yup [18:37:46] ewulczyn_____: for yours [18:37:47] i get [18:37:51] : org.apache.hadoop.mapred.InvalidInputException: Input path does not exist: hdfs://analytics-hadoop/user/ellery/user/hive/warehouse/traces.db/test [18:38:13] hmm, wait is that my fault? [18:38:14] hang on [18:38:34] no, yeah [18:38:35] ellery [18:38:37] your script has a bug! :) [18:38:41] input_dir = 'user/hive/warehouse/traces.db/' + args.name [18:40:41] ja ewulczyn_____ i was able to run your job in cluster mode succesfully [18:41:41] yup, me to, but not in client mode [18:42:23] sorry for adding a red herring [18:42:57] yeah client mode is still a problem [18:43:02] for spark-submit i'd usually just use cluster anyway [18:43:09] but, yeah for shells you can't do that [18:50:33] ewulczyn_____: this is def a problem [18:50:38] are you unblocked for now? [18:50:40] i'm going to file a ticket [18:50:42] for the client mode stuff [18:52:24] hmm, can you give me some advice on how to debug my scripts in cluster mode? [18:52:54] client mode gives me the error [18:54:51] ^ ottomata [18:55:40] ewulczyn_____: can you run them in local mode instead of yarn? [18:55:55] --master local [18:56:18] and make sure you use a small local input and and output, with small values for executors and drivers and memory [18:56:20] probably defaults are ok [18:56:26] also, I'm used to running using python packages that are not installed on the lcuster in the driver [18:56:46] hm [18:56:53] you can ship them with the job somehow, ja? [18:57:04] --py-files PY_FILES Comma-separated list of .zip, .egg, or .py files to place [18:57:05] on the PYTHONPATH for Python apps. [18:58:26] I might just work on something else until cient mode os working again. I've tried to ship packages before with limited success [18:59:49] ewulczyn_____: what packages are you missing? [18:59:56] a small list of debianized packages? :D [18:59:59] perhaps? [19:00:01] probalby not.. [19:00:30] :) no, probably not. [19:00:51] ya this is pretty annoying [19:00:59] its ok, I can work on other stuff for a while [19:01:26] any ideas on what happened to client mode? [19:02:07] Analytics, Analytics-Cluster: Spark yarn in client mode is never moved from ACCEPTED to RUNNING - https://phabricator.wikimedia.org/T134422#2265192 (Ottomata) [19:02:10] ewulczyn_____: no idea [19:02:17] are you sure this only started a day ago? [19:03:02] no, but it definitely worked last week [19:03:25] hm ok [19:03:52] Analytics, Analytics-Cluster: Spark yarn in client mode is never moved from ACCEPTED to RUNNING - https://phabricator.wikimedia.org/T134422#2265219 (Ottomata) We aren't sure when or why this started happening, but Ellery says he was able to use client mode just fine last week. [19:17:31] (PS5) Nuria: Fix issues in metrics-by-project breakdown patterns [analytics/dashiki] - https://gerrit.wikimedia.org/r/286755 (https://phabricator.wikimedia.org/T133944) [19:19:53] (CR) Nuria: Fix issues in metrics-by-project breakdown patterns (1 comment) [analytics/dashiki] - https://gerrit.wikimedia.org/r/286755 (https://phabricator.wikimedia.org/T133944) (owner: Nuria) [19:22:58] ewulczyn_____: i'd recommend running in local mode to debug your stuff, as for shipping things, and if you need help shipping python stuff lemme know, maybe we can figure it out [19:23:17] i gotta work on some other stuff before my work day finishes, not sure when we will figure out the client mode thing [19:23:20] hopefully not too long [19:23:24] keep poking at us about it [19:23:27] ottomata, ewulczyn_____ : Was backfilling onto the thing [19:23:51] ? [19:24:02] ottomata: have we changed anything recently on the cluster that might have made a working stuff go to non-working ? [19:24:15] not that i can remember [19:24:22] ottomata: backlogging IRC sorry :) [19:24:25] ah [19:24:29] ottomata: any java update? [19:24:32] elukey: switched hue stuff around today [19:24:40] but that should be unrelated [19:24:42] hmm [19:24:43] also not that i know fo [19:25:10] I recall a global restart for java update from elukey, but I think it was before last week [19:25:55] and ewulczyn_____ said this didn't work for him yesterday too [19:25:58] and hue mysql stuff just ahppened today [19:26:05] right [19:28:00] aloha :) [19:28:10] Eya elukey [19:28:27] experiencing weird spark behavior since a few days [19:28:41] Have we done anything to java on the cluster last weeke ? [19:28:43] elukey: sorry for the ping! [19:28:45] elukey: --^ [19:28:53] no worries! I was just checking hue :P [19:28:56] Analytics, Commons, Multimedia, Wikidata, and 3 others: Review shared data namespace (tabular data) implementation - https://phabricator.wikimedia.org/T134426#2265305 (Yurik) [19:29:30] so Moritz has rolled out some upgrades to non java daemons in the past two days (ssh, ntp, etc..) due to openssl upgrades [19:30:19] but that's it, not much that could explain spark failures [19:30:30] what are the symptoms? [19:30:43] I didn't investigate after the email sorry :( [19:31:28] np elukey : Spark doesn't stop in client mode mode anymore [19:31:30] elukey: https://phabricator.wikimedia.org/T134422 [19:32:07] Analytics, Analytics-Cluster: Spark yarn in client mode is never moved from ACCEPTED to RUNNING - https://phabricator.wikimedia.org/T134422#2265321 (Ottomata) [19:32:08] elukey: client mode means that there is a local app that gets results back from the application master [19:32:44] ja elukey don't worry about it now it is late there! [19:33:09] all right, will try to follow up tomorrow :) [19:33:14] sorry! [19:33:20] Ohhhhhh, I recall now: there have been changes on the firewall for stat1002 !!!! [19:33:26] Must be that ! [19:33:53] !!! [19:34:27] 29/04 - 07:54 moritzm: enabled base::firewall on stat1002 [19:34:48] joal: --^ [19:34:59] that is last Friday [19:35:04] * joal loves when its brain works :) [19:35:15] !!!!! [19:35:17] !!! [19:35:19] hmmmm [19:35:23] hm [19:35:25] YES [19:35:41] because it starts a listener on a port, and it isn't going to know where the app master is gonna be [19:35:46] so the app master has to contact the local client [19:35:51] HMMM [19:36:15] all right, good work :) [19:36:20] talk with you tomorrow! [19:36:21] byyeeee [19:36:37] Bye elukey ! [19:36:45] Thanks having been my ruberduck ! [19:37:11] ottomata: I* really think that could be it [19:41:03] yeah i htink so too [19:41:06] here i will stop ferm for a sec [19:41:07] and try [19:41:13] (am doing like 5 thigns at once...) [19:41:55] huhuh ottomata :) [19:42:23] yup, totally it! [19:42:42] will try to make a patch to fix shortly...not really sure what i'm gonna do yet [19:42:45] dealing with analytics.wm.org first [19:54:03] thanks for thinking of that joal [19:57:58] ottomata: no prob :) [19:58:05] ottomata: cool that it was that ! [19:58:51] a-team: logging off for tonight, see you tomorrow [20:00:02] Analytics, Commons, Multimedia, Wikidata, and 3 others: Review shared data namespace (tabular data) implementation - https://phabricator.wikimedia.org/T134426#2265432 (matmarex) Surely this doesn't need all these tags and all these people. Please pay attention when creating subtasks :( [20:00:17] laters joal! [20:02:46] Analytics, ContentTranslation-Analytics, MediaWiki-extensions-ContentTranslation, Operations, and 4 others: schedule a daily run of ContentTranslation analytics scripts - https://phabricator.wikimedia.org/T122479#2265442 (Amire80) [20:02:50] Analytics, ContentTranslation-Analytics, MediaWiki-extensions-ContentTranslation, Operations, Ops-Access-Requests: access for amire80 to stat1002.eqiad.wmnet - https://phabricator.wikimedia.org/T122524#2265439 (Amire80) Resolved>Open @ellery says that I will definitely need stat1002 t... [20:07:10] Analytics, ContentTranslation-Analytics, MediaWiki-extensions-ContentTranslation, Operations, Ops-Access-Requests: access for amire80 to stat1002.eqiad.wmnet - https://phabricator.wikimedia.org/T122524#2265466 (Ottomata) Please clarify how you will run these queries. If MySQL, then you only n... [20:08:13] Analytics, ContentTranslation-Analytics, MediaWiki-extensions-ContentTranslation, Operations, Ops-Access-Requests: access for amire80 to stat1002.eqiad.wmnet - https://phabricator.wikimedia.org/T122524#2265469 (Krenair) Yes, can we please start talking in terms of groups instead of hosts? [20:21:01] Analytics: Augment 'Add a Wiki' process to include Analytics pageview whitelist - https://phabricator.wikimedia.org/T134433#2265512 (Ottomata) [20:23:21] Analytics: Augment 'Add a Wiki' process to include Analytics pageview whitelist - https://phabricator.wikimedia.org/T134433#2265532 (Krenair) We need to figure out the correct criteria for wikis to be added to this list. I noticed that there are only 4 entries containing `.wikimedia`, that can't possibly be... [20:23:26] Analytics, ContentTranslation-Analytics, MediaWiki-extensions-ContentTranslation, Operations, Ops-Access-Requests: access for amire80 to stat1002.eqiad.wmnet - https://phabricator.wikimedia.org/T122524#2265533 (ellery) @Amire80 needs to run hive queries to count the number times users navigat... [20:26:56] Analytics: Augment 'Add a Wiki' process to include Analytics pageview whitelist - https://phabricator.wikimedia.org/T134433#2265540 (Nuria) Just updated wiki: https://wikitech.wikimedia.org/wiki/Add_a_wiki#Analytics @Krenair: it is correct, only "knowledge public wikis " are on that list [20:28:51] Analytics: Augment 'Add a Wiki' process to include Analytics pageview whitelist - https://phabricator.wikimedia.org/T134433#2265548 (Krenair) So non-private, non-wikimania, non-chapter, and none of these? loginwiki outreachwiki qualitywiki strategywiki usabilitywiki [20:29:56] nuria_: yeehaw! [20:29:57] https://analytics.wikimedia.org/ [20:30:17] ottomata: you da ma! [20:30:19] *man [20:30:23] be there 1 min [20:30:25] k [21:14:33] Analytics-Kanban, Operations, Patch-For-Review: Upgrade stat1001 to Debian Jessie - https://phabricator.wikimedia.org/T76348#2265713 (ezachte) Issues fixed. Thanks, elukey, and others. [21:20:19] (CR) Mforns: Fix issues in metrics-by-project breakdown patterns (1 comment) [analytics/dashiki] - https://gerrit.wikimedia.org/r/286755 (https://phabricator.wikimedia.org/T133944) (owner: Nuria) [21:21:00] (CR) Mforns: "I tried the newest patch (5) and it has a problem, see comments in patch 4." [analytics/dashiki] - https://gerrit.wikimedia.org/r/286755 (https://phabricator.wikimedia.org/T133944) (owner: Nuria) [21:21:44] nuria_, if yt I looked at the newest patch and it has a problem, I commented in gerrit, but if you want we can chat here or batcave [21:23:06] Analytics, Analytics-Cluster, Patch-For-Review: Spark yarn in client mode is never moved from ACCEPTED to RUNNING - https://phabricator.wikimedia.org/T134422#2265751 (Ottomata) Ah ha! Of course, Moritz applied base::firewall a few days ago. https://gerrit.wikimedia.org/r/287001 should fix. [21:23:51] Analytics, Analytics-Cluster, Patch-For-Review: Spark yarn in client mode is never moved from ACCEPTED to RUNNING - https://phabricator.wikimedia.org/T134422#2265753 (Ottomata) @MoritzMuehlenhoff [21:25:47] Analytics-Cluster, Analytics-Kanban, Patch-For-Review: Spark yarn in client mode is never moved from ACCEPTED to RUNNING - https://phabricator.wikimedia.org/T134422#2265761 (Ottomata) a:Ottomata [21:26:43] Analytics, ContentTranslation-Analytics, MediaWiki-extensions-ContentTranslation, Operations, Ops-Access-Requests: access for amire80 to stat1002.eqiad.wmnet - https://phabricator.wikimedia.org/T122524#2265768 (Dzahn) a:Dzahn>None [21:29:10] Analytics, ContentTranslation-Analytics, MediaWiki-extensions-ContentTranslation, Operations, Ops-Access-Requests: access for amire80 to stat1002.eqiad.wmnet - https://phabricator.wikimedia.org/T122524#2265769 (Dzahn) it will be handled, i'm just giving it back to the pool because access requ... [21:33:58] (CR) Mforns: Fix issues in metrics-by-project breakdown patterns (1 comment) [analytics/dashiki] - https://gerrit.wikimedia.org/r/286755 (https://phabricator.wikimedia.org/T133944) (owner: Nuria) [21:41:13] Analytics-Tech-community-metrics, Developer-Relations, Community-Tech-Sprint: Investigation: Can we find a new search API for CorenSearchBot and Copyvio Detector tool? - https://phabricator.wikimedia.org/T125459#2265814 (tom29739) >>! In T125459#2262499, @Josve05a wrote: >>>! In T125459#2262353, @kal... [21:54:58] Analytics-Cluster, Analytics-Kanban, Patch-For-Review: Spark yarn in client mode is never moved from ACCEPTED to RUNNING - https://phabricator.wikimedia.org/T134422#2265930 (Ottomata) [21:55:07] Analytics-Kanban, DNS, Operations, Traffic, Patch-For-Review: Create analytics.wikimedia.org - https://phabricator.wikimedia.org/T132407#2265931 (Ottomata) [22:02:22] (PS6) Mforns: Fix issues in metrics-by-project breakdown patterns [analytics/dashiki] - https://gerrit.wikimedia.org/r/286755 (https://phabricator.wikimedia.org/T133944) (owner: Nuria) [22:17:56] Analytics-Tech-community-metrics, Developer-Relations, Community-Tech-Sprint: Investigation: Can we find a new search API for CorenSearchBot and Copyvio Detector tool? - https://phabricator.wikimedia.org/T125459#2266027 (Tnegrin) It's not the money per se - it's just a budget formality of putting the... [22:50:31] mforns: looking [22:53:39] mforns: ah right, you mention that earlier today, I see that [22:57:56] Analytics: Augment 'Add a Wiki' process to include Analytics pageview whitelist - https://phabricator.wikimedia.org/T134433#2266089 (Nuria) @krenair: correct, those are omitted on purpose so their pageviews are not counted. to be clear we still get their requests and we process them we just do not aggregate... [23:01:25] Analytics-Kanban, Patch-For-Review: Add JJB support for Jenkins Maven Release Plugin {hawk} - https://phabricator.wikimedia.org/T132175#2190696 (hashar) That patch looks entirely fine to me :) Can you propose it to upstream Gerrit? They are rather friendly and I have approval rights there to help move i... [23:01:50] Analytics-Kanban, Continuous-Integration-Config, Patch-For-Review: Add JJB support for Jenkins Maven Release Plugin {hawk} - https://phabricator.wikimedia.org/T132175#2266092 (hashar) [23:01:50] mforns: updating [23:01:54] nuria_, ok [23:02:18] Analytics-Kanban, Continuous-Integration-Config, Patch-For-Review: Add JJB support for Jenkins Maven Release Plugin {hawk} - https://phabricator.wikimedia.org/T132175#2190696 (hashar) [23:02:24] mforns: i think it will be easy to not empty breakdowns if metric has not changed on my patch and that makes code a lot simpler no? [23:02:51] nuria_, should we store the previous metric? [23:03:24] I don't like this very much [23:03:44] mforns: no need, right? we can subscribe to changes we need [23:05:21] nuria_, I see, the only change we can subscribe that is close that what we need, is the breakdownState [23:05:46] nuria_, but the breakdown state also changes when a breakdown option is toggled [23:06:37] nuria_, we can not clean up the patterns when a breakdown option is toggled, otherwise we'll see the problem we were talking about [23:07:08] Analytics: Augment 'Add a Wiki' process to include Analytics pageview whitelist - https://phabricator.wikimedia.org/T134433#2266095 (Krenair) Okay. I think this is done and we can resolve it, unless anyone disagrees? [23:07:13] Analytics-Tech-community-metrics, Developer-Relations, Community-Tech-Sprint: Investigation: Can we find a new search API for CorenSearchBot and Copyvio Detector tool? - https://phabricator.wikimedia.org/T125459#2266096 (Majora) >>! In T125459#2265814, @tom29739 wrote: >>>! In T125459#2262499, @Josve... [23:16:07] Analytics, Commons, Multimedia, Wikidata, and 3 others: Review shared data namespace (tabular data) implementation - https://phabricator.wikimedia.org/T134426#2266122 (Yurik) My apologies to anyone who is not interested in the implementation review of this feature - please unsubscribe. I am hopin...