Hi 
I’m running duplicati successfully for quite a few years on freebsd/freenas/truenas.
Without properly realizing, I’ve made some updates to the system recently and for some reason broke the duplicati installation and can’t seem to be able to fix it.
A few things:
1.) The backups and configuration still exist on source and destination, that seems to be in order and working fine
2.) The backups don’t show up as configured, but apparently the system is trying to run them at the time of night as they should.
3.) the backups are all failing with backtraces as below errors suggest:
Mono.Data.Sqlite.SqliteException (0x80004005): SQLite error
no such column: “Uploading” - should this be a string literal in single-quotes?
at Mono.Data.Sqlite.SQLite3.Prepare (Mono.Data.Sqlite.SqliteConnection cnn, System.String strSql, Mono.Data.Sqlite.SqliteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x001f8] in :0
at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x000d3] in :0
at Mono.Data.Sqlite.SqliteCommand.GetStatement (System.Int32 index) [0x00008] in :0
at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand.GetStatement(int)
at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x000b3] in :0
at Mono.Data.Sqlite.SqliteDataReader…ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in :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 :0
at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader () [0x00000] in :0
at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteReader (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Object values) [0x0005e] in <9b99db820df3422db0aa96d4648dc7b1>:0
at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteReader (System.Data.IDbCommand self, System.String cmd, System.Object values) [0x00000] in <9b99db820df3422db0aa96d4648dc7b1>:0
at Duplicati.Library.Main.Database.LocalBackupDatabase+d__48.MoveNext () [0x00056] in <9b99db820df3422db0aa96d4648dc7b1>:0
at System.Collections.Generic.EnumerableHelpers.ToArray[T] (System.Collections.Generic.IEnumerable1[T] source, System.Int32& length) [0x00032] in <4e0b4fa81dd04effbc4e22d8fabefb81>:0 at System.Linq.Buffer1[TElement]…ctor (System.Collections.Generic.IEnumerable1[T] source) [0x00022] in <4e0b4fa81dd04effbc4e22d8fabefb81>:0 at System.Linq.OrderedEnumerable1[TElement].ToArray () [0x00000] in <4e0b4fa81dd04effbc4e22d8fabefb81>:0
at System.Linq.Enumerable.ToArray[TSource] (System.Collections.Generic.IEnumerable1[T] source) [0x0001f] in <4e0b4fa81dd04effbc4e22d8fabefb81>:0 at Duplicati.Library.Main.Operation.Backup.BackupDatabase.<GetIncompleteFilesetsAsync>b__26_0 () [0x00035] in <9b99db820df3422db0aa96d4648dc7b1>:0 at Duplicati.Library.Main.Operation.Common.SingleRunner+<>c__DisplayClass4_01[T].b__0 () [0x00000] in <9b99db820df3422db0aa96d4648dc7b1>:0
at Duplicati.Library.Main.Operation.Common.SingleRunner.DoRunOnMain[T] (System.Func1[TResult] method) [0x000b0] in <9b99db820df3422db0aa96d4648dc7b1>:0 at Duplicati.Library.Main.Operation.BackupHandler.RunAsync (System.String[] sources, Duplicati.Library.Utility.IFilter filter, System.Threading.CancellationToken token) [0x01048] in <9b99db820df3422db0aa96d4648dc7b1>:0 at CoCoL.ChannelExtensions.WaitForTaskOrThrow (System.Threading.Tasks.Task task) [0x00050] in <9a758ff4db6c48d6b3d4d0e5c2adf6d1>:0 at Duplicati.Library.Main.Operation.BackupHandler.Run (System.String[] sources, Duplicati.Library.Utility.IFilter filter, System.Threading.CancellationToken token) [0x00009] in <9b99db820df3422db0aa96d4648dc7b1>:0 at Duplicati.Library.Main.Controller+<>c__DisplayClass14_0.<Backup>b__0 (Duplicati.Library.Main.BackupResults result) [0x0004b] in <9b99db820df3422db0aa96d4648dc7b1>:0 at Duplicati.Library.Main.Controller.RunAction[T] (T result, System.String[]& paths, Duplicati.Library.Utility.IFilter& filter, System.Action1[T] method) [0x0036c] in <9b99db820df3422db0aa96d4648dc7b1>:0
at Duplicati.Library.Main.Controller.Backup (System.String inputsources, Duplicati.Library.Utility.IFilter filter) [0x00074] in <9b99db820df3422db0aa96d4648dc7b1>:0
at Duplicati.Server.Runner.Run (Duplicati.Server.Runner+IRunnerData data, System.Boolean fromQueue) [0x00349] in <17916a3bd21d425da6aeece2c5428e16>:0
- the webview throws this error quite often:
Jul 16, 2024 9:49 PM: Request for http://10.34.93.205:8200/api/v1/backups gave error
Mono.Data.Sqlite.SqliteException (0x80004005): SQLite error
no such column: “” - should this be a string literal in single-quotes?
at Mono.Data.Sqlite.SQLite3.Prepare (Mono.Data.Sqlite.SqliteConnection cnn, System.String strSql, Mono.Data.Sqlite.SqliteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x001f8] in :0
at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x000d3] in :0
at Mono.Data.Sqlite.SqliteCommand.GetStatement (System.Int32 index) [0x00008] in :0
at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand.GetStatement(int)
at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x000b3] in :0
at Mono.Data.Sqlite.SqliteDataReader…ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in :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 :0
at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in :0
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader () [0x00000] in :0
at Duplicati.Server.Database.Connection+d__731[T].MoveNext () [0x00019] in <17916a3bd21d425da6aeece2c5428e16>:0 at System.Collections.Generic.LargeArrayBuilder1[T].AddRange (System.Collections.Generic.IEnumerable1[T] items) [0x0003d] in <4e0b4fa81dd04effbc4e22d8fabefb81>:0 at System.Collections.Generic.EnumerableHelpers.ToArray[T] (System.Collections.Generic.IEnumerable1[T] source) [0x00033] in <4e0b4fa81dd04effbc4e22d8fabefb81>:0
at System.Linq.Enumerable.ToArray[TSource] (System.Collections.Generic.IEnumerable1[T] source) [0x00018] in <4e0b4fa81dd04effbc4e22d8fabefb81>:0 at Duplicati.Server.Database.Connection.ReadFromDb[T] (System.Func2[T,TResult] f, System.String sql, System.Object args) [0x0004f] in <17916a3bd21d425da6aeece2c5428e16>:0
at Duplicati.Server.Database.Connection.IsUnencryptedOrPassphraseStored (System.Int64 id) [0x00011] in <17916a3bd21d425da6aeece2c5428e16>:0
at Duplicati.Server.WebServer.RESTMethods.Backups+<>c__DisplayClass1_0.b__0 (Duplicati.Server.Serialization.Interface.IBackup n) [0x00028] in <17916a3bd21d425da6aeece2c5428e16>:0
at System.Linq.Enumerable+SelectArrayIterator2[TSource,TResult].ToArray () [0x00012] in <4e0b4fa81dd04effbc4e22d8fabefb81>:0 at System.Linq.Enumerable.ToArray[TSource] (System.Collections.Generic.IEnumerable1[T] source) [0x0001f] in <4e0b4fa81dd04effbc4e22d8fabefb81>:0
at Duplicati.Server.WebServer.RESTMethods.Backups.GET (System.String key, Duplicati.Server.WebServer.RESTMethods.RequestInfo info) [0x00038] in <17916a3bd21d425da6aeece2c5428e16>:0
at Duplicati.Server.WebServer.RESTHandler.DoProcess (Duplicati.Server.WebServer.RESTMethods.RequestInfo info, System.String method, System.String module, System.String key) [0x00146] in <17916a3bd21d425da6aeece2c5428e16>:0
I’ve got both
- mono6.8-6.8.0.123_3
- sqlite3-3.46.0,1
installed for running Duplicati - 2.0.8.1_beta_2024-05-07
Any help in troubleshooting this would be very much appreciated.
Thanks a lot in advance!