Error: Incorrect key file for table '/tmp/#sql_4029_0.MYI'; try to repair it

SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path` , '0' `id_editor_edit` FROM `dir_links` t1 LEFT JOIN `dir_link_categories` t8 ON t1.`id` = t8.`id_link` AND t8.`crossed` = '0' LEFT JOIN `dir_categories` t9 ON t8.`id_category` = t9.`id` WHERE t1.`status` = 'active' AND t9.`status` = 'active' GROUP BY t1.`id` ORDER BY t1.`rank` DESC LIMIT 0, 10