Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

MYSQL server has gone away [SOLVED]


Reply


7 Posts   2634 Views

Avatar
Jedateach

Forum Moderator, 232 Posts

30 July 2009 at 5:20pm

Edited: 28/05/2010 3:46pm

For each of my sites, I get the same Error a few times each day.
"MYSQL server has gone away"

I always assumed I was getting this error because I'm on shared webhosting. My webhost tells me its not their server causing the problems.

Anyone else get this issue occuring semi-frequently like myself?

According to MySQL, there are a number of reasons it could be occuring:
[url]http://dev.mysql.com/doc/refman/5.0/en/gone-away.html[/url]

I wonder if SilverStripe could retry a query if it fails like this. Perhaps there could be a choosable number of times it retries.

Avatar
banal

Community Member, 901 Posts

30 July 2009 at 6:07pm

Hi

I never had this issue, and I have been running websites with MySQL on dozens of different shared hosts. Maybe there's too much load on the server and MySQL times out... although that's unlikely.
Do you happen to have some huge DB tables your querying? Something outside of SilverStripe?

If not, I suggest you change to a different hosting provider.

Avatar
Juanitou

Community Member, 323 Posts

31 July 2009 at 6:07am

Hi,

I'm also getting this on my shared webhosting.

FWIW,
Juan

Avatar
mindreader

Community Member, 2 Posts

1 August 2009 at 10:01pm

That is why it is better to use good shared hosting like 1and1.com or webthosting.com which are cheap and best :D

Avatar
Juanitou

Community Member, 323 Posts

2 August 2009 at 11:38pm

Some more info, I don't know if it applies: http://bugs.mysql.com/bug.php?id=28359

Avatar
Jedateach

Forum Moderator, 232 Posts

3 August 2009 at 12:21pm

Edited: 03/08/2009 12:24pm

mindreader: I do consider my webhost a good one.

If I knew why I was getting this error, I would inform them, and they'd likely take action.

banal: My tables aren't very big, at least not the ones I query. Nothing outside of SS.

Avatar
Jedateach

Forum Moderator, 232 Posts

28 May 2010 at 3:45pm

Edited: 28/05/2010 3:46pm

Just to update on this thread, it turned out the particular web hosting server I was on had disk I/O issues, causing the MySql server has gone away error. I've now moved to more reliable hosting (from the same provider).