Can't create/write to file '/tmp/ (Errcode: 30)

[dasonix]

I keep gettign this error. and its driveing me nuts

Can't create/write to file '/tmp/#sql_619_0.MYI' (Errcode: 30)

I have checked the folder perms and they are set right at 1777.

after a reboot all goes away for a few hours and then comes back, any more ideas on how to fix this. Main systems messed up by this are MYSQL.

While trying to solve this I cleared out loads of cache files (relateing to one of the websites on the server) and now no new files seem to be placed in the folder.

MYSQL sock file is set to normal destination (NOT /Tmp) but there is a empty mysql.sock file in the /tmp folder.

Things I have checked.

Folder perms (root(0)/root(0) 1777) all seem ok
Space only 15mb of 500mb used , so its not out of space

Any more ideas woudl be great

TY

[Get Em Fast]

Is that a multiple type-o on your part (1777), or is that on purpose? The permissions should be 777, without the 1 in front.

[DrByte]

What "user" is MySQL running as? What permissions does that user have to your /tmp folder?

Error 30 appears to suggest that the file-system is read-only, at least as far as MySQL is concerned.

Related articles:
http://lkml.org/lkml/2003/12/21/9
http://mononoke-bt.org/details.php?id=8885

[dasonix]

Server is a fedora Cpanel box

evreythign I have read said that the tmp folder should be set as 1777 (sticky bit set) that is how it was before anyway so have left it as that.

How do i find out the permissions and what user MYSQL is runing as?

(I know I should have got a win doz box) ;)

[DrByte]

No ... stay away from win doze !!!

Is this a standard cPanel setup ? have you done anything custom to it?
When you run ps aux, what user is mysqld running as?

You might be best advised to look for server-config assistance at webhostingtalk.com

[dasonix]

here is the PS AUX response

root      1535  0.0  0.1   4444  1264 ?        S    19:20   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mys
mysql     1562  0.3  6.1 381212 62992 ?        Sl   19:20   0:33 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file
root      1591  0.0  0.5   9744  5548 ?        S    19:20   0:00 chkservd

I have tried a few webhosting sites but nobody seems willign to help, havent had any reply off cpanel forums either, infact you are the only person who has wanted to help

to answer your ? yes a std cpanel setup exept has a new mailscanner bound with Exim but its been like that since it was built back in december, problem started with cpanel 10 day before yesterday so I upgraded to cpanel 11 yesterday and its still happening.

I have my hosts lookign into it too but they havent been much help yet.

last thing i want to do is a OS restall. but if its the only option Ill have to do that.

[dasonix]

only said abotu the windoz box as I'm a MCP so can fix most windoz probs but still on the learning curve for nix (windoz was never this hard to learn) lol

[DrByte]

It appears that your server is running mysqld as the "mysql" user, which is typical of cpanel installations, and is typically fine.

Now the problem must be ownership, permissions, or disk space.

I know you already stated 15/500, but I'm going to ask you to verify specifically again:

For the /tmp dir:
- What volume is it a part of?
- How much space is on that drive?
- How much space is allocated to /tmp ?
- How much space is used on the drive?
- What is the permissions mask on the /tmp folder?
- Who is the owner of the /tmp folder?
- Does the mysql user have any quota restrictions assigned to it (as an MCP you'd be familiar with this concept on windoze)?
- How many files/folders are in the /tmp folder? There shouldn't be many.

[dasonix]

Filesystem setup

Filesystem Size Used Avail Use% Mounted on
/dev/sda3 107G 6.8G 95G 7% /
/dev/sda1 99M 13M 82M 14% /boot
tmpfs 498M 0 498M 0% /dev/shm
/usr/tmpDSK 485M 12M 448M 3% /tmp
/dev/sdb1 74G 9.8G 60G 15% /backup

Folder perms:

tmp	41.0k	19-May-2007 23:21:05	root(0)/root(0)	1777

Files in /tmp

drwxrwxrwt  5 root     root       41984 May 19 23:21 .
drwxr-xr-x 27 root     root        4096 May 19 19:19 ..
drwxrwxrwt  2 root     root        1024 May 19 19:19 .ICE-unix
-rw-rw-r--  1 properfo properfo      93 May  3 18:52 .htaccess
-rw-r-----  1 clamav   clamav   1336308 May 19 23:01 ClamAV.update.log
-rw-------  1 mailnull mail          55 May 19 23:18 ClamAVBusy.lock
-rw-r--r--  1 root     root         330 May 19 23:21 MAIL-HOST
drwxr-xr-x  2 root     root        1024 May 19 22:38 cpbandwidth
-rw-r--r--  1 nobody   nobody         6 Jan 29 01:27 dos-208.109.16.207
-rw-r--r--  1 nobody   nobody         6 Mar 22 20:06 dos-216.120.144.66
-rw-r--r--  1 mailnull mail           0 May 19 23:01 exim_deny.lock
lrwxrwxrwx  1 root     root          30 May 19 23:15 mysql.sock -> ../../var/lib/mysql/mysql.sock
-rw-rw----  1 nobody   nobody        13 Apr 26 05:38 nobody-session-0.340426887924881
drwxr-xr-x  3 root     root        1024 Feb 23 06:38 pear
-rw-------  1 pigumbr1 pigumbr1      42 May 19 21:02 sess_333d3377503f633d6713bf00445a2f30
-rw-------  1 bunnybas bunnybas   14177 May 19 23:19 sess_91fa7a4c689bba89946536ca4c4edb92
-rw-------  1 pigumbr1 pigumbr1  102800 May 19 22:51 sess_bb08bfe663c14ee90b289816bb409529
-rw-------  1 pigumbr1 pigumbr1      42 May 19 20:54 sess_c454094f293f69c51786276400ddf5f9
-rw-------  1 pigumbr1 pigumbr1      37 May 19 22:52 sess_d923787177c49aa42beb65ed75d09c7e

no quotas set

[DrByte]

What are the properties of the mysql user ?
Is it jailed in any way?