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
I got this a couple minutes ago. I know there was a separate thread on it before, but I couldn't find it.
Edit: And now I'm getting it a whole bunch. Like every other link. Am I the only one?
Last edited by fectin on Tue Jul 05, 2011 7:49 pm, edited 1 time in total.
No it's not, but if they are bots, they may be using resources faster than normal humans merely because they are scanning a page in milliseconds while normal humans often take a minute looking at the results of a web page query. Thus if 30 humans were on line it would be rare for two of them to hit the database at the same time, but or 30 bots, at any given moment several may be hitting the database.
Just my wild speculation, since i don't know the max database connection number for this system.
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
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
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
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
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
Cuz apparently I gotta break this down for you dense motherfuckers- I'm trans feminine nonbinary. My pronouns are they/them.
Winnah wrote:No, No. 'Prak' is actually a Thri Kreen impersonating a human and roleplaying himself as a D&D character. All hail our hidden insect overlords.
FrankTrollman wrote:In Soviet Russia, cosmic horror is the default state.
You should gain sanity for finding out that the problems of a region are because there are fucking monsters there.
massive too many connections and 500 server errors, within the past 2 hours.
Play the game, not the rules.
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.)