MySQL Can’t Create File ‘/tmp/#sql2e0_98_0.frm’ (errno: 9) Problem
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.
http://bugs.mysql.com/bug.php?id`574
The error may be on the source of the copy (bak_menu.frm) not in tmp.
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.
It looks like “IF NOT EXISTS” might be creating problems.
Nope, that is not it, seams “LIKE” is the problem.