You are not logged in.
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