[03:58:46] PROBLEM - High lag on wdqs1001 is CRITICAL: CRITICAL: 33.33% of data above the critical threshold [1800.0] [04:03:45] PROBLEM - High lag on wdqs1002 is CRITICAL: CRITICAL: 30.00% of data above the critical threshold [1800.0] [04:08:06] PROBLEM - High lag on wdqs1003 is CRITICAL: CRITICAL: 34.48% of data above the critical threshold [1800.0] [07:53:23] PROBLEM - puppet last run on wdqs1003 is CRITICAL: CRITICAL: Catalog fetch fail. Either compilation failed or puppetmaster has issues [08:20:32] RECOVERY - puppet last run on wdqs1003 is OK: OK: Puppet is currently enabled, last run 11 seconds ago with 0 failures [09:48:32] RECOVERY - High lag on wdqs1003 is OK: OK: Less than 30.00% above the threshold [600.0] [10:14:31] RECOVERY - High lag on wdqs1001 is OK: OK: Less than 30.00% above the threshold [600.0] [10:46:21] is there any way to import statements from RDF to Wikidata? (or is QuickStatements the closest approximation to that?) [10:48:52] it sounds possible at least for ground statements, but it seems harder to support qualifiers and references [11:44:14] pintoch: I'm not aware of anything that can do rdf. quickstatements is probably closest, like you said, and that's the only generic tool I know of that doesn't involve writing some sort of script [11:46:16] nikki: ok, thanks :) [12:00:24] https://www.wikidata.org/w/index.php?title=Q11571&diff=519427607&oldid=514293453 it was 3 years there... :/ [12:02:10] it's not very clear what is changed in this edit https://www.wikidata.org/w/index.php?title=Q15136093&diff=519002104&oldid=514524443 [12:03:08] Stryn: looks like the “penaldo” item was itself vandalized: https://www.wikidata.org/w/index.php?title=Q295574&type=revision&diff=486983849&oldid=442992679 [12:03:18] yeah I just realized it [12:04:33] and Aveiro seems to be his real family name, so I think the statement was actually correct [12:05:15] but it's a disambiguation page [12:05:21] oh, right [12:06:50] seems like there's no item for the surname [12:07:00] or family name whatever [15:26:14] nikki: you had a bot to sync discogs and musicbrainz right? [16:03:13] sjoerddebruin: a long time ago, but I don't have that data now [16:08:07] nikki: aww. [18:47:30] playing wikidata game "person", always click "not sure" when i get to "fictional person" in books/movies and "prophet/saint/deity" [18:47:57] are all the fictional characters i clear "no" for person? [18:48:01] a [18:48:42] also some are "maybe fictional/maybe historical" or it's hard to tell [18:48:51] like eh.. Robin Hood and stuff [18:49:44] the one i am looking at right now " private detective who is a protagonist in a book" [18:50:01] I would say "no" is right for clearly fictional ones, because we don't use Q5 for fictional people [18:50:50] I'm never sure either about ones which could be real people [18:57:33] *nod*, ok. yea.. thank you [18:58:04] Catholic saints too... how would i know if they were real people [18:58:33] adds button "it's complicated" [19:00:41] saints are generally historically documented, aren’t they? [19:00:55] except perhaps for the very first ones [19:02:10] but even Peter is instance of human https://www.wikidata.org/wiki/Q33923 [19:02:55] the only way to figure out if an item has more than one statement for a property is to use group by, isn't it? [19:03:07] I think so, yeah [19:03:09] bah [19:03:56] I want to select some items with their country, but only if there's only one country statement [19:04:23] if I didn't need the country, group by wouldn't be so awkward [19:04:36] but selecting that obviously breaks the grouping :P [19:04:38] WikidataFacts: oh, interesting. i see Jesus is "instance of human biblical figure" and "mythical character" and "deity". ok [19:05:20] hm... would "sample" work? haven't used that yet [19:06:02] i still won't be sure on all the deities in Indonesian and Malaysian but fair enough [19:06:23] nikki: not sure [19:06:42] I’d use HAVING(COUNT(?country) = 1) [19:07:03] and then probably just add *all* the SELECTed variables to the GROUP BY [19:07:29] wouldn't that just return both countries as separate rows? [19:07:47] oh, you want to select the country too? [19:07:51] then probably sample that, yeah [19:07:56] and group by everything except country [19:08:54] yeah that works [19:09:06] I'm having fun with the federation stuff [19:09:18] ooh, nice [19:09:30] also having "fun" trying to use it to detect all the incorrect tgn ids people have added using mix 'n' match [19:10:44] now I wish other ids were queriable this way [19:13:05] for some reason most countries didn't yet have a tgn id, that surprised me [19:13:18] also got to add one to earth, not often I find a reason to edit Q2 :D [21:27:03] oh *finally*, after spending ages trying to figure out why my query wasn't working I found the stupid mistake I made >_< [21:27:59] now I know that 1276 of the ids don't have matching countries, out of 17,000 in total... and that's just the ones with more obvious problems [21:28:19] that's not exactly a great success rate :/