Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (57-Vette, Chosen, Stan), 39 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 10/19/08
Posts: 52
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 23
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 4 1 2 3 4 >
Topic Options
#229959 - 10/15/09 10: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 10:52 AM Re: Max User Connections error [Re: ChevyGuy]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
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 03:26 PM Re: Max User Connections error [Re: Rick]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
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 03:29 PM Re: Max User Connections error [Re: Bill B]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
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 03:35 PM Re: Max User Connections error [Re: Bill B]
Ruben Offline

Registered: 12/20/03
Posts: 4424
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
Top
#229998 - 10/15/09 03:50 PM Re: Max User Connections error [Re: Bill B]
Ruben Offline

Registered: 12/20/03
Posts: 4424
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
Top
#230001 - 10/15/09 04:19 PM Re: Max User Connections error [Re: Ruben]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
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 04:20 PM Re: Max User Connections error [Re: Bill B]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
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 04:28 PM Re: Max User Connections error [Re: Bill B]
Ruben Offline

Registered: 12/20/03
Posts: 4424
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
Top
#230006 - 10/15/09 07:27 PM Re: Max User Connections error [Re: Bill B]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
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 UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, 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
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

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