Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 registered (David Dreezer, ntdoc, 1 invisible), 25 Guests and 18 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 01/19/08
Posts: 85
Top Posters (30 Days)
Ruben Rocha 103
Rick 80
Mark S 71
Thelockman 58
Gizmo 55
driv 35
ntdoc 32
Sirdude 32
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Page 2 of 3 < 1 2 3 >
Topic Options
Rate This Topic
#212048 - 05/13/08 12:32 PM Re: Couldn't connect. [Re: Rick]
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1901
Loc: NJ

This is all I get, Rick...


Attachments
show_processlist.gif


_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
#212049 - 05/13/08 12:34 PM Re: Couldn't connect. [Re: jgeoff]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7991
Loc: Aberdeen, WA
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#212051 - 05/13/08 12:54 PM Re: Couldn't connect. [Re: Rick]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2122
Loc: SoCal, USA
SHOW VARIABLES <-- run that sql and it will show the variables

there are 2 fields

max_user_connections (usually 0 -- unlimited) and
max_connections (default 100)

Linky Poo™

for more info smile
_________________________


Top
#212052 - 05/13/08 12:55 PM Re: Couldn't connect. [Re: Sirdude]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7991
Loc: Aberdeen, WA
ah yeah, forgot about that wink

Yeah, run that and then look for the max_user_connections to see what they have it set to.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#212072 - 05/13/08 05:12 PM Re: Couldn't connect. [Re: Rick]
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1901
Loc: NJ
Code:
max_user_connections  	 25
max_connections  	500

25 seems kinda small?!

As for show processlist, I keep getting just the one line
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
#212073 - 05/13/08 05:20 PM Re: Couldn't connect. [Re: jgeoff]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7991
Loc: Aberdeen, WA
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#212076 - 05/13/08 07:31 PM Re: Couldn't connect. [Re: Rick]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7991
Loc: Aberdeen, WA
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 wink
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#212077 - 05/13/08 07:36 PM Re: Couldn't connect. [Re: Rick]
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1901
Loc: NJ

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...



Edited by jgeoff (05/13/08 07:39 PM)
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
#212078 - 05/13/08 07:38 PM Re: Couldn't connect. [Re: jgeoff]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7991
Loc: Aberdeen, WA
Check your PM, you posted right after I posted to you wink
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#212079 - 05/13/08 07:54 PM Re: Couldn't connect. [Re: Rick]
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1901
Loc: NJ

A public thank you for tracking that down!!

Rick Rawks! cool
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
Page 2 of 3 < 1 2 3 >


Shout Box

Today's Birthdays
Anoneguy
Recent Topics
Chaging the "max online" number and date
by wanted
Today at 02:22 PM
7.4.1. In Threaded Mode - "Mark All Read" Doesn't Work
by packlite
Today at 10:26 AM
Custom island with sql connection
by Robje01
Today at 09:13 AM
Arabic letters test
by Cowabanga
Today at 04:47 AM
Error Message
by Boyzone-Online
Yesterday at 03:14 PM
Forum Stats
4296 Members
33 Forums
30685 Topics
155995 Posts

Max Online: 978 @ 06/24/07 08:19 PM