Oversized Disk Usage

[pbischoff]

@girish Yes it looks like that!

[pbischoff]

@girish and the yellowtent/ directory uses 858 GB

[girish]

@pbischoff OK, so maybe du -hcs /home/yellowtent/appsdata/* will tell you which app is taking lots of space . If you put the appid that you get there into the search box of the Dashboard, you will see which app it is.

/home/yellowtent/box is just source code. I don't expect this to take much space

/home/yellowtent/platformdata is run time data (logs, databases). In the graph, this is around 180GB or so.

[pbischoff]

@girish okay thank you, that helped very much.

I identified a Directus instance that uses almost 500 GB. I think this is database data because of a cron process that fetches data periodically and writes logs for every fetch. How can I identify if it is really the database data or some files?

[girish]

@pbischoff /home/yellowtent/appsdata/<appid> only has the files. The database data is under /home/yellowtent/platformdata/postgresql .

One thing, you might want to check is the size of /home/yellowtent/appsdata/<appid>/postgresqldump . This is the size of the postgres dump of the app. Other than that, it's all file data.

You can open the web terminal for Directus app. And then, inspect /app/data there. (this is the same as /home/yellowtent/appsdata/<directus-app-id>/data on the host).

[pbischoff]

@girish okay this is really curious. When I look under "Storage" of that app in the Cloudron Dashboard it tells me The app is currently using 9.5 MB of storage (as of 1 hours ago).

[girish]

@pbischoff Sorry, I edited my post Maybe it's in the database after all. Can you check the size of the dump file?

[pbischoff]

@girish Yes it's this file! It has 447G!

Do I have to manually modify this file or will just deleting the data within Postgres do the trick?

[girish]

@pbischoff Yes, if you delete data from postgres and create a backup that file will shrink accordingly (that file is part of an app's "backup")

[pbischoff]

@girish I just wanted to say thank you for your help two weeks ago!

I didn't get Postgres running because of too little storage on the disk, so I had no idea in this short time how to delete the things out of Postgres.
For us this issue was very critical and I had to fix it very fast and so I just deleted the dump file which means the loss of the directus instance data, but that was okay in this case.
Again: thank you very much and best regards!