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

Issue

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.

Solution

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 By – Valeriu Ciuca

Answer Checked By – Marie Seifert (BugsFixing Admin)