[00:31:47] <wikibugs>	 Analytics-General-or-Unknown: datasets.wikimedia.org SSL error - https://phabricator.wikimedia.org/T74805#802896 (Mattflaschen)
[00:41:31] <milimetric>	 nuria__: ok, danny horn typed a few exclamation marks when he saw the dashboards :)
[00:41:46] <nuria__>	 that it something...
[00:41:52] <nuria__>	 at least they were not tears!
[00:41:56] <milimetric>	 hahaha
[00:46:27] <milimetric>	 dannyh> ebernhardson milimetric please tell Nuria that I love it and it gives me flashbacks to the heady days of Aug 30 - Sept 6 when we were popular
[00:46:49] <ori>	 oooh can i see?
[00:48:39] <ebernhardson>	 ori: http://flow-reportcard.wmflabs.org/
[00:49:39] <ori>	 oh, cool
[00:51:59] <ebernhardson>	 thats just db queries, also putting together some event logging stuff for UI
[01:49:59] <grrrit-wm>	 (PS1) CSteipp: Assert lengths aren't negative [analytics/kafkatee] - https://gerrit.wikimedia.org/r/177152
[10:38:12] <wikibugs>	 Analytics-EventLogging: EventLogging: Add helper for logging link clicks - https://phabricator.wikimedia.org/T54287#806366 (Prtksxna)
[11:24:32] <rtnpro>	 YuviPanda, Hi
[11:24:39] <rtnpro>	 YuviPanda, what's up?
[12:50:27] <wikibugs>	 Analytics-Tech-community-metrics: Automate creating charts from Bugzilla Weekly Report - https://phabricator.wikimedia.org/T51744#806883 (zeljkofilipin)
[13:36:46] <wikibugs>	 Analytics-Tech-community-metrics: Key performance indicator: Bugzilla response time - https://phabricator.wikimedia.org/T63561#807103 (Nemo_bis)
[13:40:28] <wikibugs>	 Analytics-Tech-community-metrics, Phabricator, Phabricator.org: Metrics for key Wikimedia projects software in Maniphest - https://phabricator.wikimedia.org/T28#807124 (Nemo_bis)
[13:44:06] <wikibugs>	 Analytics-Tech-community-metrics: Bugzilla ticket with recent comments listed under "Longest time without comment" on bugzilla_response_time.html - https://phabricator.wikimedia.org/T66373#807132 (Nemo_bis) Open>declined a:Nemo_bis > This bug is related to issues that shift from a component to anothe...
[13:44:22] <grrrit-wm>	 (CR) Gilles: [C: 2] Update schema versions [analytics/multimedia] - https://gerrit.wikimedia.org/r/176944 (owner: Gilles)
[13:44:31] <grrrit-wm>	 (Merged) jenkins-bot: Update schema versions [analytics/multimedia] - https://gerrit.wikimedia.org/r/176944 (owner: Gilles)
[13:48:45] <wikibugs>	 Engineering-Community, Analytics-Tech-community-metrics, Phabricator: Monthly report of total / active Phabricator users - https://phabricator.wikimedia.org/T1003#807146 (Nemo_bis)
[13:49:39] <wikibugs>	 Engineering-Community, Analytics-Tech-community-metrics: Monthly report of total / active Phabricator users - https://phabricator.wikimedia.org/T1003#807147 (Nemo_bis)
[13:49:54] <YuviPanda>	 rtnpro: heya!
[14:00:11] <wikibugs>	 Engineering-Community, Analytics-Tech-community-metrics, Phabricator: Monthly report of total / active Phabricator users - https://phabricator.wikimedia.org/T1003#807158 (Aklapper)
[14:44:20] <grrrit-wm>	 (PS1) QChris: Drop Oozie bundle for Icinga monitoring of webrequest datasets [analytics/refinery] - https://gerrit.wikimedia.org/r/177217
[14:46:25] <grrrit-wm>	 (PS1) QChris: Ignore dia backup files for diagrams [analytics/refinery] - https://gerrit.wikimedia.org/r/177220
[14:52:31] <grrrit-wm>	 (PS1) QChris: Ignore traffic from cache-local SSL terminators [analytics/refinery] - https://gerrit.wikimedia.org/r/177224
[14:55:57] <wikibugs>	 Engineering-Community, Analytics-Tech-community-metrics, Phabricator: Monthly report of total / active Phabricator users - https://phabricator.wikimedia.org/T1003#807261 (Aklapper) Note to myself: Add another query for "shell requests closed in last month" for Guillaume as the UI does not offer that and add G...
[15:21:45] <nuria__>	 YuviPanda: holaaa, have time for one question?
[15:21:49] <YuviPanda>	 nuria__: sure
[15:22:11] <nuria__>	 YuviPanda: we are thinking of moving wikimetrics to production
[15:22:18] <YuviPanda>	 oooh, nice
[15:22:30] <nuria__>	 YuviPanda: so here is when we ask for your wisdom
[15:23:07] <nuria__>	 and ask you to let us know (by looking at the packages) wether that would be a lot of work or medium work or nah
[15:23:14] <nuria__>	 *whether
[15:23:40] <nuria__>	 YuviPanda: let me paste the pkg list
[15:23:59] <YuviPanda>	 nuria__: sure!
[15:24:13] <nuria__>	 https://www.irccloud.com/pastebin/JxS3ywx0
[15:24:50] <YuviPanda>	 nuria__: yeah, all should be fairly easy to do, I think.
[15:24:56] <YuviPanda>	 nuria__: but I should ask, why production suddenly?
[15:25:00] <YuviPanda>	 nuria__: will it still hit labsdb?
[15:26:44] <nuria__>	 YuviPanda: labs db hasn't been able to run queries  (specially for enwiki) for a while now
[15:26:56] <nuria__>	 YuviPanda: we have seeveral metrics that just we cannot compute there
[15:26:58] <YuviPanda>	 oh, the replication issues?
[15:27:02] <YuviPanda>	 or is it just too big?
[15:27:04] <nuria__>	 YuviPanda: and perf
[15:27:12] <YuviPanda>	 right
[15:27:21] <nuria__>	 YuviPanda: both perf & replication (correctness)
[15:27:21] <YuviPanda>	 anyway, I'll be happy to help with packaging / puppetmunging to bring it to prod quality.
[15:29:03] <nuria__>	 YuviPanda: ok, we need to look at it in detail and will let you know, isn't redis going to be a problem?
[15:29:28] <YuviPanda>	 nuria__: why is redis going to be a problem?
[15:29:48] <nuria__>	 YuviPanda: i have no idea if debianizing that is easy or not
[15:30:22] <YuviPanda>	 nuria__: I also debianized a bunch of these for quarry, which is also running a celery with redis setup :)
[15:30:57] <nuria__>	 YuviPanda: all right then, we need to look at quarry's setup
[15:31:05] <nuria__>	 YuviPanda: what about security review?
[15:31:20] <YuviPanda>	 nuria__: yeaaah, that needs to go through chris.
[15:31:33] <YuviPanda>	 nuria__: however, debianizing / puppetmunging needn't wait on that, since it'll work the same in labs too.
[15:32:02] <qchris>	 One of these days, I'll get another nick. There are too many chris around and the pings get annoying :-)
[15:32:15] <YuviPanda>	 nuria__: so I think way to go is to figure out which packages actually need to be handbuilt - with trusty I suspect not a lot, and then see if any need security review
[15:32:20] <qchris>	 Mhmm... maybe ... even another name :-)
[15:32:32] <YuviPanda>	 qchris: hahaha :) sorry, for some reason you don't register as 'chris' in my head at all, just as 'queue-chris'
[15:32:38] <nuria__>	 YuviPanda: excellent!, we will task it tomorrow (after having looked at quarry's packages) and let you know
[15:32:52] <YuviPanda>	 nuria__: cool :) do tell me if you want help, etc.
[15:33:08] <nuria__>	 YuviPanda: will do, I am sure we could use your help
[15:33:30] <qchris>	 Maybe I'll just do what ^d is doing :-)
[15:48:39] <rtnpro>	 milimetric, Hi
[15:49:01] <rtnpro>	 milimetric, I am trying to follow the README at https://github.com/wikimedia/analytics-limn-mobile-data
[15:49:03] <milimetric>	 hi rtnpro - i'm in an interview atm, but talk in 45 min or so?
[15:49:24] <rtnpro>	 milimetric, ok
[16:36:08] <milimetric>	 hi rtnpro! sorry for the delay
[16:36:12] <milimetric>	 yes - the readme
[16:36:26] <rtnpro>	 milimetric, np
[16:37:19] <rtnpro>	 milimetric, I am trying to follow the steps for "Testing using local data"
[16:37:56] <rtnpro>	 milimetric, when I run, ./scripts/ssh, I get "ssh: connect to host stat1003.wikimedia.org port 22: Network is unreachable"
[16:37:57] <milimetric>	 rtnpro: sorry that doc is out of date too :(
[16:38:14] <milimetric>	 yeah, you would need access to stat1003 which you probably don't have, right?
[16:38:21] <milimetric>	 it's in our production cluster
[16:38:27] <milimetric>	 but that doesn't matter
[16:38:47] <rtnpro>	 milimetric, so, how do I get started?
[16:39:00] <rtnpro>	 milimetric, do you have some test db dump?
[16:39:53] <milimetric>	 well, so the sql that generate.py runs doesn't actually matter
[16:40:07] <milimetric>	 it's the responsibility of each team that's using this to make sure that SQL works
[16:40:41] <milimetric>	 for your purpose, you can mock the "execute_sql" functionality in some unit tests and make it return values or throw errors or whatever you need
[16:41:11] <rtnpro>	 milimetric, ok
[16:41:18] <milimetric>	 because what needs to get cleaned up is just the glue that reads the config.yaml file
[16:41:29] <milimetric>	 so - to get started maybe it's easier to think of it as a new project
[16:41:35] <milimetric>	 your input is a file like config.yaml
[16:41:54] <milimetric>	 and you have two outputs:
[16:42:14] <milimetric>	 1. a readable useful log (ebernhardson had some good ideas for integrating with logstash)
[16:42:35] <milimetric>	 2. datafiles that get generated by running SQL
[16:43:02] <milimetric>	 while it's true that you can't test it "for real", having some unit tests to make sure that glue works would be a *lot* better than where we are today
[16:43:39] <rtnpro>	 milimetric, I see
[16:44:25] <rtnpro>	 milimetric, I am going through the code, I will ping you if I have any query :)
[16:44:59] <milimetric>	 rtnpro: we all know this is not a small task, and really appreciate your interest in it.  It was my next priority so I can help with it as much as you need
[16:45:20] <rtnpro>	 milimetric, :)
[16:45:36] <rtnpro>	 milimetric, I will not be shy to ask for help
[16:45:43] <YuviPanda>	 milimetric: heard you're going to move wikimetrics to prod :)
[16:45:53] <milimetric>	 YuviPanda: now *how* in the world
[16:46:08] <burgerwednesday>	 milimetric: read scrollback :-)
[16:46:08] * milimetric runs to check his house for cameras
[16:46:18] <YuviPanda>	 burgerwednesday: you spoilt it.
[16:46:22] <ebernhardson>	 for the logstash stuff, as long as you use python logging(https://docs.python.org/2/library/logging.html) sending it on to logstash and our kibana instance for log discoverability is then just tacking on a handler library
[16:46:31] <milimetric>	 rtnpro: ^ logstash stuff
[16:47:04] <rtnpro>	 milimetric, acknowledged
[16:47:41] <rtnpro>	 ebernhardson, +1
[16:48:56] <ottomata>	 !log starting upgrade of analytics1027 to trusty, hive and oozie are offline for a bit
[16:49:17] <milimetric>	 YuviPanda: ok, read the backlog (yea yea i read slow)
[16:49:23] <YuviPanda>	 milimetric: :)
[16:49:29] <milimetric>	 yes, indeed.  performance + correctness
[17:14:54] <wikibugs>	 Analytics-Tech-community-metrics: Key performance indicator: Bugzilla response time - https://phabricator.wikimedia.org/T63561#807442 (Jdforrester-WMF) >>! In T63561#807103, @Nemo_bis wrote: >>>! In T63561#802548, @Jdforrester-WMF wrote: >> Should this be changed into a Phabricator-focussed metric? >  > Yes,...
[17:15:19] <wikibugs>	 Analytics: Move stat1002 and stat1003 into Analytics VLAN - https://phabricator.wikimedia.org/T76346#807446 (Ottomata)
[17:58:36] <wikibugs>	 Analytics: Upgrade Analytics Cluster to Trusty, and then to CDH 5.2 - https://phabricator.wikimedia.org/T1200#807619 (Ottomata) analytics1027 done.  Hue didn't work outright because it ships with its own virtual env at /usr/lib/hue/build/env.  I had to symlink /usr/lib/hue/build/env/bin/python2.7 -> /usr/lib/...
[18:00:36] <Ironholds>	 ottomata, do you remember what the thread about the hardware asks was called? I can't find it
[18:23:08] <ottomata>	 oh for stat1002!  ah i haven't responded about that, i meant to talk to toby about that in our 1:1 last week and forgot
[18:23:14] <ottomata>	 for new stat boxes*
[18:26:41] <Ironholds>	 ottomata, gotcha :). What's the discussion topic?
[18:26:53] <Ironholds>	 I have my 1:1 with him today and I'm happy to split five minutes out for us to talk it through if there are issues.
[19:08:38] <ottomata>	 Ironholds: found it:
[19:08:38] <ottomata>	 hardware requests for Analytics
[19:08:43] <Ironholds>	 ta
[19:08:51] <Ironholds>	 My 1:1 has been moved anyhoo
[19:15:39] <lzia>	 hi ottomata. do we have a documentation for webrequest table columns
[19:16:25] <ottomata>	 hm, you can do show create table webrequest;
[19:16:25] <ottomata>	 or
[19:16:29] <ottomata>	 describe webrequest;
[19:16:30] <ottomata>	 or
[19:16:50] <leila>	 yeah, did describe.
[19:16:52] <leila>	 thanks!
[19:17:18] <ottomata>	 ah, naw, that's it, cool!
[19:24:56] <travis-ci>	 wikimedia/mediawiki-extensions-EventLogging#287 (wmf/1.25wmf11 - 4f76f2a : Reedy): The build passed.
[19:24:56] <travis-ci>	 Change view : https://github.com/wikimedia/mediawiki-extensions-EventLogging/commit/4f76f2afb65d
[19:24:56] <travis-ci>	 Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-EventLogging/builds/42898775
[19:54:50] <leila>	 ottomata, when I'm searching for "human" from the searchbox in enwiki, will there be a log for every search recommendation I get as I type human in hadoop?
[19:55:23] <leila>	 or there will be one log and that's for the search query I finally press enter on, or choose from the drop down list?
[19:56:10] <ottomata>	 hm
[19:56:39] <ottomata>	 hmm
[19:56:41] <ottomata>	 i'm no tsure
[19:57:05] <leila>	 that's good. at least it wasn't an obvious question. ;p
[19:57:07] <ottomata>	 i think your search queries go to pybal and then are proxied to CirrusSearch somewhere, probably not to varnishes
[19:57:20] <ottomata>	 i really don't know
[19:57:23] <ottomata>	 you should ask ManyBubbles
[19:57:29] <ottomata>	 in #ops
[19:57:33] <leila>	 I will and will let you know
[20:13:54] <tnegrin>	 Ironholds: qq -- do you know what the definition of a country is in maxmind? I'm trying to come up with some basic stats and there seem to be 236 countries in the cube.
[20:14:41] <qchris_away>	 leila: Neither. You will get a request (in the wmf_raw.webrequests table) for each time the user pauses long enough while he is typing the search term (or hits enter)
[20:14:42] <Ironholds>	 tnegrin, anything with an ISO 3166-1 alpha-2 code.
[20:14:47] <Ironholds>	 hmn. They also have some special codes.
[20:14:58] <Ironholds>	 I can't recall off the top of my head if I filter those or not, in the C-based versions. Will check.
[20:15:09] <qchris_away>	 leila: So for example, If I want to do a search for "Berlin" and I type "Be" quickly, then pause.
[20:15:23] <qchris_away>	 leila: then type "rli" quickly then pause.
[20:15:29] <qchris_away>	 leila: then type n and hit enter.
[20:15:39] <qchris_away>	 You'll get "action=opensearch" requests for:
[20:15:42] <qchris_away>	 * Be
[20:15:44] <qchris_away>	 * Berli
[20:15:46] <qchris_away>	 * Berlin
[20:16:18] <qchris_away>	 (But the wmf_raw.webrequest table will only show the terms you search for, not the recommendations that got sent back)
[20:16:40] <leila>	 I see. now I understand qchris_away. thanks!
[20:16:49] <leila>	 do you know what long enough is?
[20:17:26] <qchris_away>	 No. I'd have to look that up. Manybubbles (and I guess also ^d) would know.
[20:17:37] <Ironholds>	 looks like the answer is "no".
[20:17:40] <Ironholds>	 grr. Will add that filter.
[20:20:36] <qchris_away>	 tnegrin: The definition of the used country codes is in
[20:20:38] <qchris_away>	 http://dev.maxmind.com/geoip/legacy/codes/iso3166/
[20:20:53] <leila>	 qchris_away: rethinking it. with your explanation, I think we're good. we have more information, and it's easy to figure out which one is the more complete one
[20:21:08] <qchris_away>	 tnegrin: Note the special ones like A1, A2, O1, EU and so on.
[20:21:21] <qchris_away>	 leila: Cool.
[20:22:34] <Ironholds>	 qchris_away, yeah, I'm excluding those.
[20:22:41] <tnegrin>	 qchris_away: thanks -- this explains it
[20:22:42] <Ironholds>	 but it looks like I historically didn't. Oop.
[20:22:56] <Ironholds>	 A quick vec.begin(),vec.end() find.
[20:23:01] <tnegrin>	 I'm using the 0.3 version of the cube
[20:24:06] <qchris_away>	 Ironholds: Excluding or not is of course your decision, but they do carry information. They have a FAQ somewhere about it.
[20:24:31] <qchris_away>	 There it is. http://dev.maxmind.com/faq/what-are-the-eu-europe-and-ap-asia-pacific-entries/
[20:24:35] <Ironholds>	 yeah, but not geolocateable information
[20:24:50] <Ironholds>	 well, not country-level-geolocateable.
[20:24:54] * Ironholds nods.
[20:25:49] <Ironholds>	 the Vatican has its own code. one day I want to use this data to write a blog post called "Filthy Habits: Internet Activity in the Catholic Church".
[20:26:01] <Ironholds>	 and get fired for both the privacy violation and the pun.
[20:26:09] <wikibugs>	 Analytics-EventLogging: Engineer reads documentation on Wikitech to set up a dashboard from EL data [3 pts] - https://phabricator.wikimedia.org/T76364#808376 (kevinator) Got feedback from Toby:  we need to include steps from the very beginning: I want to use event logging and "what's a schema?".
[20:27:25] <Ironholds>	 halfak, you just missed an epic pun.
[20:27:40] <qchris_away>	 That's exactly the reason why geocoding is ... meh. Instead of starting a rant, I guess I'll go eat something :-D
[20:27:46] <Ironholds>	 haha
[20:28:18] <halfak>	 Bummer.
[20:28:39] <Ironholds>	 *PUN ALERT* "the Vatican has its own ISO code. one day I want to use this data to write a blog post called "Filthy Habits: Internet Activity in the Catholic Church"." *PUN ALERT*
[20:28:48] <halfak>	 Just got done squashing.  Now trying to convince GroupLensers that the effects of performance changes on MediaWiki is interesting.
[20:30:53] <nuria__>	 halfak: for the hhvm experiment?
[20:30:54] * halfak doesn't see the pun. 
[20:30:57] <halfak>	 feels shame
[20:31:08] <halfak>	 nuria__, more generally, but I'll be talking about the HHVM experiment.
[20:31:21] <nuria__>	 halfak: boy, that is super interesting
[20:31:27] <Ironholds>	 halfak, filthy habits. habits.
[20:31:30] <nuria__>	 do we have a report on that?
[20:31:38] <halfak>	 OK I get it.
[20:32:09] <halfak>	 Ori and I have run two experiments.  We're deciding whether we think we have learned enough or if we should try something else.
[20:32:22] <halfak>	 I'm hoping to think better about what else to try over the next hour.
[20:32:29] <halfak>	 5 min to presentation start :)
[20:36:27] <Ironholds>	 aha
[21:14:15] <grrrit-wm>	 (CR) Ottomata: [C: 2] Ignore traffic from cache-local SSL terminators [analytics/webstatscollector] - https://gerrit.wikimedia.org/r/177101 (owner: QChris)
[21:15:34] <grrrit-wm>	 (PS1) Florianschmidtwelzow: Add data to UI-Daily [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/177318
[21:16:39] <grrrit-wm>	 (CR) Milimetric: [C: 2] Add data to UI-Daily [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/177318 (owner: Florianschmidtwelzow)
[21:16:46] <grrrit-wm>	 (Merged) jenkins-bot: Add data to UI-Daily [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/177318 (owner: Florianschmidtwelzow)
[21:34:37] <wikibugs>	 Wikimedia-General-or-Unknown, Analytics: Sudden drop in number of articles on nowiki on Nov29 (by 34k articles) - https://phabricator.wikimedia.org/T76356#808566 (greg) Definitely #Analytics
[21:34:41] <wikibugs>	 Wikimedia-General-or-Unknown, Analytics: Sudden drop in number of articles on nowiki on Nov29 (by 34k articles) - https://phabricator.wikimedia.org/T76356#808568 (greg)
[21:38:30] <wikibugs>	 Analytics-EventLogging: Engineer reads documentation on Wikitech to set up a dashboard from EL data [3 pts] - https://phabricator.wikimedia.org/T76364#808570 (ggellerman) Doc link: https://wikitech.wikimedia.org/wiki/Analytics/Dashboards#Support
[21:40:40] <milimetric>	 mforns: sorry it took so long!
[21:40:45] <milimetric>	 but! it looks great
[21:40:49] <milimetric>	 just rebase and I'll merge it
[21:40:55] <mforns>	 ok, thanks :]
[21:41:25] <milimetric>	 note: as part of the rebase, you would see a change to the DailyPageviews metric configuration (it has a breakdown now)
[21:41:30] <milimetric>	 I added that to the wiki page
[21:41:44] <mforns>	 aha
[21:41:49] <milimetric>	 btw - I think it's so kickass that this is wiki-driven now
[21:42:09] <mforns>	 yes it's nice!
[21:42:31] <mforns>	 onw thing though... I could not give the page the jsonSchema type
[21:43:26] <mforns>	 milimetric, the two config pages work, but when you browse them, they do not display nicely like Schema:EventCapsule does
[21:43:48] <mforns>	 but it seems I have no permits to set that page type
[21:43:58] <milimetric>	 mforns: no, that's not a page type
[21:44:06] <milimetric>	 it's a custom namespace
[21:44:09] <mforns>	 oh...
[21:44:19] <milimetric>	 so when EventLogging is installed, it registers "Schema" as a custom namespace
[21:44:27] <milimetric>	 with a JsonContentTypeHandler
[21:44:49] <milimetric>	 then when someone makes a page, if it starts with Schema: it gets put in that namespace
[21:44:57] <milimetric>	 in our case, the namespace Dashiki is not registered
[21:45:02] <mforns>	 ha
[21:45:11] <milimetric>	 but that's out of scope for this
[21:45:21] <mforns>	 well, should I change the way I did it?
[21:45:23] <milimetric>	 it works ok as is, and we can develop an extension at some point in the future if we want
[21:45:27] <milimetric>	 nono, it's fine
[21:45:30] <mforns>	 ok
[21:46:59] <mforns>	 btw milimetric, I need to go out for 40 minutes, is it ok if I rebase after that?
[21:47:17] <milimetric>	 mforns: no problem at all.  I'll be in one more meeting and then I'm gone
[21:47:27] <milimetric>	 feel free to self merge after you rebase - my +2 will be there
[21:47:37] <mforns>	 ok fine! see you tomorrow then
[21:48:05] <kevinator>	 mforns: I missed the link for the config page.  Can you paste it again?
[21:48:14] <kevinator>	 I want to see a config example :-)
[21:48:18] <mforns>	 of course
[21:48:32] <mforns>	 https://meta.wikimedia.org/wiki/Dashiki:CategorizedMetrics
[21:48:41] <mforns>	 https://meta.wikimedia.org/wiki/Dashiki:DefaultDashboard
[21:49:13] <kevinator>	 oooooooh… nice :_)
[21:49:15] <kevinator>	 :-)
[21:49:41] <mforns>	 ok!
[21:50:07] <mforns>	 kevinator, I need to be out for 40 mins
[21:50:15] <mforns>	 be right back
[21:50:16] <kevinator>	 ok ttyl
[22:01:17] <wikibugs>	 Analytics-EventLogging: Engineer reads documentation on Wikitech to set up a dashboard from EL data [3 pts] - https://phabricator.wikimedia.org/T76364#808612 (Milimetric) @kevinator and @tnegrin: steps from the very beginning seem out of scope.  This task talks about dashboarding once you have EL data.  Shoul...
[22:25:02] <wikibugs>	 Analytics-Engineering: Create new team project: "Analytics-Engineering" - https://phabricator.wikimedia.org/T75776#808645 (Qgil) Open>Resolved Turns out @kevinator had created #Analytics-Engineering already. Resolving.  PS: I have set the View policy to Public. Please remember this details when creating...
[22:30:45] <mforns>	 kevinator, I left kinda fast, did you have any question on the config pages?
[22:35:19] <milimetric>	 off for the night
[22:35:26] <milimetric>	 <3
[22:36:26] <Ironholds>	 take care
[22:40:41] <unicodesnowman>	 bye!
[22:40:46] <YuviPanda>	 milimetric: bye!
[22:45:12] <kevinator>	 mforns: well, I didn’t have more questions...
[22:45:19] <mforns>	 fine
[22:45:32] <kevinator>	 mforns: now I’m tempted to edit one of these pages and see what happens
[22:45:41] <mforns>	 hehe
[22:46:11] <mforns>	 well, the Dashiki version that reads that is not in production yet
[22:46:34] <mforns>	 but if it was, it would stop working as expected
[22:48:19] <kevinator>	 ahh, yes, forgot that the code wasn’t in production yet
[22:49:13] <kevinator>	 I won’t bother then testing an edit if I can’t see the impact
[22:51:10] <wikibugs>	 Analytics, Mobile-Web: Cannot permalink easily to a single graph - https://phabricator.wikimedia.org/T76670 (Jdlrobson) NEW p:Triage
[22:53:01] <wikibugs>	 Analytics-EventLogging, Mobile-Web: MobileWebClickTracking table is huge and thus querying too slow - https://phabricator.wikimedia.org/T76671#808707 (Jdlrobson)
[22:53:02] <mforns>	 :]
[22:57:32] <wikibugs>	 Engineering-Community, Analytics-Tech-community-metrics, Phabricator: Monthly report of total / active Phabricator users - https://phabricator.wikimedia.org/T1003#808728 (Aklapper) > Volume of tasks in the "shell" project resolved/fixed in last month, requested by Guillaume  Hmm, no, I can't https://phabricat...
[23:03:08] <wikibugs>	 Engineering-Community, Analytics-Tech-community-metrics, Phabricator: Monthly report of total / active Phabricator users - https://phabricator.wikimedia.org/T1003#808744 (mmodell)
[23:14:47] <grrrit-wm>	 (PS3) Mforns: Read configuration from mediawiki pages [analytics/dashiki] - https://gerrit.wikimedia.org/r/177005
[23:33:25] <kevinator>	 ggellerman____: Hi grace
[23:34:54] <Ironholds>	 ggellerman____ on IRC! Yay!
[23:35:10] <Ironholds>	 So, the Laws of Data Analysis has a new addition
[23:35:20] <Ironholds>	 it is "never trust any field in a request which the end user can modify"
[23:35:32] <Ironholds>	 do not trust referers. Do not trust x_forwarded_for. Do not trust user agent.
[23:35:39] <Ironholds>	 Trust the IP address, the URL, and that's it.
[23:38:57] <wikibugs>	 Analytics-EventLogging: Engineer reads documentation on Wikitech to set up a dashboard from EL data [3 pts] - https://phabricator.wikimedia.org/T76364#808826 (kevinator) I'll create a separate task for steps from the very beginning.  I spoke to the PM of the Collaboration team and some of the schemas they are...
[23:39:47] <leila>	 ottomata, do we keep the definition of columns in webrequest somewhere? if we don't, I'd like to start documenting it
[23:40:05] <leila>	 for example, where should I look if I want to know what's sequence
[23:41:38] <ottomata>	 i would like for comments to be on those columns
[23:41:43] <ottomata>	 but there is a bug in hive that is keeping them from sticking
[23:42:21] <leila>	 ah! I see the bug.https://issues.apache.org/jira/browse/HIVE-4703
[23:42:51] <ottomata>	 leila: i think it is documented somehwere
[23:42:53] <ottomata>	 qhcris knows
[23:42:55] <ottomata>	 i can't find it!
[23:43:01] <ottomata>	 i have to run
[23:43:02] <ottomata>	 ttyl!
[23:43:07] <leila>	 k, ttyl! :-)
[23:50:42] <wikibugs>	 Wikimedia-General-or-Unknown, Analytics: Sudden drop in number of articles on nowiki on Nov29 (by 34k articles) - https://phabricator.wikimedia.org/T76356#808842 (jeblad) This isn't a minor glitch, it is a title count for articles comparable to a //one year production// on nowiki. The loss in edits are about...
[23:52:37] <grrrit-wm>	 (CR) Bmansurov: Add support for timezones while creating reports (1 comment) [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/175169 (https://bugzilla.wikimedia.org/72116) (owner: Bmansurov)
[23:55:40] <wikibugs>	 Wikimedia-General-or-Unknown, Analytics: Sudden drop in number of articles on nowiki on Nov29 (by 34k articles) - https://phabricator.wikimedia.org/T76356#808853 (Ironholds)