[05:05:18] Platonides: Q241 has a "sovereign state" statement with a preferred rank, if you change wdt:P31 to p:P31/ps:P31 you should get all statements instead of only the most preferred [05:14:18] PROBLEM - Check systemd state on wdqs1003 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:15:54] PROBLEM - wikidata.org dispatch lag is REALLY high ---4000s- on www.wikidata.org is CRITICAL: CRITICAL - Socket timeout after 10 seconds https://phabricator.wikimedia.org/project/view/71/ [05:23:24] PROBLEM - Check systemd state on wdqs1005 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:23:54] PROBLEM - Check systemd state on wdqs1009 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:27:16] RECOVERY - Check systemd state on wdqs1003 is OK: OK - running: The system is fully operational https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:30:30] PROBLEM - Check systemd state on wdqs1006 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:31:02] PROBLEM - Check systemd state on wdqs1010 is CRITICAL: CRITICAL - degraded: The system is operational but one or more units failed. https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:38:38] RECOVERY - Check systemd state on wdqs1007 is OK: OK - running: The system is fully operational https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:39:02] RECOVERY - Check systemd state on wdqs1009 is OK: OK - running: The system is fully operational https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:39:06] RECOVERY - wikidata.org dispatch lag is REALLY high ---4000s- on www.wikidata.org is OK: HTTP OK: HTTP/1.1 200 OK - 1737 bytes in 0.098 second response time https://phabricator.wikimedia.org/project/view/71/ [05:49:30] RECOVERY - Check systemd state on wdqs1005 is OK: OK - running: The system is fully operational https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:55:08] RECOVERY - Check systemd state on wdqs1010 is OK: OK - running: The system is fully operational https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [05:56:26] RECOVERY - Check systemd state on wdqs1006 is OK: OK - running: The system is fully operational https://wikitech.wikimedia.org/wiki/Monitoring/check_systemd_state [10:56:03] nikki: it happened again :| [10:57:47] looks like it happens every time i do an edit [11:02:10] hm, now its gone [12:03:00] strange [14:56:50] Hmm. I must be stupid here, I'm trying out an example of querying Wikidata from Python using SPARQL. The SPARQL query is here: https://w.wiki/Mek [14:57:14] It is to give the population, area, average income and "age" of the EU countries. [14:57:23] Sweden is listed 4 times and Poland twice. [14:58:05] The reason appears to be that Sweden has 4 areas listed (P2046) and Poland two inceptions (P571) [14:58:10] yeah [14:58:36] None of the Swedish areas was marked preferred, so I took a deep breath and marked the one from the national survey as preferred. [14:58:49] you can either set one of them as preferred rank (if that's the right thing to do) or use sample() and group by [14:58:51] Still the same result. Is this perhaps just a cacheing problem. [14:58:59] probably, it takes a while to update [14:59:10] Okay, it's a holiday ;) Happy Easter [14:59:31] if you hover over the circular arrows at the bottom right of the edit field, it'll tell you how out of sync it is [14:59:53] Poland's inception is once when the current state was founded and once when the Kingdom of Poland was founded. Seems like the first should be preferred, or? [15:00:08] Ah, I never knew what the symbol was for :) [15:00:26] Okay, 13 minutes ago was the last update. [15:00:43] That means I need to have a coffee before checking to see if it worked - thanks! [15:02:10] https://w.wiki/Mem here's a version using sample/group by, that just picks a random value when there's multiple [15:02:32] (er, picks one of the values at random, not *any* random value) [15:02:54] Really random, or the first one and calls it random? [15:03:28] I don't know how it works, I assume it does something like pick the first one [15:03:34] Good, now it just has the silly "Kingdom of Netherlands" / "Netherlands" problem [15:03:41] Both are marked as members of the EU :) [15:03:45] fun [15:04:36] Gäh [15:05:00] I will be teaching semantic modeling this term and want some fun examples [15:05:17] I suppose this is fun to show that semantics aren't perfect :) [15:09:11] Now it works without sample for Sweden, thanks!! [15:09:48] :) [15:19:44] so many qualifiers... https://www.wikidata.org/wiki/Q90283687 ugh [15:21:39] it's almost like it would make sense to not have every platform on a single item [15:26:05] +11 [19:28:40] I hate external data providers who never sanitize (or otherwise "standardize" their data [20:08:52] Hi, few last days, Czech community members noticed saving edits to Wikidata is much slower than usual (seconds, sometimes). Any guess which Phab task that might be?