MySQL Can’t Create File ‘/tmp/#sql2e0_98_0.frm’ (errno: 9) Problem

Home » CentOS » MySQL Can’t Create File ‘/tmp/#sql2e0_98_0.frm’ (errno: 9) Problem
CentOS 6 Comments

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.

6 thoughts on - MySQL Can’t Create File ‘/tmp/#sql2e0_98_0.frm’ (errno: 9) Problem

  • 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

    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.

  • Already checked.

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

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

    [root@chiron ~]# df -h Filesystem
    Size Used Avail Use% Mounted on
    /dev/mapper/vg_chiron-LV_CHIRON_ROOT 25G 15G 8.3G 65% /
    tmpfs
    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

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

  • This is interesting.

    I tested on cacti database and on 2 Joomla databases with same results. But there might be something there.

    Database changed mysql> CREATE TEMPORARY TABLE IF NOT EXISTS plugin_temp_table LIKE jos_menu;
    ERROR 1004 (HY000): Can’t create file ‘/tmp/#sql21f8_f3_1.frm’ (errno: 9)
    mysql> CREATE TEMPORARY TABLE barney (SELECT * FROM jos_menu WHERE 1=0);
    Query OK, 0 rows affected (0.01 sec)
    Records: 0 Duplicates: 0 Warnings: 0

    mysql> CREATE TEMPORARY TABLE IF NOT EXISTS plugintest LIKE jos_menu;
    ERROR 1004 (HY000): Can’t create file ‘/tmp/#sql21f8_f3_3.frm’ (errno: 9)
    mysql> CREATE TEMPORARY TABLE IF NOT EXISTS barney LIKE jos_menu;
    Query OK, 0 rows affected, 1 warning (0.00 sec)

    Changed name of table to create produced result, but with warning.