[01:08:51] <wm-bb>	 <jeremy_b> any ideas why a query that only returns one row would be fast on shell and hang in quarry?
[01:10:36] <wm-bb>	 <jeremy_b> quarry still says it's running from 4 hours ago
[01:11:15] <Platonides>	 jeremy_b: it may need to check a lot of entries before finding that one row
[01:11:33] <Platonides>	 which query is it?
[01:12:07] <wm-bb>	 <jeremy_b> but fast on shell? refutes that I think. (re @wmtelegram_bot: <Platonides> jeremy_b: it may need to check a lot of entries before finding that one row)
[01:12:10] <wm-bb>	 <jeremy_b> https://quarry.wmcloud.org/query/68433
[01:12:26] <Platonides>	 yes, fast on shell vs slow on quarry is the important bit
[01:12:51] <wm-bb>	 <jeremy_b> SELECT * FROM revision r, revision p WHERE r.rev_page=59351544 AND r.rev_deleted=0
[01:12:51] <wm-bb>	 <jeremy_b> AND p.rev_deleted=0 AND r.rev_parent_id=p.rev_id LIMIT 1;
[01:16:37] <Platonides>	 I think it must be triggering a tablescan somehow
[01:16:53] <Platonides>	 also note, it returns 10 rows
[01:17:09] <wm-bb>	 <jeremy_b> there was a version with limit 10
[01:17:12] <wm-bb>	 <jeremy_b> earlier
[01:17:32] <Platonides>	 it can return any of the 10 revisions there
[01:17:33] <wm-bb>	 <jeremy_b> how did you get that? (re @wmtelegram_bot: <Platonides> also note, it returns 10 rows)
[01:17:49] <Platonides>	 by setting a larget LIMIT
[01:17:56] <Platonides>	 I don't mean the LIMIt 1 doesn't work
[01:18:06] <Platonides>	 just that it can return multiple things
[01:34:22] <Rook>	 It looks kind of like revision is being compared to itself. Is "revision p" a leftover from when "page" was being called, and now things are getting confused by r and p being basically the same?
[01:34:43] <Rook>	 https://quarry.wmcloud.org/query/68448 seems to work
[01:34:54] <wm-bb>	 <jeremy_b> self join was intentional (re @wmtelegram_bot: <Rook> It looks kind of like revision is being compared to itself. Is "revision p" a leftover from when "page" was being called,...)
[01:36:08] <wm-bb>	 <jeremy_b> and works fine on toolforge bastion
[01:37:12] <wm-bb>	 <jeremy_b> p is not short for page
[01:37:14] <wm-bb>	 <jeremy_b> is parent
[01:37:41] <Platonides>	 I would have used an explicit JOIN, this is old-style SQL, but nevertheless, it should work
[01:39:03] <wm-bb>	 <jeremy_b> does quarry have a mode to get more debugging?
[01:40:38] <wm-bb>	 <jeremy_b> anyway I was working on this project with someone, would help to get them shell also. when y'all have a chance.
[01:40:39] <wm-bb>	 <jeremy_b> https://toolsadmin.wikimedia.org/tools/membership/status/1343
[01:42:41] <Rook>	 membership approved
[10:04:15] <Deus>	 !log wikisp Rebuild mars-01 (T321763)
[10:04:17] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Wikisp/SAL
[10:04:17] <stashbot>	 T321763: [ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist in engine - https://phabricator.wikimedia.org/T321763
[10:04:23] <wm-bot>	 !log tools.notwikilambda <lucaswerkmeister> stopped webservice, wiki is being retired (T314880)
[10:04:25] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL
[10:22:02] <wm-bot>	 !log tools.notwikilambda <lucaswerkmeister> start webservice again (PHP 7.4 now) with new lighttpd config to rewrite everything to a very bare index.html explaining the shutdown (T314880); partial SQL dump available in public_html too
[10:22:05] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL
[10:30:31] <wm-bot>	 !log tools.bridgebot <lucaswerkmeister> Double IRC messages to other bridges
[10:30:33] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.bridgebot/SAL
[10:34:41] <wm-bot>	 !log tools.notwikilambda <lucaswerkmeister> kubectl delete deployment function-evaluator function-orchestrator pygments-server
[10:34:42] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL
[10:34:52] <wm-bot>	 !log tools.notwikilambda <lucaswerkmeister> kubectl delete deployment function-evaluator function-orchestrator pygments-server (T314880)
[10:34:53] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL
[10:38:24] <taavi>	 lucaswerkmeister: do you want to try T321990 by yourself? docs are at https://wikitech.wikimedia.org/wiki/Portal:Toolforge/Admin/Kubernetes#Quota_management
[10:38:24] <stashbot>	 T321990: Reset notwikilambda Toolforge tool quotas - https://phabricator.wikimedia.org/T321990
[10:47:48] <wm-bb>	 <lucaswerkmeister> taavi: oops, sorry about the wrong subscriber/project on t321990
[10:48:25] <taavi>	 no worries, also see my question above
[10:51:03] <wm-bb>	 <lucaswerkmeister> ah, I almost missed that question, thanks
[10:51:08] <wm-bb>	 <lucaswerkmeister> right, I suppose I could do it myself ^^
[10:51:13] <wm-bb>	 <lucaswerkmeister> yeah I’ll give it a go
[10:53:02] <wm-bb>	 <lucaswerkmeister> and I’ll just copy the quota values from a random other tool that has the default quotas?
[10:58:01] <wm-bot>	 !log tools.notwikilambda <lucaswerkmeister> kubectl delete service function-evaluator function-orchestrator pygments-server # T314880
[10:58:04] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL
[11:00:37] <wm-bot>	 !log tools.notwikilambda <lucaswerkmeister> lowered notwikilambda quotas: count/deployments.apps from 5 to 3, services from 4 to 1 (T321990)
[11:00:39] <stashbot>	 Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.notwikilambda/SAL
[17:03:07] <wm-bb>	 <Kennedy> https://t.me/SpamBot