Jump to:

23480 Posts in 18951 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » MYSQL server has gone away [SOLVED]

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

Page: 1
Go to End
Author Topic: 2552 Views
  • Jedateach
    Avatar
    Forum Moderator
    227 Posts

    MYSQL server has gone away [SOLVED] Link to this post

    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:
    http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

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

  • banal
    Avatar
    Community Member
    901 Posts

    Re: MYSQL server has gone away [SOLVED] Link to this post

    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.

  • Juanitou
    Avatar
    Community Member
    323 Posts

    Re: MYSQL server has gone away [SOLVED] Link to this post

    Hi,

    I'm also getting this on my shared webhosting.

    FWIW,
    Juan

  • mindreader
    Avatar
    Community Member
    2 Posts

    Re: MYSQL server has gone away [SOLVED] Link to this post

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

  • Juanitou
    Avatar
    Community Member
    323 Posts

    Re: MYSQL server has gone away [SOLVED] Link to this post

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

  • Jedateach
    Avatar
    Forum Moderator
    227 Posts

    Re: MYSQL server has gone away [SOLVED] Link to this post

    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.

  • Jedateach
    Avatar
    Forum Moderator
    227 Posts

    Re: MYSQL server has gone away [SOLVED] Link to this post

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

    2552 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.