Page 1 of 1

29.09.2009 Forum and site dead - here we go again

Posted: Tue Sep 29, 2009 9:06 pm
by AUbicycles
Hello.
I am sorry to announce that the forum and site were down (29.09.2009) from about 8:20pm to 8:58pm (Aus EST).
At about 8:26pm I put in an urgent ticket to the host and it is not yet answered, after about half an hour the server restarts anyway.

The error on the site and forum was MySQL: ERROR 1040: Too many connections.
I can't understand why this is happening as connections are set at unlimited (from what I can see in the server settings) and I couldn't see that there was an excessive amount of traffic on the site at the time it died. If anyone is aware of how many users were listed as being on the site just before it died, please let me know.

Yet again I will have a look and see if I can pinpoint the cause and see what it means to resolve the problem.

Cheers
Christopher

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Sep 29, 2009 9:17 pm
by Mulger bill
Same error here Christopher, good thing I did the CtrlC thing...

No idea of members aboard tho', there was about 24 when I logged on about 1900.

Shaun

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Sep 29, 2009 9:51 pm
by Rockford
Yeah about 20 odd, and about 7 bots/spiders I wonder if one of them went haywire and maxed out the connections.

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Sep 29, 2009 11:16 pm
by AUbicycles
Thanks for the feedback...

Well done Shaun, ctrl C .... or Apple C is a lifesaver!

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Oct 13, 2009 3:44 pm
by provoked
I'm not 100% certain, but I think it may have happened again. Got a MySQL Error, forums weren't available for a short while.

Can't remember exact error, sorry.

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Oct 13, 2009 3:54 pm
by Aushiker
Hi

Yep it is back or rather was at around 12:30 PM GMT + 8. Email sent.

Regards
Andrew

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Oct 13, 2009 3:57 pm
by provoked
Not sure if I have my timezones confused but mine only happened a bit before my post, i.e. 3:40PM ish

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Oct 13, 2009 3:58 pm
by Aushiker
provoked wrote:Not sure if I have my timezones confused but mine only happened a bit before my post, i.e. 3:40PM ish


That is about right assuming you are on eastern states DST. It was out for around 10 minutes.

Andrew

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Oct 13, 2009 4:02 pm
by provoked
Aushiker wrote:
provoked wrote:Not sure if I have my timezones confused but mine only happened a bit before my post, i.e. 3:40PM ish


That is about right assuming you are on eastern states DST. It was out for around 10 minutes.

Andrew


:P Apologies Andrew - told you my zones would have been confused :oops:

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Oct 13, 2009 11:35 pm
by AUbicycles
Timing may have not been identical for all - reason being is that if you already have a connection with the site that it being maintained then it may stay up - while new users or users who have their connections refreshed are thrown off.

Thanks for the mail Andrew - it was the start of a bunch of problems on the site.

Re: 29.09.2009 Forum and site dead - here we go again

Posted: Tue Jan 19, 2010 9:30 am
by steveoc
Not sure what your hosting arrangement is - but next time this happens, ideally you could login to the server via ssh, and get into mysql manually (mysql reserves a connection for the supervisor account even when maxed out), and then use SHOW PROCESSLIST to diagnose the issue ?