Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
5 Registered (David Dreezer, Djuma, LarE, MikeBTech, Sirdude), 17 Guests and 18 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11647
Rick 7499
Ian 4092
Mark S 3969
ntdoc 3089
Sirdude 2027
jgeoff 1876
David Dreezer 1744
driv 1541
AllenAyres 1506
Latest Photos
Sunflower Photo
Testing
Test Photo
4TH of July at the river!
Sunflower Photo
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: 1876
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 & 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: 4092
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: 1876
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 & 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: 1876
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 & 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: 1876
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 & 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: 1876
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 & Safari 3.1 (XP and iPhone)

Top
#212034 - 05/13/08 11:21 AM Re: Couldn't connect. [Re: jgeoff]
Sirdude Online   happy


Registered: 04/19/07
Posts: 2027
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: 1876
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 & 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: 7499
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: 7499
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
Anyone know anything about phpbb versioning?
by David Dreezer
Today at 12:43 PM
How Customizable is the Look?
by flyboy105
Today at 11:48 AM
Ex-Google architect launches rival search engine
by ScriptKeeper
Today at 09:54 AM
Is it possible to show 1 category heading but not the forums?
by ScriptKeeper
Today at 08:40 AM
Using the USERS DB for other app login verification
by ThomasM
Today at 07:02 AM
Forum Stats
3999 Members
33 Forums
30783 Topics
156296 Posts

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