Help with mySQL errors (error 28 from storage engine, incorrect key file for table)

[lat9]

I'm not sure when this started happening, but one of the sites that I manage has started burping up the following two debug-logs quite regularly:

PHP Fatal error:  126:Incorrect key file for table '/var/tmp/#sql_30e_2.MYI'; try to repair it :: show fields from orders_status_history in /includes/classes/db/mysql/query_factory.php on line 120
PHP Fatal error:  1030:Got error 28 from storage engine :: show fields from orders_status_history in /includes/classes/db/mysql/query_factory.php on line 120

I've looked at the orders_status_history table using phpMyAdmin, tried repairing it ... to no avail. Does anyone have any ideas as to what could cause this?

[Ajeh]

Did you share that with the hosting provider to see if by chance they have a space issue on their server?

[lat9]

Ajeh, I was heading there next ... especially now that you've validated the "space issue" that Google indicated!

[Ajeh]

Let us know what you discover ...

[lat9]

Unfortunately, the site is running on a shared server and there's no way to control/monitor the usage % on the /tmp directory. My options (other than finding another host!) are to either move to a different shared server or to upgrade my server package. Arggh!

It's just funny that each of the errors occur at the same point (show fields from orders_status_history).

[DrByte]

Is there a lot of wasted space consumed by old debug log files, or backups of old images or old site versions, etc? If so, then perhaps it's just your own hosting account that's out of space (regardless of what folder).

[lat9]

Thanks for that, DrByte. I'll look into what the site's file quota might be.