As a follow-up I tried check and repair and ran into an infinite loop in accts receivable and accounts payable.
I tried check and repair on descendants of income and expense but no effect I tried backing off to 3.11 to no avail John suggested it was my machine so I moved to a fresh (but only slightly newer) machine. Nothing. As a last resort I saved to XML and it opened quickly. Progress at last. Wanting the transactional behaviour of SQLite I saved again as SQLite and it now appears fast. So there was something mysterious about the file that seems to have been repaired. Sent from my iPhone > On Feb 8, 2021, at 10:50 AM, R. Victor Klassen <rvklas...@gmail.com> wrote: > > When I came in check & repair was in an infinite loop in accounts > receivable. > > The progress log shows it counting up to about 1000 out 6614 and then > restarting at 0. Not clear whether a profile of check and repair is useful. > System is relatively unresponsive while I try to interrupt it > > Sent from my iPhone > >> On Feb 5, 2021, at 3:30 PM, John Ralls <jra...@ceridwen.us> wrote: >> >> 7 minutes is a lot. If it's still doing that after the C&R finishes then >> please open a bug and attach a profile. >> >> Regards, >> John Ralls >> >> >>>> On Feb 5, 2021, at 12:21 PM, R. Victor Klassen <rvklas...@gmail.com> wrote: >>> >>> It definitely does beachball long enough. >>> >>> Might be able to get a profile. >>> >>> It’s been in check and repair for a bit over 2 hrs now so I am guessing any >>> further probing will be Monday. For what It’s worth it was in excess of 7 >>> minutes of CPU time last time I started (from a crash). Minimal disk >>> activity. Reasonable memory pressure >>> >>> Sent from my iPhone >>> >>>>> On Feb 5, 2021, at 1:57 PM, John Ralls <jra...@ceridwen.us> wrote: >>>> >>>> Does it beachball long enough to get a process sample out of Activity >>>> Monitor? Better yet, do you know your way around Xcode well enough to get >>>> a time profile? >>>> >>>> Regards, >>>> John Ralls >>>> >>>>> On Feb 5, 2021, at 9:57 AM, R. Victor Klassen <rvklas...@gmail.com> wrote: >>>>> >>>>> I should also say I’m using the SQLite back end. 90% or more of what I do >>>>> passes though the business features. When I say entering an invoice line >>>>> is slow I mean that when I hit tab to get past the last entry and start a >>>>> new one I sometimes see the spinning lollipop. >>>>> >>>>> Trying check and repair to see if it makes a difference >>>>> >>>>> Sent from my iPhone >>>>> >>>>>>> On Feb 5, 2021, at 11:41 AM, Adrien Monteleone >>>>>>> <adrien.montele...@lusfiber.net> wrote: >>>>>> >>>>>> And on that note, it is always recommended when stepping between major >>>>>> versions to run Actions > Check & Repair > Check & Repair All. (which >>>>>> should accomplish such data translations all in one go) >>>>>> >>>>>> I forgot to add that I'm using the SQLite backend. Not sure if that >>>>>> makes a difference. >>>>>> >>>>>> Regards, >>>>>> Adrien >>>>>> >>>>>>> On 2/5/21 10:28 AM, David Reiser via gnucash-user wrote: >>>>>>> My memory is a bit fuzzy, but version 4 made some significant changes >>>>>>> to (I think) a number of key-value structures in the database. The >>>>>>> first time you open version 4, it has to convert all the old values (if >>>>>>> you have done lots of transaction importing, that’s a big contributor). >>>>>>> If you quit gnucash before it’s done with the conversion, it has to >>>>>>> start over the next time. I think it took something like 45 minutes >>>>>>> before my Mac was done updating everything internally in the database. >>>>>>> After that it has been fine. >>>>>> >>>>>> _______________________________________________ >>>>>> gnucash-user mailing list >>>>>> gnucash-user@gnucash.org >>>>>> To update your subscription preferences or to unsubscribe: >>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>>> If you are using Nabble or Gmane, please see >>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>>>>> ----- >>>>>> 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@gnucash.org >>>>> To update your subscription preferences or to unsubscribe: >>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>> If you are using Nabble or Gmane, please see >>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>>>> ----- >>>>> 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@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.