So I had a major power outage causing major disk corruption, URBackup server was affected. So I restored a full backup of the server itself but the databases were apparently corrupted (somehow) and the backup that URBackup makes (the backup and it’s underlying file system was not corrupted) has several 50MB files that SQLite says are empty.
I am working on restoring everything from snapshots at this point and doing manual SQLite dump-and-rebuilds (the 22GB backup_server_files.db has been affected by the corruption).
My question (or feature request) would be: how do I make sure that URBackup Server
a) Makes proper backups of it’s own databases - it doesn’t seem to check for errors on backup
b) Does some sort of versioning on it’s own backup files
c) Does integrity checks during it’s regular maintenance of it’s own databases and does not backup corrupted databases.
I had tested everything before as far as restore is concerned, it worked, however I didn’t note that URBackup doesn’t make a versioned backup of itself like it does for it’s clients. Perhaps instead of just shuttling binary files, it should make a dump?