Mysql Errcode: 17 Can't create/write to file '/tmp/...'

Question

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.

I should note that the /tmp folder is chmod 777 and there is ample disk space. — Benbob, Nov 08 '10 at 04:16
Here is a dump of mysql variables: http://pastebin.com/hGx6tuka — Benbob, Nov 08 '10 at 05:44

score 1 · Answer 1 · answered Nov 08 '10 at 03:42

1

Sounds like a full /tmp to me

Or a permissions problem..

answered Nov 08 '10 at 03:42

Arenstar

3,602
2
25
34

NB the /tmp filesystem should have the other sticky bit set (drwxrwxrwt) – symcbean Nov 08 '10 at 09:31

score 0 · Answer 2 · answered Nov 08 '10 at 03:39

0

Just do a killall mysqld.

For the real cause..... is your disk (or /tmp) full?

answered Nov 08 '10 at 03:39

J-16 SDiZ

238
2
9

Nope, 400MB free. – Benbob Nov 08 '10 at 04:16
`grep /var/log/messages` for SELinux. -- is SELinux blocking your mysqld? You should see message like `SELinux is preventing mysqld (something)` – J-16 SDiZ Nov 08 '10 at 04:35
No occurrences of 'SELinux'. – Benbob Nov 08 '10 at 05:35

score 0 · Answer 3 · edited Sep 03 '14 at 21:14

0

The temporary file "#sql_272_0.MYD" cannot be written to because it was not removed from a past session and unwrittable by the current session. It needs to be manually removed from the /tmp directory.

ssh into your server using the terminal, and enter the following command:

rm -f "/tmp/#sql_272_0.MYD"

Edit: make sure to execute the command as a user with permission to delete the file.

edited Sep 03 '14 at 21:14

ThoriumBR

5,302
2
24
34

answered Sep 03 '14 at 20:19

fogmann

1
1

Mysql Errcode: 17 Can't create/write to file '/tmp/...'

3 Answers3