[00:53:15] When I try to connect to Toolforge using PuTTY or FileZilla, the sever is returning the error (server sent: publickey,hostbased) [00:53:15] . Does anyone know how to fix this? [07:44:04] So in an attempt to win an argument, I've been trying to optimize an SQL query [07:44:23] For some reason, in the explain it lists a full table scan of the revision table [07:44:36] now i know that comes in when calculated which rows of the actor table should be redacted [07:44:50] but nonetheless, I don't understand why it would do a full table scan [07:45:13] or maybe I'm reading things wrong, as it definitely completes too fast (When adding a LIMIT), to actually be a full table scan [07:45:54] Anyways, https://dpaste.org/gS7y/raw is my query and the explain (During testing,I was putting a LIMIT 10 in the inner subquery [07:46:08] Am i just misinterpreting the explain, or is it really doing a full table scan on revision [10:20:14] !log tools create new VM instance tools-prometheus-03 (T238096) [10:20:17] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [10:20:18] T238096: Toolforge: prometheus: refresh setup - https://phabricator.wikimedia.org/T238096 [12:57:54] !log tools created domain `tools.wmcloud.org` in the tools project after some back and forth with designated, permissions and the database. I plan to use this domain to test the new Debian Buster-based prometheus setup (T238096) [12:57:57] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [12:57:57] T238096: Toolforge: prometheus: refresh setup - https://phabricator.wikimedia.org/T238096 [12:59:46] !log tools associated floating IPv4 185.15.56.60 to tools-prometheus-03 (T238096) [12:59:49] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [13:09:38] !log tools created FQDN `prometheus.tools.wmcloud.org` pointing to IPv4 185.15.56.60 (tools-prometheus-03) to test T238096 [13:09:41] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [13:09:41] T238096: Toolforge: prometheus: refresh setup - https://phabricator.wikimedia.org/T238096 [13:14:59] !log tools drop floating IP 185.15.56.60 and FQDN `prometheus.tools.wmcloud.org` because this is not how the prometheus setup is right now. Use a web proxy instead `tools-prometheus-new.wmflabs.org` (T238096) [13:15:12] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [13:15:12] T238096: Toolforge: prometheus: refresh setup - https://phabricator.wikimedia.org/T238096 [13:42:06] !log tools disable puppet in prometheus servers while syncing metric data (T238096) [13:42:10] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [13:42:10] T238096: Toolforge: prometheus: refresh setup - https://phabricator.wikimedia.org/T238096 [16:25:29] !log tools point tools-prometheus.wmflabs.org proxy to tools-prometheus-03 (T238096) [16:25:33] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [16:25:33] T238096: Toolforge: prometheus: refresh setup - https://phabricator.wikimedia.org/T238096 [16:27:54] !log tools create VM tools-prometheus-04 as cold standby of tools-prometheus-03 (T238096) [16:27:57] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [20:39:23] !log tools apt-get install python3-keystoneclient on tools-prometheus-03 and tools-prometheus-04 to suppress cronspam. Possible real fix for this is https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/569084/ [20:39:31] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [21:04:11] !log tools also apt-get install python3-novaclient on tools-prometheus-03 and tools-prometheus-04 to suppress cronspam. Possible real fix for this is https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/569084/ [21:04:13] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL