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

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

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

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

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

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.