Windows 11 Pro ver. 10.0.22631, build 22631 *(upgraded from Windows 10 originally) *
I have a mapped drive to a Synology DS220j NAS running 2 disk drives that are mirrored.
My .rmtree and all backup files are located on that mapped drive. The rootsmagic.exe is run from my laptop local C: drive.
I typically have many applications open and running at the same time. For example, MS Outlook, Excel, Word, TextPad, FastStone Image Viewer and File explorer.
The issue:
Whenever I leave Roots Magic open and running overnight (meaning, not closing out the application)…which is basically every day, the next time I try to work in Roots Magic, I get the following SQlite error 10 error:
And have to end the process in the task manager, in order to re-open Roots Magic to be able to use it again.
I’ve tried running the database clean-up tools in File > Tools > Test Integrity / Rebuild Indexes / Clean Phantom Records and I do not have any cloud file storage (ex. one drive, etc) running.
The built-in Windows Firewall is not set to scan or monitor the mapped drive. Even if I stop, or suspend the firewall, the error still occurs.
More of a suspicion or a wild guess than an idea. The short answer is that if an RM database is on a home network that is synced in any way, then the database can be just as at risk as is an RM database that is synced to the Internet cloud. The wild guess is that the Synology device’s mirroring process has the exact same risk.
I suspect that the Synology device’s mirroring process is reading the “primary” drive in the middle of the night and writing data to the “mirror” drive. I suspect that the mirroring algorithm works very hard to make sure to mirror only when there is little or no disk activity so as not to interfere in any way with computer’s access to the “primary” drive". It’s certainly possible for RM to be slightly active in the middle of the night, doing things like looking for Web hints or looking for RM updates or looking for RM announcement to users. There may be other things that RM is doing in the middle of the night. So the “primary” device may seem idle to the mirroring process but not idle enough to be safe.
I would grant my wild idea seems highly improbable for a problem such as you describe. But it’s the only thing I can think of. If I were in your situation, I would move my RM database and only my RM database off of the Synology device.
I have a Synology Network drives, The Mirror functionality writes to BOTH drives at the same time.
I suspect the issue is as stated above, being the fact that the database is on a Network Drive, it may be going into a ‘Power Save’ state overnight and may actually go offline to Windows and only reconnect when accessed again. (I sometimes see a slight delay on the first access in the morning)
It is also not recommended to keep the Live Database and Backup on the same Drive or Mirror/Raid set because if the electronics/controller developes a fault, you have lost both copies.
OK, my guess.
My understanding is that most (all?) NAS servers/drives use Linux as their OS and probably use Samba as the SMB file share system.
There has been lots written about Samba not doing file locking correctly. It may be related to that.
I used windows file share from a Win 10 machine and it worked fine- except for being slow, - and I didn’t leave it open for long periods. (Did any of the machines go into sleep mode- just to complicate the situation?).
Thanks for the link to the documentation on SQLite. I guess I was just subconsciously working off decades of working with MySQL backed applications for client/server writes.
