Database Error: Lost connection to MySQL server during query

[civano1]

I received some complaints from forum members about this, and now it's happening to me.  I can't log into my own forum...

Sorry, I'm too new to this.  Installed smf package from GoDaddy, did all the steps on the hosting and database setup.  The forum worked great for about 2 weeks and 46 new members.   So I don't know what to do now.

Thanks in advance for the help...
Mare

[青山 素子]

GoDaddy is known to have this issue. They did something with their servers a while back and many SMF forums on their hosting services have had problems ever since.

I'm not sure the cause was ever determined.

[ke4obt]

Ya, and all they can say is it's all on your end.

as it is i've had to close 4 sites because of this>
!!
and still have to put up with this till July next yer, see if i don't move.

     Flip - KE4BT
     The Blind Ham

[青山 素子]

Ya, and all they can say is it's all on your end.

Of course they will say that. They don't want to admit fault. You are welcome to search their name and find all the other topics about problems with them.

The only suggestions I can think of is to find the topic where there was a solution for old versions of MySQL 5.0 (what had a bug causing this behavior) and try that fix.

One other option is on the host's side. They can try increasing connect_timeout on their MySQL servers from the default 5 to 10 seconds. On very busy networks (and GoDaddy's is likely overloaded - they oversell like mad), five seconds may not be enough time to get the connection to work.

There is discussion about one bug possibly causing this issue in MySQL Bug #28359. That bug was fixed in version 5.0.52, but good luck getting them to upgrade their servers.

Additional information on the error is at MySQL Reference Manual - B.1.2.3. Lost connection to MySQL server. As that page says, "Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs frequently." The BLOB possibility doesn't fit because SMF doesn't use BLOB fields (afaik).

[goodwyne]

ke4obt, you don't have to wait to leave GoDaddy.  You can cancel your account at any time and they will refund the difference.  We're considering the same thing.

[civano1]

After 4 emails with GoDaddy and a final email to THE PRESIDENT...  lol,   Here is the response I received in part:

[i]...Our staff has investigated the matter and found that your database commands are causing timeouts on the database server.  This means that moving your account to a new server may not correct the issues.  However as a means of testing, we would like to move your account to a new server to see if the performance improves for your site.  Please note that this may involve downtime, but would be a good way to see if the behavior of the server itself is causing the problems you are experiencing.  [/i]
If you would like to proceed with this process, Please respond with the four digit support PIN on the account,  ...
I responded with,   YES,   Let's do it, because ALL my members cannot get into the forum anyway, so no loss if it all goes away!! 

BTW,  SMF,  I'm the only one that can get into the forum??  12 of 45 members I know for sure cannot access the forum.

I'll update this forum as we know more...

Mare

[青山 素子]

If it's in the process of being moved, that is normal. It can take 24 to 48 hours for all the new IPs to get to all the computers out there that have the old one.

Which commands are causing the timeout? If they can say, it might help in diagnosing the problems. I know that at least one bug in MySQL 5.0 was found that way (the bug was fixed in 5.0.21 and newer).

[civano1]

No it's not being moved.   My getting into my own SMF forum, has been ok for the last 10 days.  My members cann't get in due to the above error message, or they have to hit the refresh button a gazillion times. They usually give up at that point.

GD decided today that changing the hosting server would probably not fix the problem.  So they are doing research on SMF, including this forum, to help solve the smf forum querys.

Thanks for all the help ...   I'm getting too busy with helping the Obama Campaign to mess with this much longer.   Be back after November 4th.... maybe.
Mare

[青山 素子]

They are welcome to contact us about the problems and we can try to lend what assistance we can.

I do believe I can find what date this suddenly started with. Maybe if they have logs of changes they can pin down what was changed during that period to cause this to become a major issue.

[civano1]

Hi everyone,
Well the forum still is locking everyone out but a couple of us...    GoDaddy has created a test member in my forum.   evidently they get in, because last week I saw their stats as being in twice.   

Still no resolution.    I'm giving up, and redirecting my domain name to another set of blog pages.

Between GD and SMF, this has been pretty disappointing.    Thanks for any help you all have tried to give here.

Civanoforum.com
anyone here want to try to get in for testing purposes??

[Rumbaar]

Was there a change to the settings.php for the path to the mySQL server for GoDaddy.com users.  ie from localhost to a defined path etc?

Not sure if that relates to GoDaddy, I'm working from dim memories.

[wayoutwest]

regarding goaddy - from info here http://blog.terrypearson.com/2008/02/29/mysql-server-has-gone-away-problem-solved/ [nofollow] it looks like they've shorted the time the connection will stay open.

[SlammedDime]

Hi everyone,
Well the forum still is locking everyone out but a couple of us...    GoDaddy has created a test member in my forum.   evidently they get in, because last week I saw their stats as being in twice.   

Still no resolution.    I'm giving up, and redirecting my domain name to another set of blog pages.

Between GD and SMF, this has been pretty disappointing.    Thanks for any help you all have tried to give here.

Civanoforum.com
anyone here want to try to get in for testing purposes??

Is your ISP Cox Communications?  Are the users having the problem also on Cox??

[civano1]

Interesting question??   Yes we are on Cox, and I imagine many of the users are too.  We also have qwest dsl but I don't know if those got on easily or not.  Some members had no trouble, others were constantly out.   UMMMM?

[SlammedDime]

As much as GoDaddy doesn't want to admit it, there is some sort of issue with their servers and users of Cox.  I have yet to see this issue occur when that combination is not present.

Turning off Hostname Lookups in SMF seems to help with the problem, but not always.

[wyrdgirl]

I am just now receiving this error too for a few members.  Funny enough they both use Cox as well.  Turning off the lookups appears to be working so far.  Thanks for the suggestion

[thefley]

I am a Cox customer and I have had many issues for about 8 months with them on all my sites. I have been on the phone to them over 15 times and they always blame in on my end. I have moved the database to other servers on godaddy as they have suggested but it never works.  I finally ran across this thread and find out I am not alone. Screw Godaddy, they blamed it all on SMF and my database to many times. 

Anyone know a good host for my 14 domains?  And I would not recommend 1&1 nether they are just as bad.

[civano1]

Hi,  I don't know if this would work for you, but it's worth the investigation or writing to the admins with your needs.  Please insist that they use my sponsor ID of XXXX if they can set you up with server strength that will meet your needs.  You could end up with all your hosting paid for with commissions.  Check it out.

Want a website hosted for $10 bucks a month?
Check this out:  hxxp:yourcashcow.biz/ [nonactive]
(This is also a business in itself, and the hosting is dynamite)

Mare
hxxp:ctutor.com [nonactive]
Computer Tutor, Inc. and Civano Forums


Edit: Sorry, we don't allow affiliate links on our site. - Motoko-chan

[JimM]

You might want to take a look at this board as it has lots of good host and information on hosting.

Hosts, Hosting and Commercial Services

[Rumbaar]

I take it from your last post civano1 that you are no longer with GoDaddy?  Is this still an issue for you?

[civano1]

actually, I have 10 over at godaddy, but no sql's.  I did the search for numbers and got the 4300 other domains on the server that I am on.  Quite disappointing.  Anyway, I also have a couple on the hostcash site listed above that people can find on the hxxp:ctutor.com [nonactive] site at the top.

Couldn't believe my eyes!

Mare

[Rumbaar]

Okay so the original post you've made at the start of this thread is no longer valid then?  As you no longer have any SQL db's on that host?

[Deprecated]

4,300 domains on one server? 4,300? Woah, that's at least 3x the highest I've ever even heard of let alone seen!

What is wrong with GoDaddy? Are they planning on laying off 80 percent of their staff and getting rid of 50% of their servers?

This is just crazy...

[Rumbaar]

If they are all just parked domains, it wouldn't make much difference.

[Deprecated]

And how would you know if they were all parked domains? Visit them all? (No, I didn't.)

[thefley]

I set up a new forum tonight on hostmonster.com and it works great!!!! but I am still haveing the issues on Godaddy.com.  I will be moving all mine over to hostmonster.com 

IT IS NOT A COX ISSUE!!!

GOODBYE GODADDY!!!   google GODADDY SUCKS and you will see many others that hate them.

[FullDraw]

I am just now receiving this error too for a few members.  Funny enough they both use Cox as well.  Turning off the lookups appears to be working so far.  Thanks for the suggestion

As much as GoDaddy doesn't want to admit it, there is some sort of issue with their servers and users of Cox.  I have yet to see this issue occur when that combination is not present.

Turning off Hostname Lookups in SMF seems to help with the problem, but not always.

My main site sponsor was getting these error codes for about a month. The only way he could communicate on the site was through the shout box. I turned off host name look ups and the problem was solved. A couple of other people also infromed me they were able to enter the forum all of a sudden also. All were affiliated with Cox. Thanks for the info guys.....

[thefley]

I dissabled the host look up and tried it that way and this did not work for me nor the members on cox.  seems to help some but not all.   

[pope and young]

I am new to this also, I don't mean to sound outta line here. But I run a dating site with godaddy with no known issues. Is it just simple machines? I don't know. My guess would be yes. Because if everyone's websites with godaddy acted the same way, godaddy would be outta bussiness. I'm not knocking simple machines, just trying to think outside the box.
If anyone has a large forum and has no trouble with their "HOST" They need to list it here as a sticky.

[青山 素子]

But I run a dating site with godaddy with no known issues. Is it just simple machines? I don't know. My guess would be yes. Because if everyone's websites with godaddy acted the same way, godaddy would be outta bussiness.

You are lucky then or you don't happen to trip on the core issue. SMF necessarily does a lot of tracking for security and moderation purposes. It seems at least some of this happens to trigger the issue many are having. Specifically, it seems to be narrowed to a problem between GoDaddy's servers and Cox internet users. This hasn't been seen on other hosts, so it doesn't seem to be an issue with SMF itself.

Oh, and there are more than enough people out there willing to believe they can get ultra-cheap hosting that even a large churn won't hurt GoDaddy.

If anyone has a large forum and has no trouble with their "HOST" They need to list it here as a sticky.

That's what the Hosts, Hosting and Commercial Services board and child boards are for.

[pope and young]

lol, I just check that out after I posted this. I do have a bad feeling about godaddy I can't put my finger on, I was just talking in all fairness with my experience so far. I am going to contact montecarlo services with some questions regarding their dedicated servers. But I am still fascinated with learning how to run my own even if it cost more.

I wonder if any other "forum" boards makers like "vb" have this sort of trouble with godaddy and or the internet provider in question. I think I will research this before my community grows.
I don't like any of the other forums out there paid for or free. I like simple machines and hope simple machines works out for me.

[pope and young]

Come to think about it, I did get an email from my forums saying something about a database error. I deleted the email and thought nothing of it....
Soon as I get the money together for a move, I'm moving to a different host before the problem gets worse.