See https://phabricator.wikimedia.org/T242453 linked on the report page
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-out...
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