Hello. After search without chance here and over internet, I decided to write how I solved my problem.
I have Nextcloud install in a docker for home use (sync photos, music, caldendars…). I had a 500GB HDD but, 1 year ago, it become full. I thought it was because I start use Talk with some friends whom I’ve created an account in my istance, and maybe other apps I’ve tried to install. So I bought another HDD with 1TB space.
Days ago, it become full!
I’ve tried to remove Preview generators and others app, cleaup the database, of course remove all dangling docker images. After few days, same situation: zero space!
The problem was some .err files, under the directory nextclouddb/databases. Some files reached more than a hundred of GB.
In every line of some of these incredible-sized files was reported: “[ERROR] Incorrect definition of table mysql.column_stats”.
I found that the problem is an incorrect update of the database. And so I entered the database (docker exec -it nextclouddb bash) and start a manual uprade (/usr/bin/mariadb-upgrade --user=root --password=database_password).
Now my space is get back to less than 200GB.
I hope this can help someone.
Have a good day.
2 Likes
Thanks for sharing your experience. In theory, Nextcloud should manage space efficiently so that versions and trash bin are cleaned out automatically. But your case shows how important it is to know you system a bit to track down where the storage is used and how to fix it.
1 Like