Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
2 Registered (adminwendy, AzHousePro), 24 Guests and 20 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11708
Rick 7567
Ian 4107
Mark S 3984
ntdoc 3114
Sirdude 2041
jgeoff 1882
David Dreezer 1759
driv 1569
AllenAyres 1530
Latest Photos
Carrie - So Very
Testing
Test Photo
4TH of July at the river!
Test shots from D300 part 3
Page 1 of 3 1 2 3 >
Topic Options
Rate This Topic
#212021 - 05/13/08 08:04 AM Couldn't connect.
jgeoff Offline
Pooh-Bah

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

I'm having major problems since yesterday. Users and myself are getting "Couldn't connect." errors -- I'm getting them constantly submitting anything in the control panel -- I can't do anything!

Check out these gems:

Quote:

UBB Message
We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: User gbb_admin has already more than 'max_user_connections' active connections
SQL Error #: 1203
Query: Unable to connect to the database!

Please click back to return to the previous page.

Quote:

UBB Message
We encountered a problem. The reason reported was

Script: /home/gbb/public_html/threads/libs/user.inc.php
Line#: 434
SQL Error: Table 't1' is marked as crashed and should be repaired
SQL Error #: 1194
Query: SELECT t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID = 2 AND t1.USER_ID = t2.USER_ID

Please click back to return to the previous page.

Quote:

UBB Message
We encountered a problem. The reason reported was

Script: /home/gbb/public_html/threads/scripts/activetopics.inc.php
Line#: 139
SQL Error: Got error 127 from storage engine
SQL Error #: 1030
Query: select count(t1.TOPIC_ID) from ubbt_TOPICS as t1, ubbt_FORUMS as t2 where t1.TOPIC_LAST_REPLY_TIME > 1210084688 and t1.FORUM_ID in (16,1,9,12,13,2,3,6,7,10,11,8,14,17,18,5,4,15) and t1.FORUM_ID = t2.FORUM_ID and t2.FORUM_ACTIVE_POSTS = 1 and t1.TOPIC_IS_APPROVED = 1 and t1.TOPIC_STATUS <> 'M'

Please click back to return to the previous page.



Host "repaired" the database to no avail. The board otherwise works, but these *&^$%#@#^%*&^ random (on the main site, and constant in admin) "Couldn't connect" errors upon submitting forms is killing me!! mad

What could be the problem?


Edited by jgeoff (05/13/08 11:21 AM)
_________________________
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
#212023 - 05/13/08 08:30 AM Re: Couldn't connect. [Re: jgeoff]
Ian Moderator Offline


Registered: 06/05/06
Posts: 4107
Loc: Essex, UK
Essentially you have too many people trying to connect to your database than MySQL allows.

Sadly I am not an expert on this, so will have to bow down to someone else.

I have been trying to find a good setting for my server, which is a 4GB Quad CPU machine, but to date have not found anyone to assist (the only site that seems to have anyone is a VB site and I would rather not use their service LOL)
_________________________
Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....))

Top
#212025 - 05/13/08 08:46 AM Re: Couldn't connect. [Re: Ian]
jgeoff Offline
Pooh-Bah

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

6 Registered (4 invisible), 2 Guests and 18 Spiders online. :/

Making a post sometimes gives me "Cannot Connect" but the post goes through anyway -- but in control panel, I cannot successfully submit ANY form that contains data -- can't even clear cache! frown
_________________________
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
#212026 - 05/13/08 10:00 AM Re: Couldn't connect. [Re: jgeoff]
jgeoff Offline
Pooh-Bah

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

Another symptom? My Who's Online island hasn't updated in forever, despite the main WOL page, and the other islands, working fine. I can't clear my cache w/o connect errors.

I'm getting really pissed off right now. mad
_________________________
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
#212031 - 05/13/08 10:45 AM Re: Couldn't connect. [Re: jgeoff]
jgeoff Offline
Pooh-Bah

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

From my host:
Quote:

I was doing some testing on your site and also searching some forums, it seems you are hitting your max connections. There has to be something in your script that is not closing the connections after they are initiated or it might be the 'shout box' killing all your resources. I would reccomend taking down the shout box and seeing if you still get the "Couldn't connect" issue.
_________________________
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
#212032 - 05/13/08 11:06 AM Re: Couldn't connect. [Re: jgeoff]
jgeoff Offline
Pooh-Bah

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

It wasn't the Shout Box. Guess I'll open up a ticket to rule out threads...

Edit: Crap, no credits. frown


Edited by jgeoff (05/13/08 11:08 AM)
_________________________
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
#212034 - 05/13/08 11:21 AM Re: Couldn't connect. [Re: jgeoff]
Sirdude Offline


Registered: 04/19/07
Posts: 2041
Loc: SoCal, USA
are you using persistent connections? turn that off, if you were/are.

_________________________

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

Top
#212036 - 05/13/08 11:25 AM Re: Couldn't connect. [Re: Sirdude]
jgeoff Offline
Pooh-Bah

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

No, I've never enabled that...
_________________________
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
#212045 - 05/13/08 12:25 PM Re: Couldn't connect. [Re: jgeoff]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7567
Loc: Aberdeen, WA
Well, since it's a max_user_connection limit, then you should be able to take a gander at every running connection and see what it's doing and if they are closing or not.

Best bet would be to do it through your host's control panel, like phpmyadmin.

Run the following SQL command and see what you get:

show processlist
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

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

*****

Registered: 06/04/06
Posts: 7567
Loc: Aberdeen, WA
Also, it might be interesting to hear what they have for your max_user_connection limit.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
Page 1 of 3 1 2 3 >


Shout Box

Recent Topics
Problem with forum move
by AzHousePro
Today at 03:41 PM
[7.3.x] Ignore link showed in userprofile for global moderators
by blaaskaak
Yesterday at 01:27 PM
[7.3.x] Database password shown in adminlogs...
by blaaskaak
Yesterday at 10:24 AM
7.3.1 Flood protection
by MattUK
Yesterday at 03:55 AM
Changing title of forum
by Baby Boomer
09/05/08 07:38 AM
Forum Stats
4027 Members
33 Forums
30886 Topics
156841 Posts

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