SQL error

[Rommie]

Got this a few times lately- something about too many people logged in, and the site won't load. Anyone else?

[The Supreme Canuck]

Yep. A few times over the last week or so.

[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.

[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.

[geonuc]

Haven't seen it.

[brite]

I put in a trouble ticket about it... we'll see what they come back with...

[Cyborg Girl]

Wow. That was fixed fast.

[geonuc]

So we have a proper, responsive host?

[brite]

When I was looking for a hosting company... I looked for one that was in the US and spoke English...

[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?

[Cyborg Girl]

Because the forum moved from a subdirectory to the main site. It's now just fwis3.com.

[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.

[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.

[The Supreme Canuck]

No, she posted a little earlier.

[Cyborg Girl]

Here we go again!

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

[cid]

Are we dealing with an AI that has more sense than we do?

[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.

[brite]

Sigma... would you mind saying that in English??

[SciFiFisher]

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.

[Sigma_Orionis]

I have been writing a long explanation in plain english of what I said, but Fisher's is much better

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.

[Swift]

I've had more difficulties (but not impossibles) to get on the forum today.

[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.

[The Supreme Canuck]

Sometimes I can't get the page to load at all (not even an error page) for almost the entire day.

[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.

[geonuc]

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.