>Sent: Friday, January 14, 2011 7:31 AM
>Subject: Incorrect key file for table
>While doing a select query I got the following error in the error-log file:
> Incorrect key feil for table '/tmp/#sql_5f8_0.MYI'; try to repair it
>It seem rather meaningless to try to repair a temporary table... So is this a
>bug in MySQL, or?
[JS] Check for space in /tmp. I've seen temporary files that are 10x the size
of the actual table(s).
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com
>The database I'm using has only InnoDb tables and I'm using version
>The query is build using Propel (from a web-application made by Symfony
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1