Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread John Ralls
Colin, Maybe a problem with your book. I just did the same exercise (stepping in the debugger to make sure that everything was getting called in the right places, it is) and didn't get any such errors. Regards, John Ralls > On Apr 20, 2019, at 8:49 AM, Colin Law wrote: > > I thought I would

Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread Colin Law
I thought I would try this with 3.5 on Ubuntu 18.10. Using Save As repeatedly to sqlite3 does not result in locked files. I can go back and open the previous versions without issue. However, when saving to sqlite, which I don't normally, I do see in the trace file * 16:43:29 ERROR [error_handler

Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread mc
Geert I assume the state files are the .gcm files in ~/.local/share/gnucash/ But, I never change the names of the underlying files, yet still, frequently when I open a previous version, I will lose the tabs, nd just get the default "Accounts" tab. Was just trying to test it to see if I could es

Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread mc
Thanks John The SQL locks are in a table inside the database, not in a separate file" That would mean there is one for each gnucash file.  Good to know. "How are you creating these "earlier saved versions"" Just with "save as". Then I do some more changes, then do another "save as" with a higher

Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread Geert Janssens
Op zaterdag 20 april 2019 17:08:02 CEST schreef Adrien Monteleone: > I figured the lock was in the db, but wasn’t certain. > > I just tested with my current data file: > > Clean exit via GnuCash > Quit GnuCash > Copy & Rename file to `test-1234.gnucash` > Re-open GnuCash > File > Open > `test-123

Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread Adrien Monteleone
I figured the lock was in the db, but wasn’t certain. I just tested with my current data file: Clean exit via GnuCash > Quit GnuCash Copy & Rename file to `test-1234.gnucash` Re-open GnuCash File > Open > `test-1234.gnucash` The file opened fine, save none of the open tabs from when I exited wer

Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread John Ralls
> On Apr 20, 2019, at 5:58 AM, mc wrote: > > Config: > gnucash 3.5 clean install. > (X)ubuntu Linux 18.04 > gnucash files saved as sqlite. > > Am new to gnucash and testing it. > > I keep several versions of a gnucash file, > saved with names like --.gnucash > > After cleanly exiting gnucas

Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread Adrien Monteleone
Good question, I use SQLite3 also, and there are no .LCK files in my data directory. (they might be placed elsewhere as I’m on MacOS) But I’ve never had an issue opening other files than my current one. The only thing I noticed was that you mentioned you cleanly exited before opening one of th

[GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread mc
Config: gnucash 3.5 clean install. (X)ubuntu Linux 18.04 gnucash files saved as sqlite. Am new to gnucash and testing it. I keep several versions of a gnucash file, saved with names like --.gnucash After cleanly exiting gnucash by a normal Quit,, I may try to open an earlier saved version. I fr