By PipSqueak on

I receive this message in my log:

"Can't create/write to file '/private/var/tmp/#sql_182_0.MYI' (Errcode: 28) query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 0 in /Library/WebServer/site/includes/database.mysql.inc on line 66."

and apparently it is by a visitor to my site that kept receiving it multiple times in a row - but I cant pinpoint where exactly the visitor encountered this, even using IE, FireFox, Safari, PC & Mac, and other people's computers (not logged in). Therefore, since I don't encounter this myself, I can't fix it.

Can anyone help?

⋅ Categories: Drupal 4.6.x

Comments

heine’s picture

heine commented

Error 28 on my system means 'no space left on device'; in this case the device where the temporary directory is located.
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

PipSqueak’s picture

PipSqueak commented

Thank you for your reply. Does it mean the server disk space? Because i still have a lot of space, doesn't seem to make sense - also, I don't encounter it at all when I use other computers.

Lappie’s picture

Lappie commented

As Heine already commented, it's the space on the temporary directory: the place were mysql writes temporary stuff. This directory (read disk) can be full without your involvement. Other users might be accidently uploading a big file that is also placed on the same disk, completely filling it.

Just a guess!?

PipSqueak’s picture

PipSqueak commented

Thanks all for your reply, I haven't received the error since so you may be right. I will keep watch on the disk space although it is still a mystery