General Error?

Post suggestions, correct errors or omissions, or anything else about the site
Post Reply
User avatar
Lunick
6-bit nerd
Posts: 77
Joined: March 2nd, 2013, 2:55 am
Location: Tasmania, Australia
Contact:

General Error?

Post by Lunick »

Every second or so click on the forum gives me the following error:


General Error
SQL ERROR [ mysql4 ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.


What's up?
User avatar
MrFlibble
Forum Administrator
Posts: 1798
Joined: December 9th, 2010, 7:19 am

Re: General Error?

Post by MrFlibble »

Errors like this happen sometimes. This seems to be related to website traffic but I'm no programmer so I can't tell for sure.
Lunick wrote:Too many connections [1040]
I guess this is the reason (again I'm not a specialist in this area!). Usually when a forum starts to slow down or goes offline I just wait for half an hour or more, and the problem disappears.
User avatar
Lunick
6-bit nerd
Posts: 77
Joined: March 2nd, 2013, 2:55 am
Location: Tasmania, Australia
Contact:

Re: General Error?

Post by Lunick »

Hmm, well I haven't had the error before that's all :/
User avatar
MrFlibble
Forum Administrator
Posts: 1798
Joined: December 9th, 2010, 7:19 am

Re: General Error?

Post by MrFlibble »

Does it persist as of now?
User avatar
Lunick
6-bit nerd
Posts: 77
Joined: March 2nd, 2013, 2:55 am
Location: Tasmania, Australia
Contact:

Re: General Error?

Post by Lunick »

I haven't had it today, maybe it was just a minor hiccup.
User avatar
DOSGuy
Website Administrator
Posts: 1063
Joined: September 2nd, 2005, 8:28 pm
Contact:

Re: General Error?

Post by DOSGuy »

Yeah, I'm getting pretty tired of seeing that error in the error logs. When I first purchased hosting from HostGator, they were more than able to handle the traffic we were getting. Things still seemed pretty smooth, even after traffic tripled, but a few months ago they reduced the resources available to shared hosting accounts (even though they deny it) and we're now getting errors like those, even though daily traffic dropped more than 50% from peak, and even though I've spent the last few months reducing the number of database queries and HTTP requests and optimizing the hell out of the site to reduce the load on their servers. With those changes, daily traffic has recovered from ~1500 to ~2500, but I don't think we can support 3000-4000 visitors per day any more. We need to move to better hosting, and I fear it may require expensive Virtual Private Server hosting.
Today entirely the maniac there is no excuse with the article.
User avatar
DOSGuy
Website Administrator
Posts: 1063
Joined: September 2nd, 2005, 8:28 pm
Contact:

Re: General Error?

Post by DOSGuy »

HostGator upgraded the server that RGB is hosted on a few months ago, and I'm not seeing that error message any more. Daily traffic is back in the 3000-4000 range, and we handled over 8000 visitors on June 3 without generating any errors. Hopefully this won't be a problem again.
Today entirely the maniac there is no excuse with the article.
Post Reply