MySQL Forums
Forum List  »  MyISAM

Re: ERROR 126 (HY000): Incorrect key file for table
Posted by: Vinayak Javaly
Date: May 02, 2007 09:06AM

We're running 5.0.27-max on Linux and have my.cnf setting "key_buffer_size=128M".

I receive error:
(ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_32f8_1.MYI'; try to repair it)
while performing:
"select ... from table where indexed_column between X and Y order by rand() limit 50"
on one of these servers and not the other. These 2 servers are identical (h/w, s/w, my.cnf settings, etc.).
The table is InnoDB.

Does anyone have a workaround? Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 126 (HY000): Incorrect key file for table
24487
May 02, 2007 09:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.