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. -- Ljubomir Ljubojevic (Love is in the Air) PL Computers Serbia, Europe StarOS, Mikrotik and CentOS/RHEL/Linux consultant