[01:25:24] <SothoTalKer>	 https://www.wikidata.org/wiki/User_talk:Magnus_Manske/authority_control.js#Missing_identifiers_&_a_bug_that_leads_to_database_pollution
[07:26:16] <reosarevok>	 SothoTalKer: one is Estonian for Grimm Brothers, one is Russian for the same, and then a Russian and Estonian for each brother
[07:26:22] <reosarevok>	 It feels 4 of those don't belong here?
[09:19:23] <icinga-wm>	 PROBLEM - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is CRITICAL: HTTP CRITICAL: HTTP/1.1 200 OK - pattern not found - 1972 bytes in 0.098 second response time
[09:39:22] <icinga-wm>	 RECOVERY - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is OK: HTTP OK: HTTP/1.1 200 OK - 1967 bytes in 0.123 second response time
[09:43:55] <nikki>	 reosarevok: yeah, they have other ids for the other brother and the brothers as a group
[09:53:25] <frickel>	 hi
[09:53:44] <frickel>	 can I express somehow that a work is someones favorite?
[10:38:40] <JLJAdmin>	 Hi, is there anyone here that could help with a math error on a new wikibase install?
[10:39:05] <JLJAdmin>	 This is the error https://www.irccloud.com/pastebin/isNRL2FB/Internal%20error
[10:41:37] <JLJAdmin>	 any pointers to what could be causing it would be good
[11:03:30] <hasharAway>	 JLJAdmin: nobody works today :) You might want to fill a task in https://phabricator.wikimedia.org/  and mention how to reproduce the issue
[11:04:46] <JLJAdmin>	 ok
[12:44:49] <stephanebisson>	 Hi, I'm looking for some help with a wikidata query. It's to troubleshoot an issue with a map with a geoshape overlay based on a query.
[13:25:09] <SothoTalKer>	 stephanebisson: did you get help already? :-)
[13:25:27] <stephanebisson>	 SothoTalKer: nope, can you help?
[13:26:09] <SothoTalKer>	 i don't know, i'm just a normal user and by far no expert, but i could give it a try.
[13:26:46] <stephanebisson>	 This is my query: http://tinyurl.com/ybpgtrnx
[13:26:59] <stephanebisson>	 it returns US states with head of gov.
[13:27:25] <stephanebisson>	 The problem is it returns 2 rows for New Hampshire because the data contains 2 heads of gov (for different periods)
[13:27:58] <stephanebisson>	 I would like to filter out the one with a 'end time' (P582)
[13:28:23] <nikki>	 change the rank of the current one to preferred and it should only return that one
[13:28:34] <Lucas_WMDE>	 I was just about to say that :)
[13:28:59] <stephanebisson>	 Sounds promising... what do you mean by "change the rank"?
[13:29:15] <nikki>	 when you edit a statement, there are some arrows on the left
[13:29:26] <Lucas_WMDE>	 https://www.wikidata.org/wiki/Help:Ranking#How_to_apply_ranks
[13:29:56] <stephanebisson>	 ohh nice, let me try that
[13:33:06] <SothoTalKer>	 Lucas_WMDE: but what if someone wants to get all the heads of gov for a state? :D
[13:33:15] <SothoTalKer>	 current + past ones
[13:33:23] <Lucas_WMDE>	 SothoTalKer: then you use full statements instead of truthy ones
[13:33:36] <Lucas_WMDE>	 they don’t completely vanish from the query service :)
[13:33:50] <Lucas_WMDE>	 but the wdt: shortcut is for the “current”/“best” value
[13:35:07] <stephanebisson>	 That worked, thanks a lot!
[13:35:11] <Lucas_WMDE>	 \o/
[13:35:32] <stephanebisson>	 But I am aware this can break again when the data changes, we'll have to look at better error handling in maps overlays.
[13:35:38] <SothoTalKer>	 ah, i see. so it returns always the "best" result available. If none is set to preferred it returns the list of equally ranked statements.
[13:35:51] <Lucas_WMDE>	 indeed
[13:35:59] <Lucas_WMDE>	 also, it never returns deprecated statements, even if they’re the only ones
[13:51:22] <icinga-wm>	 PROBLEM - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is CRITICAL: HTTP CRITICAL: HTTP/1.1 200 OK - pattern not found - 1971 bytes in 0.099 second response time
[13:51:33] <hoo>	 oho
[13:51:55] <hoo>	 hm, we're at 600 edits/minute
[13:53:47] <hoo>	 should be fine again
[13:56:22] <icinga-wm>	 RECOVERY - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is OK: HTTP OK: HTTP/1.1 200 OK - 1954 bytes in 0.081 second response time
[13:57:23] <SothoTalKer>	 poor database servers
[15:48:32] <icinga-wm>	 PROBLEM - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is CRITICAL: HTTP CRITICAL: HTTP/1.1 200 OK - pattern not found - 1967 bytes in 0.099 second response time
[15:53:32] <icinga-wm>	 RECOVERY - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is OK: HTTP OK: HTTP/1.1 200 OK - 1945 bytes in 0.118 second response time
[16:08:09] <SothoTalKer>	 hm
[16:08:24] <SothoTalKer>	 I do not see a valid reason to keep deprecated identifiers: https://www.wikidata.org/wiki/Q5700587
[16:19:36] <SothoTalKer>	 https://www.wikidata.org/wiki/Help:Ranking#Deprecated_rank - point one applies, maybe
[18:35:01] <nikki>	 SothoTalKer: yeah, viaf links that id to that item, so if we just remove it, it looks like it's just a missing id that should be re-added, but marking it as deprecated makes it clear that we know it's wrong
[18:36:50] <SothoTalKer>	 it would be better to inform VIAF about the wrong link.
[18:37:07] <nikki>	 but what do you do while you wait for them to fix it?
[18:38:00] <SothoTalKer>	 i bet VIAF does not check for deprecation. neither does the constraint violation tool
[18:38:14] <nikki>	 then they should!
[18:40:06] <SothoTalKer>	 they should do a lot of things ;)
[18:40:21] <nikki>	 indeed
[18:40:48] <SothoTalKer>	 i guess they need a poke or two.
[19:15:52] <icinga-wm>	 PROBLEM - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is CRITICAL: HTTP CRITICAL: HTTP/1.1 200 OK - pattern not found - 1966 bytes in 0.090 second response time
[19:20:08] <hoo>	 :/
[19:20:52] <icinga-wm>	 RECOVERY - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is OK: HTTP OK: HTTP/1.1 200 OK - 1978 bytes in 0.106 second response time