[Labs-l] Tool Labs slow + MySQL connection errors

[Bryan White]

I am also having troubles with  "db-issues (lost connection) occurred when
accessing tools-db."  from the webserver.  I'm also getting "Could not
connect to database: Can't connect to MySQL server on 'tools-db' " errors.

A few weeks ago, the database problems were only related to
tools-webgrid-04.   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.


On Sat, Aug 30, 2014 at 5:10 PM, Hedonil <hedonil at action.ms> wrote:

>  Ah, keep on hammering s6 ;)
> 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.
> In a nutshell
> -
> https://de.wikipedia.org/wiki/Benutzer_Diskussion:Hedonil#Wikiviewstats_API
>
> The db-issues (lost connection) occurred when accessing tools-db.
>
> --Hedonil
>
>
> On 29/08/14 17:59, Morten Wang wrote:
>
> 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.
>
>  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.
>
>
>  Regards,
> Morten
>
>
>
> On 29 August 2014 08:48, Hedonil <hedonil at action.ms> wrote:
>
>> In the last ~ 4 days there has been a noticeable decrease in
>> performance, esp. longer lasting periods of lag
>> Since yesterday additionally MySQL connection errors. Logs are full with
>> stuff like:
>> oursql.OperationalError: (2013, 'Lost connection to MySQL server during
>> query', None)
>>
>> Any maintenance going on? New power-players in Tools? An app running wild?
>>
>> -Hedonil
>>
>> _______________________________________________
>> Labs-l mailing list
>> Labs-l at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/labs-l
>>
>
>
>
> _______________________________________________
> Labs-l mailing listLabs-l at lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20140902/f311273a/attachment.html>