The Gaming Den

[fectin]

[tzor]

YOU ARE NOT ALONE!

Although I'm not getting it at this moment.

I suspect we are being visited by bots on a frequent basis.

After I posted I went to the main page

In total there are 35 users online :: 8 Registered, 0 Hidden and 27 Guests

[Meikle641]

Just got that error myself.
_________________

[Zherog]

Thanks for the heads up.

[tzor]

[Zherog]

I did a bit more digging last night, and for the first time my searching turned up an answer that points to a bug in the software rather than a server-side setting. If the source I found is correct, phpbb has a bug that makes it so not all db connections are closed after they're used. Eventually, the open connection will time out and release itself, but if enough of them hang at one time (such as when a crawler is on the site), then we get the error.

The source I found also had a very simple fix that can be added to any page. It goes out, finds SQL connections older than some specified time, and kills them. I'm going to find some time this week to make those changes, and then we'll see if the issue goes away.
_________________
You can't fix stupid.

"A life is not important except in the impact it has on other lives." ~ Jackie Robinson

[Parthenon]

If you've already made those changes then it hasn't helped- I just got another too many connections error twice in a row about a minute ago.

[Zherog]

I haven't yet made the changes. Been losing a fight with the scheduling monster. Thanks for the update, though.

edit: also, I deleted one of your double posts... just so nobody wonders where it went.
_________________
You can't fix stupid.

"A life is not important except in the impact it has on other lives." ~ Jackie Robinson

[Zherog]

note to self: get off your lazy ass and fix the error already, you lazy fucking bastard...
_________________
You can't fix stupid.

"A life is not important except in the impact it has on other lives." ~ Jackie Robinson

[fectin]

Would it work t write a cronjob that kills all old connections every 15 min?

[Zherog]

I've just now installed a fix. While I can't test it - because I don't have the capacity to reproduce the error - everything seems to be functioning normal. Essentially, every time anybody loads the index page it'll go out and find any SQL connections that are more than 500 seconds old and kill them. I can adjust that number up or down as needed. My hunch is I'll need to reduce it once or twice, but I'd rather start out there.

If anybody has any issues loading pages today (Sunday July 31st) please send me a PM so that I'll get an email notification. I can revert back to the previous code if necessary. If anybody encounters the "too many connections" error going forward, please post the info in this thread, and I'll look into getting the number of seconds reduced.

Sorry for the delay getting it fixed; hopefully this wraps up the issue.

*

Fectin -- your idea would seem to work to me, except I don't know if I have access to crontab on the server or not. The solution I have, instead, just looks for the old connections whenever that page loads and kills them. Same effect, different way of getting to it.
_________________
You can't fix stupid.

"A life is not important except in the impact it has on other lives." ~ Jackie Robinson

[Zherog]

Alright, so no PMs and no posts since I made the changes likely means I didn't fuck anything up. Yay me!

Hopefully this issue is behind us now. Of course, if anybody encounters it then certainly go ahead and post here, and I'll see if I can find anything else on the error.
_________________
You can't fix stupid.

"A life is not important except in the impact it has on other lives." ~ Jackie Robinson

[Zherog]

Well, so much for it being fixed... I just got the message. At some point this week I'll try adding the code to a page that gets loaded more often, like the Forum or Thread page, rather than just the index.
_________________
You can't fix stupid.

"A life is not important except in the impact it has on other lives." ~ Jackie Robinson

[fectin]

It's back again. I've been getting rather a lot of them.

[Prak_Anima]

today, 27 minutes ago.

Click here to see the hidden message (It might contain spoilers)

Warning: mysql_connect() [function.mysql-connect]: User niftymes_tgdmbpr already has more than 'max_user_connections' active connections in /home2/niftymes/public_html/tgdmb/db/mysql4.php on line 48
phpBB : Critical Error

Could not connect to the database

_________________
Formally taking commissions. Click to see prices and portfolio.

[Cynic]

It's been appearing on and off today.
_________________
Koumei's The Last Laugh campaign - Murphy: Part man, part woman, part robot, mostly stolen from Robocop

[shadzar]

massive too many connections and 500 server errors, within the past 2 hours.
_________________
Play the game, not the rules.

Click here to see the hidden message (It might contain spoilers)

Swordslinger wrote:

Or fuck it... I'm just going to get weapon specialization in my cock and whip people to death with it. Given all the enemies are total pussies, it seems like the appropriate thing to do.

Lewis Black wrote:

If the people of New Zealand want to be part of our world, I believe they should hop off their islands, and push 'em closer.

good read (Note to self Maxus sucks a barrel of cocks.)