[04:27:07] <Andycyca>	 Hello. I have a question about notability/deletion in wikidata
[04:28:46] <Andycyca>	 Hello, I have a question about notability/deletion at Wikidata
[09:25:37] <sDrewthedoff>	 anyone else having creation issues? I am getting "Fatal exception of type" error
[09:26:02] <sDrewthedoff>	 Wikimedia\Rdbms\DBQueryError
[09:27:20] <sDrewthedoff>	 aude Tpt[m] Lydia_WMDE 
[09:27:22] <sDrewthedoff>	 ^^
[09:29:07] <Lydia_WMDE>	 hey sDrewthedoff
[09:29:13] <Lydia_WMDE>	 anyone else seeing issues?
[09:29:22] <sDrewthedoff>	 no one answered
[09:30:08] <Lydia_WMDE>	 sDrewthedoff: are you using special:newitem? or the api? or some tool?
[09:30:43] <sDrewthedoff>	 special:new item for one,  and the WEF tool
[09:30:55] <sDrewthedoff>	 both failed, WEF tool silently
[09:30:56] <Lydia_WMDE>	 ok
[09:31:31] <Lydia_WMDE>	 Amir1:  ^ can you have a look when you are back please?
[09:31:46] <sDrewthedoff>	 let me try this PC, to make sure it is not cxn based
[09:31:56] <Lydia_WMDE>	 ok thx
[09:32:48] <sDrewthedoff>	 A database query error has occurred. This may indicate a bug in the software.
[09:32:48] <sDrewthedoff>	 [WjouHgpAAEEAAFLVR70AAAAF] 2017-12-20 09:32:30: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"
[09:33:09] <sDrewthedoff>	 forerunner code changes, time changed; message same
[09:33:32] <sDrewthedoff>	 want a phab ticket?
[09:33:57] <Lydia_WMDE>	 yeah that would be great
[09:34:08] <Lydia_WMDE>	 then Amir1 can have a look when he is back
[09:36:41] <sDrewthedoff>	 T183341
[09:36:42] <stashbot>	 T183341: New item fails (Special and WEF tool) - https://phabricator.wikimedia.org/T183341
[09:42:36] <sDrewthedoff>	 some new items are being created
[09:44:20] <sDrewthedoff>	 hmm, now good
[09:44:26] <sDrewthedoff>	 big gap of nothing
[09:47:19] <Lydia_WMDE>	 heh
[09:47:24] <Lydia_WMDE>	 still weird and should be looked at
[09:48:26] <sDrewthedoff>	 sure, commentary only :-)
[10:03:56] <sjoerddebruin>	 https://twitter.com/chrisalbon/status/943342608742604801
[10:23:56] <reosarevok>	 First and last constraints on https://www.wikidata.org/wiki/Property:P2580 seem to clash
[10:24:03] <reosarevok>	 It can be a noble family but it must be human?
[10:24:36] <reosarevok>	 (it can definitely be a noble family, https://www.wikidata.org/wiki/Q767258)
[10:25:20] <sjoerddebruin>	 The latter format is the preferred format, but was added rather weirdly.
[10:25:59] <sjoerddebruin>	 It also takes subclasses in account.
[10:26:30] <sjoerddebruin>	 Useful with (unneeded imo) items like https://www.wikidata.org/wiki/Q15054477
[11:12:57] <reosarevok>	 Is there any bot running to remove "Wikimedia disambiguation page" descriptions from things that aren't?
[11:13:17] <reosarevok>	 Found several noble families marked as disambiguations, yet with no wiki page linked being one 
[11:18:34] <sjoerddebruin>	 I think so.
[11:19:43] <reosarevok>	 Hopefully :)
[11:23:03] * reosarevok is confused about the regexes for https://www.wikidata.org/wiki/Property:P158
[11:23:09] <reosarevok>	 What are they checking for exactly?
[11:23:45] <sjoerddebruin>	 Probably Commons file name guidelines?
[11:23:45] <sDrewthedoff>	 which bit?
[11:23:52] <reosarevok>	 That the seal is not a flag or a shield?
[11:24:01] <reosarevok>	 The general idea
[11:24:17] <reosarevok>	 (was looking at https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/Mandatory_constraints/Violations again)
[11:25:36] <sDrewthedoff>	 reosarevok: if it is the leading question mark, that is for a non-capturing regex
[11:26:45] <reosarevok>	 No, I'm mostly wondering what they're trying to avoid. I'm not great at regexes
[11:27:03] * reosarevok is a bit ashamed that he's always sucked at those
[11:27:42] <sDrewthedoff>	 #cheatsheet
[11:30:00] <sDrewthedoff>	 ^(?!.*[Cc]oat of [Aa]rms).*$   ^ = not  ?! n-ve lookahead
[11:30:36] <Lucas_WMDE>	 I’m more confused about the “format as a regular expression” regex tbh https://www.wikidata.org/wiki/Property:P158#P1793
[11:30:44] <Lucas_WMDE>	 is it intentional that the first one ends in | ?
[11:30:59] <Lucas_WMDE>	 afaiu that means “should be blahblahblah, or empty”
[11:31:51] <sDrewthedoff>	 a ? at the end makes the last character or ()? regex optional
[11:32:36] <Lucas_WMDE>	 reosarevok: https://regexr.com/3i9oo
[11:32:54] <Lucas_WMDE>	 (there’s a lot of explain-regex websites, but this one looks good)
[11:33:21] <sDrewthedoff>	 I have my davechild regex cheatsheet
[11:33:42] <sDrewthedoff>	 pdf on the desktop to help me
[11:34:27] <sDrewthedoff>	 <- crap on the look ahead, look behinds, look in your navel
[11:36:22] <sDrewthedoff>	 most of my stuff for our global blacklists is just kept simpler anyway
[12:26:45] <Amir1>	 Lydia_WMDE: I'm back now, what's up? is there a phab card so I can take a look
[12:27:08] <Lydia_WMDE>	 Amir1: hey :)
[12:27:17] <Lydia_WMDE>	 Amir1: T183341
[12:27:18] <stashbot>	 T183341: New item fails (Special and WEF tool) - https://phabricator.wikimedia.org/T183341
[12:27:51] <Amir1>	 Thanks
[12:28:02] <Lydia_WMDE>	 sjoerddebruin: haha @ tweet. that rule is enforced at wikimedia :D
[12:28:09] <Lydia_WMDE>	 by greg-g for example
[12:28:45] <Lydia_WMDE>	 Amir1: it might have just been a fluke but probably worth having a look
[12:30:00] <Lucas_WMDE>	 which tweet?
[12:31:58] <Lydia_WMDE>	 https://twitter.com/chrisalbon/status/943342608742604801
[12:32:32] <Lucas_WMDE>	 :D
[12:32:37] <Lucas_WMDE>	 sounds about accurate
[12:41:37] <sDrewthedoff>	 Amir1: it was minimum of 10-15 minutes while not happening.  Nothing showed in normal RC, though I didn't think to look at whether there was success in bot activity
[12:42:01] <sDrewthedoff>	 nothing showed = no new items showed
[12:42:56] <Amir1>	 sDrewthedoff: I'm looking into logs, it seems that DBAs depooled some hosts from s5 (wikidata's shard) https://grafana.wikimedia.org/dashboard/db/mysql-replication-lag?panelId=5&fullscreen&orgId=1
[12:43:02] <Amir1>	 https://wikitech.wikimedia.org/wiki/Server_Admin_Log
[12:43:15] <Amir1>	 That can be the reason
[12:43:33] <sDrewthedoff>	 good-o, crappy error message
[12:44:09] <sDrewthedoff>	 used to the old "locked, come back later"
[12:44:15] <Amir1>	 it's around the time db1096 got depooled 
[12:46:17] <Amir1>	 I see lots of "Error: 1205 Lock wait timeout exceeded; try restarting transaction"
[12:46:25] <Amir1>	 let me talk to DBAs
[12:49:17] <sDrewthedoff>	 it did take a while to generate the error message, it wasn't click instantaneous response
[12:49:37] <sDrewthedoff>	 say > 10s for error
[13:18:46] <reosarevok>	 What is preferred, to have multiple bot accounts, each doing one (or a set of) related task(s), or to have one or two doing many things?
[13:18:58] * reosarevok finds the first more clear, but isn't sure what's the standard
[13:56:34] <Nemo_bis>	 reosarevok: usually one creates an ad hoc bot account only for long-term editing
[13:56:49] <Nemo_bis>	 For instance there are specialised bot accounts for archiving talk pages
[15:27:16] <Lena_>	 Hi everyone !
[15:28:49] <Lena_>	 Does anyone knows if there is a script/tool somewhere that creates Wikidata items based on a Commons {{artwork}} template ?
[15:28:49] <AsimovBot>	 10[4] 10https://www.wikidata.org/wiki/Template:artwork
[16:26:45] <greg-g>	 Lydia_WMDE: yeah, that's pretty much why I enforce the no deploys rule :)
[18:28:16] <zakharyas>	 I'm still getting to grips with Wikidata terminology. For https://www.wikidata.org/wiki/Q32159, I notice that the runway statement also lists the runway length and material as well as the direction. Are the lengths and and material qualifiers? 
[18:28:49] <sjoerddebruin>	 Yes.
[18:28:57] <zakharyas>	 Thanks :)
[19:03:15] <zakharyas>	 I'm trying to write a query to show airports named after footballers. In my WHERE clause I have "?airport wdt:P31 wd:Q1248784 .", "?airport wdt:P138 ?namedAfter ." and "?namedAfter wdt:P106 wd:Q937857". The query runs but returns only a single airport named after Marconi, who wasn't a footballer. What have I done wrong?
[19:08:28] <sjoerddebruin>	 Maybe consider subclasses of airports as well?
[19:10:31] <zakharyas>	 sjoerddebruin: the airport selection part of the query seems fine--if I run just that, it returns lots of airports
[19:11:36] <sjoerddebruin>	 Could you throw me the query link?
[19:12:26] <zakharyas>	 sjoerddebruin: http://tinyurl.com/yb6ga3cd
[19:13:22] <sjoerddebruin>	 And after reverting vandalism it will return zero... https://www.wikidata.org/w/index.php?title=Q36488&type=revision&diff=611445384&oldid=611043475
[19:13:35] <sjoerddebruin>	 Are you sure the data is in Wikidata?
[19:14:39] <zakharyas>	 sjoerddebruin: yes, https://www.wikidata.org/wiki/Q8987 named after https://www.wikidata.org/wiki/Q164521 whose occupation is footballer
[19:15:07] <sjoerddebruin>	 That one has P31 https://www.wikidata.org/wiki/Q644371 though
[19:15:14] <sjoerddebruin>	 That's why I suggested subclasses :)
[19:15:29] <zakharyas>	 damn it
[19:18:14] <zakharyas>	 sjoerddebruin: changed to ?airport wdt:P279 wd:Q1248784 but instead of getting airports, I get a list of subclasses of airport (e.g. international, domestic, regional, ...). Clearly using the wrong property I guess.
[19:18:26] <sjoerddebruin>	 try wdt:P31/wdt:P279 
[19:18:46] <sjoerddebruin>	 (is direct instance of P31 or a subclass of it)
[19:20:26] <zakharyas>	 sjoerddebruin: do you literally mean: ?airport wdt:P279/wdt:P31 wd:Q1248784  ?
[19:21:25] <sjoerddebruin>	 ?airport wdt:P31/wdt:P279 wd:Q1248784
[19:22:20] <zakharyas>	 sjoerddebruin: works :) I guess the order is significant
[19:22:28] <sjoerddebruin>	 Indeed :)
[19:37:37] <zakharyas>	 sjoerddebruin: OK, now I'm trying to show the lengths of runways at airports named after people. The naming after people part is fine, but with OPTIONAL {     ?airport ps:P529 ?runway .
[19:37:37] <zakharyas>	     ?runway pq:P2043 ?length . } I don't see runway lengths for airports that do have runway lengths specified (e.g. https://www.wikidata.org/wiki/Q853886). Any hints? :)
[19:38:59] <sjoerddebruin>	 Ah, qualifiers...
[19:39:33] <zakharyas>	 yup
[19:39:50] <zakharyas>	 Been looking at https://en.wikibooks.org/wiki/SPARQL/WIKIDATA_Qualifiers,_References_and_Ranks
[19:41:11] <zakharyas>	 Maybe "ps" should be "p"
[19:41:31] <zakharyas>	 Yup, that's it
[20:00:53] <zakharyas>	 sjoerddebruin: works, but now I'm taking it a step further: I want to see the units of length as well. I don't see any units, even for airports with runway lengths where units are specified. Query: http://tinyurl.com/yaktdavm
[20:01:26] <sjoerddebruin>	 https://en.wikibooks.org/wiki/SPARQL/WIKIDATA_Precision,_Units_and_Coordinates :D
[20:24:53] <zakharyas>	 sjoerddebruin: I've tried to adapt that example but not getting anywhere unfortunately: http://tinyurl.com/y9hg37e5 . Getting a little confused with all the terminology. I already have runway length in ?length but that does not seem to be a value node. Is my understanding correct?
[20:50:16] <nikki>	 zakharyas: http://tinyurl.com/yd8omp56 seems to be what you want
[20:52:29] <zakharyas>	 nikki: I see, I didn't know about pqv: for getting the property qualifier's value node
[20:52:31] <zakharyas>	 Thanks
[20:53:44] <nikki>	 you're welcome :) took me a while to notice what the problem was too