[GNC] Gnucash 3.7 freezes on any report after update from 2.6
I have just upgraded my 2.6 installation to 3.7 (Windows 10) and the gnucash would freeze immediately if I click on any report (there were 2 opened tabs by default as carried over from how I had it on 2.6). Thinking this was caused by incompatible reports, I managed to close them with "X" while they were not yet active, saved, reopened gnucash. Then I created brand new report. First time it worked but then as soon as I changed report to show 15 items versus default, was it 8?, it froze. Second and subsequent time, trying to create ANY report immediately freezes the gnucash. Basically it is impossible to create any reports, at least not expense reports. I did wait a number of minutes (10+) but it just doesn't come back from complete freeze. Is there a way around this? Or are my only options to either stick to 2.6 forever or start a completely new file at the beginning of next year for new data and keep 2.6 installed on another PC (as they cannot coexist on windows?)? Keep in my that my existing file has more than 10 years of history of daily transactions so it's pretty large. Thanks for any suggestions. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6
> On Oct 20, 2019, at 10:51 AM, andrewTE wrote: > > I have just upgraded my 2.6 installation to 3.7 (Windows 10) and the gnucash > would freeze immediately if I click on any report (there were 2 opened tabs > by default as carried over from how I had it on 2.6). Thinking this was > caused by incompatible reports, I managed to close them with "X" while they > were not yet active, saved, reopened gnucash. Then I created brand new > report. First time it worked but then as soon as I changed report to show 15 > items versus default, was it 8?, it froze. Second and subsequent time, > trying to create ANY report immediately freezes the gnucash. Basically it is > impossible to create any reports, at least not expense reports. I did wait a > number of minutes (10+) but it just doesn't come back from complete freeze. > > Is there a way around this? Or are my only options to either stick to 2.6 > forever or start a completely new file at the beginning of next year for new > data and keep 2.6 installed on another PC (as they cannot coexist on > windows?)? Keep in my that my existing file has more than 10 years of > history of daily transactions so it's pretty large. > > Thanks for any suggestions. This might be be https://bugs.gnucash.org/show_bug.cgi?id=797283. Does it really freeze on any report at all or just on graphical reports? Is GnuCash completely hung so that if you click one of the other tabs it doesn't switch after a few minutes? Are there any unusual messages in the trace file (https://wiki.gnucash.org/wiki/Tracefile)? Try starting GnuCash from a CMD prompt with the debug option: "c:\Program Files (x86)\gnucash\bin\gnucash" --debug Then look at the end of the new tracefile to see what was the last message GnuCash printed before it hung. Please start Task Manager, switch to the Details tab, and find the gnucash entry. Does it show 0 CPU? 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 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.
Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6
Andrew, See the wiki about obtaining a tracefile on Windows. Make sure to check the tracefile before re-starting GnuCash after a freeze. (it gets overwritten on subsequent runs) Also, check the wiki for running GnuCash from the command line. (cmd.exe) Some errors or warnings are sent back to the command window that way. You might not get anything of use, but both are worth checking out. In the meantime... Can you run other reports, such as P&L (Income Statement), Balance Sheet, Cash-Flow, et cetera? Can you try running the offending reports and narrow down the expense accounts? Perhaps one or more has some sort of bad transaction info or is corrupted. Try the Transaction Report on those (or various) expense accounts and see if it freezes as well. The goal here is to narrow down which (or if all) reports choke, and then trying to find out what they are choking on. Of course, make a backup of your datafile before proceeding. You shouldn’t have to stay on 2.6 forever, and you shouldn’t need to make a new file. But this might take some sleuthing. Regards, Adrien > On Oct 20, 2019 w43d293, at 12:51 PM, andrewTE > wrote: > > I have just upgraded my 2.6 installation to 3.7 (Windows 10) and the gnucash > would freeze immediately if I click on any report (there were 2 opened tabs > by default as carried over from how I had it on 2.6). Thinking this was > caused by incompatible reports, I managed to close them with "X" while they > were not yet active, saved, reopened gnucash. Then I created brand new > report. First time it worked but then as soon as I changed report to show 15 > items versus default, was it 8?, it froze. Second and subsequent time, > trying to create ANY report immediately freezes the gnucash. Basically it is > impossible to create any reports, at least not expense reports. I did wait a > number of minutes (10+) but it just doesn't come back from complete freeze. > > Is there a way around this? Or are my only options to either stick to 2.6 > forever or start a completely new file at the beginning of next year for new > data and keep 2.6 installed on another PC (as they cannot coexist on > windows?)? Keep in my that my existing file has more than 10 years of > history of daily transactions so it's pretty large. > > Thanks for any suggestions. ___ 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.
Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6
I've run it with debug. No messages showing on the console, and in the tracefile I get something like this: * 11:57:01 INFO [gnc_plugin_page_report_setup] report-id: 11 * 11:57:01 INFO [gnc_plugin_page_report_setup] set needs save * 11:57:02 INFO [gnc_html_webkit_init] webkit_settings: Set default font to [[gnc_html_w] * 11:57:02 INFO [gnc_gsettings_register_cb] schema: general.report, key: default-zoom, settings_ptr: 0b6a7f40, handler_id: 20891 * 11:57:02 INFO [gnc_plugin_page_report_realize_uri] Realized Container size is 1w x 1h * 11:57:02 INFO [qof_object_foreach] type=Split * 11:57:02 INFO [qof_collection_foreach] Hash Table size of Split before is 50912 * 11:57:02 INFO [qof_collection_foreach] Hash Table size of Split after is 50912 * 11:57:02 INFO [qof_query_run_internal] matching objects=1d3f count=50504 * 11:57:03 INFO [qof_object_foreach] type=Split * 11:57:03 INFO [qof_collection_foreach] Hash Table size of Split before is 50912 * 11:57:03 INFO [qof_collection_foreach] Hash Table size of Split after is 50912 * 11:57:03 INFO [qof_query_run_internal] matching objects=14af9a60 count=1284 * 11:57:03 MESSG
Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6
I am able to run Income Statement, Balance Sheet and Cash Flow. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6
> On Oct 20, 2019, at 12:08 PM, andrewTE wrote: > > I am able to run Income Statement, Balance Sheet and Cash Flow. > OK, that plus the tracefile output indicating that javascript has left the building means that it's bug 797293. 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 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.
Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6
Okay thanks. Reading on it, seems like it's caused by library and compiler compatibility issues with no current way forward. Worse yet it may be caused by threading issues. And it's intermittent to reproduce for some people to boot. Being a SW developer myself, this does not look promising for a fix any time soon. I guess my best bet is to use 3.5 or stick to 2.6 then? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6
> On Oct 20, 2019, at 12:32 PM, andrewTE wrote: > > Okay thanks. Reading on it, seems like it's caused by library and compiler > compatibility issues with no current way forward. Worse yet it may be caused > by threading issues. And it's intermittent to reproduce for some people to > boot. Being a SW developer myself, this does not look promising for a fix > any time soon. I guess my best bet is to use 3.5 or stick to 2.6 then? Unfortunately that seems like a correct assessment. Unless you need FinTS I think 3.5 is your best bet. Unless, of course, you have some skill in working with pthreads on Windows and can figure out what's going astray... 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 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.