It seems the default location for the sqlite database is /root/.config/Duplicati
This area of the filesystem has limited storage. I started getting Duplicati errors about “the database or disk is full”.
What is the correct way to change this location? I want to do it correctly so future Synology package updates won’t revert to the old location.
When I do move the database and correct this problem, will Duplicati properly recover? Or am I now at risk of database/backup corruption?
This part I’m not sure how to do with Synology. I am pretty new to their hardware so am not sure how apps are launched exactly. I am quite familiar with regular Linux but ultimately dind’t know how to modify this without it being undone by future package installs.
So for now I just made a symlink to where I moved the database files to. Will see if it works.
But what about my second question… how do I know that the database is OK after these out-of-space issues?
Edit- never mind, I see you mentioned it’s in advanced options!
I checked and the default appears to be /volume1/@appstore/Duplicati/temp/. On my system that would be fine since volume1 is the big array.
I had this problem too and manually changed the location to: /volume1/@appstore/Duplicati/SQLite-datafolder/RCTIOGLGOX.sqlite
Mono.Data.Sqlite.SqliteException (0x80004005): Insertion failed because the database is full
database or disk is full
at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00096] in <62e44d67e13348a795e30fd7dd8622df>:0
at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x00046] in <62e44d67e13348a795e30fd7dd8622df>:0
at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00129] in <62e44d67e13348a795e30fd7dd8622df>:0
at Mono.Data.Sqlite.SqliteDataReader…ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x00051] in <62e44d67e13348a795e30fd7dd8622df>: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 <62e44d67e13348a795e30fd7dd8622df>:0
at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery () [0x00000] in <62e44d67e13348a795e30fd7dd8622df>:0
at Duplicati.Library.Main.Database.ExtensionMethods.ExecuteNonQuery (System.Data.IDbCommand self, System.String cmd, System.Object values) [0x0004e] in <118ad25945a24a3991f7b65e7a45ea1e>:0
at Duplicati.Library.Main.Database.LocalDatabase.Vacuum () [0x0000c] in <118ad25945a24a3991f7b65e7a45ea1e>:0
at Duplicati.Library.Main.Database.LocalDatabase.PurgeLogData (System.DateTime threshold) [0x00072] in <118ad25945a24a3991f7b65e7a45ea1e>:0
at Duplicati.Library.Main.Operation.BackupHandler.Run (System.String sources, Duplicati.Library.Utility.IFilter filter) [0x0082a] in <118ad25945a24a3991f7b65e7a45ea1e>:0
I just created the folder “SQLite-datafolder” in /volume1/@appstore/Duplicati/ (default installation location of Duplicati) and then changed the “Local database path:” to this (/volume1/@appstore/Duplicati/SQLite-datafolder/RCTIOGLGOX.sqlite) location in the backup task settings.
I was a bit hesitant to put my database there because I don’t know how Synology handles package uninstalls. Like if I uninstall to put on a newer version, I’d hate for it to wipe out the whole folder. I might test this when I upgrade my Synology Duplicati version. Place an extra dummy file there to see if it gets nuked.
I have been reading through this thread and what I am not sure of is after you manually move the database, how do you get Duplicati to find it? Here is my scenario. I could not run Duplicati and my Synology was failing to run properly because my backup databases in the default location were taking up too much space. I manually moved them out of the default location to a /volume1/ directory. However, all of my configured backups no longer show on the Home tab and I would prefer to not rebackup everything? How do I get Duplicati to find the DBs where I moved them? Or do I just need to start from scratch?