SQLite Error 11: database disk image is malformed
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: SQLite Error 11: database disk image is malformed
Thanks for sharing the details! Do you know how this "hot-swapping" of the notebook happened? Was it because of Dropbox?
Alex
-
- Posts: 23
- Joined: Sat Aug 09, 2014 5:18 pm
- Contact:
Re: SQLite Error 11: database disk image is malformed
It was from a Dropbox-like application (QSync client). It's not a problem with Dropbox as Dropbox always refuses to update the .db file until I close CintaNotes for a while (with the flip-side being it's a bit of a nuisance to update your notebook).
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: SQLite Error 11: database disk image is malformed
Thanks for the extra information! Do you have notebook disconnection active by the way ("notebook.disconnect.enabled" param in settings file)?
Alex
-
- Posts: 23
- Joined: Sat Aug 09, 2014 5:18 pm
- Contact:
Re: SQLite Error 11: database disk image is malformed
Yes "notebook.disconnect.enabled = 1" is in cintanotes.settings. Despite this, Dropbox hasn't worked for me for quite some time.
I think what is actually allowing QSync to replace the notebook out from under Cintanotes is the fact the notebook on one PC is stored and accessed via a Windows network SMB/CIFS share. Another error I have just got is
"class db::DatabaseException SQLite error 10: disk I/O error"
Which repeatedly pops up with only one button (OK), at least 30 or so times. I suspect this is either to do with the network share or QSync, I'm unsure. Either way, the notebook appears to be just fine.
I think what is actually allowing QSync to replace the notebook out from under Cintanotes is the fact the notebook on one PC is stored and accessed via a Windows network SMB/CIFS share. Another error I have just got is
"class db::DatabaseException SQLite error 10: disk I/O error"
Which repeatedly pops up with only one button (OK), at least 30 or so times. I suspect this is either to do with the network share or QSync, I'm unsure. Either way, the notebook appears to be just fine.
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: SQLite Error 11: database disk image is malformed
Oh, network share is a whole different story that opens up a lot of possibilities for subtle bugs, so you need to be extra careful when using CN like that. Note that this is not officially supported, although seems to work most of the time. Better make sure there are a lot of regular backups done!
Alex