The Planet Forums > Need Help with Errcode: 28 in MySQL and tmp folders

Full Version: Need Help with Errcode: 28 in MySQL and tmp folders

The Planet Forums > Control Panels > cPanel/WHM

RamiroS

Mar 10 2008, 10:26 AM

Hello, need some advice with this.

I'm getting this error with big query results:

CODE

Error writing file '/tmp/MYGVKwOq' (Errcode: 28)

CODE

/dev/hda3 on / type ext3 (rw,usrquota)
none on /proc type proc (rw)
none on /dev/pts type devpts (rw,gid=5,mode=620)
usbdevfs on /proc/bus/usb type usbdevfs (rw)
/dev/hda1 on /boot type ext3 (rw)
/dev/hdb1 on /home2 type ext3 (rw,usrquota)
/dev/tmpMnt on /tmp type ext2 (rw,noexec,nosuid,loop=/dev/loop0)
none on /dev/shm type tmpfs (rw,noexec,nosuid)

This is my df -h

CODE

/dev/hda3              72G   34G   35G  50% /
/dev/hda1              99M   26M   69M  28% /boot
/dev/hdb1              74G   29G   41G  42% /home2
/dev/tmpMnt           190M   37M  144M  21% /tmp
none                 1004M     0 1004M   0% /dev/shm

So my questions are:

Shouldn /dev/shm use more space here? or should I put more space on /tmp? How can I solve this?

Thanks in advance

RamiroS

Mar 10 2008, 12:10 PM

Solved!

Checked the tutorial that I used by eth0 to secure /tmp and found that at that time (maybe a couple of years ago or so) I was using 180MB... so I added more space to tmp:

umount /dev/tmpMnt
cd /dev/; dd if=/dev/zero of=tmpMnt bs=1024 count=800000

and followed the same steps again. Everything went ok.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.