Search code examples
mysql-error-1064

Can't create/write to file '/var/tmp/#sql_2f6_0.MYI

For the past three to four months, we have our application live and running, we haven't deployed any new fixes / changes on Live. However ever unfortunately, we noticed that application has stopped running.

Following is the issue we observed from our logs :

"Can't create/write to file '/var/tmp/#sql_2f6_0.MYI" .

It would be really appreciable if anyone of you can extend your help.

Solution

  • Check the services and the User for which your Mysql is giving you this error. It is very much possible that any of the services might be down, or the User by which you are using the DB is not getting authenticated.