Stuck in loop with bad fileset

Support
1

One day my backup succeeds, the next day it fails with an unexpected difference in fileset 0. I delete the version, run backup and it’s fine. The next backup fails.

Running Duplicati - 2.0.5.1_beta_2020-01-18 on Linux with mono version 6.12.0.107.

I turned on logging and found this:

2021-02-17 19:05:02 -06 - [Warning-Duplicati.Library.Main.Operation.Backup.FileBlockProcessor.FileEntry-PathProcessingFailed]: Failed to process path: /home/jpschewe/.atom/packages/atom-beautify/node_modules/coffee-fmt/node_modules/lodash/object/methods.js
Mono.Data.Sqlite.SqliteException (0x80004005): Abort due to constraint violation
UNIQUE constraint failed: FilesetEntry.FilesetID, FilesetEntry.FileID
  at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00084] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0003d] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00104] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Object[] values) [0x0005e] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog) [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.LocalBackupDatabase.AddFile (System.Int64 pathprefixid, System.String filename, System.DateTime lastmodified, System.Int64 blocksetID, System.Int64 metadataID, System.Data.IDbTransaction transaction) [0x00121] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.BackupDatabase+<>c__DisplayClass15_0.<AddFileAsync>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner+<>c__DisplayClass3_0.<RunOnMain>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner.DoRunOnMain[T] (System.Func`1[TResult] method) [0x000b0] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.FileBlockProcessor+<>c__DisplayClass1_0.<Run>b__0 (<>f__AnonymousType8`2[<Input>j__TPar,<StreamBlockChannel>j__TPar] self) [0x00681] in <8f1de655bd1240739a78684d845cecc8>:0 
2021-02-17 19:05:02 -06 - [Warning-Duplicati.Library.Main.Operation.Backup.FileBlockProcessor.FileEntry-PathProcessingFailed]: Failed to process path: /home/jpschewe/.atom/packages/atom-beautify/node_modules/coffee-fmt/node_modules/lodash/object/merge.js
Mono.Data.Sqlite.SqliteException (0x80004005): Abort due to constraint violation
UNIQUE constraint failed: FilesetEntry.FilesetID, FilesetEntry.FileID
  at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00084] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0003d] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00104] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Object[] values) [0x0005e] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog) [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.LocalBackupDatabase.AddFile (System.Int64 pathprefixid, System.String filename, System.DateTime lastmodified, System.Int64 blocksetID, System.Int64 metadataID, System.Data.IDbTransaction transaction) [0x00121] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.BackupDatabase+<>c__DisplayClass15_0.<AddFileAsync>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner+<>c__DisplayClass3_0.<RunOnMain>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner.DoRunOnMain[T] (System.Func`1[TResult] method) [0x000b0] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.FileBlockProcessor+<>c__DisplayClass1_0.<Run>b__0 (<>f__AnonymousType8`2[<Input>j__TPar,<StreamBlockChannel>j__TPar] self) [0x00681] in <8f1de655bd1240739a78684d845cecc8>:0 
2021-02-17 19:05:02 -06 - [Warning-Duplicati.Library.Main.Operation.Backup.FileBlockProcessor.FileEntry-PathProcessingFailed]: Failed to process path: /home/jpschewe/.atom/packages/atom-beautify/node_modules/coffee-fmt/node_modules/lodash/object/mapKeys.js
Mono.Data.Sqlite.SqliteException (0x80004005): Abort due to constraint violation
UNIQUE constraint failed: FilesetEntry.FilesetID, FilesetEntry.FileID
  at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00084] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0003d] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00104] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Object[] values) [0x0005e] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog) [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.LocalBackupDatabase.AddFile (System.Int64 pathprefixid, System.String filename, System.DateTime lastmodified, System.Int64 blocksetID, System.Int64 metadataID, System.Data.IDbTransaction transaction) [0x00121] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.BackupDatabase+<>c__DisplayClass15_0.<AddFileAsync>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner+<>c__DisplayClass3_0.<RunOnMain>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner.DoRunOnMain[T] (System.Func`1[TResult] method) [0x000b0] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.FileBlockProcessor+<>c__DisplayClass1_0.<Run>b__0 (<>f__AnonymousType8`2[<Input>j__TPar,<StreamBlockChannel>j__TPar] self) [0x00681] in <8f1de655bd1240739a78684d845cecc8>:0 
2021-02-17 19:05:02 -06 - [Warning-Duplicati.Library.Main.Operation.Backup.FileBlockProcessor.FileEntry-PathProcessingFailed]: Failed to process path: /home/jpschewe/.atom/packages/atom-beautify/node_modules/coffee-fmt/node_modules/lodash/object/mapValues.js
Mono.Data.Sqlite.SqliteException (0x80004005): Abort due to constraint violation
UNIQUE constraint failed: FilesetEntry.FilesetID, FilesetEntry.FileID
  at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00084] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0003d] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00104] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Object[] values) [0x0005e] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog) [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.LocalBackupDatabase.AddFile (System.Int64 pathprefixid, System.String filename, System.DateTime lastmodified, System.Int64 blocksetID, System.Int64 metadataID, System.Data.IDbTransaction transaction) [0x00121] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.BackupDatabase+<>c__DisplayClass15_0.<AddFileAsync>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner+<>c__DisplayClass3_0.<RunOnMain>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner.DoRunOnMain[T] (System.Func`1[TResult] method) [0x000b0] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.FileBlockProcessor+<>c__DisplayClass1_0.<Run>b__0 (<>f__AnonymousType8`2[<Input>j__TPar,<StreamBlockChannel>j__TPar] self) [0x00681] in <8f1de655bd1240739a78684d845cecc8>:0 
2021-02-17 19:05:02 -06 - [Warning-Duplicati.Library.Main.Operation.Backup.FileBlockProcessor.FileEntry-PathProcessingFailed]: Failed to process path: /home/jpschewe/.atom/packages/atom-beautify/node_modules/coffee-fmt/node_modules/lodash/object/defaults.js
Mono.Data.Sqlite.SqliteException (0x80004005): Abort due to constraint violation
UNIQUE constraint failed: FilesetEntry.FilesetID, FilesetEntry.FileID
  at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00084] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0003d] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00104] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Object[] values) [0x0005e] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog) [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.LocalBackupDatabase.AddFile (System.Int64 pathprefixid, System.String filename, System.DateTime lastmodified, System.Int64 blocksetID, System.Int64 metadataID, System.Data.IDbTransaction transaction) [0x00121] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.BackupDatabase+<>c__DisplayClass15_0.<AddFileAsync>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner+<>c__DisplayClass3_0.<RunOnMain>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner.DoRunOnMain[T] (System.Func`1[TResult] method) [0x000b0] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.FileBlockProcessor+<>c__DisplayClass1_0.<Run>b__0 (<>f__AnonymousType8`2[<Input>j__TPar,<StreamBlockChannel>j__TPar] self) [0x00681] in <8f1de655bd1240739a78684d845cecc8>:0 
2021-02-17 19:05:02 -06 - [Warning-Duplicati.Library.Main.Operation.Backup.FileBlockProcessor.FileEntry-PathProcessingFailed]: Failed to process path: /home/jpschewe/.atom/packages/atom-beautify/node_modules/coffee-fmt/node_modules/lodash/object/defaultsDeep.js
Mono.Data.Sqlite.SqliteException (0x80004005): Abort due to constraint violation
UNIQUE constraint failed: FilesetEntry.FilesetID, FilesetEntry.FileID
  at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00084] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0003d] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00104] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Object[] values) [0x0005e] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog) [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.LocalBackupDatabase.AddFile (System.Int64 pathprefixid, System.String filename, System.DateTime lastmodified, System.Int64 blocksetID, System.Int64 metadataID, System.Data.IDbTransaction transaction) [0x00121] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.BackupDatabase+<>c__DisplayClass15_0.<AddFileAsync>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner+<>c__DisplayClass3_0.<RunOnMain>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner.DoRunOnMain[T] (System.Func`1[TResult] method) [0x000b0] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.FileBlockProcessor+<>c__DisplayClass1_0.<Run>b__0 (<>f__AnonymousType8`2[<Input>j__TPar,<StreamBlockChannel>j__TPar] self) [0x00681] in <8f1de655bd1240739a78684d845cecc8>:0 
2021-02-17 19:05:02 -06 - [Warning-Duplicati.Library.Main.Operation.Backup.FileBlockProcessor.FileEntry-PathProcessingFailed]: Failed to process path: /home/jpschewe/.atom/packages/atom-beautify/node_modules/coffee-fmt/node_modules/lodash/object/create.js
Mono.Data.Sqlite.SqliteException (0x80004005): Abort due to constraint violation
UNIQUE constraint failed: FilesetEntry.FilesetID, FilesetEntry.FileID
  at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00084] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0003d] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00104] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Object[] values) [0x0005e] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog) [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.LocalBackupDatabase.AddFile (System.Int64 pathprefixid, System.String filename, System.DateTime lastmodified, System.Int64 blocksetID, System.Int64 metadataID, System.Data.IDbTransaction transaction) [0x00121] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.BackupDatabase+<>c__DisplayClass15_0.<AddFileAsync>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner+<>c__DisplayClass3_0.<RunOnMain>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner.DoRunOnMain[T] (System.Func`1[TResult] method) [0x000b0] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.FileBlockProcessor+<>c__DisplayClass1_0.<Run>b__0 (<>f__AnonymousType8`2[<Input>j__TPar,<StreamBlockChannel>j__TPar] self) [0x00681] in <8f1de655bd1240739a78684d845cecc8>:0 
2021-02-17 19:05:02 -06 - [Warning-Duplicati.Library.Main.Operation.Backup.FileBlockProcessor.FileEntry-PathProcessingFailed]: Failed to process path: /home/jpschewe/.atom/packages/atom-beautify/node_modules/coffee-fmt/node_modules/lodash/object/keys.js
Mono.Data.Sqlite.SqliteException (0x80004005): Abort due to constraint violation
UNIQUE constraint failed: FilesetEntry.FilesetID, FilesetEntry.FileID
  at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00084] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0003d] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00104] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
  at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <bd1441a78b104a3a92ac102d55be11d3>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Object[] values) [0x0005e] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.Boolean writeLog) [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Database.LocalBackupDatabase.AddFile (System.Int64 pathprefixid, System.String filename, System.DateTime lastmodified, System.Int64 blocksetID, System.Int64 metadataID, System.Data.IDbTransaction transaction) [0x00121] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.BackupDatabase+<>c__DisplayClass15_0.<AddFileAsync>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner+<>c__DisplayClass3_0.<RunOnMain>b__0 () [0x00000] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Common.SingleRunner.DoRunOnMain[T] (System.Func`1[TResult] method) [0x000b0] in <8f1de655bd1240739a78684d845cecc8>:0 
  at Duplicati.Library.Main.Operation.Backup.FileBlockProcessor+<>c__DisplayClass1_0.<Run>b__0 (<>f__AnonymousType8`2[<Input>j__TPar,<StreamBlockChannel>j__TPar] self) [0x00681] in <8f1de655bd1240739a78684d845cecc8>:0
2

I may be wrong, but I think there have been some improvements since 2.0.5.1 to address some “constraint violation” errors. I need to dig through the issues and pull requests to be sure.

3

But there isn’t another beta or stable release after 2.0.5.1. I really don’t want to trust all of my data to canary backups.

4

Not yet, but hopefully a new beta will be released soon. In general I agree - don’t use Canary for production backups. That being said, I personally find 2.0.5.112 more stable and of better quality than 2.0.5.1. I do use it on my production systems but plan to switch most back to the Beta channel when the next Beta comes out.

5

Does anyone know of a way to fix this database? Or do I start my backup all over again?

6

How healthy/broken is the database looking on operations that are not a backup?

If this were Windows, I’d be asking you to look for path ending in period or space.
Unfortunately that was a Windows weirdness where it returned same path twice.
Your result looks similar though. If a path repeats, FileID repeats, which is wrong.

You could look in the log before the UNIQUE constraint error. What was it doing?
At Verbose log level, you should see file paths that are intended to get backed up.
At Profiling level with profile-all-database-queries set, you would see SQL.
That makes a large log (though smaller if it fails fast) so a search tool might help.
As a regular expression, you’re probably looking for last INSERT.*FilesetEntry

There might be other ways. Did you take a shot at Repair to see if it fixes things?
Recreate is a step stronger, but sometimes can download a lot and then give up.
If all goes well though, only relatively small dlist and dindex files are downloaded.
Before messing with the database, consider saving a copy for history or a revert.

How are the upload and download speeds, and how critical are old file versions?
There might be a tradeoff between manual work versus just starting it over again.

7

I decided to give up and start a new backup. Hopefully I don’t run into this again.