Mariadb: Can't create/write to file '/var/tmp/#sql_c27_0.MAI' (Errcode: 2 "No such file or directory")

Question

I trying to select or desc tables sometimes it works and sometimes I got:

ERROR 1 (HY000): Can't create/write to file '/var/tmp/#sql_c27_0.MAI' (Errcode: 2 "No such file or directory")

it worked and stop working.

Thanks.

Looks like an apparmor / setenforce problem. I've seen this error when the system security is blocking mysqld from using an unauthorized directory. Did you try to change the `tmpdir` option recently? — Bill Karwin, Mar 15 '22 at 16:19

score 0 · Accepted Answer · answered Mar 15 '22 at 15:50

0

It seems that your disk is out of space. I'd recommend running the following commands to check to see if it has free space / free inodes:

df -h
df -ih

answered Mar 15 '22 at 15:50

Valeriu Ciuca

The error code is 2, not 28 (= no space left of device) – Georg Richter Mar 16 '22 at 05:56

1 Answers1