Page 1 of 2

messed-up homepage

Posted: Thu Jul 22, 2010 10:46 pm
by mysterio
i cant access anything but the forums. anyone else have this problem?

Re: messed-up homepage

Posted: Thu Jul 22, 2010 10:47 pm
by zeda.beta
nvm, homepage just stopped loading.

Re: messed-up homepage

Posted: Thu Jul 22, 2010 11:00 pm
by SEAL
Yeah, whenever I try to go there it just shows a blank screen.

Re: messed-up homepage

Posted: Thu Jul 22, 2010 11:06 pm
by cantab
Confirmed the problem.

Re: messed-up homepage

Posted: Thu Jul 22, 2010 11:11 pm
by SSCBen
I started investigating via MySQL in the terminal this time and I came across this:

Code: Select all

mysql> show status like 'Conn%';
+---------------+---------+
| Variable_name | Value   |
+---------------+---------+
| Connections   | 2498414 | 
+---------------+---------+
1 row in set (0.00 sec)
I think millions of connections might be a problem... I'm going to figure out how to terminate these connections.

Re: messed-up homepage

Posted: Thu Jul 22, 2010 11:16 pm
by mysterio
ok, that seems like a LOT of connections. gl with that. and thanks for seeing this

Re: messed-up homepage

Posted: Thu Jul 22, 2010 11:36 pm
by SSCBen
I don't think there's anything I can do to terminate these connections. I've informed our host of the problem and hopefully they'll terminate the connections.

This is an odd problem because it started only late last year if I recall correctly. I haven't changed any of the backend code in a while. Silence, did you change any of the code in a way that this might occur?

I'm going to look through the backend to make sure that all connections close.

Re: messed-up homepage

Posted: Sat Jul 24, 2010 12:28 pm
by Silence
I don't think so...I don't think I've modified any database code at all. I know I rewrote the home page around this time last year so I'll take a look at that.

For those who did encounter this problem, was it only on the home page or anywhere in the main website (http://www.sscentral.org/...)? I can't tell because things are working at the moment.

Edit: Looks like I did a bit of backend work. But what I've looked at so far looks clean, and none of it would have been executed 10,000 times a day for 300 days.

Re: messed-up homepage

Posted: Sat Jul 24, 2010 4:07 pm
by zeda.beta
It works now! Whatever you guys did, great job!

Re: messed-up homepage

Posted: Sat Jul 24, 2010 7:02 pm
by SSCBen
The problem is almost certainly not the database. The number I posted above applies for the entire server. I did a check of processes for our account and the only process listed was the process to check what processes are being performed.

I think Silence might have fixed part of the problem, but we'll know in a few days. Let us know here or at iSoaker.net if there are any problems.

Re: messed-up homepage

Posted: Thu Aug 05, 2010 12:30 pm
by SEAL
It's gone down again.

Re: messed-up homepage

Posted: Thu Aug 05, 2010 1:58 pm
by SSCBen
I can see that now. This is frustrating. I'll recode the backend this weekend to see if that has an effect.

Re: messed-up homepage

Posted: Fri Aug 06, 2010 3:30 pm
by SEAL
Well, it seems to be back up again. I hope it stays that way.

Re: messed-up homepage

Posted: Sat Aug 14, 2010 8:58 pm
by Fredcompany
It's down again at 21:57 in England. See the time of my post for the forum time.
The message I get from Google Chrome is:

"This webpage is not available.

The webpage at http://sscentral.org/ might be temporarily down or it may have moved permanently to a new web address.

More information on this error"

Re: messed-up homepage

Posted: Sat Aug 14, 2010 9:19 pm
by SEAL
Yeah we've confirmed the problem at iSoaker. Except with me, it just shows a blank screen. But I don't have google chrome.