New subject: WDQS outage - 2020/07/23

27 Jul 2020

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
 &lt;kidehen(a)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
     &lt;kidehen(a)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-ou…

 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(a)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(a)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(a)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

Re: [Wikidata] WDQS outage - 2020/07/23