Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
5 registered (cascadeclimbers, DougMM, Gizmo, smallufo, Thelockman), 30 Guests and 21 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 09/18/08
Posts: 9
Top Posters (30 Days)
Ruben Rocha 179
Gizmo 112
Rick 106
Thelockman 79
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
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: 7903
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: 2077
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: 7903
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: 7903
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: 7903
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: 7903
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
No Birthdays
Recent Topics
I'm the Admin but.....
by David DelMonte
Today at 11:12 AM
Fatal error: Smarty::require_once
()

by ThreadsUser
Today at 08:17 AM
PayPal batch file for ID'ing expired and failed payment subscriptions?
by Mitch P.
Today at 06:02 AM
Shrinking graemlins
by Djuma
Yesterday at 05:48 PM
2 problems I'm seeing now.
by DougMM
Yesterday at 04:39 PM
Forum Stats
4261 Members
33 Forums
30535 Topics
154978 Posts

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