[GNC] Crash on account delete

[Xe Roy]

Thanks.
I'll go with MySQL.
Is there anything I need to do to force GnuCash to use MySQL other than simply do a SAVE AS to MySQL?


Sent from Outlook<http://aka.ms/weboutlook>

________________________________
From: gnucash-user <gnucash-user-bounces+xeroy=hotmail.com at gnucash.org> on behalf of Adrien Monteleone <adrien.monteleone at lusfiber.net>
Sent: Sunday, January 1, 2023 3:50 PM
To: gnucash-user at lists.gnucash.org <gnucash-user at lists.gnucash.org>
Subject: Re: [GNC] Crash on account delete

On 1/1/23 6:36 PM, Xe Roy wrote:
> I have the latest version 4.13 downloaded yesterday running on Windows 11 on AMD Ryzen 9 5950x.

Thanks for the clarification, and good to know you are up to date.

> I can't remember if the account I was trying to delete was the placeholder or the subaccount.

That makes it harder to try to duplicate, and it might be important, but
'til then...

> There were no transactions in the account or the subaccount.
Good to know. There otherwise shouldn't have been a loss of data, except...

> When I re-ran GnuCash I got the UNABLE TO OBTAIN LOCK error.
> The only option that worked was to ignore the error.
Usually the case after a crash, nothing out of the ordinary here,

> The lost transactions were in other accounts.
> I assume that when the program crashed, I lost everything since the last automatic save.
Highly likely.

Investigate your auto-save interval in the meantime. Maybe a shorter one
will help, or else:

Make a copy of your file and do some tests.

Recreate the accounts you desired to delete.

Do a manual save.

Delete the desired account(s)

What happens?

If you reproduce the crash, that's technically a good thing, because
you've not only identified a problem, you can reproduce it so the
developers can too, and most likely fix it. (the hard to reproduce stuff
is the most difficult to fix, because it can be nearly impossible to
figure out what the cause)

If all goes as expected, then I'd chalk it up to something weird. Not
necessarily 'not a bug' but not quite yet identifiable.

-----
Here's where one of the benefits of the various SQL backends kicks in,
as David H. mentioned : instant auto-save.

If you get a crash using one of them, you *may* only loose data pending
to be saved, not other transactions already committed. With the XML
format, you'll lose anything within the time window of your auto-save
preference.

Regards,
Adrien

_______________________________________________
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
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.