On 02/13/2014 09:21 PM, Ljubomir Ljubojevic wrote: > On 02/13/2014 09:18 PM, Ljubomir Ljubojevic wrote: >> On 02/13/2014 08:49 PM, Les Mikesell wrote: >>> On Thu, Feb 13, 2014 at 1:06 PM, Ljubomir Ljubojevic <centos at plnet.rs> wrote: >>>> >>>> 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? >>> >>> http://bugs.mysql.com/bug.php?id=60574 >>> The error may be on the source of the copy (bak_menu.frm) not in tmp. >>> >> >> 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. -- Ljubomir Ljubojevic (Love is in the Air) PL Computers Serbia, Europe StarOS, Mikrotik and CentOS/RHEL/Linux consultant