Engineering a New World

Something Can Be Done About It

WordPress “Table is marked as crashed and should be repaired” Error & Solution

Recently had this error on my Scientology Parent website, owing to a translations plugin that went crazy and started caching jiggabytes of data locally and ran the /var/ partition out of disk space.  Wordpress pages were showing up blank or coming up with “no posts matched criteria” messages.

Looking in /var/log/mysqld.log, found errors like:

130816 14:21:01 [ERROR] /usr/libexec/mysqld: Table './ScientologyParent_/wp_posts' is marked as crashed and should be repaired

As such, the easy solution is:

(1) Log into mysql from the command line.

(2) Run:
mysql> repair table wp_posts;
 | Table | Op | Msg_type | Msg_text |
 | ScientologyParent_.wp_posts | repair | info | Found block that points outside data file at 716320 |
 | ScientologyParent_.wp_posts | repair | status | OK |
 2 rows in set (0.08 sec)
mysql> quit

Fixed the problem instantly. Wanted to put it here for future reference, should I hit this again. 🙂

About turbotad

My name is Tad Reeves, and I am a certified AEM Dev/Ops Engineer, cycling enthusiast, train & transit junkie, and father of three. I’m currently an Adobe Experience Manager Architect, consulting for ICF Next, as well as for other companies.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


This entry was posted on August 16, 2013 by in technology and tagged , , , , , , .
%d bloggers like this: