[01:16:48] <icinga-wm>	 PROBLEM - High lag on wdqs1003 is CRITICAL: 3603 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen
[03:18:59] <icinga-wm>	 PROBLEM - WDQS HTTP Port on wdqs1004 is CRITICAL: HTTP CRITICAL: HTTP/1.1 502 Bad Gateway - 380 bytes in 0.001 second response time
[03:21:08] <icinga-wm>	 PROBLEM - Check systemd state on wdqs1004 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed.
[03:21:18] <icinga-wm>	 RECOVERY - WDQS HTTP Port on wdqs1004 is OK: HTTP OK: HTTP/1.1 200 OK - 434 bytes in 0.021 second response time
[03:22:09] <icinga-wm>	 RECOVERY - Check systemd state on wdqs1004 is OK: OK - running: The system is fully operational
[05:18:58] <icinga-wm>	 PROBLEM - High lag on wdqs1005 is CRITICAL: 3.041e+04 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen
[05:20:19] <icinga-wm>	 PROBLEM - wikidata.org dispatch lag is REALLY high ---4000s- on www.wikidata.org is CRITICAL: HTTP CRITICAL: HTTP/1.1 200 OK - pattern not found - 1979 bytes in 0.063 second response time
[05:40:49] <icinga-wm>	 RECOVERY - wikidata.org dispatch lag is REALLY high ---4000s- on www.wikidata.org is OK: HTTP OK: HTTP/1.1 200 OK - 1977 bytes in 0.079 second response time
[06:32:58] <icinga-wm>	 PROBLEM - High lag on wdqs1003 is CRITICAL: 3620 ge 3600 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen
[07:01:18] <icinga-wm>	 RECOVERY - High lag on wdqs1004 is OK: (C)3600 ge (W)1200 ge 1024 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen
[07:31:19] <icinga-wm>	 RECOVERY - High lag on wdqs1003 is OK: (C)3600 ge (W)1200 ge 1178 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen
[07:33:56] <reosarevok>	 Is there a way to get (via petscan or whatever) a list of how many wikis do have an article for each page in a wiki category?
[07:34:46] <reosarevok>	 nikki: maybe you know :)
[08:46:00] <nikki>	 reosarevok: the only thing I can think of is doing a sql query in quarry
[08:46:27] <nikki>	 there might be other ways but if so, I don't know about them
[08:46:31] <reosarevok>	 Hmm
[08:46:48] <reosarevok>	 Does query.wd allow something like "for item in {QXXX, QXXX}"?
[08:47:00] <reosarevok>	 (if so I could get the Qs from Petscan and then run that)
[08:47:19] <nikki>	 yes, "values ?item { wd:Qxxx wd:Qyyy }"
[08:48:36] <nikki>	 hm... wonder if the mw api support can get category members... I tried before and couldn't do it but maybe I did something wrong
[08:49:28] <nikki>	 do you have a category I can test with?
[08:50:17] <reosarevok>	 https://et.wikipedia.org/wiki/Kategooria:Eestit_v%C3%A4isanud_prominendid is the one we're looking at
[08:50:44] <nikki>	 oh I think I remember... it didn't used to fetch all pages of results when doing api queries, so even with a generator it didn't work right
[08:50:57] <nikki>	 ok
[08:51:19] <nikki>	 but that changed at some point, since I then reported two issues with it fetching all the results :P
[08:56:32] <nikki>	 http://tinyurl.com/y72bxqdo I think?
[08:56:52] <reosarevok>	 Huh. I got different numbers :D
[08:56:54] <reosarevok>	 LEt's compare
[08:57:07] <reosarevok>	 Oh, you used the API
[08:58:01] <nikki>	 yeah, after I remembered that that should work now, I figured I should try :P
[08:59:50] <reosarevok>	 Hmm. Why does FILTER regex(?article, ".wikipedia.org/") . not work
[08:59:54] <reosarevok>	 Do I need to escape something?
[09:00:59] <reosarevok>	 (one example in the query examples has   FILTER (SUBSTR(str(?article), 11, 15) = ".wikipedia.org/") . but that seems like it would only work for wikis with a specific lang name length ?)
[09:00:59] <nikki>	 you can use schema:isPartOf/wikibase:wikiGroup "wikipedia"
[09:01:35] <nikki>	 and you probably need to use str(?article) rather than just ?article
[09:01:43] <reosarevok>	 Oh, ok :)
[09:01:57] <reosarevok>	            schema:isPartOf/wikibase:wikiGroup "wikipedia". seems to take forever :/
[09:02:34] <reosarevok>	 huh :D
[09:02:37] <nikki>	 it does sometimes but http://tinyurl.com/yaaf7e6l took 1.8 seconds for me
[09:02:39] <reosarevok>	 I still get different numbers
[09:02:44] <nikki>	 (will be faster now that it's cached)
[09:03:10] <reosarevok>	 http://tinyurl.com/yb22q5lg :/
[09:05:10] <nikki>	 I'm getting the same numbers as far as I can tell
[09:05:18] <nikki>	 which one isn't the same for you?
[09:05:24] <nikki>	 (which item, I mean)
[09:05:55] <reosarevok>	 Well my highest seems to be Michael Jackson with 231, but your API query has 264
[09:06:12] <reosarevok>	 And Obama has 300 for you, but 227 for me :/
[09:06:17] <reosarevok>	 (with the regex)
[09:06:30] <reosarevok>	 I did say DISTINCT though, wonder if some are dupes?
[09:07:14] <nikki>	 264 includes the non-wikipedia ones
[09:08:27] <reosarevok>	 Oh
[09:08:29] <reosarevok>	 Ok
[09:08:39] <reosarevok>	 Yay then :D
[09:08:40] <nikki>	 in the second link where I said it took 1.8 seconds, I get 230, since I did count(*) - 1 (since obviously etwiki has a page :P)
[09:09:14] <reosarevok>	 Ok, if we agree then I guess the results are sane :D
[09:09:18] <reosarevok>	 Will send them to the guy who asked
[09:09:20] <reosarevok>	 Thanks!!!
[09:09:42] <nikki>	 no problem :)
[09:10:17] <reosarevok>	 Should https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples#Numbers_of_sitelinks_for_items_with_Art_UK_artist_ID_(P1367)_for_each_language be changed?
[09:10:24] <reosarevok>	 I'm fairly sure that query is kinda bogus
[09:14:29] <nikki>	 I think so, yes, but I'm having trouble getting it to not time out :/
[09:14:33] <nikki>	 (the fixed version)
[09:15:33] <nikki>	 I guess your regex works
[09:16:31] <nikki>	 and it returns a bunch of three-letter language codes too
[10:57:31] <nikki>	 Lucas_WMDE: any idea why https://query.wikidata.org/#select%20%2a%20%7B%0A%20%20wd%3AQ1707%20p%3AP625%2Fpsv%3AP625%20%3Fa%20.%0A%20%20%3Fa%20%3Fp%20%3Fv%20.%0A%7D returns multiple values for lat/lon/precision?
[10:57:57] <nikki>	 looking at the json, it seems that there's one set of xsd:decimal and one set of xsd:double but that doesn't explain why there's two sets
[10:58:13] <nikki>	 and https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Globe_coordinate only mentions decimal
[10:59:49] <Lucas_WMDE>	 well Special:EntityData returns xsd:double
[10:59:53] <Lucas_WMDE>	 weird
[11:00:21] <Lucas_WMDE>	 if it changed at some point, then the xsd:decimal triples are probably older ones that weren’t cleaned, and xsd:double are the newer ones
[11:03:34] <nikki>	 hm
[11:04:29] <Lucas_WMDE>	 okay, apparently it was changed from decimal to double in https://gerrit.wikimedia.org/r/c/mediawiki/extensions/Wikibase/+/387754
[11:04:40] <Lucas_WMDE>	 so a) if the documentation still says xsd:decimal, um, oops
[11:04:46] <Lucas_WMDE>	 and b) apparently we should have reloaded WDQS after that
[11:05:00] <Lucas_WMDE>	 (no, wait, wasn’t there at least one reload for unrelated reasons since November 2017?)
[11:05:26] <nikki>	 I don't know, I was taking a long break then
[11:05:52] <nikki>	 updating the docs is at least easy :)
[11:07:19] <Lucas_WMDE>	 okay, I’ll update the documentation and open a task for the extra triples
[11:07:24] <Lucas_WMDE>	 thanks for noticing :)
[11:08:03] <nikki>	 thanks for helping :D
[11:09:52] <icinga-wm>	 RECOVERY - High lag on wdqs1005 is OK: (C)3600 ge (W)1200 ge 1142 https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1&panelId=8&fullscreen
[20:09:20] <koom>	 hi, why does this query return 0 results? "select ?x where { ?x wdt:P31 wdt:Q427626 .}". Q427626 is "taxonomic rank", P31 is "instance of", and i expect to get "species" (Q7432)
[20:17:00] <abian>	 Hi, koom
[20:17:16] <abian>	 You should use wd:Q427626 instead of wdt:Q427626
[20:17:38] <abian>	 wdt is just for properties
[20:26:47] <koom>	 abian, i see, thanks!
[20:27:11] <abian>	 :D
[20:35:47] <abian>	 Hi, Arkanosis :)
[20:36:26] <abian>	 Arkanosis: Is [[User:Skabiosis]] a fan of yours? :)
[20:36:26] <AsimovBot>	 10[1] 04https://www.wikidata.org/wiki/User:Skabiosis