[CentOS] MySQL Can't create file '/tmp/#sql2e0_98_0.frm' (errno: 9) problem

Thu Feb 13 20:24:31 UTC 2014
Ljubomir Ljubojevic <centos at plnet.rs>

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