Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
0 registered (), 14 Guests and 19 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/13/08
Posts: 15
Top Posters (30 Days)
Ruben Rocha 167
Rick 116
Gizmo 107
Thelockman 63
driv 56
AllenAyres 35
ScriptKeeper 34
Ian 31
Mark S 30
blaaskaak 29
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
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: 1885
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: 7881
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: 2066
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: 7881
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: 1885
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: 7881
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: 7881
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: 1885
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: 7881
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: 1885
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
Neptin
Recent Topics
How do I set Moderation Queue for an individual user?
by luket
Today at 11:28 AM
Custom Island per Forum?
by unixpaul
Today at 10:18 AM
SQL Corruption?
by Jason Carey
Today at 05:52 AM
adding views column to portal page
by nick1
Today at 05:12 AM
Upload broken in 7.4.1
by MacW
Today at 03:23 AM
Forum Stats
4247 Members
33 Forums
30483 Topics
154643 Posts

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