[09:10:18] <legoktm>	 bd808: whenever you have some time, I'd appreciate help setting up my elasticsearch application, as I'm not sure where I'm going wrong
[09:10:57] <legoktm>	 My goal is to be able to do regex substring matches over jenkins logs that I've imported, but for now I'm just trying to get plain substring searches working
[09:11:20] <legoktm>	 My code is https://phabricator.wikimedia.org/source/tool-flaky-ci/
[09:11:52] <legoktm>	 specifically, https://phabricator.wikimedia.org/source/tool-flaky-ci/browse/master/app.py;13792bcafc41e5fbcad487666b6700a0572b2e3f$111 is the search part. I've verified that at least one of the logs has that substring in it
[09:13:55] <legoktm>	 https://www.elastic.co/guide/en/elasticsearch/guide/current/_wildcard_and_regexp_queries.html said that to do regexp queries over full text you need to disable the analyzer
[09:14:25] <legoktm>	 so I did that in https://phabricator.wikimedia.org/source/tool-flaky-ci/browse/master/index.json;13792bcafc41e5fbcad487666b6700a0572b2e3f$9
[09:14:31] <legoktm>	 following https://www.elastic.co/guide/en/elasticsearch/guide/current/mapping-intro.html
[09:14:36] <legoktm>	 and I'm not sure where I'm going wrong still
[09:14:48] <legoktm>	 Because when I run my search script, it's not finding anything
[09:14:54] <legoktm>	 (v)tools.flaky-ci@tools-bastion-03:~/tool-flaky-ci$ python app.py 
[09:14:54] <legoktm>	 {'hits': {'max_score': None, 'total': 0, 'hits': []}, 'took': 8, '_shards': {'failed': 0, 'total': 1, 'successful': 1}, 'timed_out': False}
[18:25:07] <bd808>	 !log tools.paws Added Chico Venancio as a maintainer (T193828)
[18:25:10] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.paws/SAL
[18:25:10] <stashbot>	 T193828: PAWS culler stopped working - https://phabricator.wikimedia.org/T193828
[18:40:16] <zhuyifei1999_>	 !log toolsbeta to unblock k8s testing while waiting on https://gerrit.wikimedia.org/r/430539, installed the package directly on `toolsbeta-k8s-master-01` with `$ sudo apt install python3-yaml`
[18:40:18] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL
[19:09:22] <zhuyifei1999_>	 chicocvenancio: I think I accidentally deleted toolsbeta /data/project/paws/ while deleting the mess from maintain-kubeusers being given the wrong project. if it contains some database, could you recover it?
[19:09:50] <zhuyifei1999_>	 (I also deleted grid configuration, I guess I gotta reboot those instances)
[19:10:24] <chicocvenancio>	 I'm looking at paws-beta now, trying to migrate to mysql
[19:10:34] <chicocvenancio>	 whatever db was there is incosequential
[19:10:54] * chicocvenancio guesses the sqlitedb was there
[19:11:04] <zhuyifei1999_>	 ok
[19:11:37] <chicocvenancio>	 as soon as I can figure out why jupyterhub is not playing nice with toolsdb I can recreate it
[19:13:53] <chicocvenancio>	     sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1709, 'Index column size too large. The maximum column size is 767 bytes.') [SQL: '\nCREATE TABLE `groups` (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tname VARCHAR(255), \n\tPRIMARY KEY (id), \n\tUNIQUE (name)\n)\n\n'] (Background on this error at: http://sqlalche.me/e/2j85)
[19:14:07] <chicocvenancio>	 is the error its throwing at me
[19:20:01] <chicocvenancio>	 Huh, UTF takes 4 bytes per char, the name is over the limit
[19:22:34] <zhuyifei1999_>	 o.O
[19:25:37] <chicocvenancio>	 I could create the table and set it to UTF8 instead of utf8mb4
[19:25:46] <chicocvenancio>	 but that doesn't seem like a good idea
[19:29:24] * chicocvenancio wonders if we could/should set `innodb_large_prefix`in toolsdb
[19:34:16] <chicocvenancio>	 HUH, it is set!
[19:34:27] * chicocvenancio is very confused
[19:40:06] <zhuyifei1999_>	 (tooldbeta grid is back up)
[19:41:07] * chicocvenancio is less confused now
[19:51:36] <zhuyifei1999_>	 !log toolsbeta `systemctl mask maintain-kubeusers` because it's causing a mess, tries to get the tool list from toolforge T190893
[19:51:38] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL
[19:51:39] <stashbot>	 T190893: Setup the webservice-related instances in toolsbeta - https://phabricator.wikimedia.org/T190893
[22:47:33] <bd808>	 !log mediawiki-vagrant Rebuilding LXC container as stretch (T193818)
[22:47:35] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Mediawiki-vagrant/SAL
[22:47:35] <stashbot>	 T193818: Download and copy fresh MediaWiki vagrant installer iso to USB thumb drives for the hackathon - https://phabricator.wikimedia.org/T193818
[23:01:35] <chicocvenancio>	 toolsbeta-paws-master is returning nothing for paws pods... which is a bit weird
[23:37:38] <zhuyifei1999_>	 !log tools regenerate k8s creds for tools.zhuyifei1999-test because I messed up while testing
[23:37:40] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL