<div dir="ltr">I am also having troubles with "<span style="font-family:arial,sans-serif;font-size:13px">db-issues (lost connection) occurred when accessing tools-db." from the webserver. I'm also getting "</span><font face="arial, sans-serif">Could not connect to database: Can't c</font><span style="font-family:arial,sans-serif">onnect to MySQL server on 'tools-db' " errors.</span><div>
<span style="font-family:arial,sans-serif"><br></span></div><div><span style="font-family:arial,sans-serif">A few weeks ago, the database problems were only related to </span><span style="color:rgb(0,0,0);font-family:monospace,'Courier New';line-height:1.1em;white-space:pre-wrap;background-color:rgb(249,249,249)">tools-webgrid-04.</span><span style="font-family:arial,sans-serif"> I just stopped and started the webserver to have it run on a different webgrid and things started running smoothly again. Not sure which webgrid is which, but when doing a qstat, it was running on the 2nd webgrid in the list. It is now running on the 4th. </span></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Aug 30, 2014 at 5:10 PM, Hedonil <span dir="ltr"><<a href="mailto:hedonil@action.ms" target="_blank">hedonil@action.ms</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Ah, keep on hammering s6 ;)<br>
Also reminds me to fully publish the pageviews-api for those who
want fast access to pageview data without requesting direct access
to the database.<br>
In a nutshell <br>
-
<a href="https://de.wikipedia.org/wiki/Benutzer_Diskussion:Hedonil#Wikiviewstats_API" target="_blank">https://de.wikipedia.org/wiki/Benutzer_Diskussion:Hedonil#Wikiviewstats_API</a><br>
<br>
The db-issues (lost connection) occurred when accessing tools-db.<br>
<br>
--Hedonil<br>
<br>
<br>
On 29/08/14 17:59, Morten Wang wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">If the performance issues are related to s6, it
might be because I've been hammering that database a bit, for
about 4 days until midnight UTC last night. Don't think they
should result in connection problems, though.
<div>
<br>
</div>
<div>As I'm thinking about grabbing more data (I left a message
on your talk page on de-WP regarding redirects), I'll do some
testing to figure out how to treat the database more kindly.</div>
<div><br>
</div>
<div><br>
</div>
<div>Regards,</div>
<div>Morten</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On 29 August 2014 08:48, Hedonil <span dir="ltr"><<a href="mailto:hedonil@action.ms" target="_blank">hedonil@action.ms</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">In the
last ~ 4 days there has been a noticeable decrease in<br>
performance, esp. longer lasting periods of lag<br>
Since yesterday additionally MySQL connection errors. Logs
are full with<br>
stuff like:<br>
oursql.OperationalError: (2013, 'Lost connection to MySQL
server during<br>
query', None)<br>
<br>
Any maintenance going on? New power-players in Tools? An app
running wild?<br>
<br>
-Hedonil<br>
<br>
_______________________________________________<br>
Labs-l mailing list<br>
<a href="mailto:Labs-l@lists.wikimedia.org" target="_blank">Labs-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Labs-l mailing list
<a href="mailto:Labs-l@lists.wikimedia.org" target="_blank">Labs-l@lists.wikimedia.org</a>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/labs-l</a>
</pre>
</blockquote>
<br>
</div>
<br>_______________________________________________<br>
Labs-l mailing list<br>
<a href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
<br></blockquote></div><br></div>