|
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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. |
|
![]() |
| Outils de la discussion | |
|
|