Fetching path information fails during restore


#1

Hello to all!
I’m now runnig Duplicati - 2.0.3.3_beta_2018-04-02.
Tried to test the restore functionality and faced up with a problem, described in topic title. Below are some screenshots and log info. Any help will be greatly appreciated.

I frogot to mention, I’m running Ubuntu 16.04.

Some peice of Live Log:

Apr 13, 2018 5:42 PM: Running List took 00:00:00.386
Apr 13, 2018 5:42 PM: ExecuteNonQuery: DROP TABLE IF EXISTS "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" took 00:00:00.000
Apr 13, 2018 5:42 PM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634"
Apr 13, 2018 5:42 PM: ExecuteReader: SELECT DISTINCT "A"."FilesetID", "B"."FileCount", "B"."FileSizes" FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" A LEFT OUTER JOIN ( SELECT "A"."FilesetID" AS "FilesetID", COUNT(*) AS "FileCount", SUM("C"."Length") AS "FileSizes" FROM "FilesetEntry" A, "File" B, "Blockset" C WHERE "A"."FileID" = "B"."ID" AND "B"."BlocksetID" = "C"."ID" AND "A"."FilesetID" IN (SELECT DISTINCT "FilesetID" FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634") GROUP BY "A"."FilesetID" ) B ON "A"."FilesetID" = "B"."FilesetID" ORDER BY "A"."Timestamp" DESC took 00:00:00.024
Apr 13, 2018 5:42 PM: Starting - ExecuteReader: SELECT DISTINCT "A"."FilesetID", "B"."FileCount", "B"."FileSizes" FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" A LEFT OUTER JOIN ( SELECT "A"."FilesetID" AS "FilesetID", COUNT(*) AS "FileCount", SUM("C"."Length") AS "FileSizes" FROM "FilesetEntry" A, "File" B, "Blockset" C WHERE "A"."FileID" = "B"."ID" AND "B"."BlocksetID" = "C"."ID" AND "A"."FilesetID" IN (SELECT DISTINCT "FilesetID" FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634") GROUP BY "A"."FilesetID" ) B ON "A"."FilesetID" = "B"."FilesetID" ORDER BY "A"."Timestamp" DESC
Apr 13, 2018 5:42 PM: ExecuteNonQuery: DROP TABLE IF EXISTS "Filenames-2D640D089C58B74C8644F5832B0AF37F" took 00:00:00.012
Apr 13, 2018 5:42 PM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "Filenames-2D640D089C58B74C8644F5832B0AF37F"
Apr 13, 2018 5:42 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ? took 00:00:00.005
Apr 13, 2018 5:42 PM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ?
Apr 13, 2018 5:42 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ? took 00:00:00.005
Apr 13, 2018 5:42 PM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ?
Apr 13, 2018 5:42 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ? took 00:00:00.005
Apr 13, 2018 5:42 PM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ?
Apr 13, 2018 5:42 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ? took 00:00:00.005
Apr 13, 2018 5:42 PM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ?
Apr 13, 2018 5:42 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ? took 00:00:00.006
Apr 13, 2018 5:42 PM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ?
Apr 13, 2018 5:42 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ? took 00:00:00.006
Apr 13, 2018 5:42 PM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ?
Apr 13, 2018 5:42 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ? took 00:00:00.007
Apr 13, 2018 5:42 PM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE SUBSTR("Path", 1, ?) = ?
Apr 13, 2018 5:42 PM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" took 00:00:00.001
Apr 13, 2018 5:42 PM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F"
Apr 13, 2018 5:42 PM: ExecuteNonQuery: DELETE FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE "Path" NOT IN (SELECT DISTINCT "Path" FROM "File", "FilesetEntry" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "FilesetEntry"."FilesetID" IN (SELECT "FilesetID" FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634") ) took 00:00:00.196
Apr 13, 2018 5:42 PM: Starting - ExecuteNonQuery: DELETE FROM "Filenames-2D640D089C58B74C8644F5832B0AF37F" WHERE "Path" NOT IN (SELECT DISTINCT "Path" FROM "File", "FilesetEntry" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "FilesetEntry"."FilesetID" IN (SELECT "FilesetID" FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634") )
Apr 13, 2018 5:42 PM: ExecuteNonQuery: INSERT INTO "Filenames-2D640D089C58B74C8644F5832B0AF37F" SELECT DISTINCT "Path" FROM "File" WHERE "Path" LIKE ? took 00:00:00.040
Apr 13, 2018 5:42 PM: Starting - ExecuteNonQuery: INSERT INTO "Filenames-2D640D089C58B74C8644F5832B0AF37F" SELECT DISTINCT "Path" FROM "File" WHERE "Path" LIKE ?
Apr 13, 2018 5:42 PM: ExecuteNonQuery: CREATE TEMPORARY TABLE "Filenames-2D640D089C58B74C8644F5832B0AF37F" ("Path" TEXT NOT NULL) took 00:00:00.000
Apr 13, 2018 5:42 PM: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "Filenames-2D640D089C58B74C8644F5832B0AF37F" ("Path" TEXT NOT NULL)
Apr 13, 2018 5:42 PM: ExecuteNonQuery: DELETE FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" WHERE "FilesetID" NOT IN (SELECT "FilesetID" FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" ORDER BY "Timestamp" DESC LIMIT 1 ) took 00:00:00.000
Apr 13, 2018 5:42 PM: Starting - ExecuteNonQuery: DELETE FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" WHERE "FilesetID" NOT IN (SELECT "FilesetID" FROM "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" ORDER BY "Timestamp" DESC LIMIT 1 )
Apr 13, 2018 5:42 PM: ExecuteNonQuery: CREATE INDEX "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634_FilesetIDTimestampIndex" ON "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" ("FilesetID", "Timestamp" DESC) took 00:00:00.000
Apr 13, 2018 5:42 PM: Starting - ExecuteNonQuery: CREATE INDEX "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634_FilesetIDTimestampIndex" ON "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" ("FilesetID", "Timestamp" DESC)
Apr 13, 2018 5:42 PM: ExecuteNonQuery: CREATE TEMPORARY TABLE "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" AS SELECT DISTINCT "ID" AS "FilesetID", "Timestamp" AS "Timestamp" FROM "Fileset" WHERE "Timestamp" <= ? took 00:00:00.000
Apr 13, 2018 5:42 PM: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "Filesets-D31F6F0DBEA6D8499A41AFC944A2F634" AS SELECT DISTINCT "ID" AS "FilesetID", "Timestamp" AS "Timestamp" FROM "Fileset" WHERE "Timestamp" <= ?
Apr 13, 2018 5:42 PM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 00:00:00.000
Apr 13, 2018 5:42 PM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
Apr 13, 2018 5:42 PM: ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES (?, ?); SELECT last_insert_rowid(); took 00:00:00.047
Apr 13, 2018 5:42 PM: Starting - ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES (?, ?); SELECT last_insert_rowid();
Apr 13, 2018 5:42 PM: Starting - Running List
Apr 13, 2018 5:42 PM: Running List took 00:00:00.072

#2

Hello @bobr, welcome to the forum!

I think there’s an known issue with the restore process not correctly handling paths that begin with “/” or “//”. I don’t know that a fix has been implemented yet, but a workaround seems to be to put a “.” in the “Search for files” field.

If that doesn’t work, could you let us know what OS you’re running on and what type (local path, drive letter, mount point, UNC, etc.) of source paths you’re using?

(By the way, I edited your post by adding “~~~” before and after the log entries to make the individual lines easier to read.)


#3

Sorry - I frogot to mention, I’m running Ubuntu 16.04.


#4

@JonMikelV I did as you sugested and it worked, but the navigation in a “file list frame” (I’ve marked it with red rectangle) is extremly slow…


#5

OK - so it sounds like it is the same issue we’ve seen before, though honestly I’ve never checked performance when using this workaround.

I’ll dig around and see if I can find my notes about the issue before - I think I had a possible fix in mind, but never got around to testing it.


#6

Hey, @JonMikelV - are there any good news?