[19:52:58] Is it just me or is toolforge having a bad day? [19:53:02] let’s see if someone else reverts it I guess [19:53:04] I think I may have stumbled onto why some of Magnus's tools are failing for folks when the client-side browser is making API calls - accessing " https://wikimedia.org/api/rest_v1/metrics/pageviews/..." might be a false positive filtered by ad blockers because of "metrics" in the URL [19:53:10] hey! Is there any technical way that the left-right arrows instead of opening another page load another table? Like having a hidden March/April... that is shown on click? : https://tools-static.wmflabs.org/bridgebot/18f2b6e0/file_45410.jpg [20:01:22] Hey folks! Trying to find out how many users are creating items on Wikidata using a particular tool − through the edit comment used. I got as far as https://quarry.wmcloud.org/query/71333 but that has been running for hours now. (a simpler version with a LIMIT was returning the correct edits, so at least the `comment_text like` part should be correct. [20:02:29] "for hours now"...was it killed when the cloud services servers went down? (re @JeanFred: Hey folks! Trying to find out how many users are creating items on Wikidata using a particular tool − through the edit comment u...) [20:03:02] Fair enough ; Stopped the query and submitted it again :) (re @mahir256: "for hours now"...was it killed when the cloud services servers went down?) [20:03:34] (My money is still on me doing something stupid in SQL :p ) [20:05:23] that looks like an inherently slow query to me :/ [20:05:48] but I notice Alicia’s version filtered by rev_timestamp – if these are recent edits, then adding a filter like that should speed up the query a lot, I think [20:07:02] (I think the current version of the query has to scan the whole revision table *and* the whole comment table, because neither rev_comment_id nor comment_text are usefully indexed) [20:33:53] Oki, let’s try again with https://quarry.wmcloud.org/query/71337 (re @lucaswerkmeister: but I notice Alicia’s version filtered by rev_timestamp – if these are recent edits, then adding a filter like that should speed...) [20:51:17] @fuxheado: All of Cloud VPS has had a bad day, but things should be recovered now. See https://lists.wikimedia.org/hyperkitty/list/cloud-announce@lists.wikimedia.org/thread/3IPA3YL7XVRF5WRF3RG27EKRRU7NBRLR/ [20:51:48] argh. @fuzheado ^ [21:03:15] ``` [21:03:16] Query status: complete [21:03:18] Executed in 991.50 seconds [21:03:19] ``` [21:03:21] [21:03:22] \o/ (re @lucaswerkmeister: but I notice Alicia’s version filtered by rev_timestamp – if these are recent edits, then adding a filter like that should speed...) [21:03:58] yay [21:11:14] @JeanFred: https://quarry.wmcloud.org/query/71333 is going to do a full table scan on the comment table which has so many rows that a simple `select count(*) from comment` has been running for a couple of minutes now. The rev_timestamp limit should help a lot by trimming rows from the full scan. The `limit 5` is not really going to make things faster because the `group by` will require all results to be found and then all but the first 5 [21:11:14] to be thrown out. [21:13:04] There is no index on the comment_text field, so the leading wildcard in that like comparison isn't technically making anything worse. [21:19:01] Forwarded from fuzheado: Most services are back but Petscan is dead - https://petscan.wmflabs.org/ [21:38:37] @fuzheado: petscan should be working again now. Unfortunately Magnus has not set that up to restart automatically. Someone has to ssh into the instance, become Magnus' user, start a `screen` process, and finally start his custom service to make it work. https://wikitech.wikimedia.org/wiki/Nova_Resource:Petscan#Starting_the_service [21:39:10] Thanks much for the update [21:43:11] I had no idea that other tools like GLAMorgan invoked Petscan to act as a generator of filenames. It makes sense, but I'd never seen that connection before. [21:50:50] I figured out that GLAMorgan is majorly affected by ad blocking. I added more info here: https://meta.wikimedia.org/wiki/GLAMorgan