MySQL got error 28 from storage engine when disk is not full?

Question

linux

Hello.
For no reason, this error appeared, I found that it can be issued in the absence of free space, but the disk / inodes were free.
Rebooted and the error disappeared. Has anyone had something similar?

Answer 1

There was not enough free space in / tmp to execute the request (requests).
On reboot, / tmp was cleared, respectively, mysql nothing else interferes.
/tmp is a folder where all programs write temporary files, it can have a fixed size or it can use the total disk space.
When repeating the problem, pay attention to the completion of all sections in the output of the command:
then think about the results