Hi,
I’ve been trying to recover data after a system reset for over a month now.
“Recreating database” seemingly never finishes and has very slow progress, and the live log is full of the following messages under the profiling category:
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “Metadataset”.“ID” FROM “Metadataset”,“Blockset” WHERE “Metadataset”.“BlocksetID” = “Blockset”.“ID” AND “Blockset”.“FullHash” = ? AND “Blockset”.“Length” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “Metadataset”.“ID” FROM “Metadataset”,“Blockset” WHERE “Metadataset”.“BlocksetID” = “Blockset”.“ID” AND “Blockset”.“FullHash” = ? AND “Blockset”.“Length” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “ID” FROM “Blockset” WHERE “Length” = ? AND “FullHash” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “ID” FROM “Blockset” WHERE “Length” = ? AND “FullHash” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “Metadataset”.“ID” FROM “Metadataset”,“Blockset” WHERE “Metadataset”.“BlocksetID” = “Blockset”.“ID” AND “Blockset”.“FullHash” = ? AND “Blockset”.“Length” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “Metadataset”.“ID” FROM “Metadataset”,“Blockset” WHERE “Metadataset”.“BlocksetID” = “Blockset”.“ID” AND “Blockset”.“FullHash” = ? AND “Blockset”.“Length” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “ID” FROM “Blockset” WHERE “Length” = ? AND “FullHash” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “ID” FROM “Blockset” WHERE “Length” = ? AND “FullHash” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “Metadataset”.“ID” FROM “Metadataset”,“Blockset” WHERE “Metadataset”.“BlocksetID” = “Blockset”.“ID” AND “Blockset”.“FullHash” = ? AND “Blockset”.“Length” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “Metadataset”.“ID” FROM “Metadataset”,“Blockset” WHERE “Metadataset”.“BlocksetID” = “Blockset”.“ID” AND “Blockset”.“FullHash” = ? AND “Blockset”.“Length” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “ID” FROM “Blockset” WHERE “Length” = ? AND “FullHash” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “ID” FROM “Blockset” WHERE “Length” = ? AND “FullHash” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “Metadataset”.“ID” FROM “Metadataset”,“Blockset” WHERE “Metadataset”.“BlocksetID” = “Blockset”.“ID” AND “Blockset”.“FullHash” = ? AND “Blockset”.“Length” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “Metadataset”.“ID” FROM “Metadataset”,“Blockset” WHERE “Metadataset”.“BlocksetID” = “Blockset”.“ID” AND “Blockset”.“FullHash” = ? AND “Blockset”.“Length” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “ID” FROM “Blockset” WHERE “Length” = ? AND “FullHash” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “ID” FROM “Blockset” WHERE “Length” = ? AND “FullHash” = ?
-
22 Nov 2018 13:10: ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ? took 00:00:00.000
-
22 Nov 2018 13:10: Starting - ExecuteScalarInt64: SELECT “ID” FROM “File” WHERE “Path” = ? AND “BlocksetID” = ? AND “MetadataID” = ?
It’s worth noting that my backup is pretty big (approx 2.2TB), not sure that duplicati was really mean for this size of backup. I’m only trying to recover a very small amount of it, probably sub 1GB.
It is stored on a home server, and connects over FTP.
I really know very little about the software, and have been unable to glean any information from a lot of googling, so sorry for any vagueness or stupidity.
Thanks.