[CentOS] MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem

Thu Feb 13 20:13:11 UTC 2014
Ljubomir Ljubojevic <centos at plnet.rs>

On 02/13/2014 08:17 PM, Clint Dilks wrote:
> Hi,
> Have you verified that permissions on /tmp appear correct ?
> An example from one of my systems
> # ls -lsahd /tmp
> 4.0K drwxrwxrwt. 3 root root 4.0K Feb 14 07:01 /tm
> So permissions 1777

Already checked.

[root at chiron ~]# ls -lsahd /tmp
4.0K drwxrwxrwt. 17 root root 4.0K Feb 13 20:55 /tmp

> Perhaps test creating a file in /tmp as root and as a non root user and let
> us know the results that way we may be able to help further.

There is enough space, and I successfully created files as root, mysql 
and plnet user (domain owner).

[root at chiron ~]# df -h
   Size  Used Avail Use% Mounted on
/dev/mapper/vg_chiron-LV_CHIRON_ROOT       25G   15G  8.3G  65% /
   1.3G  676K  1.3G   1% /dev/shm
/dev/md0                                  485M  197M  263M  43% /boot
/dev/mapper/vg_chiron-LG_CHIRON_EXTRA     1.8T  1.6T  143G  92% /extra

> On Fri, Feb 14, 2014 at 8:06 AM, Ljubomir Ljubojevic <centos at plnet.rs>wrote:
>> Hi.
>> I have a strange problem.
>> I installed cacti, and set it up.
>> When I click on the Plugins Management, I noticed Error
>> "FATAL: Database or Table does not exist"
>> Further testing revealed that at the moment MySQL can not create
>> temporary files in /tmp. It is same for ANY database!
>> SELinux is disabled.
>> I logged to mysql as root and error is same.
>> Command used is:
>> CREATE TEMPORARY TABLE IF NOT EXISTS plugin_temp_table LIKE bak_menu;
>> Error is:
>> ERROR 1004 (HY000): Can't create file '/tmp/#sql21f8_f3_0.frm' (errno: 9)
>> What could be the problem, any idea how to proceed?
>> I do not think I edited any MySQL setting.

I forgot to mention that I use Virtualmin GPL for ~10 domains, but up 
until now I have not seen any problems.

Ljubomir Ljubojevic
(Love is in the Air)
PL Computers
Serbia, Europe

StarOS, Mikrotik and CentOS/RHEL/Linux consultant