AnsweredAssumed Answered

After upgrade database got MySQL error 126: Incorrect key file for table try to repair it

Question asked by Autchara Chaiprom on Jun 12, 2017
Latest reply on Jun 13, 2017 by André Lopes

Hi,

 

I have some problem with database after upgrade to mysql 5.0.11 before we upgrade this error hardly happen.

Not always but sometimes.

I found it happen only in account module with query JOIN many table where IN many condition.

Query Failed: SELECT  accounts.id id, accounts.date_modified date_modified, 
accounts.assigned_user_id assigned_user_id, 
.....
,accounts.id DESC  LIMIT 0,26:
MySQL error 126: Incorrect key file for table '/tmp/#sql_54ad_2.MYI'; try to repair it

 

If it has many error like this finally system will got Too many connection and Sugar down for a minute.

I researched in google many people talk about may came from not enough space for tmp and some chaos key table but I have not much experience with server.

 

Do someone have this problem before?

Any solution or suggestion for me?

 

Sugarcrm Pro 7.8.2.0

Thanks,

M

Outcomes