[07:00:00] (03PS2) 10Joal: Update mediawiki history related tables [analytics/refinery] - 10https://gerrit.wikimedia.org/r/361500 (https://phabricator.wikimedia.org/T161147) [07:00:06] git br [07:02:35] (03PS11) 10Joal: Add sampled-webrequest druid loading oozie jobs [analytics/refinery] - 10https://gerrit.wikimedia.org/r/355598 (https://phabricator.wikimedia.org/T166967) [07:03:56] (03CR) 10Joal: "I corrected a last gotcha in hourly/daily scheduling (better to run daily after some delay to prevent hour and day being loaded conjointly" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/355598 (https://phabricator.wikimedia.org/T166967) (owner: 10Joal) [07:14:57] !log Rerun wikidata-articleplaceholder_metrics-wf-2017-6-26 [07:14:58] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [07:46:33] 10Analytics, 10EventBus, 10Wikimedia-Stream, 10Patch-For-Review, 10Services (watching): Expose revision-create in EventStreams - https://phabricator.wikimedia.org/T167670#3381284 (10akosiaris) I 've commented on the change already. [07:55:00] 10Analytics, 10Operations, 10ops-eqiad: Smartctl errors for one kafka1012 disk - https://phabricator.wikimedia.org/T168927#3381297 (10elukey) [07:57:00] kafka1012 has a disk that will likely break in a bit :) [08:05:10] elukey: Hi ! How should we handle that ? [08:05:24] elukey: remove machine from cluster, fix, then back? [08:07:52] joal: o/ - I opened a task to swap the disk, I think that we can wait and see what will happen.. worst case scenario kafka on kafka1012 stops for IO errors [08:08:18] last time that happened we managed to swap the disk before the breakage (that might even not happen) [08:08:45] k elukey - Hot swap? [08:10:26] joal: nope, we'll need to shutoff kafka1012 [08:10:41] k makes sense elukey :) [08:10:42] swap the disk, re-create the partition etc.. [08:10:47] right [08:11:58] 10Analytics-Kanban: Add time_to_user_next_edit and time_to_page_next_edit in Mediawiki Denormalized History - https://phabricator.wikimedia.org/T161896#3381352 (10JAllemandou) a:03JAllemandou [08:16:25] 10Analytics: Provide historical redirect flag in Data Lake edit data - https://phabricator.wikimedia.org/T161146#3122912 (10JAllemandou) XML dumps loading and preprocessing has been tested, it works. Then text parsing works as well. However there still are some issues, with biggest being: the #REDIRECT command i... [09:06:51] elukey: Eya [09:07:00] elukey: I'd need a sudo hand please [09:07:26] sure [09:08:04] elukey: our maven conf is a bit rusty, and it misses commons-lang in lib :( [09:08:30] So on stat1004: cd /usr/share/maven/lib/ [09:09:11] sudo ln -s ../../java/commons-lang-2.6.jar . [09:09:26] elukey: I'm trying to build slider [09:09:56] mmmm sounds a bit of a hack no? [09:10:52] elukey: there are plenty links in that lib folder, so yeah, sounds like a hack, but I have no better solution :( [09:13:08] I mean, what does it take to put commons-lang in there? [09:13:38] elukey: not sure about your question [09:14:54] you'd like to see a link or library for commons-lang in maven/lib right? [09:15:12] if so I'd prefer to find the correct (puppet?) way to do it [09:15:17] rather than placing a link in there [09:15:23] correct elukey - I have a failure in my build due to that lib no being present [09:15:35] Ah, ok :) [09:15:56] elukey: I think having a link is the correct way to do it, but please do it with puppet :) [09:16:58] I am not sure it is, let me check on the host [09:17:05] please [09:20:46] so maven on stat1004 should be a mirror of archiva right? [09:21:17] elukey: hm, not sure what you mean [09:22:30] I am fairly ignorant about the whole maven/archiva settings [09:22:44] but on puppet maven's settings.xml says mirror of archiva [09:23:04] elukey: AFAIU archiva is a repo for jars, and maven is a build software that uses it [09:23:58] elukey: there is a deb package for maven, and I think that's what we have, since version is old and the same on my computer [09:24:15] elukey: However, this deb version misses the commons-lang jar in the lib folder [09:24:38] elukey: and this problem is not related to maven using jars from archiv [09:25:11] ah ok so those jars are not from archiva but bundled with maven itself [09:25:21] okok now the picture is clearer [09:25:26] :) [09:25:43] the jars in /usr/share/maven/lib are actually the ones used by maven to work [09:26:42] so commons-lang might be in some debian package [09:27:05] elukey: probably so - it actually is already there on stat1004 [09:29:16] elukey@stat1004:/usr/share/maven/lib$ dpkg -S /usr/share/java/commons-lang-2.6.jar [09:29:19] libcommons-lang-java: /usr/share/java/commons-lang-2.6.jar [09:38:26] (running alters with manuel for EL, a bit lagged) [09:40:40] joal: another ignorant question to understand - shouldn't the commons-lang dependency specified in the pom.xml of the project that it is going to be built? [09:40:56] elukey: it is, I triple checked [09:41:18] elukey: I even added the deplendency in the module dependency configuration [09:43:58] joal: because my understanding was that maven polls dependencies from a repo, that in our case is archiva.. this is why I asked if commons-lang should be in there [09:44:29] elukey: problem is not in getting dependencies for a project, but for a module itself [09:44:44] ah slider is a module [09:44:46] of maven? [09:45:21] elukey: the project I'm trying to build uses maven-site-plugin, that needs commons-lang - But specifying it as a dependency in the project, and even in the plugin dependency doesn't do [09:47:59] elukey: makes sense? [09:49:52] I am really ignorant about maven so I can't really say :( [09:50:09] what is the exact error that you see ? [09:50:23] (I promise I'll do the hack if we don't find a good solution) [09:50:58] elukey: go to: /home/joal/code/apache-slider-0.92.0-incubating on stat1004 [09:51:15] And try: mvn -X clean site:site site:stage package -DskipTests [09:51:19] the -X is for debug [09:56:17] apt-cache policy maven shows that https://packages.debian.org/jessie-backports/maven is available [09:56:29] and in its deps it seems that commons something is there [09:57:14] elukey: let's triple check - plenty commons other than lang [10:00:36] I ran mvn -X dependency:analyze and it seems that it doesn't complain about commons-lang [10:02:18] ahahahh https://wiki.apache.org/commons/VfsProblems [10:02:45] so this is a bug of maven [10:02:46] :) [10:02:54] * elukey is sda [10:02:57] (sad [10:03:06] elukey: I'm happy the solution offered looks correct though :( [10:05:25] yeah but it feels a bit of a hack, I didn't doubt that it wasn't working but it makes my ops soul cry a bit [10:05:31] anyhow, hack made, can you test it :) ? [10:05:41] I can test [10:05:57] elukey: We could enable that hack using puppet, that'd make sense no? [10:05:57] !log added https://wiki.apache.org/commons/VfsProblems to stat1004 [10:05:58] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [10:06:10] joal: I'd prefer to upgrade maven if possible [10:06:17] makes sense elukey [10:06:28] elukey: looks like it works so far [10:06:38] sorry for the lag, just wanted to make sure to understand the issue [10:06:41] elukey: Waiting for the compile to finish [10:06:46] no prob elukey :) [10:07:17] elukey: dependency management stuff are hard - Does it fail because of dependency issue, or inner dependency issue, or whatever else [10:08:56] Success elukey :) [10:08:58] Thanks a lot [10:09:27] 10Analytics-Kanban: Add a job that regularly deletes druid webrequest deep-stored data - https://phabricator.wikimedia.org/T168614#3381673 (10JAllemandou) a:03JAllemandou [10:09:57] 10Analytics-Kanban: Data Lake queries abort with HDFS write fail - https://phabricator.wikimedia.org/T168497#3381677 (10JAllemandou) No answer, merging. [10:10:29] 10Analytics-Kanban: Data Lake queries abort with HDFS write fail - https://phabricator.wikimedia.org/T168497#3381682 (10JAllemandou) [10:10:31] 10Analytics-Kanban, 10Patch-For-Review: Provide cumulative edit count in Data Lake edit data - https://phabricator.wikimedia.org/T161147#3122928 (10JAllemandou) [10:11:35] joal: good :) Let's talk about updating maven then, so moar issues like this one will get fixed [10:11:47] sure elukey [11:35:56] (03PS1) 10Joal: Add script deleting druid deep storage data [analytics/refinery] - 10https://gerrit.wikimedia.org/r/361651 (https://phabricator.wikimedia.org/T168614) [11:37:44] 10Analytics-Kanban, 10Patch-For-Review: Add a job that regularly deletes druid webrequest deep-stored data - https://phabricator.wikimedia.org/T168614#3381823 (10JAllemandou) First version of a python script deleting data (tested, obviously). After CR and when deployed, let's not forget to automate it for webr... [11:38:16] 10Analytics-Kanban, 10Patch-For-Review: Add a job that regularly deletes druid webrequest deep-stored data - https://phabricator.wikimedia.org/T168614#3381824 (10JAllemandou) [11:39:47] taking a break a-team, later [11:43:43] (03PS2) 10Joal: Add script deleting druid deep storage data [analytics/refinery] - 10https://gerrit.wikimedia.org/r/361651 (https://phabricator.wikimedia.org/T168614) [12:09:02] hey team :] [12:10:37] o/ [12:11:36] mforns: how are things going? Is your daughter feeling better? [12:11:59] hi elukey! no... she's feeling bad still [12:13:32] but yea, tomorrow she'll be better for sure [12:13:47] :) [12:14:12] I'm reviewing your EL changes [12:14:48] mforns: I forgot one thing, namely the extra check in the whitelist that needs to be removed [12:14:58] aha [12:15:04] I am also running alter tables with Manuel on db1047 and dbstore1002 [12:15:12] elukey, awesome! [12:15:15] some of them takes ~5mins to run on the big tables [12:15:17] :/ [12:15:42] elukey, that is ok no? as long as the other ones are quick... [12:16:12] sure, but it may take a while before completing all the tables :) [12:16:19] ok [12:16:22] plus we need to deploy the change to EL [12:16:25] yes [12:16:28] I'll do that [12:16:32] before standup [12:17:37] ..get up standup, don't give up the fight [12:17:38] :) [12:17:57] going afk for a bit, need to run errand [12:17:59] ttl! [12:18:04] (back in maximum 1 hour) [12:23:46] o/ [12:47:42] elukey, actually, the EL nullabe-making code is already in production, thanks ottomata for deploy [13:04:30] 10Analytics: Eventstreams graphite disk usage - https://phabricator.wikimedia.org/T160644#3382087 (10fgiunchedi) [13:05:55] 10Analytics-Kanban: Extraneous whitelist items for WikimediaBlogVisit schema - https://phabricator.wikimedia.org/T168475#3382094 (10mforns) Hi @Tbayer Thanks for looking into this! Yes, these fields come from an older version of the EL capsule. Let me see.. [13:22:11] Hmm, another Wiktionary jump? https://analytics.wikimedia.org/dashboards/vital-signs/#projects=enwikibooks,enwikiquote,enwikisource,enwikivoyage,enwiktionary/metrics=UniqueDevices [13:31:28] mforns: \o/ [13:31:33] elukey, helloooo [13:33:28] mforns: I am checking your comments.. I can add a better query but the one that I put returns the correct result now [13:34:11] it returns table with timestamp or event* or both [13:34:17] elukey, yes, aha [13:34:27] (there is one EL table without timestamp, not sure why :/) [13:34:38] I just was wondering if you did that on purpose, OK then! [13:34:47] elukey, really? [13:34:49] BUT yours seems more precise [13:34:49] which one? [13:35:04] I'll double check it and see [13:36:32] mforns: might have been wrong, not able to get the table again with [13:36:41] select table_name from information_schema.tables where table_schema = 'log' and table_name not in (SELECT table_name FROM information_schema.columns WHERE table_schema = 'log' and column_name = 'timestamp'); [13:36:53] (I get only mw tables) [13:37:12] my bad then [13:38:54] mforns: do you remember what was the check to remove for the whitelist? [13:39:13] IIRC it was to abort if some attributes were not in the schema [13:43:03] but I don't remember why it was not ok [13:43:05] :P [13:48:54] elukey, yes, as the white-list is schema-oriented (not schema_revision-oriented) [13:49:18] say, a schema A_1 has fields a, b, and c [13:49:23] yeeesssssssss [13:49:26] now I remember [13:49:33] and then, someone modifies A to include field d [13:49:45] so we have A_2 with a, b, c and d [13:49:47] ok ok [13:59:36] 10Analytics-Kanban: Extraneous whitelist items for WikimediaBlogVisit schema - https://phabricator.wikimedia.org/T168475#3382274 (10mforns) At the time of the white-list creation, I added those fields to it for WikimediaBlogVisit schema, because its purging policy mentioned keeping non-sensitive data indefinitel... [14:17:44] (03CR) 10Elukey: "Only some comments, but overall it seems gooooood!" (035 comments) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/361651 (https://phabricator.wikimedia.org/T168614) (owner: 10Joal) [14:32:06] MariaDB [log]> ALTER TABLE ChangesListFilters_16837986 MODIFY COLUMN wiki varbinary(1024) NULL; [14:32:10] Query OK, 5899316 rows affected (15 min 47.85 sec) [14:32:10] mforns: --^ [14:32:27] on db1047 :D :D [14:38:15] 10Analytics-Kanban, 10Analytics-Wikistats: Deploy new Wikistats to stats.wikimedia.org/v2 - https://phabricator.wikimedia.org/T167684#3382415 (10Milimetric) [14:38:20] 10Analytics-Kanban, 10Patch-For-Review, 10User-Elukey: Make non-nullable columns in EL database nullable - https://phabricator.wikimedia.org/T167162#3382417 (10elukey) We'll use this task to track the work on db1047 and dbstore1002, but it will likely take days before completion. [15:00:17] (03CR) 10Mforns: [V: 032 C: 032] "LGTM!" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/360327 (https://phabricator.wikimedia.org/T168402) (owner: 10Joal) [15:01:24] ping joal [15:02:01] standduppp [15:32:18] (03CR) 10Joal: "Everything done! Incredible :)" (035 comments) [analytics/refinery] - 10https://gerrit.wikimedia.org/r/361651 (https://phabricator.wikimedia.org/T168614) (owner: 10Joal) [15:36:27] (03PS3) 10Joal: Add script deleting druid deep storage data [analytics/refinery] - 10https://gerrit.wikimedia.org/r/361651 (https://phabricator.wikimedia.org/T168614) [15:36:35] elukey: --^ :) [15:36:39] Thank youuuuuu :) [15:43:50] joal: one last nit - logging.exception("message") will log the message and the stacktrace [15:43:52] 10Analytics-Kanban, 10Operations, 10User-Elukey: New analytic hosts with BBU learning cycle enabled - https://phabricator.wikimedia.org/T167809#3382757 (10Nuria) 05Open>03Resolved [15:45:17] 2017-06-27T15:45:03 DEBUG "GET /druid/coordinator/v1/metadata/datasources/batman HTTP/1.1" 404 0 [15:45:20] 2017-06-27T15:45:03 ERROR Couldn't get datasource metadata for datasource batman. Aborting. [15:45:26] so sad [15:45:36] looks good joal! [15:47:13] (03CR) 10Elukey: [C: 031] "Last nit/suggestion would be to use logging.exception inside a except, but the rest looks good!" [analytics/refinery] - 10https://gerrit.wikimedia.org/r/361651 (https://phabricator.wikimedia.org/T168614) (owner: 10Joal) [15:53:34] Ah ok elukey, I'm not really a python guy :) [15:54:44] elukey: should I remove the explicti exception catching then? [15:54:53] joal: at some point there must be things that you don't know perfectly :D :D [15:54:59] :D [15:55:27] nono rather than logging.error + format(e) just do logging.exception("message") [15:55:30] that's it [15:55:50] elukey: Ah, but I still nee the e? [15:56:05] yep the stacktrace is appended [15:57:19] sorry elukey, lost my connection [15:58:47] just tested the thing elukey - works great [15:59:14] super :) [15:59:21] (03PS4) 10Joal: Add script deleting druid deep storage data [analytics/refinery] - 10https://gerrit.wikimedia.org/r/361651 (https://phabricator.wikimedia.org/T168614) [15:59:22] And e is not needed [16:00:30] joal: will it be run in cron ? [16:00:36] it should yes [16:00:43] so the exit(1) [16:00:58] I am wondering if it could be good to add a file handle to the logger [16:01:22] so it will not emit anything to stdout [16:01:27] but directly to a file [16:01:34] elukey: IIRC we use channel redirections in crons [16:02:08] sure sure I was only wondering if it was needed [16:02:14] rest looks good [16:02:25] elukey: other scripts don't have file logging [16:03:54] sure, we can go without it [16:04:09] (already +1ed :) [16:04:39] Thanks :) [16:18:38] MariaDB [log]> ALTER TABLE Edit_10676603 MODIFY COLUMN wiki varbinary(191) NULL; [16:18:41] Query OK, 12917440 rows affected (32 min 31.49 sec) [16:18:42] mforns: --^ [16:18:45] aahahahh [16:19:32] elukey, uuuuuuuuffffff [16:20:27] elukey, you think the fact that we are mentioning the type (varbinary) makes the command O(N) ? [16:23:58] not sure but it seems to create a tmp table, insert everything and then switch [16:26:14] !log quarry Rebooted all the boxes in an attempt to fix performance problems [16:26:15] Logged the message at https://www.mediawiki.org/wiki/Analytics/Server_Admin_Log [16:33:15] 10Analytics-Kanban, 10Analytics-Wikistats: Deploy new Wikistats to stats.wikimedia.org/v2 - https://phabricator.wikimedia.org/T167684#3383158 (10mmodell) [16:35:17] fdans: not sure if you saw, but we have https://phabricator.wikimedia.org/T168549 [16:35:47] fdans: want to hang out tomorrow and try to fix the prod build and deploy? [16:36:10] milimetric: hell yeeeea [16:51:34] ok, cool, then let's shoot for tomorrow, I'll try to get this wiki selector in better shape [16:53:19] 10Analytics-Tech-community-metrics, 10Developer-Relations (Apr-Jun 2017): Find out (and fix) why we have a higher number of identity entries than before switching to new Bitergia DB scheme - https://phabricator.wikimedia.org/T168217#3383274 (10Aklapper) https://wikimedia.biterg.io:443/goto/3423b26f9958ae594cbf... [16:59:42] mforns: SELECT DISTINCT table_name FROM information_schema.columns WHERE table_schema = 'log' and table_name not in (SELECT DISTINCT table_name FROM information_schema.columns WHERE table_schema = 'log' and column_name LIKE 'event_%') AND table_name not in (SELECT DISTINCT table_name FROM information_schema.columns WHERE table_schema = 'log' and column_name = 'timestamp') [16:59:48] too horrible? [17:00:06] err s/not in/in/g [17:00:18] elukey, reading [17:00:20] (I was checking the negation to validate) [17:03:22] elukey, I think it will work, however, is there a need to do the subqueries? you think my suggestion was missing something? [17:03:35] they do the same right? [17:03:50] yep I am trying also yours, it is more readable [17:04:21] also, I'm not sure if mysql caches the results of subqueries in where clauses? [17:04:29] probably it does [17:05:04] maybe we can ask milimetric (a.k.a. sql master) to give his opinion [17:05:12] :] [17:05:18] it was super fast on dbstore1002, plus it is a one time only [17:05:24] ok [17:05:32] oh yeah yours now works [17:05:40] I got some issue before but probably PEBKAC [17:05:43] updating the code review [17:05:50] I also removed the check in the whitelist [17:05:53] I see, it could be, I didn't test it! [17:07:01] I don't know at all how mysql handles that, I'd do the same thing you are - guess and check and run explain [17:07:26] (the check_not_valid_whitelist_table_prefixes) [17:07:32] 10Analytics-Tech-community-metrics, 10Developer-Relations (Apr-Jun 2017): Find out (and fix) why we have a higher number of identity entries than before switching to new Bitergia DB scheme - https://phabricator.wikimedia.org/T168217#3383411 (10Albertinisg) >>! In T168217#3383274, @Aklapper wrote: > https://wik... [17:07:45] thanks milimetric :] [17:07:47] k [17:10:12] mforns: PS16 out! [17:10:29] looking [17:15:25] 10Analytics, 10Discovery, 10Wikidata, 10Wikidata-Query-Service: Data request for logs from SparQL interface at query.wikidata.org - https://phabricator.wikimedia.org/T143819#3383498 (10Smalyshev) See also: T164019 which could probably provide a platform for collecting the stats. [17:15:42] elukey, I think the check we needed to remove was the other one, the one from L264 to L274, no? [17:16:05] this one checks that all tables in the whitelist are actual tables, which makes sense [17:18:02] ah snap you are right [17:18:35] are you still my friend elukey? :P [17:18:44] I am stupid that's all :D [17:18:58] I feel so nitpicky... :S [17:19:12] xD [17:20:45] so I cherry pick PS15, then restart [17:24:27] PS17 is not good [17:24:30] a test fails [17:24:33] ahahhaha [17:24:40] hehehe [17:24:51] PS18 should be good mforns [17:25:01] ok! [17:29:34] mforns: going afk now, will re-check tomorrow! Let me know if there is anything to change [17:29:55] (03CR) 10XXN: "There could be added as well a link to https://wikitech.wikimedia.org/wiki/Help:MySQL_queries and the menu button label changed to "Help"," [analytics/quarry/web] - 10https://gerrit.wikimedia.org/r/361299 (owner: 10XXN) [17:30:35] * elukey off! [17:31:57] 10Analytics, 10EventBus, 10Wikimedia-Stream, 10Patch-For-Review, 10Services (watching): Expose revision-create in EventStreams - https://phabricator.wikimedia.org/T167670#3383643 (10Nuria) The stream needs to be documented publicy just like recent-changes is: https://www.mediawiki.org/wiki/API:Recent_cha... [17:35:50] 10Analytics-Kanban, 10Wikimedia-Stream: Port RCStream clients to EventStreams - https://phabricator.wikimedia.org/T156919#3383654 (10Nuria) See @BBlack note " in https://phabricator.wikimedia.org/T168919 I was looking at RCStream's traffic, it's still in the ballpark of ~2-3 reqs/sec averaged over a day (~200... [17:41:17] elukey, I commented on the change, looks ready to me! [17:59:53] 10Analytics-Kanban, 10Wikimedia-Stream: Port RCStream clients to EventStreams - https://phabricator.wikimedia.org/T156919#3383772 (10BBlack) [18:05:38] wikimedia/mediawiki-extensions-EventLogging#666 (wmf/1.30.0-wmf.7 - b4359b9 : Translation updater bot): The build has errored. [18:05:38] Change view : https://github.com/wikimedia/mediawiki-extensions-EventLogging/compare/wmf/1.30.0-wmf.7 [18:05:38] Build details : https://travis-ci.org/wikimedia/mediawiki-extensions-EventLogging/builds/247632733 [18:24:13] 10Quarry: Login to somebody's account - https://phabricator.wikimedia.org/T120988#1866469 (10Milimetric) This happened again, after I rebooted all the quarry instances. Must be some shared Flask state or something. No time to look into it, but posting for future reference. [18:26:21] 10Analytics-Kanban: Extraneous whitelist items for WikimediaBlogVisit schema - https://phabricator.wikimedia.org/T168475#3383905 (10Tbayer) Thanks @mforns! As indicated in the task description, the aim was to flag this inconsistency in case it causes problems with the script or elsewhere. Since we now know that... [18:28:43] (03CR) 10Nuria: [V: 032 C: 032] Add sampled-webrequest druid loading oozie jobs [analytics/refinery] - 10https://gerrit.wikimedia.org/r/355598 (https://phabricator.wikimedia.org/T166967) (owner: 10Joal) [18:29:11] 10Analytics-Kanban: Update undocumented EventLogging mediawiki hooks - https://phabricator.wikimedia.org/T158331#3383913 (10Nuria) 05Open>03Resolved [18:29:14] 10Analytics, 10Analytics-EventLogging, 10Collaboration-Team-Triage, 10MediaWiki-ContentHandler, and 5 others: Multiple MediaWiki hooks are not documented on mediawiki.org - https://phabricator.wikimedia.org/T157757#3383914 (10Nuria) [18:29:20] 10Analytics-Kanban: Clean up datasets.wikimedia.org - https://phabricator.wikimedia.org/T125854#3383916 (10Nuria) [18:29:22] 10Analytics-Kanban, 10Patch-For-Review: Announce analytics.wikimedia.org/datasets and deprecation of datasets.wikimedia.org - https://phabricator.wikimedia.org/T159409#3383915 (10Nuria) 05Open>03Resolved [18:29:32] 10Analytics-Kanban, 10Patch-For-Review: Rename last_access_uniques to per-domain uniques - https://phabricator.wikimedia.org/T167043#3383930 (10Nuria) 05Open>03Resolved [18:29:48] 10Analytics-Kanban, 10User-Elukey: Reboot all the Analytics hosts for kernel upgrades - https://phabricator.wikimedia.org/T168381#3383931 (10Nuria) 05Open>03Resolved [18:30:03] 10Analytics-Kanban: Global Unique Devices Counts - https://phabricator.wikimedia.org/T143927#3383933 (10Nuria) [18:30:04] 10Analytics-Kanban, 10Patch-For-Review: Count project-wide unique devices (like *.wikipedia.org) - https://phabricator.wikimedia.org/T143928#3383932 (10Nuria) 05Open>03Resolved [18:30:16] 10Analytics-Kanban, 10Patch-For-Review: Update per-domain uniques fresh-sessions computation - https://phabricator.wikimedia.org/T167005#3383934 (10Nuria) 05Open>03Resolved [18:30:29] 10Analytics-Kanban: Initial Launch of new Wikistats 2.0 website - https://phabricator.wikimedia.org/T160370#3383936 (10Nuria) [18:30:31] 10Analytics-Kanban, 10Analytics-Wikistats: Initial FE code for Wikistats 2.0. Dashboard skeleton - https://phabricator.wikimedia.org/T163814#3383935 (10Nuria) 05Open>03Resolved [18:30:40] 10Analytics-Kanban, 10Analytics-Wikistats: Data Model using Crossfilter, called DimensionalData - https://phabricator.wikimedia.org/T167678#3383937 (10Nuria) 05Open>03Resolved [18:30:42] 10Analytics-Kanban, 10Analytics-Wikistats: Implement pageviews and unique devices detail pages in Wikistats UI - https://phabricator.wikimedia.org/T163817#3383938 (10Nuria) [18:54:46] Yay :) First Slider app successfully launched :) [18:55:18] Leaving that for today :) [18:55:22] See you tomorrow a-team [18:55:28] Thanks again mforns and elukey for reviews :) [18:56:36] o/ [19:30:12] bye joal !