Repair database fails

#1

I was previously running duplicati in a freenas jail. I have now migrated to an ubuntu VM and exported my config from the jail and imported it in to the new VM.

I have been unable to complete a backup since. I get the following error regarding a database missing a bunch of files and needing repairing. I have tried running the repair which fails every time, i then tried the delete and recreate which is now giving the below error

The database was attempted repaired, but the repair did not complete. This database may be incomplete and the repair process is not allowed to alter remote files as that could result in data loss.

The backup is around 3tb in size and is to google drive.
I still have the jail so can grab files from that. How can i fix my backup?

EDIT:

Duplicati: Duplicati.Server, Version=2.0.4.5, Culture=neutral, PublicKeyToken=null (Duplicati.Library.Main, Version=2.0.4.5, Culture=neutral, PublicKeyToken=null)
Autoupdate urls: https://updates.duplicati.com/beta/latest.manifest;https://alt.updates.duplicati.com/beta/latest.manifest
Update folder: /usr/share/Duplicati/updates
Base install folder: /usr/lib/duplicati
Version name: "2.0.4.5_beta_2018-11-28" (2.0.4.5)
Current Version folder /usr/lib/duplicati
OS: Unix 4.15.0.46
Uname: Linux mgc-offsite 4.15.0-46-generic #49-Ubuntu SMP Wed Feb 6 09:33:07 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
64bit: True (True)
Machinename: mgc-offsite
Processors: 4
.Net Version: 4.0.30319.42000
Mono: True (4.6.2) (4.6.2 (Debian 4.6.2.7+dfsg-1ubuntu1))
Locale: en-US, en-US, en-US
Date/time strings: dddd, MMMM d, yyyy - h:mm:ss tt
Tempdir: /tmp/
SQLite: 3.22.0 - Mono.Data.Sqlite.SqliteConnection
SQLite assembly: /usr/lib/mono/gac/Mono.Data.Sqlite/4.0.0.0__0738eb9f132ed756/Mono.Data.Sqlite.dll

Enabled email logging and received this:

Failed: The database was attempted repaired, but the repair did not complete. This database may be incomplete and the repair process is not allowed to alter remote files as that could result in data loss.
Details: Duplicati.Library.Interface.UserInformationException: The database was attempted repaired, but the repair did not complete. This database may be incomplete and the repair process is not allowed to alter remote files as that could result in data loss.
at Duplicati.Library.Main.Operation.RepairHandler.RunRepairRemote () [0x000cb] in <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Operation.RepairHandler.Run (Duplicati.Library.Utility.IFilter filter) [0x0016e] in <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Controller+<>c__DisplayClass17_0.<Repair>b__0 (Duplicati.Library.Main.RepairResults result) [0x0001c] in <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Controller.RunAction[T] (T result, System.String& paths, Duplicati.Library.Utility.IFilter& filter, System.Action`1[T] method) [0x0011d] in <c6c6871f516b48f59d88f9d731c3ea4d>:0

Log data:
2019-03-20 14:26:58 +00 - [Warning-Duplicati.Library.Main.Operation.RepairHandler-InProgressDatabase]: The database is marked as “in-progress” and may be incomplete

0 Likes

#2

The latest, I deleted the database and the initiated a repair - this appeared to work for around an hour and then crashed - error below. Repair will not work any further

Failed: Abort due to constraint violation
UNIQUE constraint failed: Remotevolume.Name, Remotevolume.State
Details: Mono.Data.Sqlite.SqliteException (0x80004005): Abort due to constraint violation
UNIQUE constraint failed: Remotevolume.Name, Remotevolume.State
at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00096] in <fe9fd999cd9f407db94500dce293e66f>:0
at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x00046] in <fe9fd999cd9f407db94500dce293e66f>:0
at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00129] in <fe9fd999cd9f407db94500dce293e66f>:0
at Mono.Data.Sqlite.SqliteDataReader…ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x00051] in <fe9fd999cd9f407db94500dce293e66f>: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 <fe9fd999cd9f407db94500dce293e66f>:0
at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in <fe9fd999cd9f407db94500dce293e66f>:0
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader () [0x00000] in <a566c189d19d4271ab58420d6f875b13>:0
at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteScalarInt64 (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Int64 defaultvalue, System.Object values) [0x00061] in <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteScalarInt64 (System.Data.IDbCommand self, System.Boolean writeLog, System.String cmd, System.Int64 defaultvalue) [0x00000] in <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteScalarInt64 (System.Data.IDbCommand self, System.Int64 defaultvalue) [0x00000] in <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Database.LocalDatabase.RegisterRemoteVolume (System.String name, Duplicati.Library.Main.RemoteVolumeType type, Duplicati.Library.Main.RemoteVolumeState state, System.Int64 size, System.TimeSpan deleteGraceTime, System.Data.IDbTransaction transaction) [0x000c5] in <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Database.LocalDatabase.RegisterRemoteVolume (System.String name, Duplicati.Library.Main.RemoteVolumeType type, System.Int64 size, Duplicati.Library.Main.RemoteVolumeState state) [0x0000d] in <c6c6871f516b48f59d88f9d731c3ea4d>: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) [0x0030e] in <c6c6871f516b48f59d88f9d731c3ea4d>: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 <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Operation.RepairHandler.RunRepairLocal (Duplicati.Library.Utility.IFilter filter) [0x000ba] in <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Operation.RepairHandler.Run (Duplicati.Library.Utility.IFilter filter) [0x00012] in <c6c6871f516b48f59d88f9d731c3ea4d>:0

at Duplicati.Library.Main.Controller+<>c__DisplayClass17_0.<Repair>b__0 (Duplicati.Library.Main.RepairResults result) [0x0001c] in <c6c6871f516b48f59d88f9d731c3ea4d>:0
at Duplicati.Library.Main.Controller.RunAction[T] (T result, System.String& paths, Duplicati.Library.Utility.IFilter& filter, System.Action`1[T] method) [0x0011d] in <c6c6871f516b48f59d88f9d731c3ea4d>:0

0 Likes