Site crashing, Can't create/write to file '/tmp

Asked Jun 13 '13 at 00:22

Active Jun 13 '13 at 05:45

Viewed 1,276 times

I have a site that is using question2answer script and some custom made code. I recently have a problem with the site crashing. The error I get when I open the page is:

Database query error 1 Can't create/write to file '/tmp/#sql_819_0.MYI' (Errcode: 13)

(SELECT 'options' AS selectkey, title, content FROM qa_options) UNION ALL (SELECT 'time', 'db_time', UNIX_TIMESTAMP(NOW()))

All seems to be fine with the tmp permissions: drwxrwxrwt

I don't know when this is happening. If I restart the server everything is working fine and I get no errors. Then, after some time it is happening again. Site is down and all I get is that message.

Really need your help!

edited Jun 13 '13 at 05:45

asked Jun 13 '13 at 00:22

Cristian Stoicescu

Free space? You might have run out of disk space. Check with `df -h` – marekful Jun 13 '13 at 00:27
Crashing is when your program breaks for some reason. Crushing is when an elephant sits on your DB server :-) – paxdiablo Jun 13 '13 at 00:40
Checked to see if I'm running of free space, but it is not the case. 990M still free in /tmp , only one percent used – Cristian Stoicescu Jun 13 '13 at 05:47
OS error code 13: Permission denied So it does not look like a space problem. – Cristian Stoicescu Jun 13 '13 at 06:21
Can someone explain what drwxrwxrwt means? – Cristian Stoicescu Jun 13 '13 at 06:23
Those are the file permissions: d- directory r- red, w - write, x - execute rwx repeats three times once each for owner, group, others – Deb Mar 02 '14 at 21:39

Site crashing, Can't create/write to file '/tmp

0 Answers0