CentOS - Feb 2014 - 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.

-- 
Ljubomir Ljubojevic
(Love is in the Air)
PL Computers
Serbia, Europe

StarOS, Mikrotik and CentOS/RHEL/Linux consultant

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.




On Fri, Feb 14, 2014 at 8:06 AM, Ljubomir Ljubojevic <centos at
plnet.rs>wrote:
> 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.
>
> --
> Ljubomir Ljubojevic
> (Love is in the Air)
> PL Computers
> Serbia, Europe
>
> StarOS, Mikrotik and CentOS/RHEL/Linux consultant
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>

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.

-- 
   Les Mikesell
     lesmikesell at gmail.com