[GNC] Upgrade to 3.x Save As (sqlite3) failing with data corruption error

[salex]

I've been trying to set up a procedure where two people can access our XML
file located on a file server and of course ran into problems and know there
are other possible problem (file marked open if you loose the network - yes
I know its single user) 

My tests last week seemed to work, but I've been cautious. There may be
potential problems in that I'm on a Mac and the other user will be on
Windows 10.  Then the file server is a debian server.

I noticed that the Windows version 3.x and I was using 2.6.4.  Also noticed
that the windows version had Postgres option. I download the new version
using brew cask wanting to try postgres for my report system,

I've been using a procedure for years that now seems broken.

I update the main book on a Mac (using xml). A few times a month I do a
"Save As" and save off an sqlite3 version in another folder inside my
GnuCash folder. I immediately open the xml version and quit.

I then run a bash script to backup the folder(rsync) to the debian server.

The sqlite3 file is used by a Rails server to produce reports I've
developed.

I figured we'd use a modified procedure in that the updates would use the
XML version on the debian server (maybe a script to check dates or see if
file is open). I'd also put in a cron task to backup the folder to another
offsite server.

Since I was on the server, when I did my "Save As", it was in the same file
system. I alway just did the save as over the existing version since its
just a read only file ( just confirm overwrite message)

When I did that with 3.x, after confirming overwrite, I'd get an error
message saying it could complete because of data corruption.

Don't know if this is 3.x problem or not.  Switched back to 2.6 and it
worked, even working on the server version.

Before I switched back to 2.6, I did the save as on my mac and copied the
file the the server, I haven't verified this but my report system broke. I
got no errors but a simple checkbook register had a balance but do ledger
lines.

Have not tried the Windows version - I don't like to touch those systems if
I can avoid it.

If there is a problem with accessing the same data file from different
system, I just may have tho keep the file on windows and VNC into it.

Steve Alex



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html