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> 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> 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
https://lists.wikimedia.org/mailman/listinfo/wikidata


--
Hi, do you like citation networks? Already 51% of all citations are available available for innovative new uses. Join me in asking the American Chemical Society to join the Initiative for Open Citations too. SpringerNature, the RSC and many others already did.

-----
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
ImpactStory: https://impactstory.org/u/egonwillighagen

_______________________________________________
Wikidata mailing list
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
https://lists.wikimedia.org/mailman/listinfo/wikidata


--
Hi, do you like citation networks? Already 51% of all citations are available available for innovative new uses. Join me in asking the American Chemical Society to join the Initiative for Open Citations too. SpringerNature, the RSC and many others already did.

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