Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Gizmo, GregK), 35 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 10/29/06
Posts: 250
Top Posters (30 Days)
Ruben 45
Bert 26
Gizmo 18
Rob Provencher 12
Rimex 9
SD 8
sw55 7
Eugene 5
TCS1 4
Matthias1976 4
Latest Photos
Uhm...
Mayan End of World
Gas Station Disco Video Shoot
Test Pictures
Audrey Kate
Page 1 of 4 1 2 3 4 >
Topic Options
#229959 - 10/15/09 09:01 AM Max User Connections error
ChevyGuy Offline
stranger
Registered: 07/16/06
Posts: 5
Loc: Issaquah, WA
Just upgraded from 7.4.1 to 7.5.3

Now our board has slowed WAY DOWN and I'm seeing hundreds of max_user_connections error messages in the log.

I saw some earlier threads on this but they related to a custom Island. Are there any issues, or tips that I need to take into account as a result of the upgrade?

The host (Webintellects) just came back with this response:
Quote:
Error message means that you have exceeded limit on amount of connections to your database, you need to check your application and make sure that open connections are closed properly, because, unfortunately we can't increase max_user_connections value on the server, since it can cause server overload.
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#229964 - 10/15/09 09:52 AM Re: Max User Connections error [Re: ChevyGuy]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10177
Loc: Aberdeen, WA
Hmm, not real sure what we be causing that. The upgrade from 7.4.1 really didn't add much in the way of new heavy features at all.

Can you post some info like what the max_user_connections is and how many users you have online when you get the error?
Top
#229994 - 10/15/09 02:26 PM Re: Max User Connections error [Re: Rick]
Bill B Offline

enthusiast
Registered: 10/29/06
Posts: 250
Loc: Issaquah, WA
Wow.. I've been getting emails (hate mail :-) since this morning... ouch.

At 9 am today it behaved good for a while. (Suspect they reset the server after my trouble ticket posting to them.)

Then within an hour later with only 5 or 6 uses showing got this from my database guy:

I'm getting errors now when I try to access the DBs:

*Warning*: mysql_connect() [function.mysql-connect <http://vcca.org/members/admin/members/function.mysql-connect>]: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in *E:\inetpub\vhosts\vcca.org\httpdocs\members\Connections\mx_shop.php* on line *9*

*Fatal error*: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in *E:\inetpub\vhosts\vcca.org\httpdocs\members\Connections\mx_shop.php* on line *9
*
_________________________
--BIll B
Top
#229995 - 10/15/09 02:29 PM Re: Max User Connections error [Re: Bill B]
Bill B Offline

enthusiast
Registered: 10/29/06
Posts: 250
Loc: Issaquah, WA
I can't even log in right now...

UBB Message
We encountered a problem. The reason reported was
Database error only visible to forum administrators

Please click back to return to the previous page.
_________________________
--BIll B
Top
#229996 - 10/15/09 02:35 PM Re: Max User Connections error [Re: Bill B]
Ruben Offline

Registered: 12/20/03
Posts: 4932
Loc: Lutz,FL
Can't even view the site url right now
Quote:
We encountered a problem. The reason reported was

Database error only visible to forum administrators

Please click back to return to the previous page.

That error should be viewable from the control panel.
Or ftp to your error logs folder
_________________________
Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Top
#229998 - 10/15/09 02:50 PM Re: Max User Connections error [Re: Bill B]
Ruben Offline

Registered: 12/20/03
Posts: 4932
Loc: Lutz,FL
If you never enabled logs in the ubb control panel.
There is another way to view the errors to get something other than the generic message.
Here
_________________________
Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Top
#230001 - 10/15/09 03:19 PM Re: Max User Connections error [Re: Ruben]
Bill B Offline

enthusiast
Registered: 10/29/06
Posts: 250
Loc: Issaquah, WA
Thanks... I'll need to FTP in since I can't log in to the Control Panel...

Yes, I know about the generic message flag, but have forgotten about it. Maybe it WOULD be helpful to let the users see the "real" message.
_________________________
--BIll B
Top
#230002 - 10/15/09 03:20 PM Re: Max User Connections error [Re: Bill B]
Bill B Offline

enthusiast
Registered: 10/29/06
Posts: 250
Loc: Issaquah, WA
ah... just realized why I never enacted this before.

Quote:
You'll want to change this back when you're finished however, as it could identify db names and other data your users don't really need...
_________________________
--BIll B
Top
#230003 - 10/15/09 03:28 PM Re: Max User Connections error [Re: Bill B]
Ruben Offline

Registered: 12/20/03
Posts: 4932
Loc: Lutz,FL
Yep, You don't want to edit the file and leave it on.
But in a pinch it may be the only way to find the real error.
_________________________
Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Top
#230006 - 10/15/09 06:27 PM Re: Max User Connections error [Re: Bill B]
Gizmo Online   cat

Registered: 06/05/06
Posts: 15453
Loc: Portland, OR; USA
Originally Posted By: Bill B
Maybe it WOULD be helpful to let the users see the "real" message.
Not really, if the error contained say a 3rd party location sql server if you where being DoSed; or say if a password would potentially be dumped to the browser...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
Page 1 of 4 1 2 3 4 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Express hosting.
by Ruben
05/16/13 03:54 PM
Level of detail in new user registration emails
by Mitch P.
05/15/13 10:20 PM
Approving users
by Bert
05/15/13 09:22 PM
Users randomly added to other group
by Bert
05/15/13 09:15 PM
Posting and other problems with 7.5.7
by Matthias1976
05/15/13 02:58 PM
Forum Stats
10965 Members
36 Forums
33957 Topics
183405 Posts

Max Online: 978 @ 06/24/07 10:19 PM
Random Image