Hello everyone.

I'm getting a strange error when calling a SELECT query with JOIN:

Mysql::Error: Table '' is marked as crashed and should be repaired

Note that there is no name for the table that is marked as crashed.

An example of a query that causes this is:

select feed_items.* from feed_items inner join (feed_visits) on
(feed_items.id = feed_visits.feed_item_id) GROUP BY id ORDER BY
count(*) DESC LIMIT 5

* tables being used: feed_items, feed_visits
* both use InnoDB
* the error only appears every 10 minutes ... I hit refresh and
everything works again
* both tables seem OK when I run checks

I'm thinking:
The temporary table created by the join statement is somehow mistaken
as crashed. Could this happen because another process is updating the
table?

Anyone got any ideas on how I can prevent this from happening?

I'm running:
* MySQL community version 5.0.51
* Debian Etch (I got mysql from the backports)

Any would be very much appreciated

Many thanks,
Geir.