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.

13

1 Answer 1

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)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .