Jump to:

23486 Posts in 18995 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » Frequent corruption in MySQL databases

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: 1689 Views
  • timp
    Avatar
    Community Member
    4 Posts

    Frequent corruption in MySQL databases Link to this post

    Hi,

    we have a server running with around 40 installs on it, and lately seemingly at random, we have been experiencing database tables becoming marked as crashed.

    when i run analyze table SiteTree_Live; i get the following output:

    mysql> analyze table SiteTree_Live;
    +-------------------------+---------+----------+-------------------------------------------------------------------------------+
    | Table | Op | Msg_type | Msg_text |
    +-------------------------+---------+----------+-------------------------------------------------------------------------------+
    | exclusive.SiteTree_Live | analyze | Error | Table './exclusive/SiteTree_Live' is marked as crashed and should be repaired |
    | exclusive.SiteTree_Live | analyze | Error | Table 'SiteTree_Live' is marked as crashed and should be repaired |
    | exclusive.SiteTree_Live | analyze | error | Corrupt |
    +-------------------------+---------+----------+-------------------------------------------------------------------------------+
    3 rows in set (0.00 sec)

    its fairly easy to repair (repair table SiteTree_Live), but its becoming a pain, as it happens at random, and our clients sites being down for no apparent reason is becoming annoying to say the least.

    has anyone seen anything like this before?

    Cheers,
    Tim

  • Mo
    Avatar
    Community Member
    508 Posts

    Re: Frequent corruption in MySQL databases Link to this post

    I did have this issue once, If I remember, it was related to some conflict with one of my page classes or dataobjects in version 2.3.2. Is that the version you are using? If so, upgrading to at least 2.3.3 seemed to fix it for me.

    Mo

  • timp
    Avatar
    Community Member
    4 Posts

    Re: Frequent corruption in MySQL databases Link to this post

    the sites it has been happening to most frequently are running 2.3.3, 2.2.3, and 2.3.4. it seems to happen when someone edits a page through the CMS.

    Cheers,
    Tim

  • Mo
    Avatar
    Community Member
    508 Posts

    Re: Frequent corruption in MySQL databases Link to this post

    Hmm, are you capturing any custom data that might ne be properly sanitised by any chance? Maybe people are pasting stuff in from word that contains unsupported characters that is causing issues with the database? Just a thought, thought I can't see how this could happen through the cms.

    Mo

  • Judge
    Avatar
    Community Member
    79 Posts

    Re: Frequent corruption in MySQL databases Link to this post

    It shouldn't matter what the application is doing: it is the database that is responsible for keeping the tables sane. My money would be on an update to MySQL to fix this problem. Perhaps the MySQL daemon is crashing or running out of memory? Check its logs.

    -- Jason

  • alva
    Avatar
    Community Member
    1 Post

    Re: Frequent corruption in MySQL databases Link to this post

    The corruption of database is very painful. If you are facing any issue related to your Database corruption then you can MySQL Repair Tool to resolve any sort of issue related to your MySQL.

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