Might this be affecting our searches? The following query times out very quickly on Chrome, and runs forever in Firefox before crashing the whole browser (or is there a problem with my query?)
PREFIX wd: http://www.wikidata.org/entity/ PREFIX wdt: http://www.wikidata.org/prop/direct/ PREFIX wikibase: http://wikiba.se/ontology# PREFIX p: http://www.wikidata.org/prop/ PREFIX v: http://www.wikidata.org/prop/statement/ PREFIX q: http://www.wikidata.org/prop/qualifier/ PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema#
SELECT ?photographer ?photographer_label ?nat ?nat_label ?dob ?dod WHERE { ?photographer wdt:P106 wd:Q33231 . # find items that have "occupation (P106): photographer (Q33231) " OPTIONAL {?photographer wdt:P27 ?nat .} # with a P19 (place of birth) claim OPTIONAL {?photographer wdt:P569 ?dob .} # ... where the pob has a Country OPTIONAL {?photographer wdt:P570 ?dod ;} #where the pob has a state
OPTIONAL {?photographer rdfs:label ?photographer_label filter (lang(?photographer_label) = "en") .} OPTIONAL {?nat rdfs:label ?nat_label filter (lang(?nat_label) = "en") .} #OPTIONAL {?cob rdfs:label ?cob_label filter (lang(?cob_label) = "en") .} #OPTIONAL {?state rdfs:label ?state_label filter (lang(?state_label) = "en") .} }
On Fri, Nov 6, 2015 at 1:27 PM, Neil Harris neil@tonal.clara.co.uk wrote:
On 06/11/15 18:04, Mikhail Popov wrote:
Hi! We looked at the logs. 21,740,641 requests are coming from a single IP without a user agent that we can't geolocate because it's in the 10 range.
Looking into the actual queries revealed that it's probably a broken bot. Stas said "the query makes no sense and is broken" and that it "looks like somebody trying to download whole DB in very weird way but is doing it all wrong."
We are investigating the issue.
– *Mikhail Popov* // Data Analyst, Discovery
Michail,
If by "in the 10 range", you mean an IPv4 address of the form 10.x.x.x, then it's an RFC1918 address, and more than likely coming from inside your own network.
Neil
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata