[GNC] Sluggish after 5.13

[Xe Roy]

John Ralls,

That did the trick!

Thanks!

On 10/31/2025 11:32 AM, John Ralls wrote:
> I merged Sherlock’s PR yesterday so it should be included in today’s 
> nightly: 
> https://code.gnucash.org/builds/win32/stable/gnucash-5.13-2025-10-31-git-5.13-32-g3956d7e52f+.setup.exe 
>
>
> If you haven’t already, please try that. If you have and it still 
> doesn’t open your SQLite3 file then we have some more work to do.
>
> Regards,
> John Ralls
>
>
>> On Oct 31, 2025, at 07:54, Xe Roy <xeroy at hotmail.com> wrote:
>>
>> I still cannot use gnucash.
>>
>> Should I keep downloading the latest stable version or is the "No 
>> suitable backend was found for [sqlite3.gnucash file]" not on the fix 
>> list any time soon?
>>
>> Or should I just fall back to 5.12?
>>
>> If I install 5.12, will it overwrite 5.13?
>>
>>
>>
>> -------- Forwarded Message --------
>> Subject: Re: [GNC] Sluggish after 5.13
>> Date: Thu, 30 Oct 2025 11:11:42 -0700
>> From: John Ralls <jralls at ceridwen.us>
>> To: Sherlock <sh025622 at gmail.com>
>> CC: gnucash-user at lists.gnucash.org
>>
>>
>>
>> Sherlock,
>>
>> Fixing the code is always the right answer. Setting GNC_DBD_DIR in 
>> the Mac bundle file does no harm so there’s no rush to remove it.
>>
>> Regards,
>> John Ralls
>>
>>> On Oct 30, 2025, at 10:31 AM, Sherlock <sh025622 at gmail.com> wrote:
>>>
>>> John,
>>>
>>> Thanks. That explains why only Windows appears broken.
>>>
>>> So, is the intent to use GNC_DBD_DIR on Windows as well or should we 
>>> fix the code and not use GNC_DBD_DIR to work around the issue on Mac?
>>>
>>> Regards,
>>>
>>> Sherlock
>>>
>>>
>>> On 10/30/25 8:28 AM, John Ralls wrote:
>>>> Sherlock,
>>>> It doesn’t affect the Mac Bundle because that defines GNC_DBD_DIR 
>>>> to point to the bundle’s Resources/lib/dbd in the environment file.
>>>> Mingw64 doesn’t provide libdbi so it’s built by jhbuild. We set the 
>>>> dbd-driver directory to the installation prefix, 
>>>> https://github.com/Gnucash/gnucash-on-windows/blob/668227c9651224bd0a0f9ce87713546ccfca9af8/jhbuildrc.in#L82.
>>>> Regards,
>>>> John Ralls
>>>>> On Oct 29, 2025, at 20:02, Sherlock <sh025622 at gmail.com> wrote:
>>>>>
>>>>> I've been trying to understand why this hasn't been an issue on 
>>>>> the other platforms that have been on libdbi 0.9.1 for sometime. 
>>>>> The generic bug was introduced 2 years ago (commit b011c81). I 
>>>>> suspect the issue isn't seen on Linux where libdbi is installed in 
>>>>> the system location or on a Mac build machine. I think the issue 
>>>>> should appear on non-build Macs but, of course, the issue won't be 
>>>>> apparent to a user unless they aren't using the xml format.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Sherlock
>>>>>
>>>>> On 10/29/25 6:54 PM, Sherlock wrote:
>>>>>> I maybe wrong about the c:\libdbi\lib\dbd folder as there are 
>>>>>> compile time definition that will override the location which 
>>>>>> appears to be something like /mingw32/lib/dbd but that should 
>>>>>> still typically miss in a typical user's gnucash installation.
>>>>>> Setting GNC_DBD_DIR to something like C:\Program Files 
>>>>>> (x86)\gnucash\lib\dbd should work around the issue.
>>>>>> Regards,
>>>>>> Sherlock
>>>>>> On 10/29/25 4:32 PM, Sherlock wrote:
>>>>>>> Hi John,
>>>>>>>
>>>>>>> I suspect the Windows nightly builds have not been properly 
>>>>>>> supporting databases since libdbi was updated to 0.9.1 on 
>>>>>>> October 5th unless the drivers are in the c:\libdbi\lib\dbd 
>>>>>>> folder or the folder to which the GNC_DBD_DIR environment 
>>>>>>> variable is set.
>>>>>>>
>>>>>>> For example, attempt to save as sqlite3.
>>>>>>>
>>>>>>> It appears there is a generic bug in 
>>>>>>> gnc_module_init_backend_dbi() when HAVE_LIBDBI_R is defined. 
>>>>>>> Specifically, when the initial dbi_initialize_r() returns no 
>>>>>>> drivers, the dbi_instance variable is still set.
>>>>>>>
>>>>>>> So, instead of:
>>>>>>>
>>>>>>> #if HAVE_LIBDBI_R
>>>>>>> if (dbi_instance)
>>>>>>> return;
>>>>>>> #endif
>>>>>>>
>>>>>>> the code should be:
>>>>>>>
>>>>>>> #if HAVE_LIBDBI_R
>>>>>>> if (dbi_instance)
>>>>>>> {
>>>>>>> dbi_shutdown_r (dbi_instance);
>>>>>>> dbi_instance = nullptr;
>>>>>>> }
>>>>>>> #endif
>>>>>>>
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> Sherlock
>>>>>>>
>>>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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.
>>
>> _______________________________________________
>> 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.
>> _______________________________________________
>> 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.
>