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:
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