Mysql Errcode: 17 Can’t create/write to file ‘/tmp/…’

centos5MySQL

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.

Best Answer

Sounds like a full /tmp to me

Or a permissions problem..

Related Solutions

MySQL – Can’t Create/Write to File ‘/tmp/#sql_xxxx.MYI’ (Errcode: 13)

It looks like your permissions on /tmp are wrong. They really should be read/write/execute for everyone with the sticky bit set.

chmod 1777 /tmp

The sticky bit add some restrictions to how other users interact with files not created or owned by them, so there's no reason to worry.

If you wish, you may also create a seperate directory owned and writeable by the mysql user and specify that directory in my.cnf to be used instead of the system wide /tmp.

Mysql – Can’t create/write to file ‘#sql_1fc7_3.MYD’ (Errcode: 17)

Error 17 is "file exists".

See if anything else has #sql_1fc7_3.MYD open:

lsof | grep '#sql_1fc7_3.MYD'

If it doesn't, then move it. I'm not sure what led to this problem, but one guess is that MySQL crashed at some point and as a result didn't clean up a temp table's file named #sql_1fc7_3.MYD.

Best Answer

Related Solutions

MySQL – Can’t Create/Write to File ‘/tmp/#sql_xxxx.MYI’ (Errcode: 13)

Mysql – Can’t create/write to file ‘#sql_1fc7_3.MYD’ (Errcode: 17)

Related Topic