[01:29:50] Hi I am trying to figure out is there an SQL equivalent of the XML version of https://dumps.wikimedia.org/enwiki/latest/enwiki-latest-pages-logging.xml.gz [01:29:53] The page logs [01:30:09] xinbenlv: ? [01:31:00] so I am trying to find the page logs that contains when and by whom a page is protected. halfak pointed me to the XML version of dump https://dumps.wikimedia.org/enwiki/latest/enwiki-latest-pages-logging.xml.gz, that's great, I am wondering if there is an SQL version? [01:31:14] wait a miniute, you are id=SQL?....... [01:31:22] ... [01:31:57] xinbenlv: The logging table perhaps? https://www.mediawiki.org/wiki/Manual:Logging_table [01:34:30] How could I access that table? Or is there a way to access the dump? [01:35:09] You could use SQL Statements in quarry https://quarry.wmflabs.org [01:39:45] Thanks SQL [01:39:48] ```SELECT command denied to user 's52788'@'10.64.37.15' for table 'logging'``` [01:39:51] Got this problem [01:40:01] https://quarry.wmflabs.org/query/41931 [01:42:10] ? I get a result at that link [01:52:20] 10Scoring-platform-team, 10Discovery-Search, 10Growth-Team (Current Sprint): Newcomer tasks: determine how to use ORES ontology - https://phabricator.wikimedia.org/T244192 (10Catrope) > But the topics themselves should be displayed alphabetically in the local language. Engineers, please let us know if that d... [06:36:22] 10ORES, 10Scoring-platform-team (Current), 10Operations: Ores celery OOM event in codfw - https://phabricator.wikimedia.org/T242705 (10elukey) Happened again today at 06:25UTC when logrotate ran, forced a puppet run on all hosts to recover quickly. [06:42:04] 10ORES, 10Scoring-platform-team (Current), 10Operations: Ores celery OOM event in codfw - https://phabricator.wikimedia.org/T242705 (10elukey) The 7 days view shows a nice increase of memory usage: https://grafana.wikimedia.org/d/000000607/cluster-overview?orgId=1&from=now-7d&to=now&var-datasource=eqiad%20p... [07:15:26] 10ORES, 10Scoring-platform-team (Current), 10Operations: Ores celery OOM event in codfw - https://phabricator.wikimedia.org/T242705 (10elukey) There you go: https://tools.wmflabs.org/sal/log/AXAM254BfYQT6VcDATbh The deployment matches the start of the memory growth, @Halfak do you have any idea what caused... [08:13:30] 10ORES, 10Scoring-platform-team (Current), 10Operations: Ores celery OOM event in codfw - https://phabricator.wikimedia.org/T242705 (10akosiaris) T243451 does explain the higher memory usage. It even points out that the higher memory usage is worrisome, however it was deployed anyway. [15:10:13] o/ [15:10:15] Forgot to start up hexchat [16:27:45] Resolving out topc modeling stuff [16:27:48] *our [16:27:55] 10ORES, 10Scoring-platform-team (Current): Deploy ORES -- Late Jan 2020 - https://phabricator.wikimedia.org/T243451 (10Halfak) 05Open→03Resolved a:03Halfak [16:28:52] 10ORES, 10Scoring-platform-team (Current): Deploy ORES -- Late Jan 2020 - https://phabricator.wikimedia.org/T243451 (10Halfak) [16:29:44] 10ORES, 10Scoring-platform-team (Current), 10Patch-For-Review: Reduce memory footprint of topic models - https://phabricator.wikimedia.org/T243522 (10Halfak) 05Open→03Resolved [16:29:46] 10Scoring-platform-team (Current), 10drafttopic-modeling, 10revscoring, 10artificial-intelligence: Implement common lib for text preproccessing - https://phabricator.wikimedia.org/T242647 (10Halfak) 05Open→03Resolved [16:29:48] 10ORES, 10Scoring-platform-team (Current): Deploy ORES -- Late Jan 2020 - https://phabricator.wikimedia.org/T243451 (10Halfak) [16:29:51] 10ORES, 10Scoring-platform-team (Current), 10drafttopic-modeling: Add new vectors to deployment assets - https://phabricator.wikimedia.org/T243108 (10Halfak) 05Open→03Resolved [16:29:53] 10Scoring-platform-team (Current), 10drafttopic-modeling: Retrain enwiki drafttopic models on supervised vectors - https://phabricator.wikimedia.org/T243107 (10Halfak) 05Open→03Resolved [16:29:55] 10ORES, 10Scoring-platform-team (Current): Deploy ORES -- Late Jan 2020 - https://phabricator.wikimedia.org/T243451 (10Halfak) [16:29:57] 10Scoring-platform-team (Current), 10drafttopic-modeling: Implement English pronoun count features in topic models - https://phabricator.wikimedia.org/T242345 (10Halfak) 05Open→03Resolved [16:30:01] 10ORES, 10Scoring-platform-team (Current): Deploy ORES -- Late Jan 2020 - https://phabricator.wikimedia.org/T243451 (10Halfak) [16:30:03] 10Scoring-platform-team (Current), 10drafttopic-modeling, 10revscoring, 10artificial-intelligence: Generate word vectors for ar, cs, en, and ko using FastText - https://phabricator.wikimedia.org/T235184 (10Halfak) 05Open→03Resolved [16:30:05] 10ORES, 10Scoring-platform-team (Current): Deploy ORES -- Late Jan 2020 - https://phabricator.wikimedia.org/T243451 (10Halfak) [16:30:07] 10Scoring-platform-team, 10drafttopic-modeling, 10revscoring, 10artificial-intelligence: Experiment with different vector lengths for ar, cs, en, and kowiki topic models. - https://phabricator.wikimedia.org/T235183 (10Halfak) [16:30:09] 10Scoring-platform-team (Current), 10drafttopic-modeling, 10revscoring, 10artificial-intelligence: Build WikiProject directory topic models for ar, cs, and kowiki - https://phabricator.wikimedia.org/T235181 (10Halfak) 05Open→03Resolved a:03Halfak [16:30:11] 10ORES, 10Scoring-platform-team (Current): Deploy ORES -- Late Jan 2020 - https://phabricator.wikimedia.org/T243451 (10Halfak) [17:35:59] \o/ kevinbazira got mobile resizing to work on the jade ui [17:36:11] :) [17:39:45] it's starting to feel much more cohesive, looking forward to getting this out on beta soon [17:41:12] halfak, we may need to rethink icon colors for label data, we can't set the asset colors directly. i'll look into some possible alternatives today [17:41:52] "asset colors" == icon colors? [17:42:11] nice work kevinbazira! [17:42:21] accraze, ^ see my question [17:42:33] yep thats correct halfak [17:43:54] Gotcha. I thought that might be complicated. It appears as though it's common to change the color of these icons, so I imagine there is a way. I wonder if there is a collection of assets with colors from the standard WMF pallete. [17:44:16] https://stackoverflow.com/questions/22252472/how-to-change-the-color-of-an-svg-element [17:45:53] https://developer.mozilla.org/en-US/docs/Web/CSS/filter#Browser_compatibility [17:46:46] Oh wait. Looks like that doesn't work on modern browsers... I'm confused. [17:47:04] yeah that's what i'm looking into, another approach might be to use a "borderless" button widget instead of icon, but we'll see which approach makes more sense w/ ooui [17:48:48] https://www.mediawiki.org/wiki/Design/Archive/WikiFont [17:49:00] Seems like this is included in a font. In theory we can change the color then. [17:50:02] yeah i'm think the issue comes down to how we are creating the widget in the js [17:53:51] This is definitely annoying. I can get clever with this but I'd like to check in with designers first. [18:06:57] i dont think its a total blocker yet, might just need to refactor our icon code a bit [21:14:03] that table in hdfs is what I need [21:14:12] don't need to do the historical scoring any more at all [21:14:27] it has about 1 year of data :) [21:24:40] very excited [22:06:03] \o/ [22:06:04] WOOO [22:06:09] groceryheist, ^ [22:06:12] I had no idea. [22:06:15] This is awesome! [22:25:03] yeah it also makes it easy to solve the issue with different revert windows we had before. [22:26:28] i mean we were talking about earlier [22:52:17] 10Scoring-platform-team, 10Discovery-Search, 10Growth-Team (Current Sprint): Newcomer tasks: UX changes for ORES topics - https://phabricator.wikimedia.org/T244421 (10MMiller_WMF) [22:53:35] 10Scoring-platform-team, 10Discovery-Search, 10Growth-Team (Current Sprint): Newcomer tasks: UX changes for ORES topics - https://phabricator.wikimedia.org/T244421 (10MMiller_WMF) @RHo -- I'm putting this in your column for two reasons: * This is where you can add a link to the prototype of the overlay/dial... [22:55:04] 10Scoring-platform-team, 10Discovery-Search, 10Growth-Team (Current Sprint): Newcomer tasks: determine how to use ORES ontology - https://phabricator.wikimedia.org/T244192 (10MMiller_WMF) Thanks, @Catrope. Regarding the "reversed view", I added [[ https://docs.google.com/spreadsheets/d/1ksVeVbiJ9XnGmG7kz6_c... [22:55:21] 10Scoring-platform-team, 10Discovery-Search, 10Growth-Team (Current Sprint): Newcomer tasks: ORES ontology mapping and score thresholds - https://phabricator.wikimedia.org/T244192 (10MMiller_WMF) [22:56:58] 10Scoring-platform-team, 10Discovery-Search, 10Growth-Team (Current Sprint): Newcomer tasks: UX changes for ORES topics - https://phabricator.wikimedia.org/T244421 (10RHo) >>! In T244421#5854210, @MMiller_WMF wrote: > @RHo -- I'm putting this in your column for two reasons: > > * This is where you can add a... [23:09:34] 10Scoring-platform-team, 10Discovery-Search, 10Growth-Team (Current Sprint): Newcomer tasks: UX changes for ORES topics - https://phabricator.wikimedia.org/T244421 (10MMiller_WMF) @RHo -- could you please also comment on how this overlay should work? Like should the messaging at the top scroll away? Or sho... [23:11:46] 10Scoring-platform-team, 10Discovery-Search, 10Growth-Team (Current Sprint): Newcomer tasks: UX changes for ORES topics - https://phabricator.wikimedia.org/T244421 (10MMiller_WMF) [23:19:26] 10Scoring-platform-team, 10Discovery-Search, 10Growth-Team (Current Sprint): Newcomer tasks: UX changes for ORES topics - https://phabricator.wikimedia.org/T244421 (10MMiller_WMF)