I'm having major problems since yesterday. Users and myself are getting "Couldn't connect." errors -- I'm getting them constantly submitting anything in the control panel -- I can't do anything!
Check out these gems:
Quote
UBB Message We encountered a problem. The reason reported was
Script: Line#: SQL Error: User gbb_admin has already more than 'max_user_connections' active connections SQL Error #: 1203 Query: Unable to connect to the database!
Please click back to return to the previous page.
Quote
UBB Message We encountered a problem. The reason reported was
Script: /home/gbb/public_html/threads/libs/user.inc.php Line#: 434 SQL Error: Table 't1' is marked as crashed and should be repaired SQL Error #: 1194 Query: SELECT t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID = 2 AND t1.USER_ID = t2.USER_ID
Please click back to return to the previous page.
Quote
UBB Message We encountered a problem. The reason reported was
Script: /home/gbb/public_html/threads/scripts/activetopics.inc.php Line#: 139 SQL Error: Got error 127 from storage engine SQL Error #: 1030 Query: select count(t1.TOPIC_ID) from ubbt_TOPICS as t1, ubbt_FORUMS as t2 where t1.TOPIC_LAST_REPLY_TIME > 1210084688 and t1.FORUM_ID in (16,1,9,12,13,2,3,6,7,10,11,8,14,17,18,5,4,15) and t1.FORUM_ID = t2.FORUM_ID and t2.FORUM_ACTIVE_POSTS = 1 and t1.TOPIC_IS_APPROVED = 1 and t1.TOPIC_STATUS <> 'M'
Please click back to return to the previous page.
Host "repaired" the database to no avail. The board otherwise works, but these *&^$%#@#^%*&^ random (on the main site, and constant in admin) "Couldn't connect" errors upon submitting forms is killing me!!
What could be the problem?
Last edited by jgeoff; 05/13/20082:21 PM.
GangsterBB.NET (Ver. 7.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP
Essentially you have too many people trying to connect to your database than MySQL allows.
Sadly I am not an expert on this, so will have to bow down to someone else.
I have been trying to find a good setting for my server, which is a 4GB Quad CPU machine, but to date have not found anyone to assist (the only site that seems to have anyone is a VB site and I would rather not use their service LOL)
Making a post sometimes gives me "Cannot Connect" but the post goes through anyway -- but in control panel, I cannot successfully submit ANY form that contains data -- can't even clear cache!
GangsterBB.NET (Ver. 7.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP
Another symptom? My Who's Online island hasn't updated in forever, despite the main WOL page, and the other islands, working fine. I can't clear my cache w/o connect errors.
I'm getting really pissed off right now.
GangsterBB.NET (Ver. 7.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP
I was doing some testing on your site and also searching some forums, it seems you are hitting your max connections. There has to be something in your script that is not closing the connections after they are initiated or it might be the 'shout box' killing all your resources. I would reccomend taking down the shout box and seeing if you still get the "Couldn't connect" issue.
GangsterBB.NET (Ver. 7.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP
Well, since it's a max_user_connection limit, then you should be able to take a gander at every running connection and see what it's doing and if they are closing or not.
Best bet would be to do it through your host's control panel, like phpmyadmin.
Run the following SQL command and see what you get:
Ok, refresh that from time to time. That looks good. It means at the time you ran that, there was only 1 active connection to the database.
Keep refreshing it, especially if the error pops up quite a bit, when it does pop, if it truly is a connection number problem, then you should see a long list of connections.
25 is pretty small, especially if there is any sort of delay in any of the queries running. If any happen to need to do some sort of table lock while the mysql server is a bit slow then anyone else on the forums at that point will get queued up.
So, 25 connections could conceivably be taken up in very short order. Normally, even on this site, I'll only see 1-3 active connections. But there are times it can spike up for sure.
That being said, the error you are getting normally seems a bit odd. "Couldn't connect" is pretty generic, definitely not coming from UBB.threads, and the fact that I can get this error on your site when show processlist is showing only 1 active mysql connection is pretty suspicious.
For anyone following along, this isn't threads related. It's a custom island issue with trying to connect to a database that apparently doesn't have permission
It is? I know Who's Online stopped working... OH! So did the TV Listings... hmm... You're right! That's where the error message is coming from. I'll have to look into why it just stopped working all of a sudden. I know they moved the server it was hosted on - maybe it has something to do with that. I'll disable it and see if everything else starts working again...
Last edited by jgeoff; 05/13/200810:39 PM.
GangsterBB.NET (Ver. 7.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP
Whew! After another whole day working with my web host wondering why mysql_connect wasn't working, Level 2 support figured it out pretty quickly: apparently there was some unrelated IP address that needed to be added to the Access Hosts list. Bizarre, because it appears to be a dedicated IP for some unrelated web site on the server.
Thanks again, Rick, for tracking down the source of this non-Threads problem!
GangsterBB.NET (Ver. 7.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP
We encountered a problem. The reason reported was Script: Line#: SQL Error: Too many connections SQL Error #: 1040 Query: Unable to connect to the database!
Please click back to return to the previous page.
I don't even think I can get into the control panel.
And if this is something MySql related, I'm really screwed because that stuff is Greek to me.
This is basically stating that you've reached the max connections allowed to MySQL. Are you on a shared server or is this your own server? If it's your own/dedicated server then it's just a matter of bumping up max_connections if the server has the resources.
If you're on a shared host, then it's a bit tricky. The error message is the global one, meaning that they have a set amount of connections for all domains on the machine, and it's being reached, and they might not bump it.
It's her own server; I bumped it up to something insanely high that she should never reach and restarted MySQL... Luckily she caught me yesterday morning before i went to bed...