Go Back   Super Soaker Central > Super Soaker Central > Feedback
User Name
Password
FAQ Members List Calendar Mark Forums Read


Welcome to the SSC Forums! You are currently viewing our boards as a guest which gives you limited access. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and more. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us.
Important note: The SSC forums are now in archive mode. WaterWar.net is the new online discussion board for the water gun hobby.

Reply
 
Thread Tools
Old 07-22-2010, 05:46 PM   #1
mysterio
LPD enthusiast.
 
mysterio's Avatar
 
Join Date: Jul 2010
Posts: 142
UserID: 2187
Default messed-up homepage

i cant access anything but the forums. anyone else have this problem?
mysterio is offline   Reply With Quote
Old 07-22-2010, 05:47 PM   #2
zeda.beta
Senior Member
 
zeda.beta's Avatar
 
Join Date: May 2009
Location: Crater 5, Moon
Posts: 683
UserID: 1825
Default Re: messed-up homepage

nvm, homepage just stopped loading.
__________________
I reject your reality and substitute my own.
Quack damn you.
zeda.beta is offline   Reply With Quote
Old 07-22-2010, 06:00 PM   #3
SEAL
Host of 1st ever community war
 
SEAL's Avatar
 
Join Date: Jul 2010
Location: 2 hours north of New York City
Posts: 192
UserID: 2146
Default Re: messed-up homepage

Yeah, whenever I try to go there it just shows a blank screen.
__________________
Captain of the Catskill Mountain S.E.A.L.s (Soaker Elite Assault Legion.)
SEAL is offline   Reply With Quote
Old 07-22-2010, 06:06 PM   #4
cantab
Administrator
 
cantab's Avatar
 
Join Date: Oct 2007
Location: England
Posts: 1,492
UserID: 1400
Default Re: messed-up homepage

Confirmed the problem.
__________________
I work on Windows. My toolbox is Linux.
Arsenal:
Super Soaker: XP215, 2xXP220, Liquidator, Aquashock Secret Strike M(odded), Arctic Blast M, CPS1200, CPS2100, SC Power Pak, 3l aquapack, 1.5l aquapack
Water Warriors: Jet, Sting Ray M, Shark, Argon M, Tiger Shark, PulseMaster
Others: Waterbolt, The Blaster, Storm 500, Shield Blaster 2000, generic PR gun, generic backpack piston pumper (broken), 3l garden sprayer M, 10l water carrier:
cantab is offline   Reply With Quote
Old 07-22-2010, 06:11 PM   #5
Ben
Founder
 
Ben's Avatar
 
Join Date: Mar 2003
Location: Maryland
Posts: 6,449
UserID: 1
Default Re: messed-up homepage

I started investigating via MySQL in the terminal this time and I came across this:

Code:
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.
__________________

[email address] / Please read this before emailing or PMing me

Do not ask me water gun questions by email or PM. Please post the question at the forum. Private questions and suggestions are welcome by PM and email. Also, I do not sell or buy water guns online.
Ben is offline   Reply With Quote
Old 07-22-2010, 07:16 PM   #6
mysterio
LPD enthusiast.
 
mysterio's Avatar
 
Join Date: Jul 2010
Posts: 142
UserID: 2187
Default Re: messed-up homepage

ok, that seems like a LOT of connections. gl with that. and thanks for seeing this
mysterio is offline   Reply With Quote
Old 07-22-2010, 07:36 PM   #7
Ben
Founder
 
Ben's Avatar
 
Join Date: Mar 2003
Location: Maryland
Posts: 6,449
UserID: 1
Default Re: messed-up homepage

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.
__________________

[email address] / Please read this before emailing or PMing me

Do not ask me water gun questions by email or PM. Please post the question at the forum. Private questions and suggestions are welcome by PM and email. Also, I do not sell or buy water guns online.
Ben is offline   Reply With Quote
Old 07-24-2010, 08:28 AM   #8
Silence
Administrator
 
Silence's Avatar
 
Join Date: Apr 2006
Location: Cville, VA / Urbana, IL
Posts: 3,825
UserID: 576
Default Re: messed-up homepage

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 (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.
__________________
Forum rules

Last edited by Silence : 07-24-2010 at 09:00 AM.
Silence is offline   Reply With Quote
Old 07-24-2010, 12:07 PM   #9
zeda.beta
Senior Member
 
zeda.beta's Avatar
 
Join Date: May 2009
Location: Crater 5, Moon
Posts: 683
UserID: 1825
Default Re: messed-up homepage

It works now! Whatever you guys did, great job!
__________________
I reject your reality and substitute my own.
Quack damn you.
zeda.beta is offline   Reply With Quote
Old 07-24-2010, 03:02 PM   #10
Ben
Founder
 
Ben's Avatar
 
Join Date: Mar 2003
Location: Maryland
Posts: 6,449
UserID: 1
Default Re: messed-up homepage

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.
__________________

[email address] / Please read this before emailing or PMing me

Do not ask me water gun questions by email or PM. Please post the question at the forum. Private questions and suggestions are welcome by PM and email. Also, I do not sell or buy water guns online.
Ben is offline   Reply With Quote
Old 08-05-2010, 08:30 AM   #11
SEAL
Host of 1st ever community war
 
SEAL's Avatar
 
Join Date: Jul 2010
Location: 2 hours north of New York City
Posts: 192
UserID: 2146
Default Re: messed-up homepage

It's gone down again.
__________________
Captain of the Catskill Mountain S.E.A.L.s (Soaker Elite Assault Legion.)
SEAL is offline   Reply With Quote
Old 08-05-2010, 09:58 AM   #12
Ben
Founder
 
Ben's Avatar
 
Join Date: Mar 2003
Location: Maryland
Posts: 6,449
UserID: 1
Default Re: messed-up homepage

I can see that now. This is frustrating. I'll recode the backend this weekend to see if that has an effect.
__________________

[email address] / Please read this before emailing or PMing me

Do not ask me water gun questions by email or PM. Please post the question at the forum. Private questions and suggestions are welcome by PM and email. Also, I do not sell or buy water guns online.
Ben is offline   Reply With Quote
Old 08-06-2010, 11:30 AM   #13
SEAL
Host of 1st ever community war
 
SEAL's Avatar
 
Join Date: Jul 2010
Location: 2 hours north of New York City
Posts: 192
UserID: 2146
Default Re: messed-up homepage

Well, it seems to be back up again. I hope it stays that way.
__________________
Captain of the Catskill Mountain S.E.A.L.s (Soaker Elite Assault Legion.)
SEAL is offline   Reply With Quote
Old 08-14-2010, 04:58 PM   #14
Fredcompany
That guy from England
 
Join Date: May 2010
Location: England
Posts: 198
UserID: 2073
Default Re: messed-up homepage

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"
__________________
I'm a dude
Fredcompany is offline   Reply With Quote
Old 08-14-2010, 05:19 PM   #15
SEAL
Host of 1st ever community war
 
SEAL's Avatar
 
Join Date: Jul 2010
Location: 2 hours north of New York City
Posts: 192
UserID: 2146
Default Re: messed-up homepage

Yeah we've confirmed the problem at iSoaker. Except with me, it just shows a blank screen. But I don't have google chrome.
__________________
Captain of the Catskill Mountain S.E.A.L.s (Soaker Elite Assault Legion.)
SEAL is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -5. The time now is 07:05 AM.


Powered by vBulletin
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2003 - 2011 The Super Soaker Central project