Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
4 Registered (auduntvedt, blaaskaak, mcasado, 1 invisible), 20 Guests and 21 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11702
Rick 7567
Ian 4107
Mark S 3983
ntdoc 3110
Sirdude 2041
jgeoff 1882
David Dreezer 1759
driv 1568
AllenAyres 1529
Latest Photos
Carrie - So Very
Testing
Test Photo
4TH of July at the river!
Test shots from D300 part 3
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: 1882
Loc: NJ

This is all I get, Rick...


Attachments
show_processlist.gif(67 downloads)

_________________________
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: 7567
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: 2041
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
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

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

*****

Registered: 06/04/06
Posts: 7567
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: 1882
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: 7567
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: 7567
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: 1882
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: 7567
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: 1882
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

Recent Topics
Changing title of forum
by Baby Boomer
Today at 07:38 AM
Disable PM's for one group
by Musky
Today at 07:10 AM
SQL Error: Got error 28 from storage engine ?
by jgeoff
Yesterday at 05:03 PM
Stop All E-mail
by Mark S
Yesterday at 11:16 AM
Ability to Truncate a thread from any point at any time.
by Naz
Yesterday at 07:37 AM
Forum Stats
4025 Members
33 Forums
30880 Topics
156803 Posts

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