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
 Bye

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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Information

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