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 > <kide...@openlinksw.com <mailto:kide...@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 >> <kide...@openlinksw.com <mailto:kide...@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 -- 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
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
