List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:January 14 2011 1:03pm
Subject:Re: Incorrect key file for table
View as plain text  
Check your free diskspace on your temp location.

On Fri, Jan 14, 2011 at 1:31 PM, Jørn Dahl-Stamnes
<sql06@stripped>wrote:

> 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?
>
> 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).
>
> --
> Jørn Dahl-Stamnes
> 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
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

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