[07:44:07] Morning. Can anyone help me optimise this sparkql to actually resolve the country names? https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3F_Country%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ5398426%3B%0A%20%20%20%20%20%20%20%20rdfs%3Alabel%20%22The%20Crown%22%40en.%0A%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%3Fitem%20wdt%3AP495%20%3F_Country.%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wi [07:44:07] kibase%3Alanguage%20%22en%22.%20%7D%0A%7D [07:44:14] let me shorten it.e eek [07:44:37] http://bit.ly/2B1TiEf [07:49:11] jackiewackie: should suffice to add ?_CountryLabel to the first line [07:54:13] let me try :) [07:54:26] great thank you [08:12:27] Is it possible to also get the associated ISO 3166-1 alpha-2 code? [08:12:29] P297 [08:23:20] jackiewackie: "?_Country wdt:P297 ?ISO" as another line inside OPTIONAL and adding ?ISO to the selected list should do the trick I think? [08:23:55] amazing, thank you [08:43:20] this "slow user interface bug" is really annoying :-( [08:43:36] https://phabricator.wikimedia.org/T182322 [08:43:38] So it's not just me, it's horribly slow for everyone [08:43:40] Yay! [08:43:48] (of sorts) [08:43:53] anyone able to tell when its going to be solved? [08:44:57] "An entity with heritage designation should also have a statement located in the administrative territorial entity." What is the administrative territorial entity for something in the territorial sea of a country? The country itself? (this is a shipwreck) [08:46:50] if this is the most specific administrative territorial entity at the site, it sounds intuitively okay at least [08:51:45] in my experience, one way to mitigate the "slow UI bug" is to disable a few gadgets (if you have some) [08:53:02] yes I have, but which ones? [08:54:15] I disabled the user scripts commented out here: https://www.wikidata.org/wiki/User:Pintoch/common.js [08:54:43] i'm not sure about the gadgets anymore :-/ [08:55:55] looks like particularly API calls are slow [08:56:13] but not always^^ [08:59:26] Yeah - I have the same that T ticket says - works fine for a bit, then it doesn't [08:59:32] same here [08:59:58] after a couple of requests, each further API call takes some 5.5 seconds or so [10:09:51] *cough* https://www.wikidata.org/wiki/Special:Contributions/Khalilmater1995 *cough* [10:15:12] I find that Wikidata has been slow in the last couple of days. https://www.wikidata.org/w/api.php?action=wbparsevalue take over 5 seconds to return [10:21:28] fnielsen: yes, there seems to be some performance problem, we’re not yet sure what it is. see https://phabricator.wikimedia.org/T182322 [10:25:23] I have found the task: https://phabricator.wikimedia.org/T182322 [10:25:48] Ok. I see that @Lucas_WMDE also pointed to that. [10:26:10] ah, I was wondering if I was muted or something :D [10:30:40] No. I just need to read the full line :) [10:35:24] hi! anyone in touch with the toolforge admins? I made a membership request a few days ago but couldn't get through so far https://toolsadmin.wikimedia.org/tools/membership/status/182 [10:38:08] what is going on last days the performance is really worse..... ? [10:38:09] https://grafana.wikimedia.org/dashboard/db/wikidata-edits?refresh=1m&orgId=1&from=now-2d&to=now [10:45:59] Placed a message here: https://www.wikidata.org/wiki/Wikidata:Project_chat#problem_with_Special:Watchlist_&_Wikidata_is_slow [12:03:07] Lucas_WMDE: undid that, was the "cough" for something else? :p [12:03:26] Rudolphous: https://phabricator.wikimedia.org/T182322 [12:03:44] yes, found the ticket [12:03:54] Just in case :) [12:03:54] looks like the issue is also pinpointed now [12:03:59] reosarevok: the cough was for nothing in particular – after all, it’s not my place to perform or suggest edits while I’m wearing the WMDE hat ;) [12:04:09] thanks :-) [12:04:19] Oh [12:04:31] * reosarevok is still not fully aware of the limits of that stuff :) [12:04:41] neither am I :D [12:04:42] Well anyway your throat might be better now [13:01:53] https://www.wikidata.org/wiki/User%3AReosarevok%2FEstonian_politics%2FVallad finally done-ish with the basic bits of merged municipalities I think... [13:02:11] Is there any one-click way to add "replaces X" on the other side of "replaced by X"? [13:02:23] Because doing all these by hand is over even my limit of tedious crap [13:05:05] * Lucas_WMDE puts on WikidataFacts hat [13:05:18] reosarevok: you could paste the results of this query into QuickStatements http://tinyurl.com/y934zudq [13:05:45] ideally, you would edit the query so that it only affects the items you edited, and not random other stuff where the correct thing might actually be to remove the statement instead of adding a second one [13:05:57] * reosarevok first looks into QuickStatements to begin with [13:06:07] I should have done this a while ago, shouldn't I :D [13:06:20] it’s a very useful tool :) [13:07:15] So I can use this instead of a bot to do stuff that is a bit... bot-y. What's the acceptable limit? [13:07:25] (since bots need community approval, yet this does not) [13:09:12] not sure, and I also can’t see anything about that question on https://www.wikidata.org/wiki/Help:QuickStatements [13:09:59] I mean, this one seems harmless enough, but I suspect there's a limit :) Oh well, I'll just be conservative [13:16:30] reosarevok: for instance, if you’ve been working on Estonian items, I would use this query http://tinyurl.com/y86cts7d instead of the one I posted above [13:16:43] only 200 instead of almost 4000 results [13:16:52] so all those other results might be unrelated stuff [13:16:59] I'm being even more conservative, and specifically looking only at municipalities :) [13:17:26] Thanks for the help! This also means no adding country - Estonia to stuff by hand anymore, yay [13:18:00] yay, now you’ll be able to edit more efficiently \o/ [13:18:22] \o/ [13:18:43] Any other super-useful tools I might not have heard of? [13:19:04] (I already use the "see constraints issues" tool, that's how I figured out this was missing in the first place :) ) [13:19:06] I think QuickStatements is the really big one [13:19:27] what tool is that? the checkConstraints gadget? [13:19:38] or something external I’m not aware of? [13:19:47] Yeah, that :) [13:19:56] I haven't really activated many gadgets at all, other than that and merge [13:20:09] cool! it’s great to hear people use that stuff [13:21:20] https://www.wikidata.org/wiki/User%3AReosarevok%2FEstonian_politics%2FVallad already looks much better :) [13:22:07] I see some old municipalities are P31 https://www.wikidata.org/wiki/Q26742250 and some https://www.wikidata.org/wiki/Q19953632 (and most neither). I guess maybe one of the two would make sense. [13:23:26] How does preferred rank work with queries? [13:23:46] If I set "preferred" to "former municipality" or whatever, would the results still come up when searching for the other P31s? [13:23:59] not if the queries use wdt:P31 [13:24:13] https://www.mediawiki.org/wiki/Wikibase/Indexing/RDF_Dump_Format#Truthy_statements [13:25:39] Hmm, ok. So they would need to use wds + p instead? [13:26:26] Hmm. On one hand it seems useful to be able to say "currently, this is a former municipality", but at the same time, it would seem useful to be able to query for all municipalities unless I specifically requested only current ones :/ [13:26:26] yes [13:26:40] (for a normal user without needing to learn more stuff I mean) [13:27:02] well former municipality is a subclass of municipality [13:27:28] so any query that takes subclasses into account – which is necessary anyways for stuff like “municipality of $country” afaict – will still include former municipalities, right? [13:27:47] Hmm, so a query for subclass of municipality of Estonia, rather than my current union of p31 of all different types, would work for that, huh [13:28:40] I guess so :) Of course, it still doesn't help for when I want only *one* type (they have slightly different government organs), but on the other hand, creating even further Qs for "former municipality of Estonia of type X" might be overkill [16:09:25] I wanted to do a lot of editing but... :( [16:51:05] sjoerddebruin: you can always edit MusicBrainz, it's working fine ;p [16:51:46] (or start writing the bot to add positions and stuff when you're done? :) ) [18:06:50] https://www.wikidata.org/w/index.php?title=Wikidata:Database_reports/Constraint_violations/Mandatory_constraints/Violations&action=history has reached its lowest point since the end of July, though. [18:51:23] PROBLEM - High lag on wdqs1003 is CRITICAL: CRITICAL: 30.00% of data above the critical threshold [1800.0] https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1panelId=8fullscreen [19:11:45] PROBLEM - Check systemd state on wdqs1003 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. [19:12:21] hew, how I page back on new wikidata recent changes page? I can see the latest ones but there's no link to go back [19:27:44] RECOVERY - Check systemd state on wdqs1003 is OK: OK - running: The system is fully operational [20:17:25] RECOVERY - High lag on wdqs1003 is OK: OK: Less than 30.00% above the threshold [600.0] https://grafana.wikimedia.org/dashboard/db/wikidata-query-service?orgId=1panelId=8fullscreen [20:42:15] We can clearly see that editing speed is back to normal. ;) https://grafana.wikimedia.org/dashboard/db/wikidata-edits?refresh=1m&panelId=1&fullscreen&orgId=1&from=now-24h&to=now [21:12:09] PROBLEM - Check systemd state on wdqs1003 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. [21:28:09] RECOVERY - Check systemd state on wdqs1003 is OK: OK - running: The system is fully operational