SQL error, Maximum connections exceeded (30)

[bchandler]

Over the last couple of weeks I have noticed that the site has become very unstable... seems to be restarting frequently, and is frequently indicating that there are no more connections available to the sql database... even when i am just starting up my browser and attempting to log in.

So, there seems to be some kind of connection limit threshold that is set to low, or the hosting company has throttled traffic to the SQL server so severely that the site frequently does not function.

I am using the latest release of firefox for my browser, running on a fully patched version of windows XP. Quad core 3.6 GHz cpu and 4GB RAM. If that helps at all... though i suspect the real issue is on the back-end.

[burien1]

I am using the latest release of firefox for my browser, running on a fully patched version of windows XP. Quad core 3.6 GHz cpu and 4GB RAM. If that helps at all... though i suspect the real issue is on the back-end.

I've noticed problems all week. And today had trouble even logging on. Whatever is wrong is getting worse, too. I use Firefox, but couldn't tell you a thing about all the rest of what you're talking about.

[SueAnn]

I am using the latest release of firefox for my browser, running on a fully patched version of windows XP. Quad core 3.6 GHz cpu and 4GB RAM. If that helps at all... though i suspect the real issue is on the back-end.

I've noticed problems all week. And today had trouble even logging on. Whatever is wrong is getting worse, too. I use Firefox, but couldn't tell you a thing about all the rest of what you're talking about.

I got that SQL error message, too. I use Internet Explorer...and I know even less than Burien about the other technical stuff you babbled.

[bchandler]

General Error
SQL ERROR [ mysql4 ]

User 'fulfilld_phpbb3' has exceeded the 'max_user_connections' resource (current value: 30) [1226]

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

There is the exact error message.

[GodsStudent]

I've gotten it too. Also, when I make posts, it takes sometimes as long as minutes for the post to take and for me to be able to move on. Then, when I am reading threads, there is a much longer delay going on when I try to move from one thread to another.

[AndCanItBe]

I have found when it hangs up after I've hit the submit button, that I can normally wait about 30 seconds to a minute, and then go ahead and click on the title of the thread again. My post will usually be there in the thread. I always highlight my post and copy it before doing that though. That way I don't have to retype if it didn't work that time.


Thank you all for your patience.

[Jericho]

The hamsters are working overtime.

[burien1]

So where did the Trump thread go ?

[Abiding in His Word]

So where did the Trump thread go ?

New forum

[burien1]

It says I don't have permission to access.

[Abiding in His Word]

It says I don't have permission to access.

thanks for telling me, burien1! I'll check that out right away!

[burien1]

Thanks Abiding. There was a link posted by Kh2010 that I really wanted to copy. Best piece of journalism on Obama's birth certificate mystery, that I've seen to date.

[Abiding in His Word]

I moved that thread back to the News forum for now, burien1.

[Truthinlove]

I keep getting this error too. Most recently about 5 minutes ago.

[bchandler]

yea, i am still seeing this error a lot... sometimes even upon an initial attempt to connect to the site... no teven logged in yet.

[bchandler]

Just a thought for the tech admins regarding this 30 connection limit maxing out all the time. I am noticing that when these errors occur, the google and yahoo web crawling bots are always active on the site.

Is it possible to limit the number of connections they are allowed to make to the SQL server individually? This would prevent these bots from opening too many connections while they are cataloging the site and hopefully prevent the site from being rendered inaccessible.

The current situation really is the equivalent of a denial of service attack by google and yahoo otherwise.

[jgilberAZ]

Robots.txt

User-agent: *
Crawl-delay: 10

[burien1]

Only 6 people on here, and I still have to wait 5 full minutes to post something. No wonder this board is so dead lately.
Could someone PLEASE clue us in ? ? ? ? ? ?

[Abiding in His Word]

I've reported the problem.

[burien1]

Thanks Abiding. It is so frustrating to have a story to post, and not be able to get on. Or read 3 posts and can go no further. Or want to reply, and you simply can't. And I know it has to be keeping others from posting articles, too.

[bchandler]

There are times i can't even hit the main page or login. Sometimes for as much as 30 min.

I don't know if your hosting service is throttling your use of the SQL server or what (that's what it looks like). But it is making the site slower, harder to access, and difficult to post on. Deleting a post almost always results in maxing out connections to the SQL server for some reason also.

I can understand their desire to limit SQL connections if multiple web sites on a single host device are using the same SQL server to access multiple Databases. But they have simply gone too far, and a maximum of 30 connections isn't working.

If the bots haven't been throttled, they need to be. If they already have been throttled, then the hosting service will likely need to increase the number of connections allowed to the SQL server. For a public site such as this one with hundreds if not thousands of members, they probably need to at least double that SQL server connection limit.