"Incorrect key file for table"

[Max P]

"Incorrect key file for table '/tmp/#sql_1cb9_2.MYI'; try to repair it"

I keep getting this errors if starting a search request, but only for some words and not every time.

I tried to CHECK / REPAIRS ... on all tables in my database, nothing helped,
CHECK was always OK, REPAIR didnt find anything to repair.

There's a fulltext index on field "name1" and "name2"

Heres one of the SQL Search Statements causing the error

SQL:

SELECT SQL_CALC_FOUND_ROWS * FROM 

(
	(
	SELECT A.*, B.*, ROUND(MATCH (aa.`name1`, aa.`name2`) AGAINST ('+INSERTSEARCHWORDHERE*' IN BOOLEAN MODE),3) AS `prio`
	FROM A as aa
	LEFT JOIN B as bb
	ON bb.`id` = aa.`id`
	WHERE
		(
		MATCH (aa.`name1`, aa.`name2`) AGAINST ('+INSERTSEARCHWORDHERE*' IN BOOLEAN MODE)
		OR (aa.`groupid` IN (1015,1037,1038,1039,1040,1041,1042,1043,1049,1053,1323,1354,1363,1364))
		)
	)
)
 as mergedtable

GROUP BY `id`
ORDER BY `c` DESC, `prio` DESC, `d` DESC
LIMIT 10

Eventually someone has an idea whats wrong with that...



Edited 2 time(s). Last edit at 10/19/2009 05:54AM by Max P.