[09:09:46] <addshore>	 *facepals gerrit being super slow for certain patchsets*.....
[09:09:52] <addshore>	 *palms...
[09:33:32] <JeroenDeDauw>	 addshore: merged all the things!
[09:33:37] <addshore>	 indeed
[09:34:02] <hoo>	 New JSON dump is there :)
[09:34:06] <addshore>	 YAY
[09:34:13] <hoo>	 But it's still smaller than the old one, which is worrysome
[09:34:15] <addshore>	 I don't believe I managed to break it in 3 different ways :D
[09:34:30] <addshore>	 hoo: well, allot of 0's got removed!
[09:34:39] <hoo>	 yeah, hopefully that's it
[09:35:44] <addshore>	 well hoo well over 10,000,000 dates ;)
[09:37:31] <addshore>	 and most of them probably lots 12 0 characters
[09:38:02] <hoo>	 Let's see how big the size change is after gzip
[09:38:09] <addshore>	 so 120,000,000 bytes :D
[09:38:35] <addshore>	 probably closer to 20,000,000 dates
[10:32:40] <JeroenDeDauw>	 addshore: that's #over9000!
[10:36:05] <hoo>	 addshore: After unzipping, the dump actually grew by 1.6%
[10:36:27] <addshore>	 hoo: yeh it should ;) as datatypes now get included for all snaks!
[10:36:44] <addshore>	 So that makes a bit of sense! :D
[10:37:40] <hoo>	 yeah
[10:40:37] <JeroenDeDauw>	 addshore unlocked the "waster of diskspace" badge
[10:51:39] <addshore>	 Fatal error: Class 'Wikibase\Repo\WikibaseRepo' whhhhyyyy
[10:56:42] <hoo>	 addshore: I guess the autoloader is not invoked in time
[10:56:53] <addshore>	 yeh, got a fix for it, about to put it up
[11:01:56] <JeroenDeDauw>	 heh?
[11:34:05] <JeroenDeDauw>	 addshore: y u confused about the direction? https://gerrit.wikimedia.org/r/#/c/229678/
[11:34:18] <JeroenDeDauw>	 You're from the UK, not Australia!
[11:35:34] <JeroenDeDauw>	 !nyan | ~=[,,_,,]#
[11:35:34] <wm-bot>	 ~=[,,_,,]#: ~=[,,_,,]:3
[11:38:14] <addshore>	 JeroenDeDauw: phpstorm disagrees with you
[11:49:48] <hoo>	 $this->hasHadServicesSet
[11:49:53] <hoo>	 I like that name :'D
[11:50:16] <addshore>	 hhss
[11:52:15] <addshore>	 hoo: i'll finish wriitng a test for your core thing then merge it :)
[11:52:26] <hoo>	 \o/
[12:49:41] <hoo>	 Yay... // FIXME: This is not really well defined. Could be either of the two.
[12:51:15] <hoo>	 ugh
[12:51:21] <hoo>	 we have cut off values in wb_changes
[12:51:25] * hoo cries
[12:54:40] <hoo>	 Anyone up for fixing the tests for master or shall I give it a shot?
[12:54:57] <hoo>	 I'm still wtf-ing about wb_changes
[13:18:23] <Thiemo_WMDE>	 hoo: does this sound familar??? https://gerrit.wikimedia.org/r/#/c/225036/
[13:18:52] <hoo>	 yeah, that's the thing
[13:21:18] <hoo>	 Thiemo_WMDE: Iaea79bd is related, yes
[13:21:35] <hoo>	 I guess SQLite changed it's query plan because it now has the indexes at hands
[13:21:51] <hoo>	 but the assumption in the test was flawed to begin with... even has a FIXME on it
[15:43:11] <addshore>	 hmm, master has a broken test...
[15:59:43] <addshore>	 hoo|away: DanielK_WMDE_ https://gerrit.wikimedia.org/r/#/c/229736/
[16:00:21] <addshore>	 oh great, it that fails for mysql though... thats lame...
[16:01:33] <DanielK_WMDE_>	 addshore: yea...
[16:03:46] <addshore>	 *facepalm life*
[16:12:47] <addshore>	 cheer Thiemo_WMDE !
[16:12:49] <addshore>	 *cheers
[17:01:57] <ysangkok>	 i am a bit puzzled by Q7502697 (shoulder angel)... i marked it as an instance of "Allegory" and "Plot device"... but i'm not sure this is right
[17:02:32] <ysangkok>	 english wikipedia says that it is a plot device, but i think that is a narrow definition, as it is not only used in narratives
[17:03:57] <ysangkok>	 related: Q1664033 "innerer Schweinehund"
[17:37:23] <DanielK_WMDE_>	 ysangkok: "innerer Schweinehund" is a phrase or expression. possibly a figure of speach. Not a plot device.
[21:05:36] <hoo>	 https://www.wikidata.org/wiki/Special:Contributions/ProteinBoxBot that bots updates retrieved dates of references... daily? :/
[21:07:28] <sjoerddebruin>	 Wut?
[21:07:43] <hoo>	 sjoerddebruin: See the revisions
[21:07:51] <sjoerddebruin>	 Jup, I see.
[21:07:53] <hoo>	 I seriously doubt that's a good idea :P
[21:07:59] <multichill>	 hahaha, lol
[21:08:01] <hoo>	 Could be done like twice a year or so...
[21:08:08] <sjoerddebruin>	 huh https://www.wikidata.org/wiki/User_talk:ProteinBoxBot
[21:08:16] <multichill>	 It's like when my bot was edit warring for over a month and nobody pointed it out
[21:08:48] <multichill>	 Do we have a central place to keep track of viaf errors?
[21:09:09] <multichill>	 https://www.wikidata.org/w/index.php?title=Q17195901&curid=18789933&diff=239010009&oldid=238959846 <- this stuff scares me a bit
[21:09:12] <sjoerddebruin>	 Wondering that too.
[21:09:37] <sjoerddebruin>	 https://www.wikidata.org/w/index.php?title=Q18056036&type=revision&diff=238990318&oldid=238941317
[21:10:13] <multichill>	 ouch, that's really bad matching
[21:11:09] <sjoerddebruin>	 I've checked every edit on my watchlist...
[21:11:51] <sjoerddebruin>	 But, what about "Wikibase\Lib\Store\UnresolvedRedirectException" on https://www.wikidata.org/wiki/User_talk:ProteinBoxBot
[21:14:42] <nikki>	 I wonder if they're just matching based on the names being the same...
[21:14:54] <nikki>	 I hope not, because that's a brilliant way to mess up your data
[21:15:25] <sjoerddebruin>	 Their based on matching done by VIAF.
[21:15:31] <sjoerddebruin>	 They are*
[21:15:35] <multichill>	 nikki: Looks like viaf matched on name
[21:15:56] <nikki>	 I meant viaf
[21:16:08] <multichill>	 So Nieuwe Gracht is a street both in Haarlem and Utrecht, picked Haarlem instead of Utrecht. Same goes for Drenthe, province of the Netherlands or town in the US
[21:16:14] <nikki>	 I sent them an email but haven't had a response yet
[21:16:31] <nikki>	 er, I meant to say I also saw one the other day
[21:16:42] <multichill>	 It's a bit like my painter boo boo :P
[21:17:02] <sjoerddebruin>	 VIAF communication is bad.
[21:21:16] <Amir1>	 hey :)
[21:24:24] <nikki>	 hi Amir1
[21:25:13] <Amir1>	 hey, how are you?
[21:26:12] <nikki>	 not too bad
[21:26:53] <nikki>	 I would be better if air conditioning were common here or if the weather weren't so hot
[21:29:30] <Amir1>	 :D
[21:30:53] <jzerebecki>	 sjoerddebruin: I don't see an exception on https://www.wikidata.org/wiki/User_talk:ProteinBoxBot
[21:31:30] <sjoerddebruin>	 Weird.
[21:38:02] <jzerebecki>	 sjoerddebruin: no I have it too :-O
[21:40:25] <sjoerddebruin>	 :O
[21:40:28] <sjoerddebruin>	 !panic
[21:40:28] <wm-bot>	 https://dl.dropboxusercontent.com/u/7313450/entropy/gif/omgwtf.gif
[21:40:54] <hoo>	 wtf
[21:40:58] <hoo>	 on a non entity page
[21:41:02] * hoo panics as well
[21:41:15] * sjoerddebruin didn't knew about !panic
[21:42:08] <jzerebecki>	 ok I think someone delete an entity that was linked like {{Q|Q19859703}}
[21:42:09] <AsimovBot>	 10[1] 10https://www.wikidata.org/wiki/Template:Q
[21:43:44] <hoo>	 jzerebecki: No, double redirects are the problem
[21:43:47] <hoo>	 :s
[21:43:55] <hoo>	 Does anyone have a bot handy to fix these?
[21:44:09] <hoo>	 See https://www.wikidata.org/w/index.php?title=Special:WhatLinksHere/Q16428906&hidelinks=1
[21:44:32] <sjoerddebruin>	 Jup https://www.wikidata.org/w/index.php?title=Q18020996&type=revision&diff=239007539&oldid=238445134
[21:44:50] <hoo>	 For some reason these don't appear on the special page
[21:44:56] <hoo>	 so I guess we have various issues here
[21:44:59] <hoo>	 uhm... yay?
[21:45:52] <hoo>	 I'll file bugs
[21:45:56] * hoo sighs
[21:46:57] <jzerebecki>	 thx
[21:56:09] <hoo>	 jzerebecki: Running updateSpecialPages.php --wiki wikidatawiki --only DoubleRedirects maybe the cache is the problem
[21:56:16] <hoo>	 if not I'll open a bug about that as well
[21:57:11] <jzerebecki>	 it is supposed to continously update, right?
[21:57:30] <hoo>	 No, it's not... it's to heavy for that (the update takes several minutes)
[22:00:27] <jzerebecki>	 oh ok. it is never run in the wikimedia cluster according to the puppet repo...
[22:02:06] <hoo>	 https://www.wikidata.org/w/index.php?title=Special:DoubleRedirects&limit=500&offset=0
[22:02:12] <hoo>	 so now it's complete
[22:02:23] <hoo>	 Not a bug, just not updated often enough it seems
[22:02:41] <hoo>	 took almost 6 minutes, btw
[22:03:52] <hoo>	 It's being refreshed every third day now... maybe we should have that being recached like twice a day?
[22:04:27] <hoo>	 Only worth it, if bots will act this often, though
[22:05:29] <jzerebecki>	 hoo: how is it being run I don't see it in puppet.git?
[22:05:43] <hoo>	 misc::maintenance::update_special_pages
[22:06:08] <hoo>	 that updates all of them, but we could run that one separately 
[22:06:22] <jzerebecki>	 oh ok there is one that is missing --only didn't see that
[22:38:02] <hoo>	 jzerebecki: https://gerrit.wikimedia.org/r/229992 Easy one
[22:42:23] <jzerebecki>	 hoo: should I sign that up for the next swat?
[22:42:47] <hoo>	 As stop gap it would be enough for someone to fix the double redirects
[22:42:58] <hoo>	 but if no one is going to do that, we can quickly backport it
[22:43:40] <hoo>	 $ grep -c 'UnresolvedRedirectException' exception.log 
[22:43:40] <hoo>	 16
[22:46:33] <jzerebecki>	 probably not worth it then. last swat before next week is in 14 minutes.
[22:47:36] <hoo>	 yeah, let's just wait for the SWAT to run through
[22:47:47] <hoo>	 * bots
[22:47:48] <hoo>	 meh
[22:59:30] <hoo>	 Restarting dbus wasn't the best idea I had today, doh
[23:13:19] <hoo>	 Do we have a page to list items with invalid site links (sitelinks that are present in two items)?