[GNC-dev] lock on MariaDb database

Bregt - ICTgroup.be bregt at ictgroup.be
Mon Mar 22 11:42:11 EDT 2021

Hi Derek,

I execute a clean exit (File -> exit). I indeed noticed before all this that the lock is not removed if for instance the (virtual) host is shut down while GnuCash is not properly exited, so ever since noticing that I perform a clean exit.


On 22/03/2021 16:37, Derek Atkins wrote:

> Hi,
> How are you exiting/quitting GnuCash?
> It should unlock on exit, if it exits cleanly.
> -derek
> On Mon, March 22, 2021 11:31 am, Bregt - ICTgroup.be via gnucash-devel wrote:
>> Hi,
>> I recently installed GnuCash 4.2 on an Ubuntu 20.04. I linked my data to
>> a database on an instance of a MariaDb server on the same host. All data
>> gets stored in the database as I expect, so far so good.
>> Last week I put up a master/master replication configuration between the
>> MariaDb server and a second MariaDb server on another host in my local
>> network, in order to have a backup (and some form of multi-user access,
>> but that's not what it's about right now). Replication works as
>> expected, so far so good.
>> I did notice however, that the lock on the database (the entry in table
>> gnclock) is set upon launching GnuCash, but is not deleted upon closing
>> GnuCash. This results in GnuCash asking me if I want to 'open anyway'
>> (ie overwrite the entry in gnclock) every time I launch GnuCash. Even
>> when detaching the primary MariaDb host from the local network, this
>> problem remains.
>> I did tamper with the database in order to test the replication: I
>> created a dummy table and upon seeing it getting replicated to my second
>> server, I deleted that table (and it got deleted on the replication
>> server too).
>> Anyone has an idea or a hint on how to get GnuCash to delete the entry
>> in table gnclock upon closing (as should happen and indeed happened
>> before configuring the replication)? Would my adding/deleting the dummy
>> table for the replication test have anything to do with this issue?
>> Kind regards,
>> Bregt
>> _______________________________________________
>> gnucash-devel mailing list
>> gnucash-devel at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> --
>        Derek Atkins                 617-623-3745
> derek at ihtfp.com
> www.ihtfp.com
> Computer and Internet Security Consultant

Met vriendelijke groet
Bregt - ICTgroup.be
bregt at ictgroup.be
Tel.: 050 96 71 58
ictgroup.be- IT in alle eenvoud
Have a nice day!

More information about the gnucash-devel mailing list