Re: [GNC] Versions after 4.13 freeze in splash screen
Yesterday's tracefile showed a successful login to the `gnucash` database, today's shows a connection failure. Notice that after the login failure it didn't do anything except load the currencies, something that's hardcoded in GnuCash. Yesterday's got into a loop trying to run a scrub on budgets; that scrub is part of the 4.x->5.x upgrade process. The "Bad or corrupt database" error can indeed come from a login failure, but there are lots of other errors that can produce it and you have to look in the tracefile to see which one. Today's tracefile says: * 06:54:25 INFO [QofSessionImpl::load_backend] Selected provider GnuCash Libdbi (MYSQL) Backend * 06:54:25 INFO [error_handler] DBI error: 1045: Access denie d for user 'gnucash'@'localhost' (using password: YES) * 06:54:25 INFO [error_handler] Note: GbcDbiSqlConnection not yet initialized. Skipping further error processing. * 06:54:25 ERROR [GncDbiBackend::session_begin()] Unable to connect to database 'gnucash' That confirms that you have an authentication problem. If you're using the same userid for both the InitFin and gnucash databases maybe you just need to grant access to that user on the gnucash db. I'd like to know the circumstances surrounding the trading accounts creating transactions with no account. That would be a pretty bad bug. Regards, John Ralls > On Sep 11, 2023, at 10:22 PM, zuperkoleoptera > wrote: > > On Mon, 2023-09-11 at 13:23 -0700, John Ralls wrote: >> >> >>> On Sep 11, 2023, at 11:48 AM, John Ralls >>> wrote: >>> >>> >>> On Sep 11, 2023, at 11:23 AM, zuperkoleoptera wrote: To answer you questions (1) other than the register I keep always open another 5 tabs ( reports, views ) no other window open. (2) No I have not uninstalled AQBanking To add more into the mystery, I installed the flatpak and when I tried to open it it asked me for credentials. Since I maintain multiple dbs, for different entities, I entered a different db this time and gnucash opened it. When I tried to change back to my main db it produced the " The server at experienced an error or encountered bad or corrupt data". I know that my db is ok since I can still access it from the 4.13 installation. >>> >>> Interesting. Does that other DB open in the debian testing build of >>> GnuCash? >>> >>> There should be more detailed error information in the tracefile >>> about the connection failure and perhaps more information in your >>> MariaDB logs. >>> >>> What version of MariaDB are you running? We've had reports of >>> problems with MariaDB 11. >> >> >> Looking some more at your tracefile I think something else is going >> on, but I don't know what it might be. It seems to be repeating the >> budget-balance scrubs in between groups of 7 or 8 sets of AQBanking >> interface complaints; that would be one per open tab. >> >> Early on there are 356 errors from the load code about splits with no >> accounts, after which there are no messages from the backend. >> >> Regards, >> John Ralls >> > To answer your questions: > (1) mariadb version is 10.3.39, so no 11 > (2) Yes, now that I tried it, the debian build of gnucash opens the > other db as well. Furthermore, when trying to change from that db to > the other one and get again the bad or corrupt data error message. I am > attaching you the gnucash_trace file from that operation. The db that > opens is called InitFin while the other one is simply called gnucash. > (3) Furthermore, I am attaching you the log from mariadb. Strangely > there is only one line denying access to the user. Question, does the > corrupt or bad data message gets produced when wrong password is > entered? I haven't changed the user password but this message implies > that there is an authentication problem. > (4) Regarding the 356 no account errors, I think those come from the > trade accounts functionality that I have enabled and is prone to > produce transactions with no accounts under some circumstances. I do > not think that those are the problem. > > > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Versions after 4.13 freeze in splash screen
> On Sep 11, 2023, at 11:48 AM, John Ralls wrote: > > > >> On Sep 11, 2023, at 11:23 AM, zuperkoleoptera >> wrote: >> >> >> To answer you questions >> (1) other than the register I keep always open another 5 tabs ( >> reports, views ) no other window open. >> (2) No I have not uninstalled AQBanking >> >> To add more into the mystery, I installed the flatpak and when I tried >> to open it it asked me for credentials. Since I maintain multiple dbs, >> for different entities, I entered a different db this time and gnucash >> opened it. When I tried to change back to my main db it produced the " >> The server at experienced an error or encountered bad or corrupt >> data". I know that my db is ok since I can still access it from the >> 4.13 installation. > > Interesting. Does that other DB open in the debian testing build of GnuCash? > > There should be more detailed error information in the tracefile about the > connection failure and perhaps more information in your MariaDB logs. > > What version of MariaDB are you running? We've had reports of problems with > MariaDB 11. Looking some more at your tracefile I think something else is going on, but I don't know what it might be. It seems to be repeating the budget-balance scrubs in between groups of 7 or 8 sets of AQBanking interface complaints; that would be one per open tab. Early on there are 356 errors from the load code about splits with no accounts, after which there are no messages from the backend. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Versions after 4.13 freeze in splash screen
> On Sep 11, 2023, at 11:23 AM, zuperkoleoptera > wrote: > > On Mon, 2023-09-11 at 10:15 -0700, John Ralls wrote: >> >> >>> On Sep 11, 2023, at 9:33 AM, john wrote: >>> >>> >>> On Sep 11, 2023, at 09:24, zuperkoleoptera wrote: On Mon, 2023-09-11 at 09:13 -0700, john wrote: > > >> On Sep 11, 2023, at 02:29, zuperkoleoptera >> wrote: >> >> Hi, >> >> I use gnucash under Debian testing with the mariadb backend, >> through an >> ssh tunnel to a VPS I maintain. >> Version of the mariadb is 10.3.39. >> Everything worked as normal, until I upgraded in version 5.1 >> from >> 4.13 >> where gnucash seemed to start but then remained indefinitely >> in the >> splash screen occasionally bringing forward the "Gnucash not >> responding" error with the option to wait or to force quit >> it. >> If I pressed wait nothing happened until the error screen >> appeared >> again. >> >> I waited until gnucash version 5.3 was migrated to Debian >> testing >> but >> the issue has not been resolved. >> I have an older box with Debian testing that still runs 4.13 >> and is >> still operational, so for the time being I use that one. >> >> I am attaching the gnucash_trace file from the box with the >> 5.3 >> version. >> If needed I have the gnucash_trace also from the one running >> 4.13. >> >> Any ideas? >> __ >> _ > > The tracefile shows 10 minutes of > 10:59:29 INFO > [gnc_main_window_set_vis_of_items_by_action] Found menu_item > 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting > vis to > 'true' > > For most, but not all, of the AQBanking actions registered by > the > AQBanking plugin. I haven't yet tracked down why GnuCash would > get > stuck in a loop trying to load the plugin, but I guess there's > also a > packaging problem with the 5.x .deb that you're using. I can't > tell > you what it might be until I figure out what's causing the > loop. > > Regards, > John Ralls > Is there a way to disable AQBanking plugin in application start? I don't use it so I do not care. >>> >>> Not at runtime. GnuCash can be built without AQBanking support. >>> >>> You could try using the flatpak instead. >> >> Two more questions: Do you have a bazillion tabs or windows open? >> Have you uninstalled AQBanking because you don't use it? >> >> Regards, >> John Ralls > > To answer you questions > (1) other than the register I keep always open another 5 tabs ( > reports, views ) no other window open. > (2) No I have not uninstalled AQBanking > > To add more into the mystery, I installed the flatpak and when I tried > to open it it asked me for credentials. Since I maintain multiple dbs, > for different entities, I entered a different db this time and gnucash > opened it. When I tried to change back to my main db it produced the " > The server at experienced an error or encountered bad or corrupt > data". I know that my db is ok since I can still access it from the > 4.13 installation. Interesting. Does that other DB open in the debian testing build of GnuCash? There should be more detailed error information in the tracefile about the connection failure and perhaps more information in your MariaDB logs. What version of MariaDB are you running? We've had reports of problems with MariaDB 11. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Versions after 4.13 freeze in splash screen
On Mon, 2023-09-11 at 10:15 -0700, John Ralls wrote: > > > > On Sep 11, 2023, at 9:33 AM, john wrote: > > > > > > > > > On Sep 11, 2023, at 09:24, zuperkoleoptera > > > wrote: > > > > > > On Mon, 2023-09-11 at 09:13 -0700, john wrote: > > > > > > > > > > > > > On Sep 11, 2023, at 02:29, zuperkoleoptera > > > > > wrote: > > > > > > > > > > Hi, > > > > > > > > > > I use gnucash under Debian testing with the mariadb backend, > > > > > through an > > > > > ssh tunnel to a VPS I maintain. > > > > > Version of the mariadb is 10.3.39. > > > > > Everything worked as normal, until I upgraded in version 5.1 > > > > > from > > > > > 4.13 > > > > > where gnucash seemed to start but then remained indefinitely > > > > > in the > > > > > splash screen occasionally bringing forward the "Gnucash not > > > > > responding" error with the option to wait or to force quit > > > > > it. > > > > > If I pressed wait nothing happened until the error screen > > > > > appeared > > > > > again. > > > > > > > > > > I waited until gnucash version 5.3 was migrated to Debian > > > > > testing > > > > > but > > > > > the issue has not been resolved. > > > > > I have an older box with Debian testing that still runs 4.13 > > > > > and is > > > > > still operational, so for the time being I use that one. > > > > > > > > > > I am attaching the gnucash_trace file from the box with the > > > > > 5.3 > > > > > version. > > > > > If needed I have the gnucash_trace also from the one running > > > > > 4.13. > > > > > > > > > > Any ideas? > > > > > __ > > > > > _ > > > > > > > > The tracefile shows 10 minutes of > > > > 10:59:29 INFO > > > > [gnc_main_window_set_vis_of_items_by_action] Found menu_item > > > > 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting > > > > vis to > > > > 'true' > > > > > > > > For most, but not all, of the AQBanking actions registered by > > > > the > > > > AQBanking plugin. I haven't yet tracked down why GnuCash would > > > > get > > > > stuck in a loop trying to load the plugin, but I guess there's > > > > also a > > > > packaging problem with the 5.x .deb that you're using. I can't > > > > tell > > > > you what it might be until I figure out what's causing the > > > > loop. > > > > > > > > Regards, > > > > John Ralls > > > > > > > Is there a way to disable AQBanking plugin in application start? > > > I > > > don't use it so I do not care. > > > > Not at runtime. GnuCash can be built without AQBanking support. > > > > You could try using the flatpak instead. > > Two more questions: Do you have a bazillion tabs or windows open? > Have you uninstalled AQBanking because you don't use it? > > Regards, > John Ralls To answer you questions (1) other than the register I keep always open another 5 tabs ( reports, views ) no other window open. (2) No I have not uninstalled AQBanking To add more into the mystery, I installed the flatpak and when I tried to open it it asked me for credentials. Since I maintain multiple dbs, for different entities, I entered a different db this time and gnucash opened it. When I tried to change back to my main db it produced the " The server at experienced an error or encountered bad or corrupt data". I know that my db is ok since I can still access it from the 4.13 installation. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Versions after 4.13 freeze in splash screen
> On Sep 11, 2023, at 9:33 AM, john wrote: > > > >> On Sep 11, 2023, at 09:24, zuperkoleoptera wrote: >> >> On Mon, 2023-09-11 at 09:13 -0700, john wrote: >>> >>> On Sep 11, 2023, at 02:29, zuperkoleoptera wrote: Hi, I use gnucash under Debian testing with the mariadb backend, through an ssh tunnel to a VPS I maintain. Version of the mariadb is 10.3.39. Everything worked as normal, until I upgraded in version 5.1 from 4.13 where gnucash seemed to start but then remained indefinitely in the splash screen occasionally bringing forward the "Gnucash not responding" error with the option to wait or to force quit it. If I pressed wait nothing happened until the error screen appeared again. I waited until gnucash version 5.3 was migrated to Debian testing but the issue has not been resolved. I have an older box with Debian testing that still runs 4.13 and is still operational, so for the time being I use that one. I am attaching the gnucash_trace file from the box with the 5.3 version. If needed I have the gnucash_trace also from the one running 4.13. Any ideas? ___ >>> >>> The tracefile shows 10 minutes of >>> 10:59:29 INFO >>> [gnc_main_window_set_vis_of_items_by_action] Found menu_item >>> 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting vis to >>> 'true' >>> >>> For most, but not all, of the AQBanking actions registered by the >>> AQBanking plugin. I haven't yet tracked down why GnuCash would get >>> stuck in a loop trying to load the plugin, but I guess there's also a >>> packaging problem with the 5.x .deb that you're using. I can't tell >>> you what it might be until I figure out what's causing the loop. >>> >>> Regards, >>> John Ralls >>> >> Is there a way to disable AQBanking plugin in application start? I >> don't use it so I do not care. > > Not at runtime. GnuCash can be built without AQBanking support. > > You could try using the flatpak instead. Two more questions: Do you have a bazillion tabs or windows open? Have you uninstalled AQBanking because you don't use it? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Versions after 4.13 freeze in splash screen
> On Sep 11, 2023, at 09:24, zuperkoleoptera wrote: > > On Mon, 2023-09-11 at 09:13 -0700, john wrote: >> >> >>> On Sep 11, 2023, at 02:29, zuperkoleoptera >>> wrote: >>> >>> Hi, >>> >>> I use gnucash under Debian testing with the mariadb backend, >>> through an >>> ssh tunnel to a VPS I maintain. >>> Version of the mariadb is 10.3.39. >>> Everything worked as normal, until I upgraded in version 5.1 from >>> 4.13 >>> where gnucash seemed to start but then remained indefinitely in the >>> splash screen occasionally bringing forward the "Gnucash not >>> responding" error with the option to wait or to force quit it. >>> If I pressed wait nothing happened until the error screen appeared >>> again. >>> >>> I waited until gnucash version 5.3 was migrated to Debian testing >>> but >>> the issue has not been resolved. >>> I have an older box with Debian testing that still runs 4.13 and is >>> still operational, so for the time being I use that one. >>> >>> I am attaching the gnucash_trace file from the box with the 5.3 >>> version. >>> If needed I have the gnucash_trace also from the one running 4.13. >>> >>> Any ideas? >>> ___ >> >> The tracefile shows 10 minutes of >> 10:59:29 INFO >> [gnc_main_window_set_vis_of_items_by_action] Found menu_item >> 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting vis to >> 'true' >> >> For most, but not all, of the AQBanking actions registered by the >> AQBanking plugin. I haven't yet tracked down why GnuCash would get >> stuck in a loop trying to load the plugin, but I guess there's also a >> packaging problem with the 5.x .deb that you're using. I can't tell >> you what it might be until I figure out what's causing the loop. >> >> Regards, >> John Ralls >> > Is there a way to disable AQBanking plugin in application start? I > don't use it so I do not care. Not at runtime. GnuCash can be built without AQBanking support. You could try using the flatpak instead. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Versions after 4.13 freeze in splash screen
On Mon, 2023-09-11 at 09:13 -0700, john wrote: > > > > On Sep 11, 2023, at 02:29, zuperkoleoptera > > wrote: > > > > Hi, > > > > I use gnucash under Debian testing with the mariadb backend, > > through an > > ssh tunnel to a VPS I maintain. > > Version of the mariadb is 10.3.39. > > Everything worked as normal, until I upgraded in version 5.1 from > > 4.13 > > where gnucash seemed to start but then remained indefinitely in the > > splash screen occasionally bringing forward the "Gnucash not > > responding" error with the option to wait or to force quit it. > > If I pressed wait nothing happened until the error screen appeared > > again. > > > > I waited until gnucash version 5.3 was migrated to Debian testing > > but > > the issue has not been resolved. > > I have an older box with Debian testing that still runs 4.13 and is > > still operational, so for the time being I use that one. > > > > I am attaching the gnucash_trace file from the box with the 5.3 > > version. > > If needed I have the gnucash_trace also from the one running 4.13. > > > > Any ideas? > > ___ > > The tracefile shows 10 minutes of > 10:59:29 INFO > [gnc_main_window_set_vis_of_items_by_action] Found menu_item > 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting vis to > 'true' > > For most, but not all, of the AQBanking actions registered by the > AQBanking plugin. I haven't yet tracked down why GnuCash would get > stuck in a loop trying to load the plugin, but I guess there's also a > packaging problem with the 5.x .deb that you're using. I can't tell > you what it might be until I figure out what's causing the loop. > > Regards, > John Ralls > Is there a way to disable AQBanking plugin in application start? I don't use it so I do not care. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Versions after 4.13 freeze in splash screen
> On Sep 11, 2023, at 02:29, zuperkoleoptera wrote: > > Hi, > > I use gnucash under Debian testing with the mariadb backend, through an > ssh tunnel to a VPS I maintain. > Version of the mariadb is 10.3.39. > Everything worked as normal, until I upgraded in version 5.1 from 4.13 > where gnucash seemed to start but then remained indefinitely in the > splash screen occasionally bringing forward the "Gnucash not > responding" error with the option to wait or to force quit it. > If I pressed wait nothing happened until the error screen appeared > again. > > I waited until gnucash version 5.3 was migrated to Debian testing but > the issue has not been resolved. > I have an older box with Debian testing that still runs 4.13 and is > still operational, so for the time being I use that one. > > I am attaching the gnucash_trace file from the box with the 5.3 > version. > If needed I have the gnucash_trace also from the one running 4.13. > > Any ideas? > ___ The tracefile shows 10 minutes of 10:59:29 INFO [gnc_main_window_set_vis_of_items_by_action] Found menu_item 0x5570bb796ab0 with action name 'ABGetBalanceAction', seting vis to 'true' For most, but not all, of the AQBanking actions registered by the AQBanking plugin. I haven't yet tracked down why GnuCash would get stuck in a loop trying to load the plugin, but I guess there's also a packaging problem with the 5.x .deb that you're using. I can't tell you what it might be until I figure out what's causing the loop. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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.
