You are not logged in.

#1 2013-03-09 23:00:52

hamelg
Member
From: France
Registered: 2008-06-19
Posts: 130

mysql-5.5.30-6 : temp files issue

since I upgraded mysql, I beginning to encounter suddenly this kind of error on any sql statement after some times :

mysql> show fields from jos_banner;
ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_25e6_0.MYI' (Errcode: 2)

I find that restarting mysqld is sufficient without actually changing any configuration files, but the problem shows up again the next day.

After some research, I find out that "PrivateTmp=true" in /usr/lib/systemd/system/mysqld.service is the guilty :
mysqld creates temp files in a private namespace (ie : /tmp/systemd-private-6DfdVO). The errors happen because the directory no more exists.

I can't figure who removes these directories, is it a systemd configuration issue ?

Offline

Board footer

Powered by FluxBB