[00:52:46] 10Phabricator, 10Gerrit: Disable Tjlsangria Gerrit and Phabricator accounts - https://phabricator.wikimedia.org/T147165#2683347 (10Legoktm) [03:23:06] 10Phabricator: Entered project tag lost after creating task - https://phabricator.wikimedia.org/T147133#2682285 (10Peachey88) Do you just write phabricator in, or do you select it from the type-a-head and select it (so it turns into the visual representation of the tag? [05:06:15] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2683486 (10MZMcBride) >>! In T146843#2681885, @epriestley wrote: > Having failure cases would be helpful for us, too. I can't reproduce the one described above --... [06:24:54] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2683525 (10Paladox) Yeh, that would be stemming and currently MySQL doesn't support stemming but upstream are going to support stemming. [08:47:37] 10Wikibugs, 07Easy, 13Patch-For-Review: Change Project-Creators to Project-Admins in channels.yaml - https://phabricator.wikimedia.org/T142851#2683673 (10Vaishnav980123) @Paladox I am really sorry that I removed the claim once after assigning it. I didn't knew that I can't do that once after adding my claim. [09:50:14] 10Wikibugs, 07Easy, 13Patch-For-Review: Change Project-Creators to Project-Admins in channels.yaml - https://phabricator.wikimedia.org/T142851#2683749 (10Paladox) Yep sorry I didn't realise that there was a hackathon yesterday so sorry for mistakenly thinking you were a spammer. I won't be doing that again,... [13:20:13] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2684248 (10epriestley) I can't reproduce `"only includes the columns"`: {F4549562} I also can't reproduce `"Content model storage"`: {F4549568} I //can// repro... [13:40:46] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2684326 (10MZMcBride) My latest theory (read: shot in the dark) is that task mentions are triggering search index updates. [14:29:14] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2684433 (10epriestley) That's definitely plausible (the "edit" code basically ends with "ok, now update the search index"). If so, the index may not have been fu... [14:48:27] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2684466 (10Paladox) Apparently there is a difference in innodb full text search http://www.vertabelo.com/blog/technical-articles/looking-for-a-simple-full-text-sea... [17:15:58] 10Phabricator, 15User-greg: Change of workboard columns in #Phabricator - https://phabricator.wikimedia.org/T131568#2685121 (10greg) >>! In T131568#2681683, @Aklapper wrote: > So I'd personally say: > * Kill "Stalled" column. Doesn't make sense to me. Can be expressed via "stalled" status instead. +1 (columns... [17:16:41] 10Phabricator, 15User-greg: Change of workboard columns in #Phabricator - https://phabricator.wikimedia.org/T131568#2685123 (10greg) a:05Danny_B>03None (Removing Danny as assignee as he hasn't responded/done anything for a while on this task, don't want to leave a lingering cookie lick.) [18:58:14] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2685613 (10Tgr) {T144865} not found by searching for [[https://phabricator.wikimedia.org/search/query/eOz9xcE09HCi/#R|pageview api action]] or [[https://phabricato... [19:10:39] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2685664 (10EBernhardson) >>! In T146843#2685613, @Tgr wrote: > {T144865} not found by searching for [[https://phabricator.wikimedia.org/search/query/eOz9xcE09HCi/#... [19:15:13] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2685674 (10epriestley) Likewise, so that's consistent with the hypothesis that mentioning tasks is causing them to index, but some of them are currently missing fr... [19:47:49] 10Phabricator, 06Project-Admins: Convert CX-* projects to subprojects of MediaWiki-Extensions-ContentTranslation - https://phabricator.wikimedia.org/T147175#2685786 (10Aklapper) [21:56:09] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2686260 (10mmodell) We ran a full reindex after switching to innodb, and that took a couple of full days to complete. I noticed that reindexing projects didn't mak... [21:56:33] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2686261 (10mmodell) I'm running another reindex task now and it's going much faster, 10% done after just a couple of minutes. [22:02:30] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2686283 (10Paladox) @mmodell maybe bin/search index --all --background --all ? [22:20:42] 10Phabricator, 06Release-Engineering-Team, 13Patch-For-Review, 07Wikimedia-Incident: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2686313 (10jcrespo) I have done #3 of T146673#2675083. The stopwords handling requires a patch to ada... [22:23:33] 10Phabricator, 06Release-Engineering-Team, 13Patch-For-Review, 07Wikimedia-Incident: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2686315 (10Paladox) @jcrespo yeh,but https://gerrit.wikimedia.org/r/313235 should improve things more... [22:35:36] 10Phabricator, 06Release-Engineering-Team, 13Patch-For-Review, 07Wikimedia-Incident: Contention on search phabricator database creating full phabricator outages - https://phabricator.wikimedia.org/T146673#2686338 (10Paladox) @jcrespo Hi, I'm wondering would you be able to do the patch that create an table... [22:40:46] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2686341 (10mmodell) @epriestley: Any clue what went wrong here? ``` EXCEPTION: (PhabricatorWorkerPermanentFailureException) Failed to update search index for doc... [22:41:53] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2686342 (10mmodell) well hmm, that task has a very long title, but I guess the search index has a shorter title column...hmm [23:00:45] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2686374 (10Paladox) @mmodell https://github.com/wikimedia/phabricator/blob/9d8a2836b01d403425cbb92502c05af53882b9f3/resources/sql/quickstart.sql#L2949 https://gi... [23:05:39] 10Wikibugs, 07Easy, 13Patch-For-Review: Change Project-Creators to Project-Admins in channels.yaml - https://phabricator.wikimedia.org/T142851#2686379 (10Paladox) @Vaishnav980123 if you want to try, you could copy my patch that is linked above in gerrit and we can go with your patch if you want? [23:28:51] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2686422 (10mmodell) I don't know... it seems like it should just truncate the title to the size of the column [23:32:20] 10Phabricator, 06Discovery, 10Elasticsearch: Re-evaluate how we implement phabricator's search engine - https://phabricator.wikimedia.org/T146843#2686429 (10MZMcBride) >>! In T146843#2686342, @mmodell wrote: > well hmm, that task has a very long title, but I guess the search index has a shorter title column....