I’ve been trying to rebuild the database of my Fedora Server backup, but it keeps failing with “SQLite error cannot rollback - no transaction is active”.
I’ve tried “repair”, “recreate” and also “delete” then “repair” making sure the database file really deleted, and still the same. I’ve check disk space including increasing the size of /tmp and there is plenty. It always reaches the final fileset when I watch the verbose server logging. Any ideas?
Here’s the final error log:
11 Feb 2020 10:17: The operation Repair has failed with error: SQLite error cannot rollback - no transaction is active
{"ClassName":"Mono.Data.Sqlite.SqliteException","Message":"SQLite error cannot rollback - no transaction is active","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":" at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00096] in <5b5fb53ffa6a4c24837c4c8b9fbd2a0f>:0
at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x00046] in <5b5fb53ffa6a4c24837c4c8b9fbd2a0f>:0
at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00129] in <5b5fb53ffa6a4c24837c4c8b9fbd2a0f>:0
at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x00051] in <5b5fb53ffa6a4c24837c4c8b9fbd2a0f>: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 <5b5fb53ffa6a4c24837c4c8b9fbd2a0f>:0
at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <5b5fb53ffa6a4c24837c4c8b9fbd2a0f>:0
at Mono.Data.Sqlite.SqliteTransaction.IssueRollback (Mono.Data.Sqlite.SqliteConnection cnn) [0x00012] in <5b5fb53ffa6a4c24837c4c8b9fbd2a0f>:0
at Mono.Data.Sqlite.SqliteTransaction.Rollback () [0x00008] in <5b5fb53ffa6a4c24837c4c8b9fbd2a0f>:0
at Mono.Data.Sqlite.SqliteTransaction.Dispose (System.Boolean disposing) [0x0001e] in <5b5fb53ffa6a4c24837c4c8b9fbd2a0f>:0
at System.Data.Common.DbTransaction.Dispose () [0x00000] in <6fbeaa5ac81e46008e9fcd2981e30d56>:0
at Duplicati.Library.Main.Operation.RecreateDatabaseHandler.DoRun (Duplicati.Library.Main.Database.LocalDatabase dbparent, System.Boolean updating, Duplicati.Library.Utility.IFilter filter, Duplicati.Library.Main.Operation.RecreateDatabaseHandler+NumberedFilterFilelistDelegate filelistfilter, Duplicati.Library.Main.Operation.RecreateDatabaseHandler+BlockVolumePostProcessor blockprocessor) [0x00f14] in <45f00521e1e84c2c83156b62530c732c>:0
at Duplicati.Library.Main.Operation.RecreateDatabaseHandler.Run (System.String path, Duplicati.Library.Utility.IFilter filter, Duplicati.Library.Main.Operation.RecreateDatabaseHandler+NumberedFilterFilelistDelegate filelistfilter, Duplicati.Library.Main.Operation.RecreateDatabaseHandler+BlockVolumePostProcessor blockprocessor) [0x00037] in <45f00521e1e84c2c83156b62530c732c>:0
at Duplicati.Library.Main.Operation.RepairHandler.RunRepairLocal (Duplicati.Library.Utility.IFilter filter) [0x000ba] in <45f00521e1e84c2c83156b62530c732c>:0
at Duplicati.Library.Main.Operation.RepairHandler.Run (Duplicati.Library.Utility.IFilter filter) [0x00012] in <45f00521e1e84c2c83156b62530c732c>:0
at Duplicati.Library.Main.Controller+<>c__DisplayClass18_0.<Repair>b__0 (Duplicati.Library.Main.RepairResults result) [0x0001c] in <45f00521e1e84c2c83156b62530c732c>:0
at Duplicati.Library.Main.Controller.RunAction[T] (T result, System.String[]& paths, Duplicati.Library.Utility.IFilter& filter, System.Action`1[T] method) [0x0026f] in <45f00521e1e84c2c83156b62530c732c>:0
at Duplicati.Library.Main.Controller.RunAction[T] (T result, Duplicati.Library.Utility.IFilter& filter, System.Action`1[T] method) [0x00007] in <45f00521e1e84c2c83156b62530c732c>:0
at Duplicati.Library.Main.Controller.Repair (Duplicati.Library.Utility.IFilter filter) [0x0001a] in <45f00521e1e84c2c83156b62530c732c>:0
at Duplicati.Server.Runner.Run (Duplicati.Server.Runner+IRunnerData data, System.Boolean fromQueue) [0x003ad] in <e46664114891401e8f4656ccf8aa21a6>:0 ","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":null,"HResult":-2147467259,"Source":"Mono.Data.Sqlite"}
And these are the messages leading up to it:
11 Feb 2020 10:17: The operation Repair has failed with error: SQLite error cannot rollback - no transaction is active
11 Feb 2020 10:17: Running Repair took 0:03:28:36.377
11 Feb 2020 10:17: Recreate database for repair took 0:03:28:36.375
11 Feb 2020 10:17: ExecuteNonQuery: PRAGMA optimize took 0:00:00:00.039
11 Feb 2020 10:17: Starting - ExecuteNonQuery: PRAGMA optimize
11 Feb 2020 10:16: CommitRecreatedDb took 0:00:00:00.000
11 Feb 2020 10:16: Starting - CommitRecreatedDb