Ok, I got one for you talented folks. Working on Edit Person, click on photo, first screen comes up asking to select a photo, I click that button and “SQLite Error 13 - database or disk is full”. This happens on my file if I run in on RootsMagic to Go. It happens when the files are on my laptop. My database is under 4000 people total, plenty of space on my hard drive and on my usb drive when I run To-Go version. I have run all of the db tools successfully but this error will not go away. Everything else seems to work correctly. Just for fun, I ran RootsMagic as administrator just to check that. Still no difference. I had a look at the file in SQLite Expert but nothing jumped out at me. Running current version 10.0.3.0. Thoughts??
are the RM folder(s) or file(s) being synced to the cloud?
Close file, Close RM then reopen and run databases tools (after you make sure not being synched to OneDrive (or other).
no syncing. Ran the db tools. Same error. It is strange, I tried to export the data out of that file to a gedcom and it blew up with the same error. I can restore from a recent backup of that corrupted file and the new tree seems to work correctly but just trying to wrap my head around it. Even stranger, I also have Gramps installed on my machine that I use for various things in my tree and it is now throwing an error SQLite 3 error…very similar to this error. Methinks that something got seriously messed up. Good news is, I have my data and I have created backups of the new datbase already because I am just paranoid that way. I guess I will just press on with business.
On RM To-Go I would check if the USB Drive was failing. It could be a bad sector on your hard drive it that’s where the file originally came from.
if not syncing issue or bad sector as @rzamor1 said. The other possibly that comes to mind – do you have any programs that are defaulting and might be opening or accessing your RM database? Sounds like a possible index issue. (unless the available space is maybe less 10% or drive location).
What’s the OS?
Here’s the description of this error:
(13) SQLITE_FULL
The SQLITE_FULL result code indicates that a write could not complete because the disk is full. Note that this error can occur when trying to write information into the main database file, or it can also occur when writing into temporary disk files.
Sometimes applications encounter this error even though there is an abundance of primary disk space because the error occurs when writing into temporary disk files on a system where temporary files are stored on a separate partition with much less space that the primary disk.
That comment about temporary disk files is suggestive. Beside SQLite itself, RM creates temporary files for some operations. They may be in the same folder as the database, in an appdata folder (Windows), and maybe elsewhere.