[03:20:57] <wm-bb>	 <harej> EpicPupper: I have an RTX 2080 SUPER; will that work?
[07:20:34] <taavi>	 !log tools.sunny00217bot disabled tool per T303128
[07:20:37] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.sunny00217bot/SAL
[07:20:37] <stashbot>	 T303128: Delete tool sunny00217bot - https://phabricator.wikimedia.org/T303128
[07:21:00] <taavi>	 !log tools.afc-zhwiki-icg-bot disabled tool per T303127
[07:21:02] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.afc-zhwiki-icg-bot/SAL
[07:21:02] <stashbot>	 T303127: Delete tool afc-zhwiki-icg-bot - https://phabricator.wikimedia.org/T303127
[07:21:39] <taavi>	 !log tools.typo-categorizer disabled tool per T302260
[07:21:41] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.typo-categorizer/SAL
[07:21:42] <stashbot>	 T302260: Archive/delete tool typo-categorizer and brandonstools - https://phabricator.wikimedia.org/T302260
[07:21:59] <taavi>	 !log tools.brandonstools disabled tool per T302260
[07:22:00] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.brandonstools/SAL
[07:22:28] <taavi>	 !log tools.commons-video-clicks disabled tool per T264720
[07:22:30] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.commons-video-clicks/SAL
[07:22:30] <stashbot>	 T264720: Delete Commons-Video-Clicks tool - https://phabricator.wikimedia.org/T264720
[09:02:04] <wm-bot>	 !log tools.shex-simple <lucaswerkmeister-wmde> hand-edited the gitdir of the two public_html worktrees from /mnt/nfs/labstore-secondary-tools-project/ to /data/project, the former path apparently doesn’t exist in k8s containers (which broke the update cronjob, T305944)
[09:02:07] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.shex-simple/SAL
[16:59:55] <taavi>	 !log tools.os-deprecation creating phab tasks for each project still running stretch T289883
[16:59:57] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.os-deprecation/SAL
[16:59:58] <stashbot>	 T289883: cloud-vps: actively deprecate/phase out use of Debian Stretch - https://phabricator.wikimedia.org/T289883
[18:30:32] <wm-bot>	 !log tools.quickcategories <lucaswerkmeister> added EXPECTED_DATABASE_ERROR to config so users will see an informative error message during next week’s ToolsDB outage
[18:30:35] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.quickcategories/SAL
[19:01:20] <razzi>	 Hi cloud team, I'm trying to get wikireplicas pooled status on etcd and I made a small puppet patch to add the basic conftool data, without using it anywhere in puppet. This way I can set and test the configuration with `confctl` before it affects anything. Here's the patch: https://gerrit.wikimedia.org/r/c/operations/puppet/+/779926
[19:04:05] <wm-bot>	 !log tools.quickcategories <lucaswerkmeister> START - purge querytime rows older than 30 days, in batches of 1000 sleeping for 1s between batches (~tools.quickcategories/purge-querytime)
[19:04:08] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.quickcategories/SAL
[19:04:27] <taavi>	 razzi: commented
[19:06:55] <razzi>	 taavi: good points
[19:09:02] <razzi>	 would wikireplicas-clouddb-hosts be a better name? Need to disambiguate it with wikireplicas-a and wikireplicas-b which already exist
[19:12:01] <razzi>	 maybe just wikireplicas-mariadb-hosts since the fact that the hosts are called clouddb isn't super important
[19:13:46] <taavi>	 yeah, or maybe wikireplica-backends? naming is hard
[19:22:57] <RhinosF1>	 taavi: can you merge https://gerrit.wikimedia.org/r/c/labs/tools/wikibugs2/+/779112
[19:34:33] <RhinosF1>	 taavi: done
[20:14:30] <RhinosF1>	 taavi: passing now
[20:18:13] <wm-bot>	 !log tools.quickcategories <lucaswerkmeister> END - purge querytime rows older than 30 days, in batches of 1000 sleeping for 1s between batches: deleted 2085455 rows (~tools.quickcategories/purge-querytime)
[20:18:15] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.quickcategories/SAL
[20:18:18] <wm-bot>	 !log tools.quickcategories <lucaswerkmeister> optimized querytime table (~tools.quickcategories/purge-querytime)
[20:18:19] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.quickcategories/SAL
[20:40:36] <wm-bb>	 <lucaswerkmeister> that… barely deleted any rows? not sure if I did something wrong
[20:40:45] <wm-bb>	 <lucaswerkmeister> 333335 before, 328596 after
[20:40:48] <wm-bb>	 <lucaswerkmeister> but it sure took long enough…
[20:53:21] <wm-bb>	 <lucaswerkmeister> I guess I didn’t optimize the table before, so the `table_rows` before might not have been accurate
[20:53:34] <wm-bb>	 <lucaswerkmeister> (I just got them from the information_schema, not from a count)
[20:55:25] <wm-bb>	 <lucaswerkmeister> yeah, looking at the local backup I took before, there should’ve been some 2.4 million rows 🤷
[20:55:38] <wm-bb>	 <lucaswerkmeister> anyways, that toolsdb table should be smaller now
[21:01:20] <andrewbogott>	 Thanks!
[21:02:20] <wm-bb>	 <lucaswerkmeister> I’ve updated the script again to optimize the table before the pruning, I’m sure I’ll run it again in a year or two ^^
[22:01:07] <andrewbogott>	 !log admin restarting galera on cloudcontrols (one by one) to clear open connections
[22:01:09] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL
[23:10:34] <Amir1>	 Hi, when I'm trying to create a phabricator project via toolsadmin, it's giving me 500 https://toolsadmin.wikimedia.org/tools/id/lsc/projects/create
[23:10:55] <Amir1>	 nbs, I can create it myself
[23:11:03] <Amir1>	 (hope don't mess it up)_