I’m seeing this as well with my largest backup set. Enabling verbose logging it seems to be stuck at
2018-02-04 12:07:47Z - Profiling: Starting - ExecuteReader: SELECT "A"."Hash", "C"."Hash"
FROM (
SELECT "BlocklistHash"."BlocksetID", "Block"."Hash", *
FROM "BlocklistHash","Block"
WHERE "BlocklistHash"."Hash" = "Block"."Hash" AND "Block"."VolumeID" = ?) A,
"BlocksetEntry" B,
"Block" C
WHERE "B"."BlocksetID" = "A"."BlocksetID" AND
"B"."Index" >= ("A"."Index" * 3200) AND
"B"."Index" < (("A"."Index" + 1) * 3200) AND
"C"."ID" = "B"."BlockID"
ORDER BY "A"."BlocksetID", "B"."Index"
I think the problem here is I didn’t change the default 50MB chunk size and this is a 3.5TB backup set composed of files that average 10GB each. The results is my sqlite DB for this set is 8.2GB. I’ve since increased the chunk size to 500MB but that doesn’t help with the existing 3.5TB of backup data.