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.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 18.104.22.168