[10:43:36] Lucas_WMDE: do you remember the thing where when you combine two fast queries, you get one really slow query that times out? I've forgotten what the workaround was and wondered if you remember :/ [10:44:36] nikki: two named subqueries and then combine the results in the main query, perhaps? [10:48:32] nope :/ [10:48:54] I remember something involving some complicated stuff I had to copy and paste [10:49:04] and "gas" is coming to mind [10:52:06] hm [10:52:11] can you paste the query [10:52:13] ? [10:53:20] https://tinyurl.com/ydbvvp3h is the original one [10:54:08] I can't confirm that it actually times out, since my router gives up before then, but it's a lot slower than the separate queries [10:58:00] oh I did just get a timeout [11:02:32] oh, the suggestion on https://www.mediawiki.org/wiki/Wikidata_Query_Service/Problematic_queries#Hard_queries seems to help [11:02:53] the suggestion on https://phabricator.wikimedia.org/T116298#3142628 doesn't... [11:39:27] nikki: this works: http://tinyurl.com/yc64a2t4 [11:40:09] actually, once you force the order of the two lines, you don’t need the gearing hints anymore: http://tinyurl.com/yadxqy89 [11:40:39] but the optimizer needs to be told that there are less items located in Bonn than instances of thoroughfare [11:47:07] huh interesting [11:56:14] *clicks official website and sees Flash-only* [12:19:33] Still curious about the arbitrary choice of making more than 12 children suspicious. https://www.wikidata.org/wiki/Q52421098#P1971 [12:25:00] I could imagine that it would be difficult for women to have many more than that... but it probably made more sense before we displayed the violations on the pages [12:28:40] heh there are more people with exactly 13 than with exactly 12 [12:30:32] You can have multiple partners. [12:30:50] This one had 5 with his first one and 8 with his second [12:47:27] VIAF is slow... [13:13:55] hi @Lucas_WMDE I have a problem related to this ticket you opened https://phabricator.wikimedia.org/T190707 I would like to create a project named `wikidata-rank` (to host https://github.com/maxlath/wikidata-rank) but my attempts are rejected: did you find a work around? [13:15:25] maxlath[m]: no, in my case I ended up calling the tool “wdmm” instead of “wikidata-massmessage” :/ [13:17:48] Lucas_WMDE: ok, thanks, so I went for wd-rank, but that's definitely going to create some confusions :/ [13:17:53] yeah :/ [13:32:16] Lucas_WMDE: btw, do you know if Wikidata json dumps are accessible from tools servers? I see xml dumps but not json [13:32:35] hm, I thought they would be [13:37:17] maxlath[m]: /public/dumps/public/wikidatawiki/entities/latest-all.json.bz2 ? [13:46:39] Lucas_WMDE: nice! but unfortunately, when I log into a [kubernetes nodejs webservice](https://wikitech.wikimedia.org/wiki/Help:Toolforge/Web#node.js_web_services) using `webservice --backend=kubernetes nodejs shell` (which is required to do anything with a non-obsolete version of nodejs), I can't access mounted file systems (to which /public/dumps/public links) :/ [13:50:20] maxlath[m]: according to https://wikitech.wikimedia.org/wiki/Help:Shared_storage I think you need to request access to those directories for your tool? [14:04:49] Lucas_WMDE: the project seems to have access, but apparently not the subshell, I will ask in #wikimedia-cloud, thanks :) [14:41:37] for men it makes no sense ot have "more thna 12" as suspeicios. maybe for a woman but (odd numbers tend for osm reason to be more common in large nubmers of kids i've read about) [14:41:55] might be becasue there are twins and thne one kid and then 3 more etc that sort of thing [14:42:12] (just my 2 NOK) [14:44:54] Technical Advice IRC meeting starting in 15 minutes in channel #wikimedia-tech, hosts: @Tonina_WMDE & @Lucas_WMDE - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [15:06:33] my 2 øre would be better maybe.. [15:37:15] Hi, I'm trying to use the Wikidata Tools plugin for Google Sheets and for some reason it can't get any info from Wikidata, is there something broken at the moment? [16:09:41] 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 - 1965 bytes in 0.095 second response time [16:19:50] RECOVERY - wikidata.org dispatch lag is higher than 300s on www.wikidata.org is OK: HTTP OK: HTTP/1.1 200 OK - 1947 bytes in 0.097 second response time [16:50:19] So the Dutch description for Finnish contained a period since 2012... https://www.wikidata.org/w/index.php?title=Q1412&type=revision&diff=278600&oldid=278597 [16:55:19] cool [16:56:19] that’s amazing [16:56:39] It's not something positive :P [17:00:54] I can also call it awesome if you’d prefer, that’s technically not limited to positive things either :P [20:02:19] hello, how can you help me? [20:02:51] hello SothoTalKer [20:03:01] we can give you an smile [20:03:05] hello plato, sir, madame [20:03:05] ☺ [20:03:36] i want your opiuminion [20:03:42] *opinioin [20:04:33] hmmm [20:04:49] hey sjoerd, nice to see you. [20:04:56] SothoTalKer: it's better to ask for an oppinion in general [20:05:11] sure, what's yours on this: https://www.wikidata.org/wiki/User_talk:Magnus_Manske/authority_control.js#Missing_identifiers_&_a_bug_that_leads_to_database_pollution [20:05:22] and let people answer if they know the (a) solution [20:06:44] The missing properties in WD probably don't have their own service to show their data [20:06:56] The others just require carefully importing [20:07:10] but it seems like this is about some gadget... [20:07:15] or script [20:07:25] Excuse me, not completely sober. [20:07:33] yes, it's a script. [20:07:56] Magnus will probably fix it shortly [20:08:28] Hmm, don't get your hopes high. [20:08:48] he seems a bit busy currently. [20:11:18] well, i'll wait a few days, then i copy it to my userspace with the changes :)