[01:46:38] New patchset: Rfaulk; "mod. (bz 48341) remove 'ban' field add 'is_blocked' (bool)." [analytics/user-metrics] (master) - https://gerrit.wikimedia.org/r/70117 [01:46:58] Change merged: Rfaulk; [analytics/user-metrics] (master) - https://gerrit.wikimedia.org/r/70117 [09:19:54] New patchset: Rfaulk; "mod. (bz 48341) modify datatype indices and rate aggregator value index." [analytics/user-metrics] (master) - https://gerrit.wikimedia.org/r/70129 [09:20:13] Change merged: Rfaulk; [analytics/user-metrics] (master) - https://gerrit.wikimedia.org/r/70129 [11:53:47] morning [12:44:44] New patchset: Stefan.petrea; "test" [analytics/wikistats] (master) - https://gerrit.wikimedia.org/r/70153 [12:46:09] New patchset: Stefan.petrea; "Changed start of processing for new mobile" [analytics/wikistats] (master) - https://gerrit.wikimedia.org/r/70153 [13:00:06] Change merged: Stefan.petrea; [analytics/wikistats] (master) - https://gerrit.wikimedia.org/r/70153 [13:29:48] New patchset: Stefan.petrea; "Removed obsolete links" [analytics/wikistats] (master) - https://gerrit.wikimedia.org/r/70158 [13:31:17] Change merged: Stefan.petrea; [analytics/wikistats] (master) - https://gerrit.wikimedia.org/r/70158 [14:57:10] hihaaaaaaaa [14:57:17] ottomata in tha house? [14:57:25] yoyooyoooo [14:57:25] milimetric in thaaa house??? [14:57:31] I AM IN THAA AHOUUUUSE [14:57:36] ALLLRIGHT [14:57:40] LET"S KICK IT [14:57:53] aite, kick it dr dee [14:58:31] yo we are one team, [14:58:34] focused like a beam [14:58:51] counting through the days [14:58:54] in many ways [15:03:18] milimetric what's the name of the balsamic component that you showed me on friday that does the tab thing for metric parameters? [15:03:43] oh nice rhyme above [15:03:51] cool, this day's getting off to a good start [15:03:59] it's just in the containers tab [15:04:11] vertical tabs or something like that? [15:05:14] k [15:05:20] got it [15:05:42] cool, not sure if we'll do it exactly that way, but it'll be good for the mockup [15:11:11] i am working on the mockup right now [15:11:27] i have a solution for the time series data btw [15:14:36] milimetric: we should make a doc with parameters per metric, do we already have such a doc? [15:15:09] nope [15:15:15] but i would disagree [15:15:27] we should iterate on this [15:15:39] start out with something that seems logical, and add parameters as we find them [15:15:58] sure we should iterate but we can already take the params from umapi v1, right? [15:15:58] because it seems to me that the parameters were designed before the requirements [15:16:09] that's what i'm not sure about [15:16:20] whether or not those parameters were meeting a requirement [15:16:37] but if Dario needs them, he'll just say - migrate as is [15:16:38] and we'll do that [15:16:53] for the first two metrics, it's pretty easy [15:17:08] (Just namespace edits and bytes added) [15:33:57] milimetric, batcave? [15:34:03] omw [15:38:16] drdee hiya, any word on the zero country thing? you just needed to upload the new kraken jars, right? [15:38:28] can do that in a sec [16:00:31] ottomata: https://plus.google.com/hangouts/_/2763caa5549d08d05417702af2d1bfa572601d0a [16:00:34] varnishkafka [16:00:42] oop [16:00:42] cpoming [16:08:18] New patchset: Milimetric; "fixed re-routing after login and string concat problem" [analytics/wikimetrics] (master) - https://gerrit.wikimedia.org/r/70193 [16:08:38] Change merged: Milimetric; [analytics/wikimetrics] (master) - https://gerrit.wikimedia.org/r/70193 [16:55:09] milimetric, what was maryana's card regarding commons stuff? [16:55:43] 775 off the top of my head [16:55:59] nope [16:56:35] 774 drdee [16:56:36] so close [16:56:42] thx [16:58:42] are you sure? that's about cross wiki edits [17:12:16] New patchset: Milimetric; "fixed metrics test to fail" [analytics/wikimetrics] (master) - https://gerrit.wikimedia.org/r/70211 [17:12:31] Change merged: Milimetric; [analytics/wikimetrics] (master) - https://gerrit.wikimedia.org/r/70211 [17:31:20] rounce123, tnegrin: https://plus.google.com/hangouts/_/b4a3abe3625563b41964c8f613c20522c49aceb1 [18:15:24] New patchset: Erosen; "fixes tests which require logging in" [analytics/wikimetrics] (master) - https://gerrit.wikimedia.org/r/70220 [18:19:37] Change merged: Erosen; [analytics/wikimetrics] (master) - https://gerrit.wikimedia.org/r/70220 [18:21:53] drdee, i'm not sure why (looking into it) [18:21:54] but i'm getting [18:21:57] Error Message : UndeclaredThrowableException: null [18:22:02] when I try to run zero country [18:22:34] no logs :/ [18:22:48] grumble [18:31:15] drdee [18:31:16] 2013-06-24 18:31:08,550 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1200: Expected (chararray), input does not have 7 fields [18:31:16] Details at logfile: /home/otto/scr/pig/pig_1372098664792.log [18:31:41] ohhhhh you are giving the wrong input [18:34:00] i thought i had pushed an updated pig script [18:37:11] i've got the latest [18:44:04] which machine is the log file? [18:44:26] and which pig script did you use? (where can i find it)? [18:49:55] hey rounce123, I see tnegrin isn't in IRC [18:50:24] if he's having trouble with that, let him know how you set it up [18:50:35] Think he is in meetings now [18:50:41] will check with him [18:52:06] ottomata: ^^ [18:54:17] drdee, oozie just failed without giving the error, so I ran like this: [18:55:22] .... [18:55:49] pig -f /opt/kraken/pig/zero_country.pig -p input=/wmf/raw/webrequest/webrequest-wikipedia-mobile/dt=2013-06-01_* -p output=tmp/zero_country_outA -p date_regex_format=2013-06-01 [18:55:53] on an02 [18:57:57] where are you getting the jars from? [18:58:11] it seems like an old jar [18:58:49] ottomata: ^^ [18:59:36] HMMMMmmMoops yeah sorry, i had just run it in my homedir thikning it would pull out of /libs... [18:59:36] sorry [18:59:39] thanks [18:59:40] lemme try again [19:03:59] yargh, is this my fault too drdee? [19:04:07] 2013-06-24 19:02:16,514 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1200: could not instantiate 'org.wikimedia.analytics.kraken.pig.GeoIpLookupEvalFunc' with arguments '[countryCode, GeoIPCity]' [19:04:07] what? [19:04:17] i've got the geoip.jar [19:04:18] gr [19:04:21] geoip-1.2.9-patch-2-SNAPSHOT.jar [19:04:23] right? [19:04:24] yes, that used to work all the time [19:04:45] ok still looking [19:09:36] milimetric: pull from wikimetrics ;) [19:09:51] k [19:10:23] very cool, but i'll need my windows compy to open them i think [19:11:18] k [19:14:35] erosen, sorry, i'm still trying to get zero country running, hopefully will have time to brainbounce soon, i'm going to take a 15 min power nap and get some coffee, brb [19:49:02] ohhh drdee!!! [19:49:09] yoooo [19:49:15] i just noticed you took out the date_bucket_regex usage out of zero_carrier.pig [19:49:27] did I? [19:49:29] yeah [19:49:43] at least [19:49:44] its not there anymore [19:51:02] or maybe it was never there? [19:51:03] looking... [19:52:23] it probably was there [19:54:14] yeah [19:54:18] drdee, most recent commit [19:54:23] Wed Jun 19 17:53:40 2013 -0700 [19:54:23] Updated Zero Carrier pig script with new business logic. [19:54:26] sorrrrryyyyy [19:54:27] - AND (DATE_BUCKET(timestamp) MATCHES '$date_bucket_regex') [19:54:39] s'ok, gotta re run carrier :):/ [19:56:12] :( [19:56:21] but is the zero_country script now working? [19:56:53] no [19:56:59] dunno what's wrong with that yet [19:57:02] i was comparing the two and just found that [19:57:11] on what machine are you doing your testing? [19:57:24] ottomata: drdee: let me know as soon as there is a minimally testable file so that I can let Amit take a look [19:57:25] an02 [19:57:39] yup, where are the jars that you use? [19:57:42] a few days of carrier only would be fine [19:57:55] /home/otto/scr/pig [19:58:04] i got them out of hdfs /libs/kraken-0.0.2 [19:58:17] the geo stuff should really work [19:58:19] erosen, i'm going to rerun carrier again, should be a few hours to get it caught up to today [19:58:19] yeah [19:58:24] i think so too [19:58:30] we haven't touch that in ages [19:58:39] i think i'm doing something wrong there, but that's just because i'm trying to isolate the problem [19:58:42] since oozie isn't tellin gme [20:00:16] also, drdee [20:00:24] carrier is currently using ZERO_PAGEVIEW [20:00:33] DEFINE ZERO_PAGEVIEW org.wikimedia.analytics.kraken.pig.ZeroFilterFunc('default'); [20:00:36] and country is using [20:00:46] IS_PAGEVIEW [20:00:46] DEFINE IS_PAGEVIEW org.wikimedia.analytics.kraken.pig.PageViewFilterFunc(); [20:00:48] is that ok? [20:01:21] yes ZERO_PAGEVIEW is a misleading function name [20:01:45] it should be something like IS_ZERO_CARRIER [20:01:55] you can change that if you wan [20:01:56] t [20:03:20] milimetric: tell me what you think about this when you get a sec: https://flask-restless.readthedocs.org/en/latest/ [20:03:30] yeah, i read it [20:03:34] gotcha [20:03:35] not necessary [20:03:38] what is your take? [20:03:45] k [20:04:54] ok, drdee, that's fine [20:05:05] but, it is ok that the two different metrics are filtering by different thigns? [20:05:17] country just uses IS_PAGEViEW [20:05:26] my guidance has been "go as simple and old-school as possible unless there's a huge benefit" [20:05:26] I liked restless though, it was cool. Thing is, we aren't actually creating a REST api [20:05:42] we're just using REST convention when creating our api :) [20:06:01] hmm [20:06:29] just to humor me, why is our API not RESTful? [20:06:31] actually, drdee, as I'm reading zero_country.pig, we're not even filtering for X-analytics header, which is what we used to do [20:07:29] org.wikimedia.analytics.kraken.pig.ZeroFilterFunc('default'); is a filter function so we are filtering [20:07:44] that's not being used in zero_country.pig [20:07:52] only in zero_carrier.pig [20:08:03] right but we don't need to filter in zero_country [20:08:11] ah this is my question [20:08:18] we just need to know the total number of page views in that country to the mobile site [20:08:53] hm, ok, i kinda think that assuming that the input data is all mobile pageviews is a little naive, even though it is true of our data right now [20:09:05] but ok [20:09:38] (didn't mean naive in a mean sense, just that the script won't work when we start importing more data) [20:10:04] sure but that will be a new card :D [20:10:07] ok [20:13:57] need help with geocoding? [20:14:57] maybe, i'm not sure if that is the problem, see if you can run the pig script with the same parameters I gave you [20:15:02] zero_country.pig [20:15:07] in your own homedir or whatever [20:18:18] ah, HM [20:18:34] drdee, i'm getting the exact same exception from zero_carrier now that I am resubmitting it [20:18:40] so this is not just a zero_country problem [20:18:42] HMMmm [20:19:05] well i have been running these scripts for days :) [20:19:19] yeah i think something bigger is wrong... [20:19:21] not sure what yet [20:20:45] what is the error log? [20:21:01] Error Message : UndeclaredThrowableException: null [20:21:03] that's all I ahve [20:21:21] the job doesn't make it to hadoop resourcemanager [20:21:23] pretty sure [20:21:29] i don't have a link,a nd I don't see it in the jobs queue [20:21:39] but oozie accepts it just fine [20:21:39] hm [20:29:28] found more more info, but i'm still confused [20:30:08] Caused by: java.net.ConnectException: Call From analytics1027/10.64.36.127 to analytics1010.eqiad.wmnet:10020 failed on connection exception: java.net.ConnectException: Connection refused; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused [20:30:17] hmm [20:30:30] OH [20:30:32] historyserver is down [20:30:33] wha? [20:32:04] was history server running on an20? [20:34:17] no [20:34:18] an10 [20:34:51] i'll be happy when I get all of the hadoop nodes reinstalled and can do that monitoring card better, eh? [20:37:39] aight [20:46:06] yay country works! [20:46:14] doh, sorry that took so long to figure out :/ [20:48:36] drdee, still some IPs in the country output, but i guess it doesn't really matter? [20:48:42] http://localhost:8888/filebrowser/view//wmf/public/webrequest/mobile/zero/country/zero_country-daily.tsv [20:49:00] mmmmmm it's okay for now [20:49:03] we can clean that up late [20:49:04] r [20:59:51] k [21:26:37] phew, ok, carrier and country both going now [21:32:21] ottomata: awesome! [21:32:25] when can erosen check? [21:32:31] in a few hours [21:32:34] sounds good [21:33:59] milimetric: how do the mockups look? [21:34:13] i haven't looked yet - buried in design [21:34:23] and i figured i'd just be depressed if i looked and saw how much more there is to do :) [21:35:36] ottomata: icinga-wm: PROBLEM - Disk space on analytics1018 is CRITICAL: DISK CRITICAL - free space: / 639 MB (2% inode=95%): [21:40:42] New patchset: Milimetric; "job create rough draft at /jobs/create" [analytics/wikimetrics] (master) - https://gerrit.wikimedia.org/r/70326 [21:40:55] Change merged: Milimetric; [analytics/wikimetrics] (master) - https://gerrit.wikimedia.org/r/70326 [21:41:20] drdee: you can pull, and check it out like this: [21:41:21] HMMMM [21:41:23] sudo pip install -e . [21:41:27] wikimetrics web [21:41:33] navigate to /jobs/create [21:41:40] AGHHHH [21:41:41] (click google and accept to login) [21:41:42] oops [21:41:47] what's up ottomata [21:41:53] k, gonna run now :) [21:41:56] laters yall [21:41:59] laterz [21:41:59] i didn't check on my disk format script well [21:42:00] erosen: see above too [21:42:03] when I brought an18 back up [21:42:11] partitions were created, but not mounted [21:42:14] can fix [21:42:17] k [21:43:59] milimetric: one sec, figuring out a 2011 tax issue [22:21:40] laters all!