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 <qof.session> [QofSessionImpl::load_backend] Selected provider GnuCash Libdbi (MYSQL) Backend * 06:54:25 INFO <gnc.backend.dbi> [error_handler] DBI error: 1045: Access denie d for user 'gnucash'@'localhost' (using password: YES) * 06:54:25 INFO <gnc.backend.dbi> [error_handler] Note: GbcDbiSqlConnection not yet initialized. Skipping further error processing. * 06:54:25 ERROR <gnc.backend.dbi> [GncDbiBackend<Type>::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 <zuperkoleopt...@gmail.com> > wrote: > > On Mon, 2023-09-11 at 13:23 -0700, John Ralls wrote: >> >> >>> On Sep 11, 2023, at 11:48 AM, John Ralls <jra...@ceridwen.us> >>> wrote: >>> >>> >>> >>>> On Sep 11, 2023, at 11:23 AM, zuperkoleoptera >>>> <zuperkoleopt...@gmail.com> 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. > > > <error.log><gnucash.trace> _______________________________________________ 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.
