[09:27:16] (03CR) 10Ladsgroup: [C: 04-1] "Fix the nesting please" (031 comment) [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) (owner: 10Sbisson) [13:25:16] 10Revision-Scoring-As-A-Service-Backlog, 10Wikidata, 05WMDE-Tech-Communication-Mentoring-And-Events: Wikidata item quality classification - https://phabricator.wikimedia.org/T127470#2952633 (10Glorian_WD) a:05Glorian_Yapinus>03Glorian_WD [13:28:49] 10Revision-Scoring-As-A-Service-Backlog, 10Wikidata, 05WMDE-Tech-Communication-Mentoring-And-Events: Wikidata item quality classification - https://phabricator.wikimedia.org/T127470#2952635 (10Glorian_WD) Claim this task with my other account since the account @Glorian_Yapinus will defunct soon. [13:32:18] (03CR) 10Thiemo Mättig (WMDE): [C: 04-1] [WIP] Fetch thresholds from live stats for filters (035 comments) [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) (owner: 10Sbisson) [14:58:21] (03PS5) 10Sbisson: [WIP] Fetch thresholds from live stats for filters [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) [14:58:27] (03CR) 10Sbisson: [WIP] Fetch thresholds from live stats for filters (035 comments) [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) (owner: 10Sbisson) [15:00:00] (03CR) 10jerkins-bot: [V: 04-1] [WIP] Fetch thresholds from live stats for filters [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) (owner: 10Sbisson) [15:03:53] (03PS6) 10Sbisson: [WIP] Fetch thresholds from live stats for filters [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) [15:04:53] o/ Amir1 [15:05:00] halfak: hey [15:05:06] Backlogging with me today? [15:05:08] :D [15:05:34] I'm in library can't be at the backlog :( [15:05:46] let me find a place [15:08:36] No worries. Can do it via IRC too :) [15:25:09] 10Revision-Scoring-As-A-Service-Backlog, 10DBA, 10MediaWiki-General-or-Unknown, 10ORES, 15User-Ladsgroup: Fatal exception of type "DBQueryError" on sorting ORES contributions - https://phabricator.wikimedia.org/T155500#2952895 (10Halfak) a:03Ladsgroup [15:25:39] 06Revision-Scoring-As-A-Service, 10ORES, 06Operations, 13Patch-For-Review: Set up monitoring for ORES redis database - https://phabricator.wikimedia.org/T155482#2952898 (10Halfak) p:05Triage>03High [15:26:00] 10Revision-Scoring-As-A-Service-Backlog: Add notice to on-wiki labeling pages (e.g. en:WP:Labels) about deprecation. - https://phabricator.wikimedia.org/T155440#2943314 (10Halfak) p:05Triage>03High [15:26:21] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: Announce presence of "oresscores" in api.php - https://phabricator.wikimedia.org/T153688#2952905 (10Halfak) p:05Triage>03Normal [15:27:17] 10Revision-Scoring-As-A-Service-Backlog, 10Wikilabels: Develop a backup strategy for campaigns/tasks/labels - https://phabricator.wikimedia.org/T155116#2952907 (10Halfak) [15:28:57] 10Revision-Scoring-As-A-Service-Backlog, 10Wikilabels: Develop a backup strategy for campaigns/tasks/labels - https://phabricator.wikimedia.org/T155116#2934029 (10Halfak) Related: {T56401} [15:30:03] 10Revision-Scoring-As-A-Service-Backlog, 10Wikilabels: Develop a backup strategy for campaigns/tasks/labels - https://phabricator.wikimedia.org/T155116#2952913 (10Halfak) If the postgres server had it's own backup scheme, that'd be fine. [15:30:29] 10Revision-Scoring-As-A-Service-Backlog, 10Wikilabels: Develop a backup strategy for campaigns/tasks/labels - https://phabricator.wikimedia.org/T155116#2952914 (10Halfak) p:05Triage>03Normal [15:31:33] 10Revision-Scoring-As-A-Service-Backlog, 10Wikilabels: Write up document explaining the current wikilabels campaign loading process - https://phabricator.wikimedia.org/T155115#2952922 (10Halfak) [15:31:45] 10Revision-Scoring-As-A-Service-Backlog, 10Wikilabels: Write up document explaining the current wikilabels campaign loading process - https://phabricator.wikimedia.org/T155115#2934003 (10Halfak) p:05Triage>03Low [15:35:36] 10Revision-Scoring-As-A-Service-Backlog, 10revscoring: Investigate use of Apertium LTtoolbox API in labs/production - https://phabricator.wikimedia.org/T155111#2952938 (10Halfak) p:05Triage>03Low [15:35:57] 10Revision-Scoring-As-A-Service-Backlog, 10revscoring, 07Spike: [Spike] Investigate use of Apertium LTtoolbox API in labs/production - https://phabricator.wikimedia.org/T155111#2933855 (10Halfak) [15:36:48] 06Revision-Scoring-As-A-Service, 10Data-release, 06Research-and-Data, 10Wikilabels: Licensing of labeled data - https://phabricator.wikimedia.org/T145024#2617400 (10Halfak) [15:37:19] 06Revision-Scoring-As-A-Service, 10rsaas-articlequality , 10rsaas-draftquality, 03Research-and-Data-2016-17-Q2: [Epic] Build draft quality model (spam, vandalism, attack, or OK) - https://phabricator.wikimedia.org/T148038#2952948 (10Halfak) a:03Halfak [15:37:25] 06Revision-Scoring-As-A-Service, 10revscoring: Sentence bank for personal attacks - https://phabricator.wikimedia.org/T148035#2712765 (10Halfak) a:03Halfak [15:37:35] 06Revision-Scoring-As-A-Service, 10revscoring: Sentence bank for vandalism - https://phabricator.wikimedia.org/T148034#2712752 (10Halfak) a:03Halfak [15:37:43] 06Revision-Scoring-As-A-Service, 10revscoring: Sentence bank for Featured Articles - https://phabricator.wikimedia.org/T148033#2712728 (10Halfak) a:03Halfak [15:40:56] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Spike] Review ORES architecture - https://phabricator.wikimedia.org/T153321#2952966 (10Halfak) [15:41:50] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Spike] Review ORES architecture - https://phabricator.wikimedia.org/T153321#2876634 (10Halfak) @dr0ptp4kt, I created a task for the ORES architecture review. Can you make sure that anyone who ought to be is subscribed and that we move forward with getting thi... [15:42:12] 10Revision-Scoring-As-A-Service-Backlog, 10ORES, 06Reading-Infrastructure-Team: [Spike] Review ORES architecture - https://phabricator.wikimedia.org/T153321#2952983 (10Halfak) [15:42:26] 10Revision-Scoring-As-A-Service-Backlog, 10ORES, 06Reading-Infrastructure-Team: [Spike] Review ORES architecture - https://phabricator.wikimedia.org/T153321#2876634 (10Halfak) p:05Triage>03High [15:45:19] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: BR-Discussion detector - https://phabricator.wikimedia.org/T153219#2952987 (10Halfak) [15:48:35] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: Design curation tools for meta-ORES - https://phabricator.wikimedia.org/T153161#2952996 (10Halfak) [15:50:17] 10Revision-Scoring-As-A-Service-Backlog, 10MediaWiki-extensions-ORES: Meta ORES: Link from score'd edit to this tool feedback interface - https://phabricator.wikimedia.org/T153157#2952999 (10Halfak) [15:51:16] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Discuss] Could Wiki Labels backend be replaced with Meta ORES? - https://phabricator.wikimedia.org/T153150#2871229 (10Halfak) p:05Triage>03Low [15:51:27] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Spec] Design meta ORES general wiki entity matching schema - https://phabricator.wikimedia.org/T153149#2871216 (10Halfak) p:05Triage>03Low [15:51:51] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: Meta ORES: UI - https://phabricator.wikimedia.org/T153148#2871202 (10Halfak) p:05Triage>03Low [15:52:05] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Spike] Should we integrate Meta ORES with Flow? - https://phabricator.wikimedia.org/T153147#2871186 (10Halfak) p:05Triage>03Low [15:52:34] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Spike] [bike shed] Name the Meta ORES service - https://phabricator.wikimedia.org/T153146#2871167 (10Halfak) p:05Triage>03Low [15:54:02] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Spike] [bike shed] Name the Meta ORES service - https://phabricator.wikimedia.org/T153146#2871167 (10Halfak) I wonder if there is a particularly human type of rock ("ore") that you might mine out of the ground. [15:54:59] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: Meta ORES: API data storage and querying - https://phabricator.wikimedia.org/T153145#2871141 (10Halfak) p:05Triage>03Low [15:55:19] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Spec] ORES query results should include Meta-ORES refutations - https://phabricator.wikimedia.org/T153143#2871103 (10Halfak) p:05Triage>03Low [15:55:39] 10Revision-Scoring-As-A-Service-Backlog, 10AbuseFilter, 10ORES: [Spec] Suppression system for Meta ORES freeform text fields - https://phabricator.wikimedia.org/T153142#2871070 (10Halfak) p:05Triage>03Low [15:56:22] 10Revision-Scoring-As-A-Service-Backlog, 10AbuseFilter, 10ORES: [Spec] Suppression system for Meta ORES freeform text fields - https://phabricator.wikimedia.org/T153142#2871070 (10Halfak) [15:56:25] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: Design curation tools for meta-ORES - https://phabricator.wikimedia.org/T153161#2953041 (10Halfak) [15:57:19] 10Revision-Scoring-As-A-Service-Backlog, 10Bad-Words-Detection-System, 10revscoring: Add language support for Romanian - https://phabricator.wikimedia.org/T152482#2849918 (10Halfak) p:05Triage>03Normal [15:58:06] 10Revision-Scoring-As-A-Service-Backlog, 10Bad-Words-Detection-System, 10revscoring: Add language support for Romanian - https://phabricator.wikimedia.org/T152482#2849918 (10Halfak) https://meta.wikimedia.org/wiki/Research:Revision_scoring_as_a_service/Word_lists/ro [15:58:11] 10Revision-Scoring-As-A-Service-Backlog, 10Bad-Words-Detection-System, 10revscoring: Add language support for Romanian - https://phabricator.wikimedia.org/T152482#2953058 (10Halfak) [15:59:35] 10Revision-Scoring-As-A-Service-Backlog, 10Bad-Words-Detection-System, 10revscoring: Add language support for Romanian - https://phabricator.wikimedia.org/T152482#2849918 (10Halfak) @Andrei_Stroe The words are generated at the link above. Can you follow the instructions to review the list for us? https://m... [15:59:45] 06Revision-Scoring-As-A-Service, 10Bad-Words-Detection-System, 10revscoring: Add language support for Romanian - https://phabricator.wikimedia.org/T152482#2953079 (10Halfak) [16:05:36] halfak: [16:05:36] select count(user_name) from user_properties as up1 join user on up1.up_user = user_id inner join user_properties as up2 on up2.up_user = up1.up_user and up2.up_property = 'ores-enabled' and up2.up_value = 1 where up1.up_property = 'betafeatures-auto-enroll' and up1.up_value = 1; [16:05:55] (you need to run it on the main database not labs replica) [16:06:05] Gotcha. [16:06:50] halfak: I think that's the exact opposite of that query :D [16:06:59] select count(user_name) from user_properties as up1 join user on up1.up_user = user_id left join user_properties as up2 on up2.up_user = up1.up_user and up2.up_property = 'betafeatures-auto-enroll' and up2.up_value = 1 where up1.up_property = 'ores-enabled' and up1.up_value = 1 and up2.up_property is NULL; [16:07:18] That would be it [16:08:48] Gotcha. Working on it now. [16:12:01] Amir1, looks like that lang issue had nothing to do with it. [16:14:01] shoot :( [16:29:35] (03CR) 10Thiemo Mättig (WMDE): "Thanks for the updates so far!" (032 comments) [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) (owner: 10Sbisson) [16:39:07] This is a weird lang bug. I'm still looking at it. [16:45:58] (03CR) 10Halfak: [C: 031] [WIP] Fetch thresholds from live stats for filters [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) (owner: 10Sbisson) [17:26:44] halfak: Today the oldest high-rise building in Tehran was on fire and then collapsed with around 200 people in it. Mostly firefighters [17:27:34] That's awful! [17:28:10] https://www.nytimes.com/2017/01/19/world/middleeast/iran-tehran-building-collapse.html [17:28:18] Yeah, I was sad for the whole day [17:50:00] 10Revision-Scoring-As-A-Service-Backlog: New editor potential predictor - https://phabricator.wikimedia.org/T155756#2953480 (10Halfak) [17:50:10] 10Revision-Scoring-As-A-Service-Backlog, 10Research Ideas: New editor potential predictor - https://phabricator.wikimedia.org/T155756#2953493 (10Halfak) [17:51:08] 06Revision-Scoring-As-A-Service, 10rsaas-articlequality : Build feature set for draft quality model - https://phabricator.wikimedia.org/T148580#2953501 (10Halfak) a:03Halfak [17:51:35] 06Revision-Scoring-As-A-Service, 10rsaas-articlequality : Build feature set for draft quality model - https://phabricator.wikimedia.org/T148580#2726845 (10Halfak) [17:57:27] (03PS7) 10Sbisson: [WIP] Fetch thresholds from live stats for filters [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) [17:57:48] (03CR) 10Sbisson: [WIP] Fetch thresholds from live stats for filters (032 comments) [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) (owner: 10Sbisson) [18:03:19] 10Revision-Scoring-As-A-Service-Backlog, 10ORES, 06Reading-Infrastructure-Team: [Spike] Review ORES architecture - https://phabricator.wikimedia.org/T153321#2953533 (10dr0ptp4kt) It's a top priority. Gergo will be primary from the Reading Infrastructure engineering perspective, and I've added Corey, Bernd, a... [18:27:04] (03PS8) 10Sbisson: [DO NOT MERGE] Fetch thresholds from live stats for filters [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) [18:29:41] (03CR) 10Sbisson: [C: 04-2] "Thanks everyone for reviewing." [extensions/ORES] - 10https://gerrit.wikimedia.org/r/332825 (https://phabricator.wikimedia.org/T152161) (owner: 10Sbisson) [18:30:36] 06Revision-Scoring-As-A-Service, 10revscoring: Sentence bank for spam - https://phabricator.wikimedia.org/T148032#2712712 (10Halfak) a:03Halfak [18:39:55] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Spike] [bike shed] Name the Meta ORES service - https://phabricator.wikimedia.org/T153146#2953726 (10awight) Or, we could work in human things that happen to miners: SORES for subjective... objective RES... [19:32:34] Amir1, check out https://github.com/wiki-ai/wikilabels/pull/157 [19:32:51] halfak: already one [19:32:56] *on it [19:33:04] Nice [19:33:27] * halfak digs back into pitch deck [20:45:45] 10Revision-Scoring-As-A-Service-Backlog, 10ORES: [Spike] [bike shed] Name the Meta ORES service - https://phabricator.wikimedia.org/T153146#2954242 (10Halfak) Oooh What about [pneumonoultramicroscopicsilicovolcanoconiosis](https://en.wikipedia.org/wiki/Pneumonoultramicroscopicsilicovolcanoconiosis)? [20:47:18] We still have 11.7k editors -- just on English Wikipedia -- who have enabled ORES but not "all beta features" :D [20:47:20] Amir1, ^ [20:47:26] And 1287 on ptwiki [20:48:26] 672 for fawiki [20:48:31] 600 for tr [20:48:38] 278 for nlwiki [20:48:44] woah! 2508 for ruwiki [20:48:59] 343 for plwiki [20:49:28] 574 for wikidatawiki. [20:49:32] OK time to math that up. [20:50:13] 17,987 [20:50:23] Looks like, even with this filter, the number went up from yesterday [20:50:24] ha [22:44:32] 06Revision-Scoring-As-A-Service, 06Research-and-Data: FY18 ORES resourcing proposal - https://phabricator.wikimedia.org/T155786#2954583 (10DarTar) [23:06:37] 10Revision-Scoring-As-A-Service-Backlog, 06Discovery-Search, 10Research Ideas: Use implicit feedback to improve search rankings - https://phabricator.wikimedia.org/T155559#2954699 (10debt) p:05Triage>03Normal