Toolserver-l

toolserver-l@lists.wikimedia.org

1612 discussions

Query-Killer is back in action
by DaB. 17 Aug '11

17 Aug '11

Hello all, during the last week I kept an eye on the database-servers and killed queries which had run for too long. In the past we had a programm for that, but somewhen it stoped working and nobody fixed it AFAIK. Because watching the mytop is a boring thing and I have to sleep too, I used the last 2-3 days to write a substitute of the old query-kiler. This program is working now. It does more or less the same as I did, but it send you an eMail when it killed one of your query. I think that is an improvment and I can spend my time with other things. You can find the parameters of when and if the killer works at [1]. Of corse there is always the possiblity of adjustments. Feel free to open bugs at JIRA or discuss on teh mailinglist. Sincerly, DaB. [1] https://wiki.toolserver.org/view/Database_access#Slow_queries_and_the_query… -- Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885

7 13

Re: [Toolserver-l] Query-Killer is back in action
by Hersfold Wikipedia 15 Aug '11

15 Aug '11

It might be best to turn this off until server 3 no longer thinks it's *8 months* behind. ---- User:Hersfold hersfoldwiki(a)gmail.com Sent from my Windows Phone From: Magnus Manske Sent: Sunday, August 14, 2011 13:51 To: toolserver-l(a)lists.wikimedia.org Subject: Re: [Toolserver-l] Query-Killer is back in action On Sun, Aug 14, 2011 at 5:42 PM, DaB. <WP(a)daniel.baur4.info> wrote: > Hello all, > > during the last week I kept an eye on the database-servers and killed queries > which had run for too long. In the past we had a programm for that, but > somewhen it stoped working and nobody fixed it AFAIK. > > Because watching the mytop is a boring thing and I have to sleep too, I used > the last 2-3 days to write a substitute of the old query-kiler. This program > is working now. It does more or less the same as I did, but it send you an > eMail when it killed one of your query. I think that is an improvment and I > can spend my time with other things. > > You can find the parameters of when and if the killer works at [1]. Of corse > there is always the possiblity of adjustments. Feel free to open bugs at JIRA > or discuss on teh mailinglist. So the max run-time is dependent on replag. But, considering this: Replag s3 6050h 10m 44s I currently get bombarded with killed-query-mails :-( Magnus _______________________________________________ Toolserver-l mailing list (Toolserver-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette

2 1

db servers s6 and s7 are apparently read-only right now
by Daniel Schwen 12 Aug '11

12 Aug '11

http://status.toolserver.org/ does not show this, and I don't see an announcement.So maybe this is new and unknown.

2 3

Please use LIMIT for sql-queries of webtools
by DaB. 12 Aug '11

12 Aug '11

Hello all, the last days when the replag on s3 was high, I looked for long-running-querys from time to time. I noticed, that many queries which are run from inside of webtools (like editcounters) had no LIMIT (see [1]). This is bad – no user waits 5000s or more for a result and he/she is long go when the query still needs resources (and at the end the result is abject). So please use a LIMIT for your querys – even if they are fast for normal (the LIMIT doesn't hurt then). Please don't confuse this with the SQL-command LIMIT (which you should also use if possibe ;-)). Sincerly, DaB. [1] https://wiki.toolserver.org/view/Database_access#Query_time_limits -- Userpage: [[:w:de:User:DaB.]] — PGP: 2B255885

1 0

Toolserver status
by MZMcBride 11 Aug '11

11 Aug '11

* http://status.toolserver.org/ is broken * ts-major-outage(a)tcx.org.uk doesn't work * s3/s6/s7 are lagged and overloaded Are there any updates on these issues? MZMcBride

7 12

Toolserver offline?
by Magnus Manske 09 Aug '11

09 Aug '11

Can't lon into nightshade or willow (ssh keeps asking for password). http://toolserver.org/ does not responsive.

5 5

Automated redirects from secure connections to insecure ones onm the toolserver.
by Purodha Blissenbach 04 Aug '11

04 Aug '11

URLs of the type https://toolserver.org/~user redirect to http://toolserver.org/~user/ Likewise, URLs of the type https://toolserver.org/~user/somepath redirect to http://toolserver.org/~user/somepath/ I think it would be better to keep the scheme, and have the redirect use https as well. -- Greetings - Purodha

1 0

Hardware failure affecting s[3467]
by River Tarnell 02 Aug '11

02 Aug '11

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, One of the database servers for these clusters (cassia) has a disk failure of some kind. All databases should be accessible now, but user databases will be missing until the problem is resolved. - river. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (NetBSD) iEYEARECAAYFAk41cOoACgkQIXd7fCuc5vKekwCgnhvooTgdXbUXZ7dWotpAAX/R vikAn0ITA4pRfpG+8TFLEnzuLnUV48K3 =kzUq -----END PGP SIGNATURE-----

1 2

FishEye is not reflecting svn commits for project "drtrigon"
by Dr. Trigon 30 Jul '11

30 Jul '11

Hello Everybody! I have a question regarding FishEye and SVN. My FishEye is not updating anymore, look at TS-1102 [1]. May be this is due the change to https for svn? May be not... Any ideas? The other question but not that important would be related with JIRA and FishEye Linkers, as mentioned in TS-748 [2]. (How to get this working?) But one after another. Any help is greatly appreciated. Thanks a lot and greetings DrTrigon [1] https://jira.toolserver.org/browse/TS-1102 [2] https://jira.toolserver.org/browse/TS-748

1 1

Having issue with Subversion
by Hersfold 27 Jul '11

27 Jul '11

Hello all, I'm trying to get my bot's code onto the toolserver's subversion thing, but when I try to commit my code I keep getting a weird error. Earwig was very helpful in trying to work out the cause or a solution, but unfortunately to no avail. Regardless of what login server I use, or if I try to commit files through SSH or through Eclipse's Subversion plugin, I get this error: Transmitting file data .svn: Commit failed (details follow): svn: Couldn't perform atomic initialization I've tried looking for a solution online, but most either refer to a bad SVN version (which isn't the case, since Earwig isn't having issues committing) or fail to provide a solution at all. Does anyone have any ideas? ---- User:Hersfold hersfoldwiki(a)gmail.com

8 8

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Toolserver-l