Page 1 of 2

SQL error

PostPosted: Sun Dec 01, 2013 7:46 pm
by Rommie
Got this a few times lately- something about too many people logged in, and the site won't load. Anyone else?

Re: SQL error

PostPosted: Sun Dec 01, 2013 7:52 pm
by The Supreme Canuck
Yep. A few times over the last week or so.

Re: SQL error

PostPosted: Sun Dec 01, 2013 7:55 pm
by Cyborg Girl
Me as well. Didn't really want to create a fuss about it though...

http://dev.mysql.com/doc/refman/5.5/en/ ... tions.html

For the record, "1203" is the error number, not the maximum number of connections. I suspect this is a matter of the host using rubbishy default settings (possibly on purpose to discourage too much traffic). But I don't know enough about MySQL and associated stuff to say for sure.

Re: SQL error

PostPosted: Sun Dec 01, 2013 8:34 pm
by Rommie
General Error
SQL ERROR [ mysqli ]

User phpdoLQEg8G already has more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Re: SQL error

PostPosted: Sun Dec 01, 2013 11:50 pm
by geonuc
Haven't seen it.

Re: SQL error

PostPosted: Mon Dec 02, 2013 9:28 am
by brite
I put in a trouble ticket about it... we'll see what they come back with...

Re: SQL error

PostPosted: Mon Dec 02, 2013 9:31 am
by Cyborg Girl
Wow. That was fixed fast. :cheer:

Re: SQL error

PostPosted: Mon Dec 02, 2013 10:10 am
by geonuc
So we have a proper, responsive host?

Re: SQL error

PostPosted: Mon Dec 02, 2013 4:42 pm
by brite
When I was looking for a hosting company... I looked for one that was in the US and spoke English...

Re: SQL error

PostPosted: Tue Dec 03, 2013 2:11 am
by The Supreme Canuck
Woah. Okay. I've been getting a 404 error for the last day or so. I've only just been able to get back on. The URL I had bookmarked doesn't point to the board anymore. There was no indication where it had gone. Obviously I found it, but I wonder if others are unable to find it and are stuck staring at a 404 page?

Re: SQL error

PostPosted: Tue Dec 03, 2013 2:24 am
by Cyborg Girl
Because the forum moved from a subdirectory to the main site. :) It's now just fwis3.com.

Re: SQL error

PostPosted: Tue Dec 03, 2013 2:34 am
by The Supreme Canuck
Yes, I know. But I had the subdirectory bookmarked. If other people do, and don't know to play with the URL, they may be stuck with the 404 and nothing else. If people stop showing up, it might be an idea to tell them.

I mean, even until earlier today, fwis3.com didn't point to the board for me, just a splash page. There was no board at all until about 30 seconds before my last post. Others might be stuck, too.

Re: SQL error

PostPosted: Wed Dec 04, 2013 9:20 am
by SciFi Chick
Anyone who is on Facebook won't be stuck, but I'm not sure who that will leave out. Someone probably better email code monkey.

Re: SQL error

PostPosted: Wed Dec 04, 2013 9:33 am
by The Supreme Canuck
No, she posted a little earlier.

Re: SQL error

PostPosted: Thu Dec 05, 2013 1:43 pm
by Cyborg Girl
Here we go again!

Seems almost like the board throws a fit when discussions get heated. :lol:

Re: SQL error

PostPosted: Fri Dec 06, 2013 11:38 pm
by cid
Are we dealing with an AI that has more sense than we do? :confused:

Re: SQL error

PostPosted: Sat Dec 07, 2013 12:19 am
by Sigma_Orionis
That damned error can happen for a couple of reasons:

I have no idea how is the Database Setup they have at FatCow, but it looks like the Web Server is opening too many connections to the MySQL Server.

From the error message I suspect that they have a large, shared MySQL installation, if the RDBMS response time gets too high, phpBB might be trying to setup additional connections to the RDBMS and after it reaches a certain limit (most probably set up by the RDBMS admin, particularly if they have a shared Database Server for multiple applications) the "too many connections" error springs up. I've seen that happening often in this type of setups.

It also depends on the version of MySQL, the version of the programming language phpBB is written on (PHP) and what PHP extension they're using to talk to MySQL (all of which are completely under the control of FatCow, there's little brite or anyone else here can do about it), if they implemented a scheme called "connection pooling" this problem shouldn't come up unless there's a major issue with the RDBMS.

Re: SQL error

PostPosted: Sat Dec 07, 2013 1:33 am
by brite
Sigma... would you mind saying that in English??

Re: SQL error

PostPosted: Sat Dec 07, 2013 7:50 am
by SciFiFisher
brite wrote:Sigma... would you mind saying that in English??


Fat cow uses a system that works like public transportation. When the bus is full you have to wait for the next bus to get to your destination. If too many people get on the bus it stops working. When the bus stops we get an error message. Fat Cow needs more buses. :tap:

Re: SQL error

PostPosted: Sun Dec 08, 2013 1:34 am
by Sigma_Orionis
I have been writing a long explanation in plain english of what I said, but Fisher's is much better :P

Maybe Fat Cow doesn't need more buses, maybe their big shared bus (if that's what they got) is having problems. Again just speculation.

Re: SQL error

PostPosted: Tue Dec 10, 2013 9:13 pm
by Swift
I've had more difficulties (but not impossibles) to get on the forum today.

Re: SQL error

PostPosted: Wed Dec 11, 2013 12:24 pm
by Thumper
It usually takes me 3-5 times to get on. Then I'll get booted off (or it just appears to lock up) after about 10 minutes. Also page refreshes seem very slow.

Re: SQL error

PostPosted: Wed Dec 11, 2013 7:03 pm
by The Supreme Canuck
Sometimes I can't get the page to load at all (not even an error page) for almost the entire day.

Re: SQL error

PostPosted: Thu Dec 12, 2013 7:01 am
by SciFiFisher
I don't seem to have any problems since we changed to using www.fwis3.com as the destination. I am also using (primarily) the Firefox browser. Although Internet Exploder seems to work albeit a bit slower than Firefox. weird.

Re: SQL error

PostPosted: Thu Dec 12, 2013 11:22 am
by geonuc
SciFiFisher wrote:I don't seem to have any problems since we changed to using http://www.fwis3.com as the destination. I am also using (primarily) the Firefox browser. Although Internet Exploder seems to work albeit a bit slower than Firefox. weird.


Ditto, using Firefox with few problems.