[00:06:46] <mindey>	 Question: dealing with databases here, and want to use wikidata for column names. Column names generally include phrases, that are very popular in software world, such as "app id", "browser activity", "has product id", "creation time", and so on. These are in fact so common, that they have rather specific meaninging. Should/shouldn't we, and what criteria should we follow, when adding such kind of 
[00:06:52] <mindey>	 concepts into wikidata? If not, where would you recommend to put such data in public?
[03:03:37] * anomie[m] sent a long message: anomie[m]_2018-03-10_03:03:36.txt <https://matrix.org/_matrix/media/v1/download/matrix.org/JLdNmWPBokljlQqImiRRtRYE>
[03:17:02] <anomie[m]>	 Nevermind, I found out why.
[03:39:58] <anomie[m]>	 Why is there nothing in the Movies column here? http://tinyurl.com/yaryya33
[07:35:31] <icinga-wm>	 RECOVERY - Host wdqs2006.mgmt is UP: PING OK - Packet loss = 0%, RTA = 38.78 ms
[07:42:13] <icinga-wm>	 PROBLEM - Host wdqs2006.mgmt is DOWN: PING CRITICAL - Packet loss = 100%
[08:59:20] <jubo2>	 Wikidata growth is hampered by the inability of non-WMF wikis to use it with Wikibase Client. Now the knowledge in the Wikibases is scattered apart and non-WMF Wikibase maintainers have low incentive to add to Wikidata if they need the data in their own wikis.
[11:22:42] <Ash_public>	 Hi, is there a way to edit the type constraint on https://www.wikidata.org/wiki/Property:P3599 so that accepts either a person or an organization?
[11:26:22] <MisterSynergy>	 You can add another qualifier "class (P2308): organization (Q43229)" to the constraint
[11:33:34] <Ash_public>	 MisterSynergy: thanks!
[11:45:23] <MisterSynergy>	 Does anyone know why we have slow servers today?
[12:25:54] <multichill>	 MisterSynergy: Someone forgot to feed them? ;-) Didn't notice it, you could check recentchanges for really fast running bots
[12:40:58] <Lydia_WMDE>	 multichill: https://wikidata.wikiscan.org/?menu=live&filter=all&sort=weight&date=12&list=users tells me yes
[12:41:02] <Lydia_WMDE>	 way too fast :(
[12:41:07] <Lydia_WMDE>	 MisterSynergy: ^
[12:41:11] <MisterSynergy>	 thnx
[12:41:24] <MisterSynergy>	 Artix Kreiger 2 is running at that pace for days now
[12:41:38] <Lydia_WMDE>	 jeeeez
[12:42:10] <MisterSynergy>	 they have collected 2.4M edits in March only
[12:42:34] <MisterSynergy>	 yet I am not sure whether this is related to the server speed I experience
[12:42:46] <Lydia_WMDE>	 i have already asked him to slow down but apparently to no avail :(
[12:43:32] <MisterSynergy>	 did you do that in Wikidata?
[12:43:37] <MisterSynergy>	 can't find anything
[12:44:26] <Lydia_WMDE>	 it was just removed from the page
[12:44:34] <Lydia_WMDE>	 let me get a diff
[12:44:48] <MisterSynergy>	 found it already
[12:45:22] <MisterSynergy>	 Do you also have charts (grafana and the like) which shows how this slows down servers?
[12:45:47] <Lydia_WMDE>	 https://www.wikidata.org/w/index.php?title=User_talk:Artix_Kreiger&diff=637301688&oldid=636924715&diffmode=source
[12:46:07] <Lydia_WMDE>	 let me check
[12:48:50] <multichill>	 Lydia_WMDE: Where did you do that?
[12:49:05] <Lydia_WMDE>	 multichill: https://www.wikidata.org/w/index.php?title=User_talk:Artix_Kreiger&diff=637301688&oldid=636924715&diffmode=source
[12:50:07] <multichill>	 Ok, blocked
[12:50:11] <multichill>	 Let's see if that helps
[12:50:25] <MisterSynergy>	 :-)
[12:50:42] <MisterSynergy>	 thnx, I would have otherwise done so as well
[12:51:27] <Lydia_WMDE>	 thank you
[12:52:38] <Lydia_WMDE>	 MisterSynergy: https://grafana.wikimedia.org/dashboard/db/wikidata-dispatch?refresh=1m&orgId=1&from=now-7d&to=now <- the sikes in the dispatch lag graph here for example worries me
[12:52:54] <Lydia_WMDE>	 same for the pending changes one
[12:53:02] <Lydia_WMDE>	 and change notification job delay
[12:54:07] <MisterSynergy>	 okay thnx; not easy to relate to high edit volumes, but at least it is something ... :-)
[12:54:38] <multichill>	 420/m is just too fast. Multiple users have been warned not to run multiple Quickstatements jobs at the same time
[12:55:04] <MisterSynergy>	 I'd estimate that they run 5 batches parallel typically
[12:55:11] <Lydia_WMDE>	 MisterSynergy: yeah :/  I'll see if we can get something clearer for the future
[12:58:11] <MisterSynergy>	 that would be great. a chart with data sets "server load" and "edit rate" over time; "server load" show somehow include all critical metrics, and display a threshold. It would certainly be complicated to compute this kind of "server load", as there can be various bottlenecks that create strain
[12:58:32] <Lydia_WMDE>	 *nod*
[12:59:34] <multichill>	 Sounds like unix load ;-)
[12:59:58] <multichill>	 https://en.wikipedia.org/wiki/Load_(computing)#Unix-style_load_calculation 
[13:01:52] <multichill>	 He agreed to slowing down so unblocked. Hope the load goes down
[13:02:17] <MisterSynergy>	 saw it already, they responded quickly
[13:06:15] <Lydia_WMDE>	 awesome
[13:06:27] <multichill>	 There he is ^ :-) 
[13:07:06] <Lydia_WMDE>	 hey Artix!
[13:07:13] <Lydia_WMDE>	 thanks for being responsive
[13:09:02] <Artix>	 Hello
[13:10:13] <Artix>	 Im using descriptioner now, which is running at 30 edits per minute.
[13:10:18] <Artix>	 and only that.
[13:10:49] <Lydia_WMDE>	 cool :)
[13:10:55] <Lydia_WMDE>	 should be fine then
[13:10:55] <MisterSynergy>	 that's a good edit rate
[13:12:09] <Artix>	 isn't wikidata running on its own servers?
[13:12:21] <Artix>	 and not part of WMF servers?
[13:12:36] <Artix>	 I mean, its own dedicated servers
[13:13:17] <Lydia_WMDE>	 it's the same infrastructure
[13:13:25] <Lydia_WMDE>	 it has a dedicated server
[13:13:37] <MisterSynergy>	 dedicated database server, right?
[13:13:41] <Lydia_WMDE>	 but it still has a lot of influence on everything else
[13:13:42] <Lydia_WMDE>	 yes
[13:14:20] <Lydia_WMDE>	 for example when people edit wikidata items then we send updates to all the articles that use the data in the wikipedias and other sister projects
[13:14:39] <Lydia_WMDE>	 and those updates should happen in a timely manner (ie not more than 1 or 2 minutes)
[13:14:51] <Artix>	 apparently enwiki has its haters,
[13:14:59] <Artix>	 like, very very strong hates.
[13:15:07] <Lydia_WMDE>	 sadly :/
[13:15:31] <Artix>	 I could name at least one.
[13:16:06] <Lydia_WMDE>	 Let's concentrate on making Wikidata the best and most useful it can be and that will hopefully solve itself
[13:16:40] <Artix>	 Sometimes, I have thoughts of people coming together to enrich it further.
[13:16:45] <Artix>	 in various languages.
[13:19:18] <Artix>	 Hey Lydia, isn't there a wikidata vandalism monitoring device
[13:19:23] <Artix>	 that was built recently ?
[13:19:52] <Lydia_WMDE>	 there are a few, yes
[13:21:55] <Lydia_WMDE>	 give me a sec to get links
[13:24:19] <Lydia_WMDE>	 https://www.wikidata.org/wiki/Wikidata:WikiProject_Counter-Vandalism
[13:24:23] <Lydia_WMDE>	 https://tools.wmflabs.org/wdvd/index.php
[13:24:38] <Lydia_WMDE>	 https://tools.wmflabs.org/wdvd/index.php should probably be linked on the wiki project tools section
[13:24:53] <Lydia_WMDE>	 (i don't think i should link it so if anyone else has time...)
[13:28:52] <MisterSynergy>	 Lydia_WMDE: done
[13:28:55] <Lydia_WMDE>	 <3
[13:36:34] <Artix>	 Can i tell everyone a joke?
[13:54:12] <Lydia_WMDE>	 of course
[13:55:44] <icinga-wm>	 RECOVERY - Host wdqs2006.mgmt is UP: PING OK - Packet loss = 0%, RTA = 36.62 ms
[14:12:44] <icinga-wm>	 PROBLEM - Host wdqs2006.mgmt is DOWN: PING CRITICAL - Packet loss = 100%
[15:55:27] <sjoerddebruin>	 multichill: been working on a lot of people on nlwiki atm, surprises me how much still lack P27.
[17:19:44] <multichill>	 sjoerddebruin: I created a lot of people, but stayed clear of the country problem
[17:19:59] <sjoerddebruin>	 We should really find a fix for it. :(
[17:56:39] <sjoerddebruin>	 It's sad how much Flash only-sites still exist.
[19:59:35] <sjoerddebruin>	 Some weird primary sources. https://www.wikidata.org/wiki/Q5739518