The saga sort of continues…
I got an error message saying that it failed due to disk space [Insertion failed because the database is full
database or disk is full] (I have a few gb available on the Ubuntu VM), but I googled and read that it could be the /tmp that became full, so I used the advanced option and moved the tmp directory to the same NAS that is backing up (via NFS, VM network – all on the same machine).
Now I started it up again and it takes forever, and the log does not show anything. The last time it took hours, and my guess is that it will take hours again.
BUT @kenkendk said it should take seconds. Any input on how to debug/figure out this?
EDIT:
Now it started to verify back end data. It took over 2 hours before anything happened. Please see this log excerpt, especially the timing entries.
From Duplicati start till “something happened”:
Sep 14, 2017 12:14 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Block" WHERE "Size" > ? **took 02:07:24.819**
Sep 14, 2017 10:04 AM: Server has started and is listening on 0.0.0.0, port 8200
From Verifiying Back End Data till starting backing up
Sep 14, 2017 2:28 PM: 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" **took 02:01:18.852**
Sep 14, 2017 12:27 PM: 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"
So in summary, it takes around 4 hours from it starts till it starts backing up. Any thing I can do to debug/speed it up?
EDIT 2:
Also, before the “out of disk space error” it was around 1,5 TB left. Now it says 3.5 TB – and are uploading. Some files should be new, but not 2+ TB worth. Should this worry me?