# Stuck on Verifying Backend
**URL:** https://forum.duplicati.com/t/stuck-on-verifying-backend/3304
**Category:** Support
**Created:** [April 22, 2018, 6:16pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304 "2018-04-22T18:16:35Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@jfield](https://forum.duplicati.com/u/jfield)
#### Post date: [April 22, 2018, 6:16pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/1 "2018-04-22T18:16:35Z")
I have 2 backups, both to Onedrive. One is ~30GB and works fine. The other is above 200GB and never completes.
Judging by the file size in Onedrive, the backup is complete, but the UI is stuck on verifying. I left it for 18 hours but there was no activity in the logs and the progress bar didn’t move (it is very close to the end).
The last log message in ‘general’ was:
_Apr 22, 2018 2:04 AM: Message_
_Deleted 2 files, which reduced storage by 1.67 KB_
The last remote log was:
_Apr 22, 2018 2:04 AM: delete duplicati-id278848393dc427aa7ebf8ace6b35254.dindex.zip.aes_
System wide logs (profiling level) the last was:
_Apr 22, 2018 2:04 AM: Backend event: List - Started: ()_
I am using Duplicati - 2.0.3.3\_beta\_2018-04-02 running as a service.
I had this problem earlier, and after repeatedly failing with ‘repair’ and ‘delete and repair’ I started again with a new backup (my internet is fairly speedy so no huge sacrifice). Unfortunately, this new backup isn’t working ☹
The UI shows ‘Last successful run:Never’.
What can I try?
What I have seen of Duplicati otherwise looks great, thank you very much.
---
### Author:  [@jfield](https://forum.duplicati.com/u/jfield)
#### Post date: [April 23, 2018, 8:09pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/2 "2018-04-23T20:09:21Z")
Interesting. 36 hours later, something started to happen.
The following were added to the General log for the backup:
_Apr 23, 2018 2:32 PM: Message_
_removing file listed as Temporary: duplicati-iadd765b35eea4d58886b43817e55deb7.dindex.zip.aes_
_Apr 23, 2018 2:32 PM: Message_
_removing file listed as Temporary: duplicati-bfb84341339a74f9691215b418b3e6519.dblock.zip.aes_
And to the remote log:
_Apr 23, 2018 2:32 PM: list_
And to the application log (profiling):
> Apr 23, 2018 2:32 PM: Backend event: Get - Started: duplicati-20180417T033005Z.dlist.zip.aes (3.11 MB)
> Apr 23, 2018 2:32 PM: Starting - RemoteOperationGet
> Apr 23, 2018 2:32 PM: ExecuteReader: SELECT “ID”, “Name”, “Size”, “Hash”, “VerificationCount” FROM “Remotevolume” WHERE “Type” = ? AND “State” IN (?, ?) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteReader: SELECT “ID”, “Name”, “Size”, “Hash”, “VerificationCount” FROM “Remotevolume” WHERE “Type” = ? AND “State” IN (?, ?)
> Apr 23, 2018 2:32 PM: ExecuteReader: SELECT “ID”, “Name”, “Size”, “Hash”, “VerificationCount” FROM “Remotevolume” WHERE “Type” = ? AND “State” IN (?, ?) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteReader: SELECT “ID”, “Name”, “Size”, “Hash”, “VerificationCount” FROM “Remotevolume” WHERE “Type” = ? AND “State” IN (?, ?)
> Apr 23, 2018 2:32 PM: 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
> Apr 23, 2018 2:32 PM: 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”
> Apr 23, 2018 2:32 PM: ExecuteScalarInt64: SELECT MAX(“VerificationCount”) FROM “RemoteVolume” took 00:00:00.002
> Apr 23, 2018 2:32 PM: Starting - ExecuteScalarInt64: SELECT MAX(“VerificationCount”) FROM “RemoteVolume”
> Apr 23, 2018 2:32 PM: 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.001
> Apr 23, 2018 2:32 PM: Starting - ExecuteReader: SELECT “ID”, “Name”, “Size”, “Hash”, “VerificationCount” FROM “Remotevolume” WHERE (“State” = ? OR “State” = ?) AND (“Hash” = “” OR “Hash” IS NULL OR “Size” \<= 0)
> Apr 23, 2018 2:32 PM: ExecuteReader: SELECT “ID”, “Timestamp” FROM “Fileset” ORDER BY “Timestamp” DESC took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteReader: SELECT “ID”, “Timestamp” FROM “Fileset” ORDER BY “Timestamp” DESC
> Apr 23, 2018 2:32 PM: RemoteOperationTerminate took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - RemoteOperationTerminate
> Apr 23, 2018 2:32 PM: AfterBackupVerify took 12:28:11.093
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DROP TABLE IF EXISTS “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689”
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DROP TABLE IF EXISTS “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689”
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689”
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689”
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “DeletedBlock” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “DeletedBlock” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” )
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “Block” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “Block” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” )
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “BlocklistHash” WHERE “Hash” IN (SELECT “Hash” FROM “Block” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” )) took 00:00:00.006
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “BlocklistHash” WHERE “Hash” IN (SELECT “Hash” FROM “Block” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ))
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “BlocksetEntry” WHERE “BlocksetID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” ) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “BlocksetEntry” WHERE “BlocksetID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” )
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “Blockset” WHERE “ID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” ) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “Blockset” WHERE “ID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” )
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “Metadataset” WHERE “BlocksetID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” ) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “Metadataset” WHERE “BlocksetID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” )
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “File” WHERE “BlocksetID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” ) OR “MetadataID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” ) took 00:00:00.115
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “File” WHERE “BlocksetID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” ) OR “MetadataID” IN (SELECT “ID” FROM “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” )
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: INSERT OR IGNORE INTO “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” (“ID”) SELECT “BlocksetEntry”.“BlocksetID” FROM “BlocksetEntry”, “Block” WHERE “BlocksetEntry”.“BlockID” = “Block”.“ID” AND “Block”.“VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ) UNION ALL SELECT “BlocksetID” FROM “BlocklistHash” WHERE “Hash” IN (SELECT “Hash” FROM “Block” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” )) took 00:00:00.058
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: INSERT OR IGNORE INTO “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” (“ID”) SELECT “BlocksetEntry”.“BlocksetID” FROM “BlocksetEntry”, “Block” WHERE “BlocksetEntry”.“BlockID” = “Block”.“ID” AND “Block”.“VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ) UNION ALL SELECT “BlocksetID” FROM “BlocklistHash” WHERE “Hash” IN (SELECT “Hash” FROM “Block” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ))
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: CREATE TEMP TABLE “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” (“ID” INTEGER PRIMARY KEY) took 00:00:00.001
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: CREATE TEMP TABLE “DelBlockSetIds-196DB9530F6EE340BF350C348CCFF689” (“ID” INTEGER PRIMARY KEY)
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “Fileset” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “Fileset” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” )
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “FilesetEntry” WHERE “FilesetID” IN (SELECT “ID” FROM “Fileset” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” )) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “FilesetEntry” WHERE “FilesetID” IN (SELECT “ID” FROM “Fileset” WHERE “VolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ))
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: DELETE FROM “IndexBlockLink” WHERE “BlockVolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ) OR “IndexVolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ) took 00:00:00.003
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: DELETE FROM “IndexBlockLink” WHERE “BlockVolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” ) OR “IndexVolumeID” IN (SELECT “ID” FROM “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” )
> Apr 23, 2018 2:32 PM: ExecuteScalarInt64: SELECT “ID” FROM “Remotevolume” WHERE “Name” = ? took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteScalarInt64: SELECT “ID” FROM “Remotevolume” WHERE “Name” = ?
> Apr 23, 2018 2:32 PM: ExecuteScalarInt64: SELECT “ID” FROM “Remotevolume” WHERE “Name” = ? took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteScalarInt64: SELECT “ID” FROM “Remotevolume” WHERE “Name” = ?
> Apr 23, 2018 2:32 PM: ExecuteNonQuery: CREATE TEMP TABLE “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” (“ID” INTEGER PRIMARY KEY) took 00:00:00.000
> Apr 23, 2018 2:32 PM: Starting - ExecuteNonQuery: CREATE TEMP TABLE “DelVolSetIds-196DB9530F6EE340BF350C348CCFF689” (“ID” INTEGER PRIMARY KEY)
> Apr 23, 2018 2:32 PM: removing file listed as Temporary: duplicati-iadd765b35eea4d58886b43817e55deb7.dindex.zip.aes
> Apr 23, 2018 2:32 PM: removing file listed as Temporary: duplicati-bfb84341339a74f9691215b418b3e6519.dblock.zip.aes
> Apr 23, 2018 2:32 PM: 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:00.060
> Apr 23, 2018 2:32 PM: 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”)
> Apr 23, 2018 2:32 PM: RemoteOperationList took 12:28:05.820
> Apr 23, 2018 2:32 PM: Backend event: List - Completed: (8.05 KB)
Interesting… The list backend took 30 hours to complete… I’m tempted to put the blame all on Onedrive.
It’s now apparently somewhat stuck on Verifying, let’s give it a week or two! ☹
---
### Author:  [@JonMikelV](https://forum.duplicati.com/u/JonMikelV)
#### Post date: [April 25, 2018, 7:54pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/3 "2018-04-25T19:54:57Z")
Hi @jfield, welcome to the forum!
Is the Verifying step it’s getting stuck on part of the backup (can you tell if it’s at the beginning or the end?) or a manual Verify command?
---
### Author:  [@jfield](https://forum.duplicati.com/u/jfield)
#### Post date: [April 25, 2018, 11:02pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/4 "2018-04-25T23:02:30Z")
Thanks @JonMikelV , it progressed from ‘Verifying backend’ in my first post (where it seemed stuck) to simply ‘Verifying’ in my second post, where it got stuck again, this time for real. This time I cancelled it after a few days and told it to run again.
I think it must have been at the end of the backup given that the files are visible in Onedrive on the web. It was an automatic verify, not manually initiated.
---
### Author:  [@JonMikelV](https://forum.duplicati.com/u/JonMikelV)
#### Post date: [April 26, 2018, 2:05pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/5 "2018-04-26T14:05:28Z")
> [@jfield](#):
>
> I think it must have been at the end of the backup given that the files are visible in Onedrive on the web. It was an automatic verify, not manually initiated.
Something you could try as a test is to set `--backup-test-samples=0`.
(See [Advanced Options - Duplicati 2 User's Manual](https://duplicati.readthedocs.io/en/latest/06-advanced-options/#backup-test-samples) for more detail.)
If that makes the issue go away then we’ve probably isolated the problem (but not actually resolved it, so don’t necessarily consider this a “fix”).
* * *
Oh, something else to consider is looking at your restore version list. You _may_ find that even though the full job (including verification) doesn’t technically finish, the actual backup part may have completed.
So if some of the dates with runs that got “stuck” show up in the restore list then you can at least know that the backups themselves are happening.
---
### Author:  [@jfield](https://forum.duplicati.com/u/jfield)
#### Post date: [April 30, 2018, 6:30pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/6 "2018-04-30T18:30:11Z")
Thank you.
It just completed today! (After almost a week of little activity.)
But even before it managed to verify it still appeared in restore.
---
### Author:  [@JonMikelV](https://forum.duplicati.com/u/JonMikelV)
#### Post date: [April 30, 2018, 6:45pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/7 "2018-04-30T18:45:46Z")
> [@jfield](#):
>
> It just completed today! (After almost a week of little activity.)
Yay! Though the “almost a week” part is definitely something we are aware of and working to improve.
So at this point it’s working OK for your or is it still taking forever on verifying the backend in subsequent runs?
Oh, and did you try the `--backup-test-samples=0` thing in my last post or was patience the trick that “made it work”?
---
### Author:  [@jfield](https://forum.duplicati.com/u/jfield)
#### Post date: [April 30, 2018, 6:49pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/8 "2018-04-30T18:49:15Z")
It was patience… I was saving it for when it failed
---
### Author:  [@JonMikelV](https://forum.duplicati.com/u/JonMikelV)
#### Post date: [April 30, 2018, 6:50pm UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/9 "2018-04-30T18:50:27Z")
Patience for the win!
Both in letting Duplicati finish it’s thing AND with us for waiting while we figure out why this is happening (and how to fix it). 🙂
---
### Author:  [@comodoro](https://forum.duplicati.com/u/comodoro)
#### Post date: [June 29, 2018, 6:29am UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/10 "2018-06-29T06:29:18Z")
So the resolution is to wait for days? I have I believe this issue (stuck on Verifying…, Duplicati 2.0.3.3\_beta\_2018-04-02, backup about 10GB to Google Drive). Progress bar is already full and the backup is running for 12 hours with no progress in logs.
---
### Author:  [@JonMikelV](https://forum.duplicati.com/u/JonMikelV)
#### Post date: [June 30, 2018, 3:17am UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/11 "2018-06-30T03:17:37Z")
> [@comodoro](#):
>
> backup is running for 12 hours with no progress in logs
Which logs did you check?
---
### Author:  [@comodoro](https://forum.duplicati.com/u/comodoro)
#### Post date: [June 30, 2018, 4:48am UTC](https://forum.duplicati.com/t/stuck-on-verifying-backend/3304/12 "2018-06-30T04:48:44Z")
Just the logs in the UI: backup name : Display log : General and Remote (The labels can differ slightly as I have them localized). Last entries are at 2018-06-28 21:02. Are there any other logs?