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

Frequent corruption in MySQL databases


Reply


6 Posts   1713 Views

Avatar
timp

Community Member, 4 Posts

25 February 2010 at 2:36pm

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

Avatar
Mo

Community Member, 509 Posts

3 March 2010 at 1:43pm

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

Avatar
timp

Community Member, 4 Posts

4 March 2010 at 3:45pm

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

Avatar
Mo

Community Member, 509 Posts

5 March 2010 at 5:37am

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

Avatar
Judge

Community Member, 79 Posts

6 March 2010 at 11:49am

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

Avatar
alva

Community Member, 1 Post

8 May 2014 at 8:46pm

The corruption of database is very painful. If you are facing any issue related to your Database corruption then you can [url=http://mysql.filerepairtool.net/blog/check-repair-corrupted-mysql-file]MySQL Repair Tool[/url] to resolve any sort of issue related to your MySQL.