[04:32:48] hi - I am getting Failed to load resource: the server responded with a status of 502 () - to my sparql query. is the server ok? [04:39:31] http://tinyurl.com/h9m9uz2 [04:39:39] for example [08:43:57] Hi. I got a simple query, but perhaps too opened, that make every time a query timeout. Perhaps U can find an optimisation ? [08:43:59] http://tinyurl.com/hrhacdb [08:44:00] Thanks a lot, and have a nice sunday ;-) [08:52:32] Cyrille37: there are some problems since yesterday. https://www.wikidata.org/wiki/Wikidata:Contact_the_development_team#WQS_turns_blue [08:57:26] sjoerddebruin: done. [09:10:36] SMalyshev: ^ [10:57:10] 08:52:05 < sjoerddebruin> Cyrille37: there are some problems since yesterday. [10:57:35] Have these issues been tracked in Phabricator? [10:57:48] Not yet, AFAIK [10:58:01] I have slow queries as well. Some queries are fast though, as if some front end servers were having difficulties while the others are fine [10:58:46] bad gateway now [10:59:13] A screenshot yesterday... https://davidabian.com/downloads/wikidata/502-error-sparql.png [11:13:27] abian: same here [11:17:37] :S [11:17:44] Tracked, https://phabricator.wikimedia.org/T146576 [11:20:50] sjoerddebruin: did you make a ticket for the text field not being focused when clicking the edit button, or only for something similar? [11:25:57] nikki: only for qualifiers, but I'm getting it for statements now too [11:47:54] anyone git an idea what happened here? https://www.wikidata.org/wiki/Wikidata:WikiProject_Theatre https://www.wikidata.org/wiki/Wikidata:WikiProject_Theatre/Archive_1 [11:48:53] hmmm [11:49:12] yes : [11:49:14] :D [11:49:35] * nikki blinks at https://www.wikidata.org/wiki/Q234 and https://www.wikidata.org/wiki/Q9337 [11:49:55] if those are supposed to be different things, people are doing a bad job of making it clear >_< [11:50:22] Oo [11:50:40] https://www.wikidata.org/wiki/Talk:Q234... [12:12:37] Lydia_WMDE : looks like it moved the description rather than the talk threads [12:12:56] yeah [12:30:14] WIDAR is slow today... [13:11:35] Good afternoon hoo. :) [13:12:27] hi sjoerddebruin :) [13:14:44] We've had a discussion about the entity suggester a while ago again and we've found out that some properties aren't hitting our screens due to the removal of the identifiers of the suggestions. [13:15:08] https://www.wikidata.org/wiki/Property:P734 shows up as suggestion until I add a identifier, for example. [13:17:57] that's weird [13:18:58] And when you add even more identifiers, the quality of the suggestions decreases more. [13:20:58] identifiers are not taken into account at all, that's very weird [13:23:58] There is really something strange going on. [13:25:27] * aude waves [13:25:33] sjoerddebruin: an identifier on the property? [13:28:39] aude: no, as a statement on a item. [13:29:31] oh [13:33:57] hmmm.... Special:Nearby is (still) not working for me :( [13:35:13] hm? [13:35:34] Wikipedia Nearby can't figure out where you are... try again? [13:35:38] not just wikidata [13:36:49] Something wrongly configured in your browser or OS? [13:37:10] firefox + chrome [13:37:48] And your OS? :) [13:38:20] it works on my phone (afaik) [13:41:51] Lydia_WMDE: oops :D [13:43:54] I am getting intermittent "Failed to load resource: the server responded with a status of 502 ()" [13:44:21] when hitting the SPARQL endpoint [13:44:34] ScholarGent: Ran into that too [13:44:42] Not sure if we already have a bug open for it [13:44:52] https://phabricator.wikimedia.org/T146576 [13:45:37] Thanks sjoerddebruin [13:45:41] * multichill subscribes SMalyshev [13:46:00] thanks - it helps a lot just to know it's not my code or network setup - I won't go looking in the wrong direction [13:46:28] What are you working on in Gent? [13:46:36] it just started yesterday, the system behaved beautifully for weeks before that [13:47:28] I am putting together a math history timeline - my dad teaches a class - and I've started automatically generating parts of it through wikidata [13:47:57] Where is he teaching? [13:48:14] Loyola, in the Chicago area [13:48:32] Ah, not in Gent too... :P [13:49:24] Also looking into histropedia ScholarGent ? [13:49:29] no - I am in Boston - [13:49:40] what's that? [13:49:46] I'll take a look [13:50:20] very nice! [14:04:48] It also uses Wikidata [14:16:57] 13:43:27 < ScholarGent> I am getting intermittent "Failed to load resource: the server responded with a status of 502 ()" [14:17:27] ScholarGent: Your error message seems different, could you describe it in T146576? [14:17:36] T146576: 502 Bad Gateway errors while trying to run simple queries with the Wikidata Query Service - https://phabricator.wikimedia.org/T146576 [14:18:27] gehel are you here? [14:18:32] abian: "when hitting the SPARQL endpoint" [14:18:34] He's probably not using the WDQS UI. [14:19:30] Jonas_WMDE: in the train, on my way to BCN [14:19:37] Humm, okay [14:19:54] https://www.irccloud.com/pastebin/KxfAxOvr/ [14:19:55] aude: it doesn't work for me either (same browsers... well, chromium but close enough, in ubuntu). a couple of months ago when I was doing something else with the geolocation stuff, that kept failing and all I could find was something about some google service which was rejecting lookups (presumably trying to get locations from ips or something)... unfortunately I neither found a solution nor remember much more than that about it [14:20:13] I can take the laptop out, but spotty internet connectivity at best [14:20:37] gehel it seems query service has problems a lot of 502 errors [14:21:32] I'll try to have a look [14:22:05] sorry - walked away from the computer [14:22:22] gehel thanks! here is the ticket T146576 [14:22:25] abian: that is the same message I am getting [14:23:06] No problem :) [14:23:10] The same as which? [14:23:23] oh - I understand - yes, I will add what I'm getting to phabricator [14:23:59] Great, ScholarGent, thanks :) [14:24:53] https://grafana.wikimedia.org/dashboard/db/wikidata-query-service <- Varnish 5xx rate went up quite a bit [14:26:29] Varnish looks sick [14:27:16] wdqs1002 seems to have replication issues [14:27:18] aude: ah, if I run "navigator.geolocation.getCurrentPosition(function (e) { console.log(e); }, function (e) { console.log(e); });" in the browser console, the error says "Network location provider at 'https://www.googleapis.com/' : Returned error code 403."... that looks like what I was getting with the stuff I was doing before, maybe that helps somehow [14:27:44] yeah, wdqs1002 definitely has some issues, and not only replciation [14:32:10] I just put wdqs1002 in manitenance, that should temporarily hide the issue if I'm reading this correctly [14:34:45] :) [14:37:59] PROBLEM - WDQS HTTP on wdqs1002 is CRITICAL: HTTP CRITICAL: HTTP/1.1 503 Service Temporarily Unavailable - 387 bytes in 0.007 second response time [14:38:31] PROBLEM - WDQS SPARQL on wdqs1002 is CRITICAL: HTTP CRITICAL: HTTP/1.1 503 Service Temporarily Unavailable - 387 bytes in 0.007 second response time [14:49:31] You might want to set some planned downtime inicinga gehel to not wake up people [14:50:40] multichill: just did... [14:51:12] can anyone still reproduce the 502 error? [14:51:46] everything seems back to normal. [14:53:21] RECOVERY - WDQS HTTP on wdqs1002 is OK: HTTP OK: HTTP/1.1 200 OK - 9779 bytes in 0.007 second response time [14:53:52] RECOVERY - WDQS SPARQL on wdqs1002 is OK: HTTP OK: HTTP/1.1 200 OK - 9779 bytes in 0.006 second response time [14:54:15] Right (although "Data updated a day ago") [14:55:13] Now "a few seconds ago" :) [14:56:32] multichill: could you purge the pageprops with a P2016 statement? http://tinyurl.com/j33qa68 is still at 78 results, compared to 940 uses. [14:58:02] Probably not a good plan to purge a lot if the query service is acting up [14:58:55] multichill: It doesn't see that [14:59:02] it only notices edits/ deletions [14:59:09] (consumes the RC stream) [15:02:29] abian: wdqs1002 is lagging behind in replication. It is catching up, but it will take some time [15:04:56] Okay, gehel [15:05:23] Have a nice week in Barcelona :) [15:05:35] abian: if you're lucky, you'll hit the server with up to date data, if you're not, you'll get the outdated one (50/50) [15:06:25] I *could* disable wdqs1002 to ensure all traffic is routed to the up to date server, but I don't think it is a very good idea to run on a single server, especially when most Ops are traveling... [15:09:00] It seems sensible, and a day of outdated data is not so much [15:10:05] Ok, going AFK (airport, plane and all that nice stuff) [15:11:58] Have fun (as far as possible) xD [16:24:19] sjoerddebruin: I'm uploading paintings from quite a few more regional museums. People like https://www.wikidata.org/wiki/Q19587495 will finally get used :-) [16:24:40] Yeah, I got a few notifications already. [16:25:05] Did the Groninger Museum the other day, yesterday Museum Rotterdam and today the Fries Museum [16:32:11] sjoerddebruin: http://tinyurl.com/zurbzy2 1282 results right now [16:38:32] hmm... it seems that geonames and tgn are using the same data (no idea whether one imported from the other or if they're using a third unknown source) [16:39:05] but every tgn id I've looked at so far has had a geonames id with the same name and type... and there's just over 4000 tgn ids with no geonames id [16:39:24] there must be an easier way to find the matches than doing it each one manually... [16:50:54] Ugh, I've got the wrong WDQ-server. 16 hours. ;_; [16:52:28] I just add a space to my query and try again :P [17:25:59] hi, am looking for a property that can capture a "manages" or "operates" relationship - any suggestions? [17:26:32] https://www.wikidata.org/wiki/Property:P121? [17:28:27] actually maybe "operates" is not right, but "manages" is closer. For example a Trust that manages a stately home. @sjoerddebruin [17:29:14] So the inverse of https://www.wikidata.org/wiki/Property:P461? [18:10:54] https://www.wikidata.org/wiki/Special:Contributions/171.7.246.91 looks like vandalism. I'm not new to the idea but I've never faced it. What is the recommended course of action ? [18:16:41] dachary: rollback! :D [18:16:57] Or don't you have those rights yet? [18:17:12] sjoerddebruin: :-) I don't have that right indeed. [18:17:17] :O [18:17:35] this seems to be a clear case of vandalism but maybe I'm wrong ? [18:18:37] 3 of the 5 changes are clearly out of line [18:20:33] * dachary reading https://www.wikidata.org/wiki/Wikidata:Blocking_policy [18:21:01] is there a place somewhere to ask for a rollback ? [18:21:58] * dachary reading https://www.wikidata.org/wiki/Wikidata:Vandalism [18:23:25] ok, so I should just undo the changes according to https://www.wikidata.org/wiki/Wikidata:Vandalism#Dealing_with_vandalism [18:23:43] since this is an IP address it seems pointless to leave a message in the talk page [18:24:36] mostly rollback is enough [18:26:59] sjoerddebruin: ok, done (not rollback but undo) [18:27:21] Please mark the edits as patrolled then. [18:27:25] * dachary feels good fighting vandalism for the first time :-) [18:27:27] ok [18:28:12] done [18:31:58] sjoerddebruin: added a reminder about that at : https://www.wikidata.org/w/index.php?title=Wikidata%3AVandalism&type=revision&diff=379943253&oldid=263087006 [18:32:33] :) [18:32:33] :) [19:08:17] Spam: Perhaps you're interested in commenting... https://www.wikidata.org/wiki/Wikidata:Property_proposal/average_yearly_temperature ... as it's not only a property proposal, but it's a proposal about saving climate data in Wikidata and how to do it [19:11:52] The Devil is messing up your number trick nikki and addshore , see https://www.wikidata.org/wiki/Q666 :P [19:12:12] I did mention that there were two 666s :P [20:34:02] Hey, I have a question about SPARQL. I'd like to find all businesses whose headquarters are within X km of a certain area, but while I can find objects by P625, it doesn't work on headquarters location because there's something like an intermediary [20:34:19] Any chance someone knows how I can filter by P625 when its within another property? [20:35:07] Just as an example, look at https://www.wikidata.org/wiki/Q2283 (Micosoft) to see what I mean - the coordinate is not P625 of the Q2238, but its within P159(headquarters location) [20:35:18] I don't know how to get a SPARQL query to pull only those items. [20:42:38] RLB5020 https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries#Working_with_qualifiers [20:45:51] but for a short answer, SELECT ?business ?businessLabel ?coords WHERE { ?business wdt:P159 [ wdt:P625 ?coords ] . OPTIONAL { ?business rdfs:label ?businessLabel . FILTER( LANG( ?businessLabel) = "en" ) . } } # should do the trick [20:46:28] this will give you the entity for the business, its name in english if available, and the coords for its headquarters [20:46:29] Much appreciated, I just got it. [20:46:34] Really really appreciate the help. [20:46:37] yw [20:47:10] would you like a bit of an explanation of what i did ? [20:47:34] Nah, I think I got it, I actually just figured it out soon as you sent me the link. Didn't know those were called qualifiers. [20:47:44] So my attempts to search for documentation before that proved fruitless :P [20:48:44] heh [20:49:52] just a thing though : mine doesn't care about qualifiers ;) [20:50:09] (it cares about the location of the item that statement points to) [20:50:39] and yes, there can be a difference, and microsoft is an excellent example [20:50:41] Ah right, couldn't I just pull that using pq:P625 though? [20:50:55] yes of course [20:51:16] if you used pq:P625, you will get the coords as expressed in the entity for microsoft [20:51:29] But yours will pull the label, and that won't? [20:51:31] if you use mine, you'll get the coords as expressed in the entity for the good town of richmond [20:51:48] (probably the town hall) [20:51:52] Aaah. [20:53:11] if you want the qualifier, you'll need SELECT ?business ?businessLabel ?coords WHERE { ?business p:P159 [ pq:P625 ?coords ] . OPTIONAL { ?business rdfs:label ?businessLabel . FILTER( LANG( ?businessLabel) = "en" ) . } } #should do the trick [20:53:24] sorry, gotta go, bbiaf [20:54:27] No worries. Again, thanks, I was getting nowhere without help. [21:48:12] and i'm back :)