Can't create/write to file '/tmp/#sql_77a8_0.MYD' (Errcode: 17)
I'm getting this for all softs of select queries. This problem is quite intermittent. Deleting the file fixes the problem but in an hour or so it's back again.
Trying to restart the service occationally gives this error:
[14:57] root@host [/home/belntwk/all_sites]# service mysql restart Shutting down MySQL. ERROR! Manager of pid-file quit without updating file. ERROR! Failed to stop running server, so refusing to try to start.
No idea what the problem is or even how to test if it has been fixed or not.