List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:January 14 2011 4:32pm
Subject:RE: Incorrect key file for table
View as plain text  
>-----Original Message-----
>Sent: Friday, January 14, 2011 7:31 AM
>To: mysql@stripped
>Subject: Incorrect key file for table
>
>Hello,
>
>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).

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.the-infoshop.com



>The database I'm using has only InnoDb tables and I'm using version
>5.1.42-log.
>The query is build using Propel (from a web-application made by Symfony
>framework).
>
>--
>homepage: http://www.dahl-stamnes.net/dahls/
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




Thread
Incorrect key file for tableJørn Dahl-Stamnes14 Jan
  • Re: Incorrect key file for tableJohan De Meersman14 Jan
    • Re: Incorrect key file for tableJørn Dahl-Stamnes14 Jan
      • Re: Incorrect key file for tableJohnny Withers15 Jan
        • Re: Incorrect key file for tableJørn Dahl-Stamnes15 Jan
          • Re: Incorrect key file for tableJohan De Meersman15 Jan
          • Re: Incorrect key file for tableMySQL)15 Jan
  • RE: Incorrect key file for tableJerry Schwartz14 Jan