MySQL Error 2006 - Server has gone away

[Catfish]

I have recently tried to synchronize my database on my home server to siteground's online server at my webhost account with them.

When I perform the sync, it always fails with a 2006 error - Server has gone away.

Is there any way around this as synchronizing my databases will be a key feature of the future in my software and business. I noticed users started getting this problem late last year and posted to teh forum around November (http://forum.siteground.com/showthread.php?t=8747). SiteGround staff claimed they had fixed this problem.

I understand on a shared account you share server load with other websites, but pretty much what I'm asking is, for shared accounts, will this error persist?

[Dimo]

It is quite hard to answer questions without having checked the actual issue ;)

Please post a support ticket from your Help Desk and ask our support team to investigate your issue. Hopefully, we'll be able to find a suitable solution for it :)

[eightcrystals]

* Edit post
* Delete post
* Report this post
* Reply with quote

Re: Installation error: 2006

Postby eightcrystals on Sun Mar 15, 2009 12:42 pm
I got this problem at one of my clients who has a website on a Magento platform.

This has nothing to do with Magento or PHP.
It’s a MySql error generated because of the poor configuration of the MySql server. The problem of my client was that when executing bulk inserts MySql was generating “General error: 2006 MySQL server has gone away” because of the "packet too large" exception. In my case the solution was to ask the hosting provider to change in the MySql configuration files on the server /etc/my.cnf max_allowed_packet = 1M to 16M or more.
So I recommend you to optimize MySql configuration for Magento. Another suggestion is try to upgrade MySql to the latest version because some things its handled differently in latest versions.
For other administration problems you can contact me at:
www.perfectmagento.com

[Faylaricia]

Dimo,

I have the same problem after installing the module for the creditcard on Zencart.

I had reported the problem to the helpdesk and Hristo told me this:

"The issue you are experiencing is caused by the fact that your application or part of it is creating a query to the database that takes too much time to complete or loops, therefore times out.

I would advise you to contact a local developer that has experience with modifying ZenCart applications in order to receive additional assistance."

However, online, everywhere I look, it tells me that this is a server issue. I already ran repair on the MySQL and that didn't fix it. It worked fine up until two weeks ago.

In one thread, Dimo, you stated that you found the problem with the server. Could you please check again? The one I am on is siteground247.com

[Val]

As mentioned by Dimo, there was a small misconfiguration of the mySQL service at some point, but we have fixed that long time ago. The error you are receiving is indeed due to the fact that your queries reach the maximum allowed time and is thus ended prematurely.

What I can recommend you is pretty much the same -- either look into the queries (which we can provide you with) and try to optimize them or alternatively get in touch with a professional web developer, who I'm sure will be able to help you.