[GNC] .log files with sqlite backend

[David T.]

Alen,
I think you have identified a potentially significant issue with log files and sql data files.  Specifically, with xml files, full snapshots are saved periodically, and log files are paired with these snapshots to enable a user to "replay" actions to recover a previous state. 
It is unclear what log file playback would do to an sql data file, since the only saved file is constantly updated. I worry that it would result in a corrupted file, since I imagine it would in essence reapply a subset of transactions onto the file. 
I'd be happy to be told I am wrong, but if this would be the result, perhaps it would be advisable for gnucash not to create log files for any sql back end. 
David

 
 
  On Wed, Apr 18, 2018 at 12:14, cicko<alen.siljak at gmx.com> wrote:   While I was using xml backend in the past couple of weeks, I finally realized
how backup files and .log files work. I really like the scheme as, before
that, I had a script that creates backups of sqlite book in the same manner
(and deletes the .log files).

Now, back to using sqlite book, I notice the difference: the .log files get
created but not the backup files. Is this intentional or accidental?

I guess it is still possible to replay the .log files that contain the
missing transactions (in case of an error). Has anyone actually tried this
with an sqlite book?

It's just that the automatic backup files are not generated. For this I have
a Python script that does exactly the same as xml backup - it appends the
date/time to the file name and copies it to the backup folder, and keeps the
last n copies. I should probably redo that to work based on time and keep
last n days, for example.

Just looking to get some background info to confirm the best recovery
procedure in case of a failure.
Cheers



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.