Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Gizmo, SteveS), 23 Guests and 12 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 886
Top Posters (30 Days)
Ruben 38
Bert 36
Gizmo 23
sb 5
After the Rose 4
hema0359 4
BellaOnline 3
skicomau 3
gladiator 3
Willzter 2
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: 4958
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: 4958
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: 4958
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: 15475
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
Need to update from 6 to latest: can't until server checked
by Digilady
Today at 08:17 AM
Shout Box
by Bert
06/15/13 04:15 PM
Calendar
by Bert
06/15/13 04:11 PM
External mail server
by Iann128
06/14/13 08:17 AM
How to get rid of text: "0 Spiders Online"
by sb
06/13/13 09:56 AM
Forum Stats
11000 Members
36 Forums
33986 Topics
183523 Posts

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