MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

2 Incorrect key file for table 'C:\WINDOWS\TEMP\#sql3a4_ef_2.MYI'; try to repair it SQL1.sql 1 1
Posted by: Asad Raza
Date: September 01, 2010 02:33AM

Hi All,

I am facing strange issue while querying view. When I query the view it says "2 Incorrect key file for table 'C:\WINDOWS\TEMP\#sql3a4_ef_2.MYI'; try to repair it SQL1.sql 1 1 ". The view is using 10 tables which are joined using left outer join. Strange thing is that when I query each base table then there is no issue but when I query view it gives invalid key file error.

Any suggested fix of this problem.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
2 Incorrect key file for table 'C:\WINDOWS\TEMP\#sql3a4_ef_2.MYI'; try to repair it SQL1.sql 1 1
3660
Asad Raza
September 01, 2010 02:33AM
Re: 2 Incorrect key file for table 'C:\WINDOWS\TEMP\#sql3a4_ef_2.MYI'; try to repair it SQL1.sql 1 1
1921
Rick James
September 02, 2010 11:28PM


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.