Suddenly getting this: SQLite error cannot commit - no transaction is active

Support
1

SQLite error cannot commit - no transaction is active

And backup will not even start

Full error text:


Dec 21, 2021 3:13 AM: The operation Backup has failed with error: 
SQLite error cannot commit - no transaction is active

{"ClassName":"Mono.Data.Sqlite.SqliteException","Message":"SQLite error\r\ncannot commit - no transaction is active","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":"  
at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00084] in <83c72f6e53eb49f28420feee73a4aa07>:0 \n  
at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x0003d] in <83c72f6e53eb49f28420feee73a4aa07>:0 \n  
at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00104] in <83c72f6e53eb49f28420feee73a4aa07>:0 \n  
at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x0004e] in <83c72f6e53eb49f28420feee73a4aa07>:0 \n  
at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader..ctor(Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)\n  
at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <83c72f6e53eb49f28420feee73a4aa07>:0 \n  
at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <83c72f6e53eb49f28420feee73a4aa07>:0 \n  
at Mono.Data.Sqlite.SqliteTransaction.Commit () [0x0002e] in <83c72f6e53eb49f28420feee73a4aa07>:0 \n  
at Duplicati.Library.Main.Operation.Common.DatabaseCommon.Dispose (System.Boolean isDisposing) [0x0000f] in <e60bc008dd1b454d861cfacbdd3760b9>:0 \n  
at Duplicati.Library.Main.Operation.Common.SingleRunner.Dispose () [0x00000] in <e60bc008dd1b454d861cfacbdd3760b9>:0 \n  
at Duplicati.Library.Main.Operation.BackupHandler.RunAsync (System.String[] sources, Duplicati.Library.Utility.IFilter filter, System.Threading.CancellationToken token) [0x01048] in <e60bc008dd1b454d861cfacbdd3760b9>:0 \n  
at CoCoL.ChannelExtensions.WaitForTaskOrThrow (System.Threading.Tasks.Task task) [0x00050] in <9a758ff4db6c48d6b3d4d0e5c2adf6d1>:0 \n  
at Duplicati.Library.Main.Operation.BackupHandler.Run (System.String[] sources, Duplicati.Library.Utility.IFilter filter, System.Threading.CancellationToken token) [0x00009] in <e60bc008dd1b454d861cfacbdd3760b9>:0 \n  
at Duplicati.Library.Main.Controller+<>c__DisplayClass14_0.<Backup>b__0 (Duplicati.Library.Main.BackupResults result) [0x0004b] in <e60bc008dd1b454d861cfacbdd3760b9>:0 \n  
at Duplicati.Library.Main.Controller.RunAction[T] (T result, System.String[]& paths, Duplicati.Library.Utility.IFilter& filter, System.Action`1[T] method) [0x0026f] in <e60bc008dd1b454d861cfacbdd3760b9>:0 \n  
at Duplicati.Library.Main.Controller.Backup (System.String[] inputsources, Duplicati.Library.Utility.IFilter filter) [0x00074] in <e60bc008dd1b454d861cfacbdd3760b9>:0 \n  
at Duplicati.Server.Runner.Run (Duplicati.Server.Runner+IRunnerData data, System.Boolean fromQueue) [0x00349] in <156011ea63b34859b4073abdbf0b1573>:0 ","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":null,"HResult":-2147467259,"Source":"mscorlib"}

Anything to try or poke at? Or is this just time for the old flush&fill?

2

nevermind - I am flushing and filling, taking this opportunity to up my blocksize from 100K to 5M

3

I see you’ve opted to start over, but just in case here is another thread mentioning this issue, and the root cause was lack of free space on the filesystem hosting the sqlite database:

4

Noted. I don’t think that was my situation here but it sorta maybe coulda been.

To be safe, I have now moved the DB to a very large partition.

Thanks