On 7/26/20 1:44 PM, Egon Willighagen wrote:
it's at the end of the page. Hard to miss, I thought :/
SELECT DISTINCT ?government_governmental_jurisdiction_governing_officials ?government_governmental_jurisdiction_governing_officials ?government_government_position_held_office_holder_inverse ?government_government_position_held_appointed_by ?government_government_position_held_basic_title_inverse WHERE { VALUES ?government_governmental_jurisdiction_governing_officials { wdt:P17 p:P17 wdt:P36 p:P36 wdt:P47 p:P47 wdt:P6 p:P6 wdt:P138 p:P138 wdt:P37 p:P37 wdt:P150 p:P150 wdt:P1313 p:P1313 wdt:P625 p:P625 wdt:P35 p:P35 } . ?c ?government_governmental_jurisdiction_governing_officials ?k . VALUES ?government_governmental_jurisdiction_governing_officials { wdt:P17 p:P17 wdt:P36 p:P36 wdt:P47 p:P47 wdt:P6 p:P6 wdt:P138 p:P138 wdt:P37 p:P37 wdt:P150 p:P150 wdt:P1313 p:P1313 wdt:P625 p:P625 wdt:P35 p:P35 } . ?c ?government_governmental_jurisdiction_governing_officials ?y . VALUES ?government_government_position_held_office_holder_inverse { wdt:P19 p:P19 wdt:P103 p:P103 wdt:P69 p:P69 wdt:P937 p:P937 wdt:P106 p:P106 wdt:P26 p:P26 wdt:P27 p:P27 wdt:P166 p:P166 wdt:P39 p:P39 wdt:P607 p:P607 wdt:P735 p:P735 wdt:P21 p:P21 wdt:P551 p:P551 wdt:P102 p:P102 wdt:P1412 p:P1412 wdt:P6886 p:P6886 wdt:P2163 p:P2163 } . wd:Q15029 ?government_government_position_held_office_holder_inverse ?y . VALUES ?government_government_position_held_appointed_by { wdt:P991 p:P991 wdt:P1308 p:P1308 wdt:P112 p:P112 wdt:P710 p:P710 wdt:P542 p:P542 wdt:P488 p:P488 wdt:P726 p:P726 wdt:P40 p:P40 wdt:P6 p:P6 wdt:P138 p:P138 wdt:P1365 p:P1365 wdt:P921 p:P921 wdt:P35 p:P35 wdt:P748 p:P748 wdt:P1366 p:P1366 wdt:P22 p:P22 wdt:P3373 p:P3373 wdt:P50 p:P50 wdt:P26 p:P26 } . ?k ?government_government_position_held_appointed_by wd:Q19211 . VALUES ?government_government_position_held_basic_title_inverse { wdt:P19 p:P19 wdt:P88 p:P88 wdt:P1193 p:P1193 wdt:P3616 p:P3616 wdt:P205 p:P205 wdt:P106 p:P106 wdt:P6161 p:P6161 wdt:P1331 p:P1331 wdt:P279 p:P279 wdt:P677 p:P677 wdt:P6828 p:P6828 wdt:P131 p:P131 wdt:P1001 p:P1001 wdt:P2099 p:P2099 } . wd:Q30461 ?government_government_position_held_basic_title_inverse ?y . VALUES ?c { wd:Q148 } . } LIMIT 100
I am currently getting an empty solution for the query above from both our endpoint and the WDQS endpoint:
[1] https://tinyurl.com/y2t5nwc9 -- results page
[2] https://tinyurl.com/y66n9bk5 -- query editor page
[3] https://tinyurl.com/yxo5kr4w -- WDQS endpoint
What did I miss?
Kingsley
On Sun, Jul 26, 2020 at 7:24 PM Kingsley Idehen <kidehen@openlinksw.com mailto:kidehen@openlinksw.com> wrote:
On 7/26/20 1:00 PM, Egon Willighagen wrote:
See https://phabricator.wikimedia.org/T242453 linked on the report page
That doesn't take directly to a SPARQL query. I just want the SPARQL query. Kingsley
On Sun, Jul 26, 2020 at 6:55 PM Kingsley Idehen <kidehen@openlinksw.com <mailto:kidehen@openlinksw.com>> wrote: On 7/24/20 3:18 PM, Ryan Kemper wrote: > Hi all, > > We experienced WDQS service disruptions on 2020/07/23. As a result > there was a full outage (inability to respond to all queries) for a > period of several minutes, and a more extended period of > intermittently degraded service (inability to respond to a subset of > queries) for 1-2 hours. > > The full incident report is available here: > https://wikitech.wikimedia.org/wiki/Incident_documentation/20200723-wdqs-outage > > Ultimately, we traced the proximate cause to a series of > non-performant queries, which caused a deadlock in blazegraph, the > backend for WDQS. We have placed a temporary block on the IP address > in question and are taking steps to better define service availability > expectations as well as processes to make detection of these events > more streamlined going forward. What was the problem query? I ask because I would like to try it against our Wikidata endpoint at: https://wikidata.demo.openlinksw.com/sparql . We have an "Anytime Query" feature designed for these kinds of problems, hence the vested interest in these kinds of problem queries. -- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com Profile Pages: Pinterest: https://www.pinterest.com/kidehen/ Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen Twitter: https://twitter.com/kidehen Google+: https://plus.google.com/+KingsleyIdehen/about LinkedIn: http://www.linkedin.com/in/kidehen Web Identities (WebID): Personal: http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this _______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org <mailto:Wikidata@lists.wikimedia.org> https://lists.wikimedia.org/mailman/listinfo/wikidata -- Hi, do you like citation networks? Already 51% of all citations are available <https://i4oc.org/> available for innovative new uses <https://twitter.com/hashtag/acs2ioc>. Join me in asking the American Chemical Society to join the Initiative for Open Citations too <https://www.change.org/p/asking-the-american-chemical-society-to-join-the-initiative-for-open-citations>. SpringerNature, the RSC and many others already did <https://i4oc.org/#publishers>. ----- E.L. Willighagen Department of Bioinformatics - BiGCaT Maastricht University (http://www.bigcat.unimaas.nl/) Homepage: http://egonw.github.com/ Blog: http://chem-bla-ics.blogspot.com/ PubList: https://www.zotero.org/egonw ORCID: 0000-0001-7542-0286 <http://orcid.org/0000-0001-7542-0286> ImpactStory: https://impactstory.org/u/egonwillighagen _______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org <mailto:Wikidata@lists.wikimedia.org> https://lists.wikimedia.org/mailman/listinfo/wikidata
-- Regards, Kingsley Idehen Founder & CEO OpenLink Software Home Page: http://www.openlinksw.com Community Support: https://community.openlinksw.com Weblogs (Blogs): Company Blog: https://medium.com/openlink-software-blog Virtuoso Blog: https://medium.com/virtuoso-blog Data Access Drivers Blog: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers Personal Weblogs (Blogs): Medium Blog: https://medium.com/@kidehen Legacy Blogs: http://www.openlinksw.com/blog/~kidehen/ http://kidehen.blogspot.com Profile Pages: Pinterest: https://www.pinterest.com/kidehen/ Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen Twitter: https://twitter.com/kidehen Google+: https://plus.google.com/+KingsleyIdehen/about LinkedIn: http://www.linkedin.com/in/kidehen Web Identities (WebID): Personal: http://kingsley.idehen.net/public_home/kidehen/profile.ttl#i : http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this _______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org <mailto:Wikidata@lists.wikimedia.org> https://lists.wikimedia.org/mailman/listinfo/wikidata
-- Hi, do you like citation networks? Already 51% of all citations are available https://i4oc.org/ available for innovative new uses https://twitter.com/hashtag/acs2ioc. Join me in asking the American Chemical Society to join the Initiative for Open Citations too https://www.change.org/p/asking-the-american-chemical-society-to-join-the-initiative-for-open-citations. SpringerNature, the RSC and many others already did https://i4oc.org/#publishers.
E.L. Willighagen Department of Bioinformatics - BiGCaT Maastricht University (http://www.bigcat.unimaas.nl/) Homepage: http://egonw.github.com/ Blog: http://chem-bla-ics.blogspot.com/ PubList: https://www.zotero.org/egonw ORCID: 0000-0001-7542-0286 http://orcid.org/0000-0001-7542-0286 ImpactStory: https://impactstory.org/u/egonwillighagen
On Sun, Jul 26, 2020 at 11:59 PM Kingsley Idehen kidehen@openlinksw.com wrote:
On 7/26/20 1:44 PM, Egon Willighagen wrote:
What did I miss?
Hi,
Thanks for looking into this, note that we don't have yet a reproducible scenario to trigger the dead-lock that caused the incident. Given the strong relations (timeline) of the suspected activity and the incident we are investigating into this direction but the query mentioned here is not sufficient to bring blazegraph down, there are probably other conditions (writes, query load) that we yet need to identify.
-- David C.