API tools faq
paste
Advertisement
Guest User

Duplicatilog

a guest
Mar 8th, 2018
168
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.27 KB | None | 0 0
raw download clone embed print report
  1.  
  2. Mar 8, 2018 2:12 AM: Running Backup took 02:50:21.967
  3. Mar 8, 2018 2:12 AM: ExecuteNonQuery: DELETE FROM "RemoteOperation" WHERE "Timestamp" < ? took 00:00:07.842
  4. Mar 8, 2018 2:12 AM: Starting - ExecuteNonQuery: DELETE FROM "RemoteOperation" WHERE "Timestamp" < ?
  5. Mar 8, 2018 2:12 AM: ExecuteNonQuery: DELETE FROM "LogData" WHERE "Timestamp" < ? took 00:00:00.135
  6. Mar 8, 2018 2:12 AM: Starting - ExecuteNonQuery: DELETE FROM "LogData" WHERE "Timestamp" < ?
  7. Mar 8, 2018 2:12 AM: ExecuteNonQuery: UPDATE "RemoteVolume" SET "VerificationCount" = MAX(1, CASE WHEN "VerificationCount" <= 0 THEN (SELECT MAX("VerificationCount") FROM "RemoteVolume") ELSE "VerificationCount" + 1 END) WHERE "Name" = ? took 00:00:00.849
  8. Mar 8, 2018 2:12 AM: Starting - ExecuteNonQuery: UPDATE "RemoteVolume" SET "VerificationCount" = MAX(1, CASE WHEN "VerificationCount" <= 0 THEN (SELECT MAX("VerificationCount") FROM "RemoteVolume") ELSE "VerificationCount" + 1 END) WHERE "Name" = ?
  9. Mar 8, 2018 2:12 AM: RemoteOperationGet took 00:00:25.095
  10. Mar 8, 2018 2:12 AM: Backend event: Get - Completed: duplicati-b500c6ac8ba3245b5a87dc626fc039a49.dblock.zip (49.90 MB)
  11. Mar 8, 2018 2:12 AM: Downloaded 49.90 MB in 00:00:25.0289530, 1.99 MB/s
  12. Mar 8, 2018 2:12 AM: Backend event: Get - Started: duplicati-b500c6ac8ba3245b5a87dc626fc039a49.dblock.zip (49.90 MB)
  13. Mar 8, 2018 2:12 AM: Starting - RemoteOperationGet
  14. Mar 8, 2018 2:12 AM: ExecuteNonQuery: UPDATE "RemoteVolume" SET "VerificationCount" = MAX(1, CASE WHEN "VerificationCount" <= 0 THEN (SELECT MAX("VerificationCount") FROM "RemoteVolume") ELSE "VerificationCount" + 1 END) WHERE "Name" = ? took 00:00:00.114
  15. Mar 8, 2018 2:12 AM: Starting - ExecuteNonQuery: UPDATE "RemoteVolume" SET "VerificationCount" = MAX(1, CASE WHEN "VerificationCount" <= 0 THEN (SELECT MAX("VerificationCount") FROM "RemoteVolume") ELSE "VerificationCount" + 1 END) WHERE "Name" = ?
  16. Mar 8, 2018 2:12 AM: RemoteOperationGet took 00:00:00.051
  17. Mar 8, 2018 2:12 AM: Backend event: Get - Completed: duplicati-i923d8a46b4df4727aa1b449c7c72ae12.dindex.zip (40.91 KB)
  18. Mar 8, 2018 2:12 AM: Downloaded 40.91 KB in 00:00:00.0500600, 817.14 KB/s
  19. Mar 8, 2018 2:12 AM: Backend event: Get - Started: duplicati-i923d8a46b4df4727aa1b449c7c72ae12.dindex.zip (40.91 KB)
  20. Mar 8, 2018 2:12 AM: Starting - RemoteOperationGet
  21. Mar 8, 2018 2:12 AM: ExecuteNonQuery: UPDATE "RemoteVolume" SET "VerificationCount" = MAX(1, CASE WHEN "VerificationCount" <= 0 THEN (SELECT MAX("VerificationCount") FROM "RemoteVolume") ELSE "VerificationCount" + 1 END) WHERE "Name" = ? took 00:00:00.140
  22. Mar 8, 2018 2:12 AM: Starting - ExecuteNonQuery: UPDATE "RemoteVolume" SET "VerificationCount" = MAX(1, CASE WHEN "VerificationCount" <= 0 THEN (SELECT MAX("VerificationCount") FROM "RemoteVolume") ELSE "VerificationCount" + 1 END) WHERE "Name" = ?
  23. Mar 8, 2018 2:12 AM: RemoteOperationGet took 00:00:11.036
  24. Mar 8, 2018 2:12 AM: Backend event: Get - Completed: duplicati-20180307T222224Z.dlist.zip (23.30 MB)
  25. Mar 8, 2018 2:12 AM: Downloaded 23.30 MB in 00:00:11.0222130, 2.11 MB/s
  26. Mar 8, 2018 2:12 AM: Backend event: Get - Started: duplicati-20180307T222224Z.dlist.zip (23.30 MB)
  27. Mar 8, 2018 2:12 AM: Starting - RemoteOperationGet
  28. Mar 8, 2018 2:12 AM: ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "Type" = ? AND "State" IN (?, ?) took 00:00:00.000
  29. Mar 8, 2018 2:12 AM: Starting - ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "Type" = ? AND "State" IN (?, ?)
  30. Mar 8, 2018 2:11 AM: ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "Type" = ? AND "State" IN (?, ?) took 00:00:00.000
  31. Mar 8, 2018 2:11 AM: Starting - ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "Type" = ? AND "State" IN (?, ?)
  32. Mar 8, 2018 2:11 AM: ExecuteReader: SELECT "A"."VolumeID", "A"."Name", "A"."Size", "A"."Hash", "A"."VerificationCount" FROM (SELECT "ID" AS "VolumeID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "State" IN (?, ?)) A, "Fileset" WHERE "A"."VolumeID" = "Fileset"."VolumeID" ORDER BY "Fileset"."Timestamp" took 00:00:00.000
  33. Mar 8, 2018 2:11 AM: Starting - ExecuteReader: SELECT "A"."VolumeID", "A"."Name", "A"."Size", "A"."Hash", "A"."VerificationCount" FROM (SELECT "ID" AS "VolumeID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "State" IN (?, ?)) A, "Fileset" WHERE "A"."VolumeID" = "Fileset"."VolumeID" ORDER BY "Fileset"."Timestamp"
  34. Mar 8, 2018 2:11 AM: ExecuteScalarInt64: SELECT MAX("VerificationCount") FROM "RemoteVolume" took 00:00:00.027
  35. Mar 8, 2018 2:11 AM: Starting - ExecuteScalarInt64: SELECT MAX("VerificationCount") FROM "RemoteVolume"
  36. Mar 8, 2018 2:11 AM: ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE ("State" = ? OR "State" = ?) AND ("Hash" = "" OR "Hash" IS NULL OR "Size" <= 0) took 00:00:00.040
  37. Mar 8, 2018 2:11 AM: Starting - ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE ("State" = ? OR "State" = ?) AND ("Hash" = "" OR "Hash" IS NULL OR "Size" <= 0)
  38. Mar 8, 2018 2:11 AM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 00:00:00.000
  39. Mar 8, 2018 2:11 AM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
  40. Mar 8, 2018 2:11 AM: RemoteOperationTerminate took 00:00:00.000
  41. Mar 8, 2018 2:11 AM: Starting - RemoteOperationTerminate
  42. Mar 8, 2018 2:11 AM: AfterBackupVerify took 00:00:30.799
  43. Mar 8, 2018 2:11 AM: ExecuteReader: SELECT DISTINCT "Name", "State" FROM "Remotevolume" WHERE "Name" IN (SELECT "Name" FROM "Remotevolume" WHERE "State" IN ("Deleted", "Deleting")) AND NOT "State" IN ("Deleted", "Deleting") took 00:00:06.386
  44. Mar 8, 2018 2:11 AM: Starting - ExecuteReader: SELECT DISTINCT "Name", "State" FROM "Remotevolume" WHERE "Name" IN (SELECT "Name" FROM "Remotevolume" WHERE "State" IN ("Deleted", "Deleting")) AND NOT "State" IN ("Deleted", "Deleting")
  45. Mar 8, 2018 2:11 AM: RemoteOperationList took 00:00:20.916
  46. Mar 8, 2018 2:11 AM: Backend event: List - Completed: (15.26 KB)
  47. Mar 8, 2018 2:11 AM: Backend event: List - Started: ()
  48. Mar 8, 2018 2:11 AM: Starting - RemoteOperationList
  49. Mar 8, 2018 2:11 AM: Starting - AfterBackupVerify
  50. Mar 8, 2018 2:11 AM: CommitFinalizingBackup took 00:00:00.302
  51. Mar 8, 2018 2:11 AM: Starting - CommitFinalizingBackup
  52. Mar 8, 2018 2:11 AM: Async backend wait took 00:00:00.000
  53. Mar 8, 2018 2:11 AM: RemoteOperationTerminate took 00:00:00.000
  54. Mar 8, 2018 2:11 AM: Starting - RemoteOperationTerminate
  55. Mar 8, 2018 2:11 AM: Starting - Async backend wait
  56. Mar 8, 2018 2:11 AM: Compacting not required
  57. Mar 8, 2018 2:11 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "UsageReport-4525653DC338444AAF670676DD94C05A" took 00:00:00.029
  58. Mar 8, 2018 2:11 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "UsageReport-4525653DC338444AAF670676DD94C05A"
  59. Mar 8, 2018 2:11 AM: ExecuteReader: SELECT "A"."Name", "B"."ActiveSize", "B"."InactiveSize", "A"."Size" FROM "Remotevolume" A, "UsageReport-4525653DC338444AAF670676DD94C05A" B WHERE "A"."ID" = "B"."VolumeID" ORDER BY "B"."Sorttime" ASC took 00:00:00.100
  60. Mar 8, 2018 2:11 AM: Starting - ExecuteReader: SELECT "A"."Name", "B"."ActiveSize", "B"."InactiveSize", "A"."Size" FROM "Remotevolume" A, "UsageReport-4525653DC338444AAF670676DD94C05A" B WHERE "A"."ID" = "B"."VolumeID" ORDER BY "B"."Sorttime" ASC
  61. Mar 8, 2018 2:11 AM: ExecuteNonQuery: CREATE TEMPORARY TABLE "UsageReport-4525653DC338444AAF670676DD94C05A" AS SELECT "VolumeID" AS "VolumeID", SUM("ActiveSize") AS "ActiveSize", SUM("InactiveSize") AS "InactiveSize", MAX("Sortime") AS "Sorttime" FROM (SELECT "A"."ActiveSize" AS "ActiveSize", 0 AS "InactiveSize", "A"."VolumeID" AS "VolumeID", CASE WHEN "B"."Sorttime" IS NULL THEN 0 ELSE "B"."Sorttime" END AS "Sorttime" FROM (SELECT SUM("Block"."Size") AS "ActiveSize", "Block"."VolumeID" AS "VolumeID" FROM "Block", "Remotevolume" WHERE "Block"."VolumeID" = "Remotevolume"."ID" AND "Block"."ID" NOT IN (SELECT "Block"."ID" FROM "Block","DeletedBlock" WHERE "Block"."Hash" = "DeletedBlock"."Hash" AND "Block"."Size" = "DeletedBlock"."Size") GROUP BY "Block"."VolumeID" ) A LEFT OUTER JOIN (SELECT "VolumeID" AS "VolumeID", MIN("Sorttime") AS "Sorttime" FROM (SELECT "Block"."VolumeID" AS "VolumeID", "Fileset"."Timestamp" AS "Sorttime" FROM "Fileset", "FilesetEntry", "File", "BlocksetEntry", "Block" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "File"."BlocksetID" = "BlocksetEntry"."BlocksetID" AND "BlocksetEntry"."BlockID" = "Block"."ID" AND "Fileset"."ID" = "FilesetEntry"."FilesetID" UNION SELECT "Block"."VolumeID" AS "VolumeID", "Fileset"."Timestamp" AS "Sorttime" FROM "Fileset", "FilesetEntry", "File", "BlocksetEntry", "Block", "Metadataset" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "File"."MetadataID" = "Metadataset"."ID" AND "Metadataset"."BlocksetID" = "BlocksetEntry"."BlocksetID" AND "BlocksetEntry"."BlockID" = "Block"."ID" AND "Fileset"."ID" = "FilesetEntry"."FilesetID" ) GROUP BY "VolumeID" ) B ON "B"."VolumeID" = "A"."VolumeID" UNION SELECT 0 AS "ActiveSize", SUM("Size") AS "InactiveSize", "VolumeID" AS "VolumeID", 0 AS "SortScantime" FROM "DeletedBlock" GROUP BY "VolumeID" UNION SELECT 0 AS "ActiveSize", 0 AS "InactiveSize", "Remotevolume"."ID" AS "VolumeID", 0 AS "SortScantime" FROM "Remotevolume" WHERE "Remotevolume"."Type" = ? AND "Remotevolume"."State" IN (?, ?) AND "Remotevolume"."ID" NOT IN (SELECT "VolumeID" FROM "Block") ) GROUP BY "VolumeID" took 00:04:36.196
  62. Mar 8, 2018 2:06 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "UsageReport-4525653DC338444AAF670676DD94C05A" AS SELECT "VolumeID" AS "VolumeID", SUM("ActiveSize") AS "ActiveSize", SUM("InactiveSize") AS "InactiveSize", MAX("Sortime") AS "Sorttime" FROM (SELECT "A"."ActiveSize" AS "ActiveSize", 0 AS "InactiveSize", "A"."VolumeID" AS "VolumeID", CASE WHEN "B"."Sorttime" IS NULL THEN 0 ELSE "B"."Sorttime" END AS "Sorttime" FROM (SELECT SUM("Block"."Size") AS "ActiveSize", "Block"."VolumeID" AS "VolumeID" FROM "Block", "Remotevolume" WHERE "Block"."VolumeID" = "Remotevolume"."ID" AND "Block"."ID" NOT IN (SELECT "Block"."ID" FROM "Block","DeletedBlock" WHERE "Block"."Hash" = "DeletedBlock"."Hash" AND "Block"."Size" = "DeletedBlock"."Size") GROUP BY "Block"."VolumeID" ) A LEFT OUTER JOIN (SELECT "VolumeID" AS "VolumeID", MIN("Sorttime") AS "Sorttime" FROM (SELECT "Block"."VolumeID" AS "VolumeID", "Fileset"."Timestamp" AS "Sorttime" FROM "Fileset", "FilesetEntry", "File", "BlocksetEntry", "Block" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "File"."BlocksetID" = "BlocksetEntry"."BlocksetID" AND "BlocksetEntry"."BlockID" = "Block"."ID" AND "Fileset"."ID" = "FilesetEntry"."FilesetID" UNION SELECT "Block"."VolumeID" AS "VolumeID", "Fileset"."Timestamp" AS "Sorttime" FROM "Fileset", "FilesetEntry", "File", "BlocksetEntry", "Block", "Metadataset" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "File"."MetadataID" = "Metadataset"."ID" AND "Metadataset"."BlocksetID" = "BlocksetEntry"."BlocksetID" AND "BlocksetEntry"."BlockID" = "Block"."ID" AND "Fileset"."ID" = "FilesetEntry"."FilesetID" ) GROUP BY "VolumeID" ) B ON "B"."VolumeID" = "A"."VolumeID" UNION SELECT 0 AS "ActiveSize", SUM("Size") AS "InactiveSize", "VolumeID" AS "VolumeID", 0 AS "SortScantime" FROM "DeletedBlock" GROUP BY "VolumeID" UNION SELECT 0 AS "ActiveSize", 0 AS "InactiveSize", "Remotevolume"."ID" AS "VolumeID", 0 AS "SortScantime" FROM "Remotevolume" WHERE "Remotevolume"."Type" = ? AND "Remotevolume"."State" IN (?, ?) AND "Remotevolume"."ID" NOT IN (SELECT "VolumeID" FROM "Block") ) GROUP BY "VolumeID"
  63. Mar 8, 2018 2:06 AM: No remote filesets were deleted
  64. Mar 8, 2018 2:06 AM: RemoteOperationNothing took 00:00:00.000
  65. Mar 8, 2018 2:06 AM: Starting - RemoteOperationNothing
  66. Mar 8, 2018 2:06 AM: ExecuteReader: SELECT "Name", "Size" FROM "RemoteVolume" WHERE "Type" = ? AND "State" = ? took 00:00:00.110
  67. Mar 8, 2018 2:06 AM: Starting - ExecuteReader: SELECT "Name", "Size" FROM "RemoteVolume" WHERE "Type" = ? AND "State" = ?
  68. Mar 8, 2018 2:06 AM: ExecuteNonQuery: UPDATE "RemoteVolume" SET "State" = ? WHERE "Type" = ? AND "State" IN (?, ?) AND "ID" NOT IN (SELECT "VolumeID" FROM "Fileset") took 00:00:08.908
  69. Mar 8, 2018 2:06 AM: Starting - ExecuteNonQuery: UPDATE "RemoteVolume" SET "State" = ? WHERE "Type" = ? AND "State" IN (?, ?) AND "ID" NOT IN (SELECT "VolumeID" FROM "Fileset")
  70. Mar 8, 2018 2:06 AM: ExecuteNonQuery: DELETE FROM "Block" WHERE "ID" NOT IN (SELECT DISTINCT "BlockID" FROM "BlocksetEntry" UNION SELECT DISTINCT "ID" FROM "Block", "BlocklistHash" WHERE "Block"."Hash" = "BlocklistHash"."Hash") took 00:41:24.450
  71. Mar 8, 2018 1:25 AM: Starting - ExecuteNonQuery: DELETE FROM "Block" WHERE "ID" NOT IN (SELECT DISTINCT "BlockID" FROM "BlocksetEntry" UNION SELECT DISTINCT "ID" FROM "Block", "BlocklistHash" WHERE "Block"."Hash" = "BlocklistHash"."Hash")
  72. Mar 8, 2018 1:25 AM: ExecuteNonQuery: INSERT INTO "DeletedBlock" ("Hash", "Size", "VolumeID") SELECT "Hash", "Size", "VolumeID" FROM "Block" WHERE "ID" NOT IN (SELECT DISTINCT "BlockID" AS "BlockID" FROM "BlocksetEntry" UNION SELECT DISTINCT "ID" FROM "Block", "BlocklistHash" WHERE "Block"."Hash" = "BlocklistHash"."Hash") took 00:41:11.000
  73. Mar 8, 2018 12:44 AM: Starting - ExecuteNonQuery: INSERT INTO "DeletedBlock" ("Hash", "Size", "VolumeID") SELECT "Hash", "Size", "VolumeID" FROM "Block" WHERE "ID" NOT IN (SELECT DISTINCT "BlockID" AS "BlockID" FROM "BlocksetEntry" UNION SELECT DISTINCT "ID" FROM "Block", "BlocklistHash" WHERE "Block"."Hash" = "BlocklistHash"."Hash")
  74. Mar 8, 2018 12:44 AM: ExecuteNonQuery: DELETE FROM "BlocklistHash" WHERE "BlocksetID" NOT IN (SELECT DISTINCT "ID" FROM "Blockset") took 00:00:18.282
  75. Mar 8, 2018 12:43 AM: Starting - ExecuteNonQuery: DELETE FROM "BlocklistHash" WHERE "BlocksetID" NOT IN (SELECT DISTINCT "ID" FROM "Blockset")
  76. Mar 8, 2018 12:43 AM: ExecuteNonQuery: DELETE FROM "BlocksetEntry" WHERE "BlocksetID" NOT IN (SELECT DISTINCT "ID" FROM "Blockset") took 00:00:32.183
  77. Mar 8, 2018 12:43 AM: Starting - ExecuteNonQuery: DELETE FROM "BlocksetEntry" WHERE "BlocksetID" NOT IN (SELECT DISTINCT "ID" FROM "Blockset")
  78. Mar 8, 2018 12:43 AM: ExecuteNonQuery: DELETE FROM "Blockset" WHERE "ID" NOT IN (SELECT DISTINCT "BlocksetID" FROM "File" UNION SELECT DISTINCT "BlocksetID" FROM "Metadataset") took 00:00:24.938
  79. Mar 8, 2018 12:42 AM: Starting - ExecuteNonQuery: DELETE FROM "Blockset" WHERE "ID" NOT IN (SELECT DISTINCT "BlocksetID" FROM "File" UNION SELECT DISTINCT "BlocksetID" FROM "Metadataset")
  80. Mar 8, 2018 12:42 AM: ExecuteNonQuery: DELETE FROM "Metadataset" WHERE "ID" NOT IN (SELECT DISTINCT "MetadataID" FROM "File") took 00:00:14.025
  81. Mar 8, 2018 12:42 AM: Starting - ExecuteNonQuery: DELETE FROM "Metadataset" WHERE "ID" NOT IN (SELECT DISTINCT "MetadataID" FROM "File")
  82. Mar 8, 2018 12:42 AM: ExecuteNonQuery: DELETE FROM "File" WHERE "ID" NOT IN (SELECT DISTINCT "FileID" FROM "FilesetEntry") took 00:00:11.751
  83. Mar 8, 2018 12:42 AM: Starting - ExecuteNonQuery: DELETE FROM "File" WHERE "ID" NOT IN (SELECT DISTINCT "FileID" FROM "FilesetEntry")
  84. Mar 8, 2018 12:42 AM: ExecuteNonQuery: DELETE FROM "FilesetEntry" WHERE "FilesetID" NOT IN (SELECT DISTINCT "ID" FROM "Fileset") took 00:00:06.628
  85. Mar 8, 2018 12:42 AM: Starting - ExecuteNonQuery: DELETE FROM "FilesetEntry" WHERE "FilesetID" NOT IN (SELECT DISTINCT "ID" FROM "Fileset")
  86. Mar 8, 2018 12:42 AM: ExecuteNonQuery: DELETE FROM "Fileset" WHERE "Timestamp" IN () took 00:00:00.000
  87. Mar 8, 2018 12:42 AM: Starting - ExecuteNonQuery: DELETE FROM "Fileset" WHERE "Timestamp" IN ()
  88. Mar 8, 2018 12:42 AM: [Retention Policy]: All backups to delete:
  89. Mar 8, 2018 12:42 AM: [Retention Policy]: Backups outside of all time frames and thus getting deleted:
  90. Mar 8, 2018 12:42 AM: [Retention Policy]: Backups in this time frame:
  91. Mar 8, 2018 12:42 AM: [Retention Policy]: Next time frame and interval pair: 365.00:00:00 / 31.00:00:00
  92. Mar 8, 2018 12:42 AM: [Retention Policy]: Keeping backup: 02/27/2018 21:29:50
  93. Mar 8, 2018 12:42 AM: [Retention Policy]: Backups in this time frame: 02/27/2018 21:29:50
  94. Mar 8, 2018 12:42 AM: [Retention Policy]: Next time frame and interval pair: 28.00:00:00 / 7.00:00:00
  95. Mar 8, 2018 12:42 AM: [Retention Policy]: Keeping backup: 03/06/2018 18:30:00
  96. Mar 8, 2018 12:42 AM: [Retention Policy]: Keeping backup: 03/04/2018 18:30:14
  97. Mar 8, 2018 12:42 AM: [Retention Policy]: Keeping backup: 03/03/2018 16:29:27
  98. Mar 8, 2018 12:42 AM: [Retention Policy]: Keeping backup: 03/01/2018 14:01:00
  99. Mar 8, 2018 12:42 AM: [Retention Policy]: Backups in this time frame: 03/01/2018 14:01:00, 03/03/2018 16:29:27, 03/04/2018 18:30:14, 03/06/2018 18:30:00
  100. Mar 8, 2018 12:42 AM: [Retention Policy]: Next time frame and interval pair: 7.00:00:00 / 1.00:00:00
  101. Mar 8, 2018 12:42 AM: [Retention Policy]: Backups to consider: 03/06/2018 18:30:00, 03/04/2018 18:30:14, 03/03/2018 16:29:27, 03/01/2018 14:01:00, 02/27/2018 21:29:50
  102. Mar 8, 2018 12:42 AM: [Retention Policy]: Time frames and intervals pairs: 7.00:00:00 / 1.00:00:00, 28.00:00:00 / 7.00:00:00, 365.00:00:00 / 31.00:00:00
  103. Mar 8, 2018 12:42 AM: [Retention Policy]: Start checking if backups can be removed
  104. Mar 8, 2018 12:42 AM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 00:00:00.000
  105. Mar 8, 2018 12:42 AM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
  106. Mar 8, 2018 12:42 AM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 00:00:00.000
  107. Mar 8, 2018 12:42 AM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
  108. Mar 8, 2018 12:42 AM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 00:00:00.000
  109. Mar 8, 2018 12:42 AM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
  110. Mar 8, 2018 12:42 AM: Async backend wait took 00:00:18.238
  111. Mar 8, 2018 12:42 AM: RemoteOperationNothing took 00:00:00.000
  112. Mar 8, 2018 12:42 AM: Starting - RemoteOperationNothing
  113. Mar 8, 2018 12:42 AM: RemoteOperationPut took 00:00:18.685
  114. Mar 8, 2018 12:42 AM: Backend event: Put - Completed: duplicati-20180307T222224Z.dlist.zip (23.30 MB)
  115. Mar 8, 2018 12:42 AM: Uploaded 23.30 MB in 00:00:18.6534840, 1.25 MB/s
  116. Mar 8, 2018 12:41 AM: Starting - Async backend wait
  117. Mar 8, 2018 12:41 AM: Uploading a new fileset took 00:01:39.561
  118. Mar 8, 2018 12:41 AM: CommitUpdateRemoteVolume took 00:00:00.446
  119. Mar 8, 2018 12:41 AM: Backend event: Put - Started: duplicati-20180307T222224Z.dlist.zip (23.30 MB)
  120. Mar 8, 2018 12:41 AM: Starting - RemoteOperationPut
  121. Mar 8, 2018 12:41 AM: Starting - CommitUpdateRemoteVolume
  122. Mar 8, 2018 12:41 AM: CommitUpdateRemoteVolume took 00:00:01.213
  123. Mar 8, 2018 12:41 AM: Starting - CommitUpdateRemoteVolume
  124. Mar 8, 2018 12:40 AM: Starting - Uploading a new fileset
  125. Mar 8, 2018 12:40 AM: VerifyConsistency took 00:01:29.119
  126. Mar 8, 2018 12:40 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "File" WHERE "BlocksetID" != ? AND "BlocksetID" != ? AND NOT "BlocksetID" IN (SELECT "BlocksetID" FROM "BlocksetEntry") took 00:00:11.052
  127. Mar 8, 2018 12:40 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "File" WHERE "BlocksetID" != ? AND "BlocksetID" != ? AND NOT "BlocksetID" IN (SELECT "BlocksetID" FROM "BlocksetEntry")
  128. Mar 8, 2018 12:40 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM (SELECT * FROM (SELECT "N"."BlocksetID", (("N"."BlockCount" + 3200 - 1) / 3200) AS "BlocklistHashCountExpected", CASE WHEN "G"."BlocklistHashCount" IS NULL THEN 0 ELSE "G"."BlocklistHashCount" END AS "BlocklistHashCountActual" FROM (SELECT "BlocksetID", COUNT(*) AS "BlockCount" FROM "BlocksetEntry" GROUP BY "BlocksetID") "N" LEFT OUTER JOIN (SELECT "BlocksetID", COUNT(*) AS "BlocklistHashCount" FROM "BlocklistHash" GROUP BY "BlocksetID") "G" ON "N"."BlocksetID" = "G"."BlocksetID" WHERE "N"."BlockCount" > 1) WHERE "BlocklistHashCountExpected" != "BlocklistHashCountActual") took 00:00:23.485
  129. Mar 8, 2018 12:39 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM (SELECT * FROM (SELECT "N"."BlocksetID", (("N"."BlockCount" + 3200 - 1) / 3200) AS "BlocklistHashCountExpected", CASE WHEN "G"."BlocklistHashCount" IS NULL THEN 0 ELSE "G"."BlocklistHashCount" END AS "BlocklistHashCountActual" FROM (SELECT "BlocksetID", COUNT(*) AS "BlockCount" FROM "BlocksetEntry" GROUP BY "BlocksetID") "N" LEFT OUTER JOIN (SELECT "BlocksetID", COUNT(*) AS "BlocklistHashCount" FROM "BlocklistHash" GROUP BY "BlocksetID") "G" ON "N"."BlocksetID" = "G"."BlocksetID" WHERE "N"."BlockCount" > 1) WHERE "BlocklistHashCountExpected" != "BlocklistHashCountActual")
  130. Mar 8, 2018 12:39 AM: ExecuteScalarInt64: SELECT Count(*) FROM (SELECT DISTINCT "BlocksetID", "Index" FROM "BlocklistHash") took 00:00:00.078
  131. Mar 8, 2018 12:39 AM: Starting - ExecuteScalarInt64: SELECT Count(*) FROM (SELECT DISTINCT "BlocksetID", "Index" FROM "BlocklistHash")
  132. Mar 8, 2018 12:39 AM: ExecuteScalarInt64: SELECT Count(*) FROM "BlocklistHash" took 00:00:07.724
  133. Mar 8, 2018 12:39 AM: Starting - ExecuteScalarInt64: SELECT Count(*) FROM "BlocklistHash"
  134. Mar 8, 2018 12:39 AM: ExecuteReader: SELECT "CalcLen", "Length", "A"."BlocksetID", "File"."Path" FROM ( SELECT "A"."ID" AS "BlocksetID", IFNULL("B"."CalcLen", 0) AS "CalcLen", "A"."Length" FROM "Blockset" A LEFT OUTER JOIN ( SELECT "BlocksetEntry"."BlocksetID", SUM("Block"."Size") AS "CalcLen" FROM "BlocksetEntry" LEFT OUTER JOIN "Block" ON "Block"."ID" = "BlocksetEntry"."BlockID" GROUP BY "BlocksetEntry"."BlocksetID" ) B ON "A"."ID" = "B"."BlocksetID" ) A, "File" WHERE "A"."BlocksetID" = "File"."BlocksetID" AND "A"."CalcLen" != "A"."Length" took 00:00:46.671
  135. Mar 8, 2018 12:38 AM: Starting - ExecuteReader: SELECT "CalcLen", "Length", "A"."BlocksetID", "File"."Path" FROM ( SELECT "A"."ID" AS "BlocksetID", IFNULL("B"."CalcLen", 0) AS "CalcLen", "A"."Length" FROM "Blockset" A LEFT OUTER JOIN ( SELECT "BlocksetEntry"."BlocksetID", SUM("Block"."Size") AS "CalcLen" FROM "BlocksetEntry" LEFT OUTER JOIN "Block" ON "Block"."ID" = "BlocksetEntry"."BlockID" GROUP BY "BlocksetEntry"."BlocksetID" ) B ON "A"."ID" = "B"."BlocksetID" ) A, "File" WHERE "A"."BlocksetID" = "File"."BlocksetID" AND "A"."CalcLen" != "A"."Length"
  136. Mar 8, 2018 12:38 AM: Starting - VerifyConsistency
  137. Mar 8, 2018 12:38 AM: UpdateChangeStatistics took 00:02:32.387
  138. Mar 8, 2018 12:38 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "TmpFileList-403959AD9A604647A8DEDAEBD4249A60"; took 00:00:00.570
  139. Mar 8, 2018 12:38 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "TmpFileList-403959AD9A604647A8DEDAEBD4249A60";
  140. Mar 8, 2018 12:38 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "TmpFileList-25C31EA5C37FA448878D248832855411"; took 00:00:00.433
  141. Mar 8, 2018 12:38 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "TmpFileList-25C31EA5C37FA448878D248832855411";
  142. Mar 8, 2018 12:38 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "TmpFileList-25C31EA5C37FA448878D248832855411" A, "TmpFileList-403959AD9A604647A8DEDAEBD4249A60" B WHERE "A"."Path" = "B"."Path" AND ("A"."Filehash" != "B"."Filehash" OR "A"."Metahash" != "B"."Metahash") took 00:00:16.040
  143. Mar 8, 2018 12:38 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "TmpFileList-25C31EA5C37FA448878D248832855411" A, "TmpFileList-403959AD9A604647A8DEDAEBD4249A60" B WHERE "A"."Path" = "B"."Path" AND ("A"."Filehash" != "B"."Filehash" OR "A"."Metahash" != "B"."Metahash")
  144. Mar 8, 2018 12:38 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "TmpFileList-25C31EA5C37FA448878D248832855411" WHERE "TmpFileList-25C31EA5C37FA448878D248832855411"."Path" NOT IN (SELECT "Path" FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ?) took 00:00:16.766
  145. Mar 8, 2018 12:38 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "TmpFileList-25C31EA5C37FA448878D248832855411" WHERE "TmpFileList-25C31EA5C37FA448878D248832855411"."Path" NOT IN (SELECT "Path" FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ?)
  146. Mar 8, 2018 12:38 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ? AND "File"."BlocksetID" != ? AND "File"."BlocksetID" != ? AND NOT "File"."Path" IN (SELECT "Path" FROM "TmpFileList-25C31EA5C37FA448878D248832855411") took 00:00:16.894
  147. Mar 8, 2018 12:38 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ? AND "File"."BlocksetID" != ? AND "File"."BlocksetID" != ? AND NOT "File"."Path" IN (SELECT "Path" FROM "TmpFileList-25C31EA5C37FA448878D248832855411")
  148. Mar 8, 2018 12:38 AM: ExecuteNonQuery: CREATE TEMPORARY TABLE "TmpFileList-403959AD9A604647A8DEDAEBD4249A60" AS SELECT "File"."Path", "A"."Fullhash" AS "Filehash", "B"."Fullhash" AS "Metahash" FROM "File", "FilesetEntry", "Blockset" A, "Blockset" B, "Metadataset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "A"."ID" = "File"."BlocksetID" AND "FilesetEntry"."FilesetID" = ? AND "File"."MetadataID" = "Metadataset"."ID" AND "Metadataset"."BlocksetID" = "B"."ID" took 00:00:16.884
  149. Mar 8, 2018 12:37 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "TmpFileList-403959AD9A604647A8DEDAEBD4249A60" AS SELECT "File"."Path", "A"."Fullhash" AS "Filehash", "B"."Fullhash" AS "Metahash" FROM "File", "FilesetEntry", "Blockset" A, "Blockset" B, "Metadataset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "A"."ID" = "File"."BlocksetID" AND "FilesetEntry"."FilesetID" = ? AND "File"."MetadataID" = "Metadataset"."ID" AND "Metadataset"."BlocksetID" = "B"."ID"
  150. Mar 8, 2018 12:37 AM: ExecuteNonQuery: CREATE TEMPORARY TABLE "TmpFileList-25C31EA5C37FA448878D248832855411" AS SELECT "File"."Path", "A"."Fullhash" AS "Filehash", "B"."Fullhash" AS "Metahash" FROM "File", "FilesetEntry", "Blockset" A, "Blockset" B, "Metadataset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "A"."ID" = "File"."BlocksetID" AND "FilesetEntry"."FilesetID" = ? AND "File"."MetadataID" = "Metadataset"."ID" AND "Metadataset"."BlocksetID" = "B"."ID" took 00:00:16.805
  151. Mar 8, 2018 12:37 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "TmpFileList-25C31EA5C37FA448878D248832855411" AS SELECT "File"."Path", "A"."Fullhash" AS "Filehash", "B"."Fullhash" AS "Metahash" FROM "File", "FilesetEntry", "Blockset" A, "Blockset" B, "Metadataset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "A"."ID" = "File"."BlocksetID" AND "FilesetEntry"."FilesetID" = ? AND "File"."MetadataID" = "Metadataset"."ID" AND "Metadataset"."BlocksetID" = "B"."ID"
  152. Mar 8, 2018 12:37 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM (SELECT "File"."Path", "Blockset"."Fullhash" FROM "File", "FilesetEntry", "Metadataset", "Blockset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "Metadataset"."ID" = "File"."MetadataID" AND "File"."BlocksetID" = ? AND "Metadataset"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FilesetID" = ? ) A, (SELECT "File"."Path", "Blockset"."Fullhash" FROM "File", "FilesetEntry", "Metadataset", "Blockset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "Metadataset"."ID" = "File"."MetadataID" AND "File"."BlocksetID" = ? AND "Metadataset"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FilesetID" = ? ) B WHERE "A"."Path" = "B"."Path" AND "A"."Fullhash" != "B"."Fullhash" took 00:00:00.000
  153. Mar 8, 2018 12:37 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM (SELECT "File"."Path", "Blockset"."Fullhash" FROM "File", "FilesetEntry", "Metadataset", "Blockset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "Metadataset"."ID" = "File"."MetadataID" AND "File"."BlocksetID" = ? AND "Metadataset"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FilesetID" = ? ) A, (SELECT "File"."Path", "Blockset"."Fullhash" FROM "File", "FilesetEntry", "Metadataset", "Blockset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "Metadataset"."ID" = "File"."MetadataID" AND "File"."BlocksetID" = ? AND "Metadataset"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FilesetID" = ? ) B WHERE "A"."Path" = "B"."Path" AND "A"."Fullhash" != "B"."Fullhash"
  154. Mar 8, 2018 12:37 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM (SELECT "File"."Path", "Blockset"."Fullhash" FROM "File", "FilesetEntry", "Metadataset", "Blockset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "Metadataset"."ID" = "File"."MetadataID" AND "File"."BlocksetID" = ? AND "Metadataset"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FilesetID" = ? ) A, (SELECT "File"."Path", "Blockset"."Fullhash" FROM "File", "FilesetEntry", "Metadataset", "Blockset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "Metadataset"."ID" = "File"."MetadataID" AND "File"."BlocksetID" = ? AND "Metadataset"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FilesetID" = ? ) B WHERE "A"."Path" = "B"."Path" AND "A"."Fullhash" != "B"."Fullhash" took 00:00:00.050
  155. Mar 8, 2018 12:37 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM (SELECT "File"."Path", "Blockset"."Fullhash" FROM "File", "FilesetEntry", "Metadataset", "Blockset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "Metadataset"."ID" = "File"."MetadataID" AND "File"."BlocksetID" = ? AND "Metadataset"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FilesetID" = ? ) A, (SELECT "File"."Path", "Blockset"."Fullhash" FROM "File", "FilesetEntry", "Metadataset", "Blockset" WHERE "File"."ID" = "FilesetEntry"."FileID" AND "Metadataset"."ID" = "File"."MetadataID" AND "File"."BlocksetID" = ? AND "Metadataset"."BlocksetID" = "Blockset"."ID" AND "FilesetEntry"."FilesetID" = ? ) B WHERE "A"."Path" = "B"."Path" AND "A"."Fullhash" != "B"."Fullhash"
  156. Mar 8, 2018 12:37 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ? AND "File"."BlocksetID" = ? AND NOT "File"."Path" IN (SELECT "Path" FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ?) took 00:00:08.160
  157. Mar 8, 2018 12:37 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ? AND "File"."BlocksetID" = ? AND NOT "File"."Path" IN (SELECT "Path" FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ?)
  158. Mar 8, 2018 12:37 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ? AND "File"."BlocksetID" = ? AND NOT "File"."Path" IN (SELECT "Path" FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ?) took 00:00:23.426
  159. Mar 8, 2018 12:36 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ? AND "File"."BlocksetID" = ? AND NOT "File"."Path" IN (SELECT "Path" FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ?)
  160. Mar 8, 2018 12:36 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ? AND "File"."BlocksetID" = ? AND NOT "File"."Path" IN (SELECT "Path" FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ?) took 00:00:08.807
  161. Mar 8, 2018 12:36 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ? AND "File"."BlocksetID" = ? AND NOT "File"."Path" IN (SELECT "Path" FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ?)
  162. Mar 8, 2018 12:36 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ? AND "File"."BlocksetID" = ? AND NOT "File"."Path" IN (SELECT "Path" FROM "File" INNER JOIN "FilesetEntry" ON "File"."ID" = "FilesetEntry"."FileID" WHERE "FilesetEntry"."FilesetID" = ?) took 00:00:27.542
  163. Mar 8, 2018 12:36 AM: RemoteOperationPut took 00:00:00.149
  164. Mar 8, 2018 12:36 AM: Backend event: Put - Completed: duplicati-i1a2943b896ce42b1a09338d31f675bfd.dindex.zip (1.39 KB)
  165. Mar 8, 2018 12:36 AM: Backend event: Put - Started: duplicati-i1a2943b896ce42b1a09338d31f675bfd.dindex.zip (1.39 KB)
  166. Mar 8, 2018 12:36 AM: Backend event: Put - Completed: duplicati-b685d126f652e4d72a76eb2902999a9d0.dblock.zip (66.85 KB)
  167. Mar 8, 2018 12:36 AM: Backend event: Put - Started: duplicati-b685d126f652e4d72a76eb2902999a9d0.dblock.zip (66.85 KB)
  168. Mar 8, 2018 12:28 AM: Skipped checking file, because timestamp was not updated /vol
  169. --- Missing a lot of "kipped checking file, because timestamp was not updated /vo...."
  170.  
  171. Mar 7, 2018 11:55 PM: Starting - ExecuteReader: SELECT "CalcLen", "Length", "A"."BlocksetID", "File"."Path" FROM ( SELECT "A"."ID" AS "BlocksetID", IFNULL("B"."CalcLen", 0) AS "CalcLen", "A"."Length" FROM "Blockset" A LEFT OUTER JOIN ( SELECT "BlocksetEntry"."BlocksetID", SUM("Block"."Size") AS "CalcLen" FROM "BlocksetEntry" LEFT OUTER JOIN "Block" ON "Block"."ID" = "BlocksetEntry"."BlockID" GROUP BY "BlocksetEntry"."BlocksetID" ) B ON "A"."ID" = "B"."BlocksetID" ) A, "File" WHERE "A"."BlocksetID" = "File"."BlocksetID" AND "A"."CalcLen" != "A"."Length"
  172. Mar 7, 2018 11:55 PM: ExecuteReader: SELECT "Key", "Value" FROM "Configuration" took 00:00:00.000
  173. Mar 7, 2018 11:55 PM: Starting - ExecuteReader: SELECT "Key", "Value" FROM "Configuration"
  174. Mar 7, 2018 11:55 PM: ExecuteReader: SELECT "Key", "Value" FROM "Configuration" took 00:00:00.017
  175. Mar 7, 2018 11:55 PM: Starting - ExecuteReader: SELECT "Key", "Value" FROM "Configuration"
  176. Mar 7, 2018 11:55 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Block" WHERE "Size" > ? took 00:32:39.989
  177. Mar 7, 2018 11:22 PM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Block" WHERE "Size" > ?
  178. Mar 7, 2018 11:22 PM: ExecuteReader: SELECT "Key", "Value" FROM "Configuration" took 00:00:00.000
  179. Mar 7, 2018 11:22 PM: Starting - ExecuteReader: SELECT "Key", "Value" FROM "Configuration"
  180. Mar 7, 2018 11:22 PM: ExecuteReader: SELECT "Key", "Value" FROM "Configuration" took 00:00:00.000
  181. Mar 7, 2018 11:22 PM: Starting - ExecuteReader: SELECT "Key", "Value" FROM "Configuration"
  182. Mar 7, 2018 11:22 PM: ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES (?, ?); SELECT last_insert_rowid(); took 00:00:00.136
  183. Mar 7, 2018 11:22 PM: Starting - ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES (?, ?); SELECT last_insert_rowid();
  184. Mar 7, 2018 11:22 PM: Starting - Running Backup
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!