I’ve got a backup to a Google Cloud Storage bucket that’s been chugging along for at least a year, and suddenly a couple days ago started getting this error:
unknown error No transaction is active on this connection
Checking the system logs gives this:
Dec 23, 2021 2:15 PM: Failed while executing "Backup" with id: 6
code = Unknown (-1), message = System.Data.SQLite.SQLiteException (0x80004005): unknown error
No transaction is active on this connection
at System.Data.SQLite.SQLiteTransactionBase.IsValid(Boolean throwError)
at System.Data.SQLite.SQLiteTransaction.Commit()
at Duplicati.Library.Main.Operation.Common.DatabaseCommon.Dispose(Boolean isDisposing)
at Duplicati.Library.Main.Operation.BackupHandler.<RunAsync>d__20.MoveNext()
As to other relevant info and things that I’ve tried, I’m running the current beta (2.0.6.3_beta_2021-06-17) on Windows 10.
I basically have two identical backup sets, one that is pointing to the aforementioned Google Cloud Storage bucket, and the other that is pointing to a local external hard drive (and is working fine).
I set up a small test backup set to a different Google Cloud bucket, so it doesn’t seem to be a Google Cloud issue.
Of course, I’ve rebooted my system.
Running a repair results in the following, so I haven’t tried to recreate the database (yet):
Destination and database are synchronized, not making any changes
The drive where the database is located has 40 GB of free space.
“Create bug report” results in the following error:
Dec 23, 2021 2:32 PM: Failed while executing "CreateReport" with id: 6
System.IO.IOException: Data error (cyclic redundancy check).
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite, Boolean checkHost)
at Duplicati.Library.Main.Operation.CreateBugReportHandler.Run()
at Duplicati.Library.Main.Controller.RunAction[T](T result, String[]& paths, IFilter& filter, Action`1 method)
at Duplicati.Library.Main.Controller.CreateLogDatabase(String targetpath)
at Duplicati.Server.Runner.Run(IRunnerData data, Boolean fromQueue)
Per the suggestion here, I checked my drives with CrystalDiskInfo, and all is good.
Trying to “verify files” results in the following error:
code = IoErr (10), message = System.Data.SQLite.SQLiteException (0x800007FF): disk I/O error
disk I/O error
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteReader(IDbCommand self, Boolean writeLog, String cmd, Object[] values)
at Duplicati.Library.Main.Database.LocalDatabase.VerifyConsistency(Int64 blocksize, Int64 hashsize, Boolean verifyfilelists, IDbTransaction transaction)
at Duplicati.Library.Main.Operation.TestHandler.Run(Int64 samples)
at Duplicati.Library.Main.Controller.RunAction[T](T result, String[]& paths, IFilter& filter, Action`1 method)
at Duplicati.Library.Main.Controller.Test(Int64 samples)
at Duplicati.Server.Runner.Run(IRunnerData data, Boolean fromQueue)