[GNC] Gnucash 3.7 freezes on any report after update from 2.6

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] Gnucash 3.7 freezes on any report after update from 2.6

andrewTE
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

John Ralls-2


> On Oct 20, 2019, at 10:51 AM, andrewTE <[hidden email]> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

Adrien Monteleone-2
In reply to this post by andrewTE
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 <[hidden email]> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tracefile on Windows (was Gnucash 3.7 freezes on any report after update from 2.6)

John Ralls-2


> On Oct 20, 2019, at 11:38 AM, Adrien Monteleone <[hidden email]> wrote:
>
> 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)

Not on Windows. On Windows each tracefile has a 6-character random string attached so they're all there until the user cleans them out.

Regards,
John Ralls
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Tracefile on Windows (was Gnucash 3.7 freezes on any report after update from 2.6)

Adrien Monteleone-2
Ah, thanks!

Regards,
Adrien

> On Oct 20, 2019 w43d293, at 1:56 PM, John Ralls <[hidden email]> wrote:
>
>
>
>> On Oct 20, 2019, at 11:38 AM, Adrien Monteleone <[hidden email]> wrote:
>>
>> 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)
>
> Not on Windows. On Windows each tracefile has a 6-character random string attached so they're all there until the user cleans them out.
>
> Regards,
> John Ralls


_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

andrewTE
In reply to this post by John Ralls-2
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.gui> [gnc_plugin_page_report_setup] report-id: 11
* 11:57:01  INFO <gnc.gui> [gnc_plugin_page_report_setup] set needs save
* 11:57:02  INFO <gnc.html> [gnc_html_webkit_init] webkit_settings: Set
default font to [[gnc_html_w]
* 11:57:02  INFO <gnc.app-utils.gsettings> [gnc_gsettings_register_cb]
schema: general.report, key: default-zoom, settings_ptr: 0b6a7f40,
handler_id: 20891
* 11:57:02  INFO <gnc.gui> [gnc_plugin_page_report_realize_uri] Realized
Container size is 1w x 1h
* 11:57:02  INFO <qof.object> [qof_object_foreach] type=Split
* 11:57:02  INFO <qof.engine> [qof_collection_foreach] Hash Table size of
Split before is 50912
* 11:57:02  INFO <qof.engine> [qof_collection_foreach] Hash Table size of
Split after is 50912
* 11:57:02  INFO <qof.query> [qof_query_run_internal] matching
objects=1d3f0000 count=50504
* 11:57:03  INFO <qof.object> [qof_object_foreach] type=Split
* 11:57:03  INFO <qof.engine> [qof_collection_foreach] Hash Table size of
Split before is 50912
* 11:57:03  INFO <qof.engine> [qof_collection_foreach] Hash Table size of
Split after is 50912
* 11:57:03  INFO <qof.query> [qof_query_run_internal] matching
objects=14af9a60 count=1284
* 11:57:03 MESSG <gnc.scm>







<link rel="stylesheet" type="text/css" href="file:///c:\Program Files
(x86)\gnucash/share\gnucash\jqplot/jquery.jqplot.css" />
<div id="chart-24145" style="width:100.0%;height:100.0%;"></div>
<script id="source">
$(function () {var data = [];var series = [];

followed by some javascript code which I can post if needed, it's rather
long but I see nothing unusual. One excerpt that may give hint into what
it's drawing is

$.jqplot.config.enablePlugins = true;
$(document).ready(function() {
var plot = $.jqplot('chart-24145', data, options);
plot.axes.xaxis.ticks = getVisualTicks();
plot.replot();

This was the average balance graph which then froze. CPU use of gnucash is
0, likewise with disk. It's not like 2.6 where it is obviously hard at work
and not frozen and comes back eventually.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

andrewTE
In reply to this post by Adrien Monteleone-2
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

John Ralls-2


> On Oct 20, 2019, at 12:08 PM, andrewTE <[hidden email]> 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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

andrewTE
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

John Ralls-2


> On Oct 20, 2019, at 12:32 PM, andrewTE <[hidden email]> 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
[hidden email]
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.