Explosion in backup file size

[Nephilimi]

Earlier this week I noticed that the hydra2 web page was down and sonarr/radarr were complaining it wasn't available. I restarted the VM and shortly later sab notified me the disk was full. On further investigation I found what's in this picture. I cleaned out some of the larger big ones to get things running again.

I'm currently on 7.10.2 and I go in and hit update maybe once every couple weeks.

October backups seem reasonable, but something big happened in November.

nzbhydra-debuginfos-2024-12-06-09-51.zip

[theotherp]

How large is the database file in the data/database folder?

Also see #974

[Nephilimi]

Right now

/opt/nzbhydra2/data/database$ ls -l -h
total 627M
-rw-r--r-- 1 nzbhydra2 nzbhydra2 627M Dec  7 05:06 nzbhydra.mv.db

Also I made a backup yesterday afternoon and it was a "normal" 250MB vs the one in the morning being 4x the size?

/opt/nzbhydra2/data/backup$ ls -l -h
total 7.3G
-rw-r--r-- 1 nzbhydra2 nzbhydra2  290M Oct 17 10:41 'nzbhydra-2024-10-17 10-40-39.zip'
-rw-r--r-- 1 nzbhydra2 nzbhydra2  307M Oct 24 10:46 'nzbhydra-2024-10-24 10-46-03.zip'
-rw-r--r-- 1 nzbhydra2 nzbhydra2  323M Oct 31 10:52 'nzbhydra-2024-10-31 10-51-31.zip'
-rw-r--r-- 1 nzbhydra2 nzbhydra2  1.1G Dec  4 14:05 'nzbhydra-2024-12-04 14-03-08.zip'
-rw-r--r-- 1 nzbhydra2 nzbhydra2 1012M Dec  6 09:34 'nzbhydra-2024-12-06 09-31-49.zip'
-rw-r--r-- 1 nzbhydra2 nzbhydra2  243M Dec  6 21:14 'nzbhydra-2024-12-06 21-13-53.zip'
-rw------- 1 nzbhydra2 nzbhydra2  4.2G Nov 21 12:43  zipfstmp3729379435280921705.tmp

Not sure what the temp file is either?

[burntoc]

I'm seeing the same here (the log file growth, not the temp file).

[Buttonskill]

+1 to this. 10GB db file and 4x 4GB plus backups.

[theotherp]

I'm working on it but need to wait for an update by the database programmers.

You can try setting the retention time in the main config (enabled advanced options) to 0. This increases the risk of corrupted databases, though. I have no way of knowing by how much. If the database is corrupted you lose history and stats but no settings and can restore from the latest backup.

[theotherp]

It would also help to see the file listing of the content of one of the backup.zips.

[Nephilimi]

Sure.