The PoliBlog
Collective


Information

academic site


e-mail
c.v.
columns
legal
rss .92
2.0
The Collective
Thursday, December 28, 2006
By Dr. Steven Taylor

I woke up this morning to the following:

WordPress database error: [Can’t open file: ‘poliblog_comments.MYI’ (errno: 144)]
SELECT COUNT(*) FROM poliblog_comments WHERE comment_approved = ‘0′

WordPress database error: [Can’t open file: ‘poliblog_comments.MYI’ (errno: 144)]
SELECT COUNT(comment_ID) FROM poliblog_comments WHERE comment_approved = ’spam’

While the blog was displaying, anything like up to calls to the comments section of the database was screwed up. Luckily I was able to use the “Repair” command in MySql to fix the problem.

Anybody out there have any idea what the problem was/what might have caused it? I am guessing some sort of comment spam attack, but if so, this is the first time I have ever seen a result like this.

Sphere: Related Content

Filed under: Computer Junk, Blogging | |

3 Comments

  1. This might be helpful:

    http://geeklog.blogspot.com/2006/10/mysql-error-144-and-apache-performance.html

    Comment by Anon — Thursday, December 28, 2006 @ 9:02 am

  2. Yep, that makes sense. The database probably shrank considerably as a result of the repair command. If it had anything to do with spam, it would be that any deleted data is not fully deleted, just flagged as deleted, until repair is done.

    OTOH this implies that you’ll run out of space again, and that perhaps space is tighter on the server than it ought to be.

    Or something could simply have been corrupt and that was enough to fix it.

    Comment by Jay — Thursday, December 28, 2006 @ 11:30 am

  3. I was able to clear out some spam-related entries in the database, which gave me quite a bit more space, so hopefully that will do the trick.

    I had some Spam Karma 2 entries that I thought I had deleted, but had not. I stopped using SK because it took up so much database space.

    Comment by Dr. Steven Taylor — Thursday, December 28, 2006 @ 12:21 pm

RSS feed for comments on this post.

The trackback url for this post is: http://www.poliblogger.com/wp-trackback-poliblog.php?p=11248

NOTE: I will delete any TrackBacks that do not actually link and refer to this post.

Sorry, the comment form is closed at this time.



Take a Look At This!
Inquiries

Visitors Since 2/15/03
Blogroll

---


Advertisement

Advertisement


Powered by WordPress