I have a server with 80+ hosts. In last 2 months i migrated many of them to others UrBackup servers for more reliability cause backup_server_files.dd size.
I have deleted like 55 hosts now and the backup_server_files.db is always 56gb like with 80 hosts.
Night procedure deleted completely files in the data directory but seems not deleted all hash in DB related to them. I need to reduce the db to reflex the actually hosts present.
I try remove-unknown with no success. Not seems delete the entries in DB of hosts anymore existing. With defrag-database/repair-database 2 months ago the database became corrupted and i lost 15gg of backups cause have to recover an old copy of it.
Defrag database would shrink the database. If you think that corrupts databases, please report the problem including relevant information so it can get fixed.
In meantime i’ve exported a copy of the DB to another file with sqlite3 .dump function and reimported. Now is 14gb. Your defrag function basically should do similar thing?
@uroni could it be that for doing a successfull defrag of the db you need at least x2 the actual free size of the file for doing that initial copy? That is maybe why @MessaUfficio db got corrupted.