I am getting the following message when trying to review the error messages from my backup (the pop up that comes up on the bottom center of the scree).
“Failed to connect: SQLite error no such table: LogData”
The db for the actual backup is not in the default location, but is correct. I can see some logs when I click on “Logs” on the left hand side, but not when I click on “Show” on the message that pops up after a backup. Seems to be happening to all backups… I am trying to resolve some inconsistencies with the backups.
Anyone got any ideas to resolve this error?
Also always getting “connection lost” not a big issue, just gets annoying. By the way, this is installed on my Synology NAS…
here is what I see in my logs (all are dated today)…
Dec 10, 2017 8:46 AM: Request for http://192.168.3.7:5000/api/v1/backup/8/log?pagesize=100 gave error
Mono.Data.Sqlite.SqliteException (0x80004005): SQLite error
no such table: LogData
at Mono.Data.Sqlite.SQLite3.Prepare (Mono.Data.Sqlite.SqliteConnection cnn, System.String strSql, Mono.Data.Sqlite.SqliteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x00236] in <62e44d67e13348a795e30fd7dd8622df>:0
at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00059] in <62e44d67e13348a795e30fd7dd8622df>:0
Dec 10, 2017 8:46 AM: Reporting error gave error
System.ObjectDisposedException: Cannot write to a closed TextWriter.
at System.IO.StreamWriter.Flush (System.Boolean flushStream, System.Boolean flushEncoder) [0x0000b] in <8f2c484307284b51944a1a13a14c0266>:0
at System.IO.StreamWriter.Flush () [0x00006] in <8f2c484307284b51944a1a13a14c0266>:0
at Duplicati.Server.WebServer.RESTHandler.DoProcess (Duplicati.Server.WebServer.RESTMethods.RequestInfo info, System.String method, System.String module, System.String key) [0x003aa] in :0
Dec 10, 2017 8:44 AM: Request for http://192.168.3.7:5000/api/v1/backup/11/log?pagesize=100 gave error
Mono.Data.Sqlite.SqliteException (0x80004005): SQLite error
no such table: LogData
at Mono.Data.Sqlite.SQLite3.Prepare (Mono.Data.Sqlite.SqliteConnection cnn, System.String strSql, Mono.Data.Sqlite.SqliteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x00236] in <62e44d67e13348a795e30fd7dd8622df>:0
at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00059] in <62e44d67e13348a795e30fd7dd8622df>:0
Dec 10, 2017 8:44 AM: Reporting error gave error
System.ObjectDisposedException: Cannot write to a closed TextWriter.
at System.IO.StreamWriter.Flush (System.Boolean flushStream, System.Boolean flushEncoder) [0x0000b] in <8f2c484307284b51944a1a13a14c0266>:0
at System.IO.StreamWriter.Flush () [0x00006] in <8f2c484307284b51944a1a13a14c0266>:0
at Duplicati.Server.WebServer.RESTHandler.DoProcess (Duplicati.Server.WebServer.RESTMethods.RequestInfo info, System.String method, System.String module, System.String key) [0x003aa] in :0
Dec 10, 2017 8:35 AM: Reporting error gave error
System.ObjectDisposedException: Cannot write to a closed TextWriter.
at System.IO.StreamWriter.Flush (System.Boolean flushStream, System.Boolean flushEncoder) [0x0000b] in <8f2c484307284b51944a1a13a14c0266>:0
at System.IO.StreamWriter.Flush () [0x00006] in <8f2c484307284b51944a1a13a14c0266>:0
at Duplicati.Server.WebServer.RESTHandler.DoProcess (Duplicati.Server.WebServer.RESTMethods.RequestInfo info, System.String method, System.String module, System.String key) [0x003aa] in :0
Dec 10, 2017 8:35 AM: Request for http://192.168.3.7:5000/api/v1/backup/5/log?pagesize=100 gave error
Mono.Data.Sqlite.SqliteException (0x80004005): SQLite error
no such table: LogData
at Mono.Data.Sqlite.SQLite3.Prepare (Mono.Data.Sqlite.SqliteConnection cnn, System.String strSql, Mono.Data.Sqlite.SqliteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x00236] in <62e44d67e13348a795e30fd7dd8622df>:0
at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00059] in <62e44d67e13348a795e30fd7dd8622df>:0
Let me know if you need any other info or logs… Thanks for your help
Sorry for the delay… I am running it on a Synology NAS. But exporting and opening it, id is 9… Not sure what default port is… 8200, 8300, 8400, 8500 not working… From what I read, 8200 is default but might be higher. Am I wrong?
I should note, and realized, I made one job, exported it, and edited the files, then imported them… Should I edit the IDs and re-order it? It looks like it changed it automatically.
The Connection lost is kind of irritating, is there a reason I keep getting that when working with the jobs?
This is an old thread, but I just encountered almost exactly the same error. The olnly difference is that the message is: “Failed to connect: SQL logic error or missing database no such table: LogData”. New Duplicati installation on PC Windows 10 1803 x64, backing up to a “local” folder that’s actually a QNAP NAS folder, using \NAS0\folder syntax. Database and temporary path folders are custom using Advanced Options.
Was there ever a resolution of this problem please? Thanks!
The “no such table: LogData” error usually happens in the rare case where you have a new job where an error / warning happens BEFORE the database has been fully populated. Since the LogData table hasn’t yet been created attempting to log the event causes a critical error resulting in what you experienced.
Of course I could be wrong and there is something else going on - can you confirm that the message is “…SQL logic error…” as you posted and not “…SQLite error…” as the original post has?
Has this job ever run correctly (in which case maybe your custom database path is at fault) or has it always failed?
Yes, I cut and paste the message from the popup, so it is different from the original in this thread. The job ran correctly twice, but now fails consistently with this message. The backup itself appears correct. I’m still just testing before using Duplicati in anger, so no lost data here.
Deleting and rebuilding the database doesn’t fix the problem.
Just in case I’m doing something stupid, the dbpath is D:\Main\Duplicati\Secure\Secure.sqlite
Is this a forward-slash, backwards=slash thing perhaps?
I deleted the backup job, uninstalled Duplicati, deleted all files, and reinstalled Duplicati. The same problem occurred. When I create a new job that does NOT use a custom dpath, all is well.
That looks like a valid Windows path to me, so I don’t think that’s the issue.
If you go into the now working / non-customized dbpath job and use the Database link it should take you to a page with database maintenance type buttons on it.
Try changing the “Local database path” field to where you want the database to be stored then clicking the “Move existing database” button. Does that work (yay) or give you an error (perhaps the account Duplicati is running under doesn’t have permission to your “Secure” folder)?
So it sounds like either the manually entered custom dbpath wasn’t quite matching the actual one OR manually moving the file didn’t give the same permissions as having Duplicati do it.
Either way, I’ve flagged my post as the “Solution” - please let me know if you disagree.
