[06:38:11] <grrrit-wm>	 (PS1) Gilles: Don't query tables that have only data older than 30 days [analytics/multimedia] - https://gerrit.wikimedia.org/r/139780
[13:57:50] <huh>	 Hi. Is anyone here?
[13:58:14] <qchris>	 Yes.
[13:58:26] <qchris>	 But team meeting is starting in 2 minutes.
[13:58:37] <qchris>	 So expect silence for some 15 minutes :-)
[14:00:05] <ottomata>	 trying to join..
[15:35:22] <Nemo_bis>	 nuria: "
[15:35:23] <Nemo_bis>	 The data we harvest from the NavigationTiming extension is segregated by country"
[15:35:35] <Nemo_bis>	 is it also on graphite, at country level?
[15:36:00] <nuria>	 on graphite...mmm.. not sure ... letme see
[15:36:52] <nuria>	 no, there are only rates/counts
[15:37:00] <nuria>	 on graphite per schema
[15:37:38] <nuria>	  Nemo_bis : that makes sense
[15:37:47] <nuria>	 as graphite is data mean for ops
[15:38:04] <Nemo_bis>	 yes, I mean rates/counts by country
[15:38:38] <Nemo_bis>	 I'm looking for *itwiki* metrics but I could only find enwiki, dewiki, ruwiki, frwiki, commons, eswiki IIRC
[15:38:55] <Nemo_bis>	 IT would be good enough if available
[15:44:08] <grrrit-wm>	 (PS1) Nuria: Making tests in wikimetrics more deterministic. [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/139852
[15:47:11] <grrrit-wm>	 (PS2) Nuria: 1st run of recurrent report is scheduled right away [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/138109 (https://bugzilla.wikimedia.org/66280)
[15:53:56] <nuria>	 Nemo_bis: no, there are only 'totals'
[15:53:59] <nuria>	 in graphite
[15:54:14] <nuria>	 'totals' per schema .. at least as far as i can see
[15:55:16] <grrrit-wm>	 (PS2) Nuria: Making tests in wikimetrics more deterministic. [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/139852
[15:56:00] <Nemo_bis>	 ok thanks
[15:56:10] <grrrit-wm>	 (PS3) Nuria: 1st run of recurrent report is scheduled right away [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/138109 (https://bugzilla.wikimedia.org/66280)
[16:05:12] <grrrit-wm>	 (PS4) Nuria: 1st run of recurrent report is scheduled right away [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/138109 (https://bugzilla.wikimedia.org/66280)
[16:22:30] <Gigs->	 Hi I was sent over here by ops.  I was looking through pageview stats to identify pages in userspace that were being abused for search rank, when I noticed an anomaly.
[16:22:39] <Gigs->	 User:Cunard is one of the top pages... on the entire site.  And it doesn't exist.  http://stats.grok.se/en/201406/User:Cunard
[16:22:54] <Gigs->	 I asked Cunard about this and it was news to him as well.  He has no idea.  He did find another non-existent userpage with high views though, User:The Philip72 ... This is all on EN
[16:23:40] <Gigs->	 We'd probably need someone to look in the squid log to see if these hits are real or give us a clue about what's causing this.
[16:38:34] <Ironholds>	 hey ottomata, guess whattomata?
[16:38:39] <ottomata>	 wha?
[16:38:54] <Ironholds>	 Gigs-, happy to take a look
[16:38:57] <Ironholds>	 ottomata, a query ran!
[16:39:02] <Ironholds>	 I have no idea why or how! :P
[16:39:13] <huh>	 Gigs-: the number one viewed page is ?search="محمد بقشان","	o.O
[16:39:15] <Ironholds>	 and it ran really really quickly and reasonably, too
[16:39:24] <ottomata>	 ha, like, very differently than before?
[16:39:42] <Ironholds>	 it completed so yeah. The query is very different and also it was over a specific date range.
[16:39:58] <ottomata>	 hm ok
[16:39:59] <ottomata>	 cool
[16:40:04] <Ironholds>	 So I'm going to test the hypotheses that either (1) the query is more efficient or (2) there's a piece of cruddy data somewhere that the longer query trips over
[16:40:19] <Ironholds>	 by, in both cases, running the same query over increasingly large ranges of data until it explodes
[16:40:23] <Ironholds>	 and then noting where it explodes and why
[16:40:57] <huh>	 http://stats.grok.se/en/201403/Special:Export/นางสาวมลิสา___สมรูป ... where is this coming from?
[16:41:35] <Ironholds>	 huh: ...huh.
[16:43:58] <ottomata>	 hm
[16:43:58] <huh>	 Gigs-: that's very strange. It must be from some bot or automated process.
[16:44:15] <Ironholds>	 both of them, yeah
[16:44:36] <Ironholds>	 I am going to set a hadoop query running looking for User:Cunard, and we will see what we will see.
[16:47:01] <huh>	 compare http://stats.grok.se/en/201212/User:Cunard and http://stats.grok.se/en/201301/User:Cunard huge difference...
[16:48:34] <Ironholds>	 yup
[16:49:12] <Ironholds>	 okay, query running :)
[16:55:18] <grrrit-wm>	 (PS1) Erik Zachte: 2004Q1 added to Global North share of views/edits [analytics/wikistats] - https://gerrit.wikimedia.org/r/139865
[16:59:59] <Ironholds>	 Gigs-, got an email address you can PM me for if/when this runs? It might take some time
[17:00:05] <Ironholds>	 huh, if you're interested in what we can find out, ditto
[17:00:44] <huh>	 I'm interested.
[17:57:35] <Gigs->	 Ironholds: gigstaggart@gmail.com
[17:58:35] <Ironholds>	 Gigs-, ta :)
[19:08:37] <grrrit-wm>	 (PS1) QChris: Upgrade used MobileWebEditing schema to current one [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/139889
[19:09:47] <grrrit-wm>	 (CR) QChris: "Not sure when you want to switch over." [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/139889 (owner: QChris)
[19:21:09] <grrrit-wm>	 (CR) Milimetric: [C: -1] Making tests in wikimetrics more deterministic. (10 comments) [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/139852 (owner: Nuria)
[19:24:15] <grrrit-wm>	 (CR) Milimetric: 1st run of recurrent report is scheduled right away (2 comments) [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/138109 (https://bugzilla.wikimedia.org/66280) (owner: Nuria)
[19:39:29] <travis-ci>	 [travis-ci] wikimedia/mediawiki-extensions-EventLogging#217 (master - b4b42ef : jenkins-bot): The build has errored.
[19:39:29] <travis-ci>	 [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-EventLogging/compare/e4b68b1399ad...b4b42effc615
[19:39:29] <travis-ci>	 [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-EventLogging/builds/27711174
[20:42:53] <qchris>	 nuria: Thanks for merging the EventLogging change, but since I am still seeing the GeoIP= events ... did you deploy the change
[20:42:56] <qchris>	 to vanadium?
[20:43:32] <ori>	 qchris: would you like me to deploy?
[20:43:49] <qchris>	 That would be great :-D
[20:43:54] * ori does
[20:43:58] <qchris>	 Wohooo \o/
[20:46:26] <ori>	 qchris: done
[20:46:32] <qchris>	 Thanks ori!
[20:46:44] <ori>	 thank you for all the work, i hope to be caught up soon
[20:46:59] <ori>	 i know i've neglected to reply to some queries
[20:47:25] <qchris>	 Not from me.
[20:47:40] <qchris>	 You responded to all my queries  :-D
[20:47:45] <ori>	 ok cool :)
[20:47:56] <qchris>	 Thanks for your help around the geoip issues.
[20:48:20] <ori>	 np at all
[20:48:41] <qchris>	 btw ... did you see my resetting of the GeoIP value on CentralNotice.
[20:48:52] <qchris>	 I wanted to ask you about it ... but it got merged too quickly.
[20:49:04] <qchris>	 Do you think that is harmless, or might that fire back
[20:49:15] <qchris>	 (I know too little about impact of such things on our servers)
[20:49:37] <qchris>	 https://gerrit.wikimedia.org/r/#/c/139357/
[20:56:15] <mwalker>	 qchris, I think it's mostly harmless
[20:56:51] <qchris>	 Soooooo many people reading in this channel these days :-D
[20:56:56] <qchris>	 Thanks mwalker.
[21:41:15] <travis-ci>	 [travis-ci] wikimedia/mediawiki-extensions-EventLogging#218 (master - 3012aad : Christian Aistleitner): The build passed.
[21:41:16] <travis-ci>	 [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-EventLogging/compare/b4b42effc615...3012aadd62e4
[21:41:16] <travis-ci>	 [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-EventLogging/builds/27721333