0

MySQL version: mysql Ver 8.0.25-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

I have a server that hosts a MySQL database and Apache Airflow. It was working fine for a couple of months. For a couple of days, my services are constantly crashing.

I see that the error is due to insufficient Disk Space: These are the errors that I see when I try to run my Airflow Service.

enter image description here

enter image description here

This is happening even though I see there is disk space left: enter image description here

I figured out that this could be due to a MySQL bug, https://community.oracle.com/tech/developers/discussion/4267115/mysql-daemon-not-releasing-deleted-temp-file

But I have a newer version of MySQL installed so this should not happen.

Tried restarting the server a couple of times.

Tried killing the MySQL services manually, but it always goes back to the same state.

So I am not even able to get it fixed temporarily.

enter image description here

Not able to understand how to fix the error permanently, any help will be appreciated.

ofnowhere
  • 101

1 Answers1

1

Out of inodes? Check with df --inodes

A quick, but temporary, fix would be to toss files in .Trash and Download

Maybe there are lots of unnecessary empty files: https://www.interserver.net/tips/kb/solution-running-inodes/ https://askubuntu.com/questions/231585/running-out-of-inodes

Maybe "compressing" a few little-used disk trees would help. (You will need a few free inodes before trying this.) Or tar up some trees that you don't need.

(etc)

Rick James
  • 2,743