21286 Posts in 5733 Topics by 2602 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1315 Views |
-
Frequent corruption in MySQL databases
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 -
Re: Frequent corruption in MySQL databases
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
-
Re: Frequent corruption in MySQL databases
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 -
Re: Frequent corruption in MySQL databases
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
-
Re: Frequent corruption in MySQL databases
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
| 1315 Views | ||
|
Page:
1
|
Go to Top |
