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@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.