>-----Original Message----- >From: Jørn Dahl-Stamnes [mailto:sq...@dahl-stamnes.net] >Sent: Friday, January 14, 2011 7:31 AM >To: mysql@lists.mysql.com >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: je...@gii.co.jp 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). > >-- >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=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
