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 help would be very much appreciated :) Many thanks, Geir. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
