Old thread, but I also have this problem. Havent this been fixed in 1,5 years? I am evaluating Duplicati for my (and others) backup solution.
-
Dec 1, 2019 8:24 AM: Backend event: Get - Started: duplicati-b0126c54c57404e6180e5dea6bcb6ba9c.dblock.zip.aes (49.91 MB)
-
Dec 1, 2019 8:24 AM: Starting - RemoteOperationGet
-
Dec 1, 2019 8:24 AM: 1 remote files are required to restore
-
Dec 1, 2019 8:24 AM: GetMissingVolumes took 0:00:00:00.002
-
Dec 1, 2019 8:24 AM: Starting - GetMissingVolumes
-
Dec 1, 2019 8:24 AM: ScanForExistingSourceBlocksFast took 0:00:00:05.495
-
Dec 1, 2019 8:24 AM: CommitBlockMarker took 0:00:00:00.000
-
Dec 1, 2019 8:24 AM: Starting - CommitBlockMarker
-
Dec 1, 2019 8:24 AM: Target file is patched with some local data: /source/training/MVI_3755.MOV
-
Dec 1, 2019 8:24 AM: ExecuteReader: SELECT DISTINCT “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“TargetPath”, “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path”, “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“ID”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Index”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Hash”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Size” FROM “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”, “File”, (SELECT “File”.“Path”, “File”.“BlocksetID”, MAX(“Fileset”.“Timestamp”) FROM “Fileset”, “FilesetEntry”, “File” WHERE “FilesetEntry”.“FileID” = “File”.“ID” AND “FilesetEntry”.“FilesetID” = “Fileset”.“ID” AND “File”.“Path” IN (SELECT DISTINCT “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path” FROM “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E” WHERE “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“ID” = “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“FileID” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Restored” = 0 AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Metadata” = 0 AND “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“TargetPath” != “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path” ) GROUP BY “File”.“Path” ) S, “Block”, “BlocksetEntry” WHERE “BlocksetEntry”.“BlocksetID” = “S”.“BlocksetID” AND “BlocksetEntry”.“BlocksetID” = “File”.“BlocksetID” AND “BlocksetEntry”.“BlockID” = “Block”.“ID” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Index” = “BlocksetEntry”.“Index” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Hash” = “Block”.“Hash” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Size” = “Block”.“Size” AND “S”.“Path” = “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path” AND “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“ID” = “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“FileID” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Restored” = 0 AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Metadata” = 0 AND “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“TargetPath” != “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path” ORDER BY “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“ID”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Index” took 0:00:00:00.014
-
Dec 1, 2019 8:24 AM: Starting - ExecuteReader: SELECT DISTINCT “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“TargetPath”, “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path”, “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“ID”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Index”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Hash”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Size” FROM “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”, “File”, (SELECT “File”.“Path”, “File”.“BlocksetID”, MAX(“Fileset”.“Timestamp”) FROM “Fileset”, “FilesetEntry”, “File” WHERE “FilesetEntry”.“FileID” = “File”.“ID” AND “FilesetEntry”.“FilesetID” = “Fileset”.“ID” AND “File”.“Path” IN (SELECT DISTINCT “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path” FROM “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E” WHERE “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“ID” = “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“FileID” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Restored” = 0 AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Metadata” = 0 AND “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“TargetPath” != “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path” ) GROUP BY “File”.“Path” ) S, “Block”, “BlocksetEntry” WHERE “BlocksetEntry”.“BlocksetID” = “S”.“BlocksetID” AND “BlocksetEntry”.“BlocksetID” = “File”.“BlocksetID” AND “BlocksetEntry”.“BlockID” = “Block”.“ID” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Index” = “BlocksetEntry”.“Index” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Hash” = “Block”.“Hash” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Size” = “Block”.“Size” AND “S”.“Path” = “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path” AND “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“ID” = “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“FileID” AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Restored” = 0 AND “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Metadata” = 0 AND “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“TargetPath” != “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“Path” ORDER BY “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E”.“ID”, “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E”.“Index”
-
Dec 1, 2019 8:24 AM: Starting - ScanForExistingSourceBlocksFast
-
Dec 1, 2019 8:24 AM: ScanForExistingTargetBlocks took 0:00:00:00.012
-
Dec 1, 2019 8:24 AM: CommitBlockMarker took 0:00:00:00.000
-
Dec 1, 2019 8:24 AM: Starting - CommitBlockMarker
-
Dec 1, 2019 8:24 AM: Target file does not exist: /source/training/MVI_3755.MOV
-
Dec 1, 2019 8:24 AM: Starting - ScanForExistingTargetBlocks
-
Dec 1, 2019 8:24 AM: CreateDirectory took 0:00:00:00.001
-
Dec 1, 2019 8:24 AM: ExecuteReader: SELECT “TargetPath” FROM “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E” WHERE “BlocksetID” == -100 took 0:00:00:00.000
-
Dec 1, 2019 8:24 AM: Starting - ExecuteReader: SELECT “TargetPath” FROM “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E” WHERE “BlocksetID” == -100
-
Dec 1, 2019 8:24 AM: Starting - CreateDirectory
-
Dec 1, 2019 8:24 AM: PrepareBlockList took 0:00:00:00.035
-
Dec 1, 2019 8:24 AM: CreateProgressTracker took 0:00:00:00.003
-
Dec 1, 2019 8:24 AM: ExecuteNonQuery: CREATE TEMPORARY TRIGGER “UpdateTotalStats_FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” AFTER UPDATE ON “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” BEGIN UPDATE “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” SET “FilesFullyRestored” = “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“FilesFullyRestored” + (CASE WHEN NEW.“BlocksRestored” = NEW.“TotalBlocks” THEN 1 ELSE 0 END) - (CASE WHEN OLD.“BlocksRestored” = OLD.“TotalBlocks” THEN 1 ELSE 0 END) , “FilesPartiallyRestored” = “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“FilesPartiallyRestored” + (CASE WHEN NEW.“BlocksRestored” BETWEEN 1 AND NEW.“TotalBlocks” - 1 THEN 1 ELSE 0 END) - (CASE WHEN OLD.“BlocksRestored” BETWEEN 1 AND OLD.“TotalBlocks” - 1 THEN 1 ELSE 0 END) , “BlocksRestored” = “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“BlocksRestored” + NEW.“BlocksRestored” - OLD.“BlocksRestored” , “SizeRestored” = “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“SizeRestored” + NEW.“SizeRestored” - OLD.“SizeRestored” ; END took 0:00:00:00.000
-
Dec 1, 2019 8:24 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TRIGGER “UpdateTotalStats_FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” AFTER UPDATE ON “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” BEGIN UPDATE “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” SET “FilesFullyRestored” = “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“FilesFullyRestored” + (CASE WHEN NEW.“BlocksRestored” = NEW.“TotalBlocks” THEN 1 ELSE 0 END) - (CASE WHEN OLD.“BlocksRestored” = OLD.“TotalBlocks” THEN 1 ELSE 0 END) , “FilesPartiallyRestored” = “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“FilesPartiallyRestored” + (CASE WHEN NEW.“BlocksRestored” BETWEEN 1 AND NEW.“TotalBlocks” - 1 THEN 1 ELSE 0 END) - (CASE WHEN OLD.“BlocksRestored” BETWEEN 1 AND OLD.“TotalBlocks” - 1 THEN 1 ELSE 0 END) , “BlocksRestored” = “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“BlocksRestored” + NEW.“BlocksRestored” - OLD.“BlocksRestored” , “SizeRestored” = “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“SizeRestored” + NEW.“SizeRestored” - OLD.“SizeRestored” ; END
-
Dec 1, 2019 8:24 AM: ExecuteNonQuery: CREATE TEMPORARY TRIGGER “TrackRestoredBlocks_Blocks-5A7A6131EF8B684FA75D571A2EF91A2E” AFTER UPDATE OF “Restored” ON “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E” WHEN OLD.“Restored” != NEW.“Restored” AND NEW.“Metadata” = 0 BEGIN UPDATE “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” SET “BlocksRestored” = “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“BlocksRestored” + (NEW.“Restored” - OLD.“Restored”) , “SizeRestored” = “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“SizeRestored” + ((NEW.“Restored” - OLD.“Restored”) * NEW.Size) WHERE “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“FileId” = NEW.“FileID” ; END took 0:00:00:00.000
-
Dec 1, 2019 8:24 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TRIGGER “TrackRestoredBlocks_Blocks-5A7A6131EF8B684FA75D571A2EF91A2E” AFTER UPDATE OF “Restored” ON “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E” WHEN OLD.“Restored” != NEW.“Restored” AND NEW.“Metadata” = 0 BEGIN UPDATE “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” SET “BlocksRestored” = “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“BlocksRestored” + (NEW.“Restored” - OLD.“Restored”) , “SizeRestored” = “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“SizeRestored” + ((NEW.“Restored” - OLD.“Restored”) * NEW.Size) WHERE “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A”.“FileId” = NEW.“FileID” ; END
-
Dec 1, 2019 8:24 AM: ExecuteNonQuery: INSERT INTO “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” ( “TotalFiles”, “TotalBlocks”, “TotalSize” , “FilesFullyRestored”, “FilesPartiallyRestored”, “BlocksRestored”, “SizeRestored” ) SELECT IFNULL(COUNT(“P”.“FileId”), 0), IFNULL(SUM(“P”.“TotalBlocks”), 0), IFNULL(SUM(“P”.“TotalSize”), 0) , IFNULL(COUNT(CASE WHEN “P”.“BlocksRestored” = “P”.“TotalBlocks” THEN 1 ELSE NULL END), 0) , IFNULL(COUNT(CASE WHEN “P”.“BlocksRestored” BETWEEN 1 AND “P”.“TotalBlocks” - 1 THEN 1 ELSE NULL END), 0) , IFNULL(SUM(“P”.“BlocksRestored”), 0), IFNULL(SUM(“P”.“SizeRestored”), 0) FROM “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” “P” took 0:00:00:00.000
-
Dec 1, 2019 8:24 AM: Starting - ExecuteNonQuery: INSERT INTO “TotalProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” ( “TotalFiles”, “TotalBlocks”, “TotalSize” , “FilesFullyRestored”, “FilesPartiallyRestored”, “BlocksRestored”, “SizeRestored” ) SELECT IFNULL(COUNT(“P”.“FileId”), 0), IFNULL(SUM(“P”.“TotalBlocks”), 0), IFNULL(SUM(“P”.“TotalSize”), 0) , IFNULL(COUNT(CASE WHEN “P”.“BlocksRestored” = “P”.“TotalBlocks” THEN 1 ELSE NULL END), 0) , IFNULL(COUNT(CASE WHEN “P”.“BlocksRestored” BETWEEN 1 AND “P”.“TotalBlocks” - 1 THEN 1 ELSE NULL END), 0) , IFNULL(SUM(“P”.“BlocksRestored”), 0), IFNULL(SUM(“P”.“SizeRestored”), 0) FROM “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” “P”
-
Dec 1, 2019 8:24 AM: ExecuteNonQuery: INSERT INTO “FileProgress-B99D6C44AAA84841A0DFD65F8FE4BC4A” (“FileId”, “TotalBlocks”, “TotalSize”, “BlocksRestored”, “SizeRestored”) SELECT “F”.“ID”, IFNULL(COUNT(“B”.“ID”), 0), IFNULL(SUM(“B”.“Size”), 0) , IFNULL(COUNT(CASE “B”.“Restored” WHEN 1 THEN “B”.“ID” ELSE NULL END), 0) , IFNULL(SUM(CASE “B”.“Restored” WHEN 1 THEN “B”.“Size” ELSE 0 END), 0) FROM “Fileset-5A7A6131EF8B684FA75D571A2EF91A2E” “F” LEFT JOIN “Blocks-5A7A6131EF8B684FA75D571A2EF91A2E” “B” ON “B”.“FileID” = “F”.“ID” WHERE “B”.“Metadata” IS NOT 1 GROUP BY “F”.“ID” took 0:00:00:00.000