Got error 28 from table handler

WordPress database error: [Got error 28 from table handler]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-01-24 01:13:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

Code (markup):

I'm getting this error on a WP install...

Anyone have any idea what's causing it?

I can't for the life of me work it out...

Any help is much appreciated.

 

Is this version 2? Using Firefox?

Google error 28 from table handler

 

Actually, it's 1.5, regardless of the browser. Which is why I'm so stumped...

 

The thread cited above indicates that this problem preceded version 2 and, according to the WP people, is a MySQL problem.

I don't know. It seems to me that Error 28 generally occurs when there are a lot of hits on the database in a short time - but you're getting it with an installation and that's weird.

 

Yep - I'm gonna have to ask the server to restart mysql I think, but it's certianly not something I've come across before...

Thanks for the help

 

You ran out of disk space...

easter:~# perror 28
System error: 28 = No space left on device

 

Huh - weird... shouldn't be the case though...

It's on a shared hosting package, so does that mean the server has simply ran out of space, or my allocation has run out?

I'm 99.9% sure I'm still within my limit (Hell, all that's on there is a wp instalation).

 

No idea how those shared servers work, but error 28 from mysql means no space left on device - do you have shell access?

Remember it's the device that mysql stores it's data on, so if the mysql database is not running locally, this might be on a completely different server.

 

That's what it's supposed to mean but it seems the error message is often generated when that situation doesn't exist...

 

I don't have shell access on this server I'm afraid.

Thanks *so* much for the help guys - at least I know I'm not going crazy.

I'll speak to the host asap and see if they know what the issue is - I'm certianly stumped.

 

Ah, well I can only speak from personal experience and I have only seen it in actual cases where the device where full.

Ofcouse I can't rule out that other problems with writing to disc could cause the same error.

 

I'm getting the same error with Wordpress. This happened last year, but I can't remember how I fixed it. I have repaired db tables but error 28 still shows. I have shell access. Suggestions?