From: Geir Freysson (geirayourta.com)
Date: Tue Apr 01 2008 - 10:16:29 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]